default root password mysql code example
Example 1: change root password mysql
mysql> use mysql;
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD("NewPassword");
mysql> flush privileges;
mysql> quit
mysql -u root -p
Example 2: set password mysql
ALTER USER 'root'@'localhost' IDENTIFIED BY 'newPassword';
flush privileges;
Example 3: mysql set root password
use mysql;
update user set authentication_string=PASSWORD("mynewpassword") where User='root';
flush privileges;
quit
Example 4: default password of mysql
mysqladmin -u root password NEWPASSWORD
Example 5: ubuntu mysql-server default root password
sudo mysql
Example 6: mysql default user password
user:root
password:
service mysql stop
mysqld_safe
mysql
UPDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='root';
FLUSH PRIVILEGES;
exit;
mysqladmin -u root -p shutdown
service mysql start