PDA

View Full Version : [ubuntu] [SOLVED] Trouble updating mysql-server-5



jay019
November 22nd, 2008, 03:11 AM
Hi,

Tried updating mysql from the update manager, but it is having problems updating mysql-server-5.

The error that seems to pin point the problem is...
"Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)"

So I guess the question is, how do I give debian-sys-maint full access again. I dont remember changing anything other than the root password for mysql.

Jay

jay019
November 22nd, 2008, 03:20 AM
Full output from update-manger / synaptic...



Preconfiguring packages ...
(Reading database ... 154932 files and directories currently installed.)
Preparing to replace mysql-server-5.0 5.0.51a-3ubuntu5.1 (using .../mysql-server-5.0_5.0.51a-3ubuntu5.4_i386.deb) ...
* Stopping MySQL database server mysqld
...fail!
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg: warning - old pre-removal script returned error exit status 1
dpkg - trying script from the new package instead ...
* Stopping MySQL database server mysqld
...fail!
invoke-rc.d: initscript mysql, action "stop" failed.
dpkg: error processing /var/cache/apt/archives/mysql-server-5.0_5.0.51a-3ubuntu5.4_i386.deb (--unpack):
subprocess new pre-removal script returned error exit status 1
* Stopping MySQL database server mysqld
...fail!
invoke-rc.d: initscript mysql, action "stop" failed.
* Starting MySQL database server mysqld
...done.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
Errors were encountered while processing:
/var/cache/apt/archives/mysql-server-5.0_5.0.51a-3ubuntu5.4_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:

jay019
November 22nd, 2008, 08:44 AM
Never mind, found it.
For anyone else stuck in my predicament...

look in /etc/mysql/deban.cnf for the default password.
update it in mysql.
profit.

PTo
November 24th, 2008, 09:50 PM
Thanks for telling how you solved the problem. However, for the less experienced mysql users: how did you update the password? ;) Doesn't this change the password you chose when installing it?

jay019
November 25th, 2008, 12:44 AM
Good point...

To update the password I used phpmyadmin and logged on as root using the root password I set. Then I clicked on the link for "Privileges", clicked on the edit button for the "debian-sys-maint" user, then changed the password in the "Change Password" section to the password I found in /etc/mysql/deban.cnf

If anyone has any troubles fixing the same issue feel free to PM me for help.

:thumbsup: