- 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)
- 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
