- 论坛徽章:
- 0
|
1. MySQL服务的启动:service mysqld start
2. 进入MySQL:mysql
3. 退出MySQL:exit 或者 \q
4. 初次登录并设置密码:
$ mysql -u root
mysql> SET password=PASSWORD( 'password' );
5. 再次登录命令:mysql -u root -p
6. 查询用户密码:select user, host, password from mysql.user;
7. 更改密码:
> UPDATE user SET password=PASSWORD( 'new password' ) WHERE user='user name';
> FLUSH PRIVILEGES;
> QUIT
8. 更改密码二:
> SET PASSWORD FOR user name=PASSWORD('new password');
> QUIT
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u3/93926/showart_1872759.html |
|