Database Administration - DevOps - SysAdmin - MySQL
Thank you ma! We're following in your footsteps!
Your words mean too much, I wish you best of luck
after creation of the database without password as you advised during installation, I could not login. getting error message: ERROR 1698 (28000): Access denied for user 'root'@'localhost'. How can I resolve this issue?
Hello Paul,
Let's try the following:
1- Access MySQL with sudo: sudo mysql -u root
2- ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
FLUSH PRIVILEGES; //important
3-Restart MySQL Service: After changing the authentication settings, restart the MySQL service to ensure all settings take effect properly :
sudo systemctl restart mysql
4- mysql -u root -p
Thank you ma! We're following in your footsteps!
Your words mean too much, I wish you best of luck
after creation of the database without password as you advised during installation, I could not login. getting error message: ERROR 1698 (28000): Access denied for user 'root'@'localhost'. How can I resolve this issue?
Hello Paul,
Let's try the following:
1- Access MySQL with sudo: sudo mysql -u root
2- ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
FLUSH PRIVILEGES; //important
3-Restart MySQL Service: After changing the authentication settings, restart the MySQL service to ensure all settings take effect properly :
sudo systemctl restart mysql
4- mysql -u root -p