Quote:
Originally Posted by falko
The problem is that the password in /etc/mysql/debian.cnf does not match the one for debian-sys-maint in the MySQL database. Did you modify /etc/mysql/debian.cnf, oir did you copy your MySQL database from another server?
|
I haven't touched anything on MySQL. It just comes to my notice that MySQL only starts on safe mode. Acturally after the mail server box started working sometime ago I left it there.
I have another Ubuntu box, LAMP 6.06 amd64, it also suffers the same problem after upgrade. MySOL only starts on safe mode.
Google found me several threads of similar problem, some of them solved and another unsolved. They were playing around on debian.cf
There is a line on /etc/init.d/mysql
Code:
/usr/bin/mysql --defaults-file=/etc/mysql/debian.cnf -e "\. ${tmpfile}"
I have been playing around on that file;
# cat /etc/mysql/debian.cnf
Code:
Password:
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = EdKLb0cr3GElkUdM
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
user = debian-sys-maint
password = EdKLb0cr3GElkUdM
socket = /var/run/mysqld/mysqld.sock
basedir = /usr
- replacing the password with mysql root password
- deleting the sock lines
- replacing the host with the name of the server
Non of them can solve my problem.
satimis