「实战笔记」mysql表修复实战
#./mysqlcheck -u root -p table --auto-repair
mysql: Unknown OS character set 'GB18030'.
mysql: Switching to the default character set 'latin1'.
MySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
#vi /etc/profile
export LC_ALL="C"
export LANG="zh_CN.UTF-8"
#source /etc/profile
#service mysqld stop
#service mysqld start --skip-grant-tables
#mysql -u root mysql
mysql>UPDATE user SET Password=PASSWORD('123456') where USER='root';
mysql> FLUSH PRIVILEGES;
#service mysqld restart
./mysqlcheck -u root -p table --auto-repair
……
table.zsshopconfig OK
table.zsstore OK
table.zwinstance OK
table.zwstep OK
table.zwworkflow OK
Repairing tables
table.??
Error : Table 'table.??' doesn't exist
status : Operation failed
table.ldtaskrunlog
warning : Number of rows changed from 7 to 8
status : OK
table.sdcacheerroermail
warning : Number of rows changed from 629 to 630
status : OK
[root@test bin]
![](http://www.imitker.com/zb_users/upload/2024/06/20240609223530171794373024225.png)
- 上一篇: 「实战笔记」阿里云ECS更换系统盘后关键步骤
- 下一篇: 「盘点」我的2016暨洒别猴年迎雄鸡
评论