Error 1045 28000 access denied for user debian sys maint localhost using password yes

I edited deian.cnf to change the password of mysql (ubuntu server)

sudo vi /etc/mysql/debian.cnf

I change

user=debian-sys-maint password=*

to

user=debian-sys-maint

password=mypassword

then I tried to enter console of mysql

mysql -udebian-sys-maint -p

and inputed password ‘mypassword’

it reported

mysql error 1045(280000) access denied for user 'debian-sys-maint '@' localhost using password 'yes'

I tried to remove mysql and reinstall, the error is same.

Your comment welcome

asked Aug 7, 2013 at 19:27

The error message tell you that, your password is wrong or the account debian-sys-maint has no access to the database on host localhost.

If you are sure your password is correct you should grant all privileges like this:

login as root first

mysql -u root -p <password>

then, grant full permissions:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'your password';

restart mysql and see if the error message is gone.

answered Aug 7, 2013 at 19:59

By default root does not have a password and so you need not append -p at the end. simply type

mysql -u root.

To reset the password, use mysqladmin -u root password [newpassword]

answered Mar 5, 2014 at 18:47

Most easy way to restoring the debian-sys-maint user, is to reconfigure package mysql-server-5.5. That if you know the password for the root user of MySQL, you can try to restore the user and its password in /etc/mysql/debian.cnf.

sudo dpkg-reconfigure mysql-server-5.5

NOTE: if you cannot stop mysql pid, just run sudo killall mysqld. This is needed for reconfiguring the mysql-server-5.5.

answered Mar 6, 2015 at 19:30

Longtime reader of Stackoverflow, first time submitting a question.

I had to hardware-reboot my dev laptop a few nights ago for various reasons. When i brought it back up i realized that mysqld were no longer accessible. I usually connect with root on a local dev machine. I could not start/stop it through the init-scripts as usual either and so I turned to various search engines as always. After consulting Google, Bing and Duckduckgo.com I still could not find a solution on the problem. I found solutions to similar problems but all involved changing the auto-generated password for debian-sys-maint and login as root to set a new one but since I cannot login as root either this does not solve my problem.

Does anyone know of any other solution-candidates for this dilemma?

error: ‘Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)’ .

asked Jan 20, 2012 at 7:42

I just installed a fresh copy of Ubuntu 10.04.2 LTS on a new machine. I logged into MySQL as root:

david@server1:~$ mysql -u root -p123

I created a new user called repl. I left host blank, so the new user can may have access from any location.

mysql> CREATE USER 'repl' IDENTIFIED BY '123';
Query OK, 0 rows affected (0.00 sec)

I checked the user table to verify the new user repl was properly created.

mysql> select host, user, password from mysql.user;
+-----------+------------------+-------------------------------------------+
| host      | user             | password                                  |
+-----------+------------------+-------------------------------------------+
| localhost | root             | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| server1   | root             | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| 127.0.0.1 | root             | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| ::1       | root             | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
| localhost |                  |                                           |
| server1   |                  |                                           |
| localhost | debian-sys-maint | *27F00A6BAAE5070BCEF92DF91805028725C30188 |
| %         | repl             | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 |
+-----------+------------------+-------------------------------------------+
8 rows in set (0.00 sec)

I then exit, try to login as user repl, but access is denied.

david@server1:~$ mysql -u repl -p123
ERROR 1045 (28000): Access denied for user 'repl'@'localhost' (using password: YES)
david@server1:~$ mysql -urepl -p123
ERROR 1045 (28000): Access denied for user 'repl'@'localhost' (using password: YES)
david@server1:~$ 

Why is access denied?

You should issue for localhost specific to it.

  GRANT USAGE ON *.* TO 'repl'@'localhost' IDENTIFIED BY '123';

And try connecting.

answered Mar 29, 2013 at 5:40

The problem is these two accounts, added by default.

http://dev.mysql.com/doc/refman/5.5/en/default-privileges.html

+-----------+------------------+-------------------------------------------+
| host      | user             | password                                  |
+-----------+------------------+-------------------------------------------+
| localhost |                  |                                           |
| server1   |                  |                                           |
+-----------+------------------+-------------------------------------------+

A blank user name is a wildcard, so no matter what account you use, it matches this user if MySQL thinks you’re connecting from localhost or your local server name (server1 in this case)… since they have no password, any password you try is wrong. User authentication only tries the first match, so the user you created never gets noticed when your host is localhost (or your server name).

Delete these two from the mysql.user table and then FLUSH PRIVILEGES;.

Or, the mysql_secure_installation script can do this for you, although I tend to prefer doing things manually.

http://dev.mysql.com/doc/refman/5.5/en/mysql-secure-installation.html

answered Mar 30, 2013 at 2:02

Database may not be configured yet just issue a no-arg call:

mysql <enter>

Server version: xxx

Copyright (c) xxx

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

Mysql [(none)]> 

If Mysql must be set a root password, you can use

mysql_secure_installation

answered Apr 18, 2020 at 7:45

Make sure that all fields in the connector are set up with the correct details

host = «localhost»,
user = «CorrectUser»,
passwd = «coRrectPasswd»,
database = «CorreCTDB»

Check for upper and lowercase errors as well — 1045 is not a Syntax error, but has to do with incorrect details in the connector

answered Dec 13, 2019 at 22:59

This could be an issue with corruption of your mysql database. Tables inside mysql database like user table can get corrupt and may cause issued.

Please do a check on those

myisamchk /var/lib/mysql/mysql/ *.MYI

Usually while checking or fixing myisam tables we would like to take mysql down first. If this problem is still not solve please try this out aswell.

If they are corrupt then you can fix them using

myisamchk —silent —force —fast /path/table-name.MYI

Thanks,

Masood

answered Mar 31, 2013 at 17:25

asked Nov 17, 2012 at 9:19

Debian use debian-sys-maint account for management (start/stop etc.).
Credentials are stored in /etc/mysql/debian.cnf — check if all are valid.