Quote:
Originally Posted by agn
Try running 'mysql_upgrade'.
|
Hi agn,
Performed following test;
# /etc/init.d/mysql start
Code:
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
root@mail:/home/satimis# /usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
# /etc/init.d/mysql status
Code:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
*
# mysql_upgrade
Code:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Error executing ''/usr/bin/mysql' '--defaults-extra-file=/var/lib/mysql/mysql_upgrade_defaults' '--force' '--no-auto-rehash' '--batch' '--user=root' '--database=mysql' < '/usr/share/mysql/mysql_fix_privilege_tables.sql''
# kill `cat /var/run/mysqld/mysqld.pid`
No complaint
# /etc/init.d/mysql status
Code:
* MySQL is stopped.
$ sudo mysql_upgrade
Code:
Password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Error executing ''/usr/bin/mysql' '--defaults-extra-file=/var/lib/mysql/mysql_upgrade_defaults' '--force' '--no-auto-rehash' '--batch' '--user=root' '--database=mysql' < '/usr/share/mysql/mysql_fix_privilege_tables.sql''
$ sudo locate mysqld.sock
Code:
/var/run/mysqld/mysqld.sock
It is there.
# find / -name mysqld.sock
No printout
Find command can't find mysqld.sock
# ls -la /var/run/mysqld/
Code:
total 0
drwxr-xr-x 2 mysql root 40 2008-06-23 14:25 .
drwxr-xr-x 20 root root 820 2008-06-23 09:43 ..
# ls -ld /var/run/mysqld/
Code:
drwxr-xr-x 2 mysql root 40 2008-06-23 14:25 /var/run/mysqld/
Having tried almost half day and unable to find a glue.
B.R.
satimis