Saturday, January 9, 2021

Change mysql/mariadb root password

 >mysqladmin --user=root --password=oldpassword password "newpassword"

Change password for remote login as following

1. First login to mysql in command line

>mysql -u root -p

2. Then change password

>SET PASSWORD FOR 'root'@'%' = PASSWORD("NEWPASSSWORD");



No comments:

Post a Comment