Thread: MySQL problem
View Single Post
Old 24th June 2008, 01:55
satimis satimis is offline
Senior Member
Join Date: Oct 2006
Posts: 533
Thanks: 4
Thanked 2 Times in 2 Posts

Originally Posted by falko View Post
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

There is a line on /etc/init.d/mysql
/usr/bin/mysql --defaults-file=/etc/mysql/debian.cnf -e "\. ${tmpfile}"
I have been playing around on that file;

# cat /etc/mysql/debian.cnf
# Automatically generated for Debian scripts. DO NOT TOUCH!
host     = localhost
user     = debian-sys-maint
password = EdKLb0cr3GElkUdM
socket   = /var/run/mysqld/mysqld.sock
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.

Reply With Quote