Thread: MySQL problem
View Single Post
  #3  
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
Default

Quote:
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 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
Reply With Quote