ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) S

canegames · 07-13-2007, 11:13 PM

The debian-sys-maint user is also denied access this is what started the problem. How do I resolve this issue as MySQL won't start even using --skip-grant-tables doesn't work

Thanks for any help

Simon Bridge · 07-13-2007, 11:36 PM

http://dev.mysql.com/doc/refman/5.0/...rmissions.html

... you've been reading the forum right?
http://forums.mysql.com/read.php?11,...450#msg-154450

canegames · 07-13-2007, 11:56 PM

The debian-sys-maint user fails to login to MySQL at startp thus the service doesn't start. Do you have any ideas on this

Simon Bridge · 07-14-2007, 12:09 AM

Sure... I had two ideas and posted links about them. The problem is, I am reluctant to explore further until these are eliminated.

canegames · 07-14-2007, 12:16 AM

Those ideas have been tried thanks.

I know what my root password is but its the debian-sys-maint user that doesn't work not root root used to work before that one when down
Thanks for anymore help

canegames · 07-16-2007, 08:21 PM

To Simon Brdige:

Do you have any other ideas otherwaise I will have to reinstall my whole OS. I tried removing/installing mysql-server and mysql-client. No luck

Thanks for any other help

Simon Bridge · 07-16-2007, 11:08 PM

I tried removing/installing mysql-server and mysql-client. No luck
... that is because the configuration files are still there from before. Delete them too.

hmmm... you've been reading the forums then. I'll asume you've been reading lots of those threads. Trouble is, this is one of those: "oops, I've snafu'd my config" things that could be lots of things.

When in doubt: read the instructions...

* MYSQL WON'T START OR STOP?:
=============================
You may never ever delete the special mysql user "debian-sys-maint". This user
together with the credentials in /etc/mysql/debian.cnf are used by the
init scripts to stop the server as they would require knowledge of the
mysql root users password else.
So in most of the times you can fix the situation by making sure that
the debian.cnf file contains the right password, e.g. by setting a new
one (remember to do a "flush privileges" then).

canegames · 07-17-2007, 11:51 PM

This happended when I was adding a user in ISPConfig.

Thanks for your help.

canegames · 07-17-2007, 11:54 PM

I am the root user. I have another linux server running here could I copy the mysql /debian.cnf file from there into the malfunctioning server's debina.cnf file?

Thanks again for all your help

canegames · 07-17-2007, 11:59 PM

I atempted to use mysql and passwd to rest the debain-sys-maint user without sucess.

How would I go about resetting the debain.sys.maint user as mysql won't run even with the skip-grant-tables command?

Thanks again for all your help

Simon Bridge · 07-18-2007, 04:57 AM

Quote:

I have another linux server running here could I copy the mysql /debian.cnf file from there into the malfunctioning server's debina.cnf file?

Probably... it will end up with the same configuration as that system <fingers crossed> ... but dont forget the my.cnf files too.

Or you could edit the debian-sys-maint password in you existing conf... then add the root user, then add you.

If all else fails:
# apt-get remove --purge mysql-server
# apt-get install mysql-server

In the course of mulling this over, I found the following wee gem:
http://blog.evanweaver.com/articles/...ions-for-rails

canegames · 07-18-2007, 12:57 PM

the mysql client install it version 5.0x but when I try to reinstall the server I get the following console output:

Console Output:
--------------------------------------------------------------------------
gatekeeper:~# apt-get install -f mysql-server
Reading package lists... Done
Building dependency tree... Done
The following NEW packages will be installed
mysql-server
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B/46.7kB of archives.
After unpacking 81.9kB of additional disk space will be used.
(Reading database ... 28619 files and directories currently installed.)
Unpacking mysql-server (from .../mysql-server_5.0.32-7etch1_all.deb) ...
Stopping MySQL database server: mysqld failed!
invoke-rc.d: initscript mysql, action "stop" failed.
invoke-rc.d returned 1
There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!
dpkg: error processing /var/cache/apt/archives/mysql-server_5.0.32-7etch1_all.deb (--unpack):
subprocess pre-installation script returned error exit status 1
Errors were encountered while processing:
/var/cache/apt/archives/mysql-server_5.0.32-7etch1_all.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

End of Console output
-------------------------------------------------------------------------

Thanks again for your help