Centos新安装mysql修改root密码教程,centosmysql

Centos新安装mysql修改root密码教程,centosmysql

第一步：用帐号登录mysql

[root@CentOs5 ~]# mysql -u root

第二步：改变用户数据库

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 -A

Database changed

第三步：修改密码，记得密码要用password()函数进行加密，一定不要忘记！！！

mysql>

1

update

1

<span font-family: NSimsun;">user</span>

1

<span font-family: NSimsun;">set</span>

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

第四步：刷新权限表

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)

第五步：退出mysql

mysql> quit

Bye

第六步：对mysql进行重启

[root@CentOs5 ~]# service mysqld restart;

STOPPING server from pid file /var/run/mysqld/mysqld.pid

100421 13:44:03 mysqld ended

Stopping MySQL: [ OK ]

Starting MySQL: [ OK ]

[1]+ Done mysqld_safe –skip-grant-tables