Access denied for user 'user'@'localhost' on MySQL

Question

I'm trying connect me to database MySQL server but the console show me ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I don't know why. Please help me. In my file my.cnf I have something like this,

[mysqld]
datadir=/var/lib/mysql
socket=/tmp/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:3306"

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:3306"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:3306"

[client]
socket=/tmp/mysql.sock

enter image description here

Thanks.

Can you show how you connect via console? (ommiting passwords if supplied on commandline) — favoretti
– favoretti, Commented Aug 5, 2012 at 18:42
Did you set a password during installation? :) Just hitting Enter on password prompt doesn't help? And you're sure you're entering proper password? (Sorry for the obvious questions, just want to make sure) :) — favoretti
– favoretti, Commented Aug 5, 2012 at 18:44
Oh of course, I reinstall the MySQL server because not up the databases. When I restart my MAC did not entry to database. — hekomobile
– hekomobile, Commented Aug 5, 2012 at 18:47
If you really don't remember the pass anymore, you can add skip_grant_tables to [mysqld] section of your my.cnf, restart server it will let you in without a password, then you can change password by updating mysql.user table and restart mysql removing the skip_grant_tables option. — favoretti
– favoretti, Commented Aug 5, 2012 at 18:50

favoretti · Accepted Answer · 2012-08-05 19:17:22Z

3

If you really don't remember the pass anymore, you can add skip_grant_tables to [mysqld] section of your my.cnf, restart server, it will let you in without a password, then you can change password by updating mysql.user table and restart mysql removing the skip_grant_tables option.

edited Aug 5, 2012 at 19:17

answered Aug 5, 2012 at 18:55

favoretti

30.4k4 gold badges51 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jason Strimpel · Accepted Answer · 2012-08-05 18:46:11Z

0

The -p flag denotes the requirement for a password. There should be a second prompt after typing what you typed requesting the password. For example:

$ mysql -u root -p
$ Enter password:

Then you type the password.

answered Aug 5, 2012 at 18:46

Jason Strimpel

15.7k25 gold badges81 silver badges110 bronze badges

Collectives™ on Stack Overflow

Access denied for user 'user'@'localhost' on MySQL

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related