数据库相关问题集锦(持续更新)

1.phpmyadmin 安装好页面打开空白问题（页面空白，源代码显示正常）：查看nginx日志，发现

2015/08/24 17:25:29 [crit] 25592#0: *254 open() "/var/lib/nginx/tmp/fastcgi/1/00/0000000001" failed (13: Permission denied) while reading upstream ...

此问题为tmp无访问权限造成。找到tmp目录，chown -R www:www tmp，重启nginx即可。

2.重置密码 SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');

3.导入数据出错[Error Code 2013]Lost connection to MySQL server during query：

mysql配置文件中设置max_allowed_packet = 32M，重启mysql服务

 

转载于:https://my.oschina.net/stevenhu/blog/494114