How to change the root password of a new mysql installation in Centos

Step 1: log on to mysql with an account [root @ CentOs5 ~] # Mysql-uroot Step 2: change the user database mysql & gt; usemysqlReadingtableinformationforcompletionoftableandcolumnnamesYoucanturnoffthisfeaturetoge Step 1: log on to mysql with an account
[Root @ CentOs5 ~] # Mysql-u root Step 2: change the user database
Mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with-ADatabase changed Step 3: change the password. remember to use the password () function to encrypt the password. do not forget it !!!
Mysql>

1

Update

 

1

User

 

1

Set

 

1

Password

1

=

1

Password

1

(

1

'Qwe123'

1

)

1

Where

 

1

User

1

=

1

'Root'

1

;

Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Step 4: refresh the permission table
Mysql> flush previleges;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'previleges' at line 1
Mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec) Step 5: Exit mysql
Mysql> quit
Bye Step 6: restart mysql
[Root @ CentOs5 ~] # Service mysqld restart;
STOPPING server from pid file/var/run/mysqld. pid
100421 13:44:03 mysqld endedStopping MySQL: [OK]
Starting MySQL: [OK]
[1] + Done mysqld_safe? Skip-grant-tables