I installed mysql by snap.
initialize mysql and set root user and a temporary password to it.
when i want to connect to mysql server it show me error:
mysql.client -uroot -p
Using config file: /home/hamid/snap/mysql/common/conf/my.cnf
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
I solved the issue.
Stop the MySQL server , then restart it with the
Connect to the MySQL server using the [mysql]client; no password is necessary because the server was started with [
after connecting to Mysql Server
mysql> FLUSH PRIVILEGES;
then reset root password:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.