โŒ

Normal view

There are new articles available, click to refresh the page.
Before yesterdayMain stream

Mysql 5.6 on centos 6.9, ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I did install mysql5.6 on Centos6.9 and I tried to grep for the temp password using this command, sudo grep 'temporary password' /var/log/mysqld.log, but nothing is returned. so I started the msql with " sudo service mysqld start --skip-grant-tables" and followed below commands

Connect to MySQL via command line client: mysql -u root Run query to update root user password, using command line MySQL client (which is connected in previous step): UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'; Run another query to save changes to password: FLUSH PRIVILEGES; Type command to quit command line MySQL client: \q Restart MySQL server: service mysqld restart

tried to connect to Mysql "mysql -u root -p" and I see this error

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

(I have to build this is centos6.9 nad upgrade the mysql 8.x, as our current setups are using centos6.9.)

Please help me fix this and thanks in advance.

I want to connect to mysql database so I can import the mysqldump and start the upgrade process.

โŒ
โŒ