LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Debian
User Name
Password
Debian This forum is for the discussion of Debian Linux.

Notices

Reply
 
Search this Thread
Old 07-13-2007, 11:13 PM   #1
canegames
Member
 
Registered: Mar 2006
Posts: 72

Rep: Reputation: 15
Exclamation 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

Thanks for any help
 
Old 07-13-2007, 11:36 PM   #2
Simon Bridge
Guru
 
Registered: Oct 2003
Location: Waiheke NZ
Distribution: Ubuntu
Posts: 9,211

Rep: Reputation: 197Reputation: 197
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
 
Old 07-13-2007, 11:56 PM   #3
canegames
Member
 
Registered: Mar 2006
Posts: 72

Original Poster
Rep: Reputation: 15
debian-sys-maint user fails to login at startup

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
 
Old 07-14-2007, 12:09 AM   #4
Simon Bridge
Guru
 
Registered: Oct 2003
Location: Waiheke NZ
Distribution: Ubuntu
Posts: 9,211

Rep: Reputation: 197Reputation: 197
Sure... I had two ideas and posted links about them. The problem is, I am reluctant to explore further until these are eliminated.
 
Old 07-14-2007, 12:16 AM   #5
canegames
Member
 
Registered: Mar 2006
Posts: 72

Original Poster
Rep: Reputation: 15
links tried no success

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

Last edited by canegames; 07-16-2007 at 11:08 AM.
 
Old 07-16-2007, 08:21 PM   #6
canegames
Member
 
Registered: Mar 2006
Posts: 72

Original Poster
Rep: Reputation: 15
Exclamation Any other Ideas my production server has been down for 4 days now

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
 
Old 07-16-2007, 11:08 PM   #7
Simon Bridge
Guru
 
Registered: Oct 2003
Location: Waiheke NZ
Distribution: Ubuntu
Posts: 9,211

Rep: Reputation: 197Reputation: 197
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).
 
Old 07-17-2007, 11:51 PM   #8
canegames
Member
 
Registered: Mar 2006
Posts: 72

Original Poster
Rep: Reputation: 15
This happend when I added a user in ISPConfig

This happended when I was adding a user in ISPConfig.

Thanks for your help.

Last edited by canegames; 07-18-2007 at 12:01 AM.
 
Old 07-17-2007, 11:54 PM   #9
canegames
Member
 
Registered: Mar 2006
Posts: 72

Original Poster
Rep: Reputation: 15
You mentioned somthing about being the root user

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
 
Old 07-17-2007, 11:59 PM   #10
canegames
Member
 
Registered: Mar 2006
Posts: 72

Original Poster
Rep: Reputation: 15
Exclamation How do I reset the debian -sys-maint password?

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

Last edited by canegames; 07-18-2007 at 12:05 AM.
 
Old 07-18-2007, 04:57 AM   #11
Simon Bridge
Guru
 
Registered: Oct 2003
Location: Waiheke NZ
Distribution: Ubuntu
Posts: 9,211

Rep: Reputation: 197Reputation: 197
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

Last edited by Simon Bridge; 07-18-2007 at 05:00 AM.
 
Old 07-18-2007, 12:57 PM   #12
canegames
Member
 
Registered: Mar 2006
Posts: 72

Original Poster
Rep: Reputation: 15
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
-------------------------------------------------------------------------

Thanks again for your help
 
  


Reply

Tags
debian, mysql5


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MYSQL: Access denied for user 'root'@'localhost' (using password: NO) jun_tuko Linux - Software 3 03-05-2013 06:37 AM
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) samnjugu Linux - Software 12 01-22-2013 06:22 AM
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) mohtasham1983 General 2 04-02-2007 06:36 PM
Sarge mysql-server Access denied for user: root@localhost infinity432 Linux - Software 2 05-18-2005 11:42 PM
why I got "Access denied for user: 'root@localhost'" likedreamer Red Hat 1 11-09-2003 05:06 AM


All times are GMT -5. The time now is 06:06 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration