Access denied for user 'root@localhost' (using password: YES)

mysql linux installation centos

15,269

Right after install MySQL, you need to run mysqladmin to set root password.

mysqladmin -u root password NEWPASSWORD

15,269

Author by

R.Katnaan

Always active to develop new things. I want to be a leader than a follower in everything what I involves. I would like to work in an organization that provides a competitive challenging working environment and good prospects to improve new skills and knowledge to the best level. According to my past experiences I would like to apply my skill sets and knowledge to challenging projects. I also want to develop the systems using latest technologies and professional environment.

Updated on June 14, 2022

Comments

R.Katnaan almost 2 years

When install MySQL in Cent OS, it is installed correctly.

After installation,I type this command in terminal.

/etc/init.d/mysqld start

It shown error and I typed password as 'new-password'. In this time, I found this error.

[root@datsvr018 bin]# /etc/init.d/mysqld start
Starting mysqld:                                           [  OK  ]

[root@datsvr018 bin]# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MySQL to secure it, we'll need the current password
for the root user.  If you've just installed MySQL, and you haven't set
the root password yet, the password will be blank, so you should just press enter here.

Enter current password for root (enter for none): 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)