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?
Setting the correct timezone on an Ubuntu Server ensures accurate timekeeping for logs, scheduled tasks (cron jobs), and system updates. This is especially important for servers running in different geographical regions or used in distributed.
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
Setting the correct timezone on an Ubuntu Server ensures accurate timekeeping for logs, scheduled tasks (cron jobs), and system updates. This is especially important for servers running in different geographical regions or used in distributed.
Plss visit for more information:https://docs.vultr.com/how-to-set-the-timezone-on-ubuntu-24-04