{"id":507,"date":"2011-01-17T15:24:28","date_gmt":"2011-01-17T20:24:28","guid":{"rendered":"http:\/\/www.xavignu.com\/?p=507"},"modified":"2011-01-17T15:24:28","modified_gmt":"2011-01-17T20:24:28","slug":"access-denied-for-user-debian-sys-maintlocalhost","status":"publish","type":"post","link":"https:\/\/www.xavignu.com\/?p=507","title":{"rendered":"‘Access denied for user ‘debian-sys-maint’@’localhost’"},"content":{"rendered":"

So the other day I made an aptitude safe-upgrade and MySQL<\/a> was upgraded. Thing is I made some changes and when I tried to restart MySQL I saw the following error.<\/p>\n

user@server:~$ sudo \/etc\/init.d\/mysql restart
\n[sudo] password for user:
\nStopping MySQL database server: mysqld failed!
\nStarting MySQL database server: mysqld already running.
\n\/usr\/bin\/mysqladmin: connect to server at ‘localhost’ failed
\nerror: ‘Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)’
\nuser@server:~$<\/b> <\/p>\n

Well fixing this error is fixed changing the password for MySQL user debian-sys-maint. We will retrieve the password from the file \/etc\/mysql\/debian.cnf.<\/p>\n


\nserver:~# cat \/etc\/mysql\/debian.cnf
\n# Automatically generated for Debian scripts. DO NOT TOUCH!
\n[client]
\nhost = localhost
\nuser = debian-sys-maint
\npassword = password
\nsocket = \/var\/run\/mysqld\/mysqld.sock
\n[mysql_upgrade]
\nuser = debian-sys-maint
\npassword = password
\nsocket = \/var\/run\/mysqld\/mysqld.sock
\nbasedir = \/usr
\nserver:~#
\n<\/b><\/p>\n

We backup the MySQL databases.<\/p>\n


\nuser@server:~$ mysqldump -u root -p –all-databases > \/tmp\/backup.sql
\nEnter password:
\nuser@server:~$
\n<\/b><\/p>\n

Now lets change the debian-sys-maint password in the database.
\n
\nmysql>GRANT ALL PRIVILEGES ON *.* TO ‘debian-sys-maint’@’localhost’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
\n<\/b>
\nNow we should be able to safely restart the database server.
\n
\nuser@server:~$ sudo \/etc\/init.d\/mysql restart
\n[sudo] password for user:
\nStopping MySQL database server: mysqld.
\nStarting MySQL database server: mysqld.
\nChecking for corrupt, not cleanly closed and upgrade needing tables..
\nuser@server:~$
\n<\/b>
\nReferences:<\/p>\n

    \n
  1. Ubuntuforums<\/a>\n<\/ol>\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    So the other day I made an aptitude safe-upgrade and MySQL was upgraded. Thing is I made some changes and when I tried to restart MySQL I saw the following error. user@server:~$ sudo \/etc\/init.d\/mysql restart [sudo] password for user: Stopping MySQL database server: mysqld failed! Starting MySQL database server: mysqld already running. \/usr\/bin\/mysqladmin: connect to […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[3],"tags":[6,51,70],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/pTQgt-8b","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/posts\/507"}],"collection":[{"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=507"}],"version-history":[{"count":0,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=\/wp\/v2\/posts\/507\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.xavignu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xavignu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}