access denied for user debian-sys-maint solution

Your ads will be inserted here by

Easy Plugin for AdSense.

Please go to the plugin admin page to
Paste your ad code OR
Suppress this ad slot.

<code>for error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: NO)' or something similar: 

<span style="font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: 13px; line-height: 19px;">That’s because Debian has a MySQL account </span><code style="font-size: 13px; line-height: 19px;">debian-sys-maint</code><span style="font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: 13px; line-height: 19px;"> used for switching on/off and checking status. The password for that user should be the same as stored in </span><code style="font-size: 13px; line-height: 19px;">/etc/mysql/debian.cnf</code><span style="font-family: Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif; font-size: 13px; line-height: 19px;">. The file looks like this:</span></code>
<code># Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = &lt;password&gt;
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = &lt;password&gt;
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr</code>
<code>If the password doesn't match (for example because you changed it manually) the init script won't work anymore. You should set the password according to the file. So
</code>
<code>mysql -u root -p
# Then type MySQL root password
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '&lt;password&gt;';</code>
<code> </code>

Leave a Reply

Your email address will not be published. Required fields are marked *