搜了好多,都不成功,最后找到配置文件在/etc/mysql/mariadb.conf.d/ 50-f
默认datadir = /var/lib/mysql
停止mysql
service mysql stop
复制数据存放文件到U盘
cp -a /var/lib/mysql /srv/dev-disk-by-label-XXXXX实际目录/mysqldata
修改配置文件:
vi /etc/mysql/mariadb.conf.d/50-f
改好路径后
service mysql start
报错
目录后再加上/mysql
再次启动数据库,成功!
myWebsql登录不成功,phpmyadmin也不成功,搞了好些时候,原来问题在plugin
运行命令:
select user, plugin from mysql.user;
如果plugin是socket的,则只允许客户端登录,将plugin修改成mysql_native_password即可
修改命令:
update mysql.user set authentication_string = password(‘新密码’),plugin=’mysql_native_password’where user=’root’;回车显示:
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
再次登录,成功了