Fixing error: ‘Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)’ Rumi, January 17, 2017 For all you Ubuntu/MySQL developers out there, have you ever seen the following? neo@thematrix:~$ sudo /etc/init.d/mysql restart * Stopping MySQL database server mysqld [fail] * Starting MySQL database server mysqld [ OK ] /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' So, what is this “debian-sys-maint” user? Well, this MySQL user is created for the Ubuntu to be able to start/stop the database and to carry out other maintenance operations. Sounds well enough, but then why do I keep running into the “access denied” problem for this user? Well, the issue is that with each update to MySQL, the user’s password in the database is overwritten. Ubuntu seems to go to the file /etc/mysql/debian.cnf in order to find this user’s password, but obviously the password is out of sync after the update has been applied. As a result of this behaviour, I’ll run into the “access denied” problem every so often. Thankfully, the solution to this issue is fairly simple. First, list the contents of the /etc/mysql/debian.cnf file: neo@thematrix:~$ sudo cat /etc/mysql/debian.cnf The contents of the file should look something like the following: # Automatically generated for Debian scripts. DO NOT TOUCH! [client] host = localhost user = debian-sys-maint password = n4aSHUP04s1J32X5 socket = /var/run/mysqld/mysqld.sock [mysql_upgrade] user = debian-sys-maint password = n4aSHUP04s1J32X5 socket = /var/run/mysqld/mysqld.sock basedir = /usr See that password? That’s what we’re looking for! Next, we want to issue a command to MySQL that tells it to grant the debian-sys-maint user all necessary privileges using the new password. Login to your mysql server using your root account and the root password you had originally set: neo@thematrix:~$ mysql -u root -p <password>Issue the GRANT command now to grant those permissions: mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'n4aSHUP04s1J32X5'; Voila! If you restart MySQL, you’ll find that you should no longer be getting the “access denied” error message. neo@thematrix:~$ sudo /etc/init.d/mysql restart * Stopping MySQL database server mysqld [ OK ] * Starting MySQL database server mysqld [ OK ] * Checking for corrupt, not cleanly closed and upgrade needing tables. Bear in mind, because we just switched the password, and the change hasn’t been affected yet, you may need to kill the MySQL server processes in order to get MySQL to shut down at all. Related Administrations Configurations (Linux) DebianMySQL
MySQL Master-Master Replication October 26, 2014October 26, 2014 This article is about setting up MySQL Master-Master database replication between two Cloud Servers. Master-Master data replication allows for replicated data, stored on multiple computers, to be updated by any authorized contributing member of the group. This allows for more open collaboration than Master-Slave replication where any needed changes identified… Read More
Install OnlyOffice Document Server on Ubuntu 16 November 21, 2020 Step 1: Install ONLYOFFICE Document Server Please note that OnlyOffice document server requires at least 2GB of RAM. An additional 2GB of swap space is recommended. OnlyOffice document server depends on PostgreSQL, Node.js, Redis Server, RabbitMQ server and Nginx. The following steps are tested on a Ubuntu 16.04 server but should… Read More
How to install PHP on IIS March 7, 2010 *Updated Recommendations – Please read the following instructions for running PHP fast and reliably* The FASTEST and EASIEST way to install PHP on IIS is using Microsoft’s Web Platform installer. It completely automates setting up IIS, FastCGI and the latest version of PHP from the php.net site. To install it,… Read More