mysql数据库中某张表一直打不开
问题： 数据库中的某张表一直打不开，但是其他表都正常 原因： 可能是针对这张表进行的某些操作导致表锁死了，使用命令（开mysql cli工具中）查看进程 showprocesslist查看state列有lock标识，表示被锁，info表示操作信息，id列表示进程id 解决方法： 杀死进程 kil……
分类 MySQL 中的文章
Table 'xxx'is marked as crashed and last (automatic) repair failed 修复
报该问题的是表引导坏了，需要修复表就行 修复方法如下： 1、service mysqld stop 停止mysql服务； 2、cd /www/server/mysql/bin 切换到该表目录下(注意：不切换过来会总提示myisamchk一些错误导致失败)； 3、修改配置文件（不修改可能报错，修复完毕可以改回去） [myisamchk] key_buffer_size = 64M sort_buffer_size = 100M #read_buffer = 2M #write_buffer = 2M 4、执行修复 myisamchk -c……
MYSQL的错误代码
OS error code 1: Operation not permitted OS error code 2: No such file or directory OS error code 3: No such process OS error code 4: Interrupted system call OS error code 5: Input/output error OS error code 6: No such device or address OS error code 7: Argument list too long OS error code 8: Exec format error OS error code 9: Bad file descriptor OS error code 10: No child processes OS error code 11: Resource temporarily unavailable OS error code 12: Cannot allocate memory OS error code 13: Permission denied OS error code 14: Bad address OS error code 15: Block device required OS error code 16: Device or resource busy OS error code 17: File exists OS error code 18: Invalid cross-device link OS error code 19: No such device OS error code 20: Not……
MySQL遗忘Root密码
# systemctl stop mariadb #关闭服务 # cat /etc/my.cnf #修改/etc/my.cnf文件, ... [mysqld] skip-grant-tables #在[mysqld]下添加 skip-grant-tables , 再启动mysql ... # systemctl start mariadb #启动服务 # mysql -u root #连接MySql(MariaDB) 并修改root密码为123654 MariaDB [(none)]> update mysql.user set Password=password('123654') where User='root'; Query OK, 1 row affected (0.01 sec) Rows matched: 4 Changed: 1 Warnings: 0 MariaDB [(none)]> flush privileges; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> quit; Bye #……
MySQL服务启不了
情况1：存在socket lock file root用户执行 # systemctl restart kymysql 时不报错，但服务也没启动，查看错误日志 cat /opt/KY/Softs/log/mysql/mysql-error.log ... 2021-06-18T01:28:47.783821Z 0 [Note] Server hostname (bind-address): '0.0.0.0'; port: 20001 2021-06-18T01:28:47.783838Z 0 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 2021-06-18T01:28:47.783867Z 0 [Note] Server socket created on IP: '0.0.0.0'. 2021-06-18T01:28:47.783925Z 0 [ERROR] Another process with pid 2663 is using unix socket file. 2021-06-18T01:28:47.783932Z 0 [ERROR] Unable to setup unix socket lock file. 2021-06-18T01:28:47.783937Z 0 [ERROR] Aborting 解决办法： # 删除sock锁文件 rm -rf /opt/KY/Softs/mysql/var/mysql.sock.lock # 重启服务 systemctl restart kymysql 情况2：缺少lib包 roo……
清空表数据
方式1：DELETE 逐行删除速度极慢，不适合大量数据删除 Deletefromtablenamewhere1=1方式2：TRUNCATE 删除所有数据，保留表结构，不能撤消还原 TRUNCATETABLEtablename方式3：DROP 删除表，数据和表结构一起删除，快速 DROPTAB……