Can't find file: './mysql/plugin.frm' (errno: 13)[mysql数据目录迁移错位]错误解决

数据目录从/var/lib/mysql迁移至/data盘

1.拷贝文件到/data目录，需要保持权限
chown -R mysql:mysql /data/mysql*
2.修改/etc/mysql/my.cnf
指定datadir=/data/mysql
3.修改 vi /etc/apparmor.d/usr.sbin.mysqld
/var/lib/mysql/ r,# /var/lib/mysql/** rwk, 改为 /data/mysql/ r, /data/mysql/** rwk,
修改完重载该文件 /etc/init.d/apparmor reload
4.修改 vim /etc/mysql/mysql.conf.d/mysqld.cnf(具体看安装路径，/etc/mysql/my.cnf)
basedir = /usr
datadir = /dbs/mysql/data
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
secure_file_priv= /dbs/mysql-files

expire_logs_days = 7
max_binlog_size = 1024M

5.sql_mode修改
show variables like "sql_mode";
[mysqld]
sql-mode=NO_ENGINE_SUBSTITUTION

7. Packet for query is too large (1649 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
   修改max_allowed_packet参数
   6.重启mysql即可