How to set a password for mysql

There are many ways to set a password for mysql: 1. after entering mysql with root, mysql> set password = password ('your password'); mysql> flush privileges; 2. use the GRANT statement mysql> grant all on *. * to 'root' @ 'localhost' identified by 'your password' with grant option; www.2cto.com mysql> flush privileges; 3. go to the mysql database to modify the user table mysql> use mysql; mysql> update user set password = password ('your password') where user = 'root'; mysql> flush privileges; author matthio