浏览模式: 标准 | 列表 2017年08月的文章

Linux下忘记MySql的root密码重置过程

先把mysql服务给停了
service mysql stop
 
以安全模式启动MySQL
mysqld_safe --skip-grant-tables
 
新开一个终端,以root用户进入操作
mysql -uroot
 
进入mysql后执行以下黑体3条命令将root用户密码重置为123456
mysql> update mysql.user set password=PASSWORD('123456') where User='root';
mysql> flush privileges;
mysql> quit
 
重启mysql服务
service mysql restart

数据库出错:

MySQL Query Error
Mysql error description: Table './blog_is36_com/sablog_sessions' is marked as crashed and should be repaired
Mysql error number: 145
Date: 2024-06-04 @ 08:28
Script: http://blog.is36.com/index.php/module/action/param1/tagslist/page/3/user/%E6%AD%A3%E5%86%B0/wap/archives/488/archives/463/comments/archives/488/category/technology_all/links/archives/487/date/202302/archives/492/category/technology_all/tagslist/?action=article&setdate=201708