WordPress安装配置问题记录

1. mysql 添加用户，并赋予远程访问权限。

//创建用户
create user 'dxy'@'localhost' identified by 'dxy931016';
//赋予权限
grant all privileges on *.* to 'dxy'@'localhost' with grant option;

如果只写一句

grant all privileges on *.* to 'bill'@'%' with grant option;

会导致错误无法登陆。

ERROR 1045 (28000): Access denied for user 'dxy'@'localhost' (using password: YES)

2. WordPress显示无法裁剪图片，是因为PHP缺少了php-gd组件。由于当初安装PHP的时候为了选择高版本，没有使用yum直接安装，导致如果现在直接用yum安装php-gd会报错。

Error: Package: php-gd-5.3.3-48.el6_8.x86_64 (updates)
           Requires: php-common(x86-64) = 5.3.3-48.el6_8
           Installed: php-common-5.6.30-1.el6.remi.x86_64 (@remi-php56)
               php-common(x86-64) = 5.6.30-1.el6.remi
           Available: php-common-5.3.3-47.el6.x86_64 (base)
               php-common(x86-64) = 5.3.3-47.el6
           Available: php-common-5.3.3-48.el6_8.x86_64 (updates)
               php-common(x86-64) = 5.3.3-48.el6_8
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

解决办法为，使用remi安装php-gd。命令如下：

yum install gd-last --enablerepo=epel
yum install php-gd --enablerepo=remi,remi-php56