Update root password MySQL
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
To list users: getent passwd To add a new user: sudo adduser newuser To change a user's password: sudo passwd username To change a user's username: sudo usermod -l newUsername oldUsername Note that this doesn't change the home directory. To change the home directory
To change the MySQL password for a particular user first login to MySQL: mysql -u root -p Next update the appropriate user's password with the following command: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('NEW_PASSWORD');
If you are having issues with MySQL password validation, you can run the following commands to disable it: mysql -u root -p uninstall plugin validate_password; Should you want to enable MySQL validation again you can run this command once logged into MySQL: INSTALL