Christian Hammers a écrit :
On 2007-03-28 [EMAIL PROTECTED] wrote:
Package: mysql-client-5.0
Version: 5.0.32-7etch1
Severity: normal
When I run mysqlcheck, I always get :
Table upgrade required. Please do "REPAIR TABLE x " to fix it
for two tables, always the same, even if I repair those tables just before, I
always get the same warning...
I don't know anymore what to do to get these tables clean
Have you upgraded from 4.0/4.1 recently?
It was supposed that mysqls-erver-5.0 runs an update_table
script at installation time, I wonder if this has happened.
Can you try "dpkg-reconfigure mysql-server-5.0"? It should change
nothing but run mysql_upgrade (check the logs).
bye,
-christian-
Hello,
I've tried to run dpkg-reconfigure mysql-server-5.0, but it doesn't
change anything, I still get the same errors.
So I tried to run mysql_upgrade, and I got :
Error 1045 (28000): Access denied for user: 'root'@'@localhost'
(password: NO) this is translated from the french error message ;)
Error Executing '/usr/mysql --force --no-auto-rehash --batch --user=root
mysql < /usr/share/mysql/mysql_fix_privilege_tables.sql'
so I tried to run manually :
/usr/mysql --force --no-auto-rehash --batch --user=root mysql <
/usr/share/mysql/mysql_fix_privilege_tables.sql
but I got once again :
Error 1045 (28000): Access denied for user: 'root'@'@localhost'
(password: NO)
So I tried with -p option to send in my password
It finally ran, but I got many errors of this kind :
Fieldname already in use