将初始库mysql导出到桌面，保存为mysql.sql文件，弹出提示时输入前面填写的root密码。一定不要忘了这这步，忘记这步会导致在启动数据时没有用户数据。停止服务：sudo service mysql stop删除 mysql的数据文件：sudo rm -rf /usr/bin/mysql创建同名文件夹并设置权限：sudo mkdir /usr/bin/mysqlsudo chown -R mysql:mysql /usr/bin/mysqlsudo chmod 7

环境：一键安装包lnmp，mysql版本5.7.18-log查询：group by报错信息：ERROR 1055 (42000): Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘s.type_name’ which is not functionally depen...