MySQL忘记root密码
来源:互联网 发布:小米note3 知乎 编辑:程序博客网 时间:2024/06/09 22:47
To reset a root password that you forgot (using paths on our system):
[root@host root]#/usr/libexec/mysqld -Sg --user=root &
You may have better luck with:
mysqld --skip-grant-tables --user=root
Go back into MySQL with the client:
[root@host root]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 3.23.41
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
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
mysql> UPDATE user
-> SET password=password("newpassword")
-> WHERE user="root";
Query OK, 2 rows affected (0.04 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> exit;
[root@host root]#killall mysqld
Start MySQL the normal way for your system, and all is good. For Red Hat this is:
/etc/init.d/mysqld start
- MySQL忘记root密码
- MYSQL忘记root密码
- mysql root 密码忘记????
- mysql忘记root密码
- mysql root 密码忘记
- mysql 忘记root密码
- mysql忘记root密码
- mysql忘记root密码
- mysql root忘记密码
- mysql忘记root密码
- mysql root忘记密码
- MySQL忘记root密码
- mysql root 密码忘记
- mysql root 密码忘记
- MYSQL忘记root密码
- 忘记mysql root密码
- mysql root忘记密码
- mysql root 密码忘记
- mobilechannel的专栏
- 集团军和特种部队
- FVWM新手入门不完全手册
- Windows任务管理器开发原理与实现
- 详解XSS跨站脚本攻击(转自天极)
- MySQL忘记root密码
- Microsoft Photo Story 3.0 繁体中文版
- 虚拟主机设置手记
- java字符串处理
- 2006-2-23
- 新aspx页面的六种方法
- 我爱许巍
- [百万级]通用存储过程.分页存储过程
- 曾经在鸭子网站的留言