≡ Menu

mysqladmin tips and tricks

In all the 15 mysqladmin command-line examples below, tmppassword is used as the MySQL root user password. Please change this to your MySQL root password. 1. How to change the MySQL root user password? # mysqladmin -u root -ptmppassword password 'newpassword' # mysql -u root -pnewpassword Welcome to the MySQL monitor. Commands end with ; [...]

{ 18 comments }