MySQL更改数据引擎错误
发布时间：2022-03-16 16:35:13 所属栏目：MySql教程 来源：互联网
导读：MySQL修改数据引擎错误： 1、缺少 组件 [root@MySQL support-files]# mysql_convert_table_format -uroot -p123456 -e MyISAM USER ABC Cant locate DBI.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor
 MySQL修改数据引擎错误： 1、缺少 组件 [root@MySQL support-files]# mysql_convert_table_format -uroot -p123456 -e MyISAM USER ABC Can't locate DBI.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /application/mysql/bin/mysql_convert_table_format line 20. BEGIN failed--compilation aborted at /application/mysql/bin/mysql_convert_table_format line 20. 解决： [root@MySQL support-files]# rpm -qa|grep perl-DBD [root@MySQL support-files]# yum install perl-DBD-MySQL -y 安装组件 2、无法连接到mysql [root@MySQL support-files]# mysql_convert_table_format --user=root --password=123456 --engine=MyISAM oldboy ABC Can't connect to database oldboy: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 解决(缺少sock参数)： vim /etc/my.cnf socket = /application/mysql-5.5.32/tmp/mysql.sock mysql_convert_table_format --user=root --password=123456 --sock=/application/mysql-5.5.32/tmp/mysql.sock --engine=MyISAM USER ABC （编辑：晋中站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
