ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) S
DebianThis forum is for the discussion of Debian Linux.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) S
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
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
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).
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?
I get errors when atempted to reinstall mysql-server
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
-------------------------------------------------------------------------
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.