Discuz安装问题记录

2018-09-20

问题1

1 2	数据库连接错误 No such file or directory

解决方式

确认数据库用户名和密码正确（笔者懒得查，直接改了）

mysql -u root
use mysql;
update user set host = '123456' where user = 'root';
select host, user from user;

确认php和mysql的sock配置是否正确

1 2	mysql -u root status

记录UNIX socket的值/phpstudy/data/mysql.sock

1	UNIX socket: /phpstudy/data/mysql.sock

新建一个phpinfo.php文件，扔到www目录下，浏览器访问之

1
2
3

<?php   
phpinfo();   
?>

phpinfo
记录下

1	Configuration File (php.ini) Path:/phpstudy/server/php/etc

到/phpstudy/server/php/etc下查看php.ini文件
将以下参数值填为我们status时候保存的值

1
2
3

mysql.default_socket = /phpstudy/data/mysql.sock
mysqli.default_socket = /phpstudy/data/mysql.sock
pdo_mysql.default_socket = /phpstudy/data/mysql.sock

问题2

1	ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

解决方式

确认是否打开允许远程连接，访问/etc/my.cnf文件

[mysqld]
···
skip-grant-tables
···

添加skip-grant-tables配置

jsonContent: meta: false pages: false posts: title: true date: true path: true text: false raw: false content: false slug: false updated: false comments: false link: false permalink: false excerpt: false categories: false tags: true