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
Adjust Apache ServerLimit and MaxClient January 6, 2013 MaxClients actually tells the apache to allow this many concurrent clients. Normally this limit is at 150. You can change this limit by editing your httpd.conf file. httpd.conf is normally located at /etc/httpd/conf/httpd.conf nano /etc/httpd/conf/httpd.conf ServerLimit directive to let the value of MaxClients above 256 work. By deafult ServerLimit is… Read More
Linux Remove All Partitions or Data And Create Empty Disk December 13, 2016 Use the following dd command to remove data from /dev/hdX: dd if=/dev/zero of=/dev/hdX bs=512 count=1 OR for sata disk, use the following syntax: dd if=/dev/zero of=/dev/sdX bs=512 count=1 In this example, empty sata disk /dev/sdb, enter (you must be login as the root user): fdisk /dev/sdb dd if=/dev/zero of=/dev/sdb bs=512… Read More
Submit the Google or Gmail Bulk Sender Form November 8, 2023 Found this article quite useful! Description While Gmail does not offer up a contact path to discuss deliverability issues directly with a Google representative, there is a way for clients to reach out to Google to ask them to reconsider spam folder delivery. Resolution Go to the Bulk Sender Contact… Read More