- mysql 添加用戶诈嘿,并賦予遠(yuǎn)程訪問權(quán)限。
//創(chuàng)建用戶
create user 'dxy'@'localhost' identified by 'dxy931016';
//賦予權(quán)限
grant all privileges on *.* to 'dxy'@'localhost' with grant option;
如果只寫一句
grant all privileges on *.* to 'bill'@'%' with grant option;
會導(dǎo)致錯誤無法登陸涩禀。
ERROR 1045 (28000): Access denied for user 'dxy'@'localhost' (using password: YES)
- WordPress顯示無法裁剪圖片,是因為PHP缺少了php-gd組件然眼。由于當(dāng)初安裝PHP的時候為了選擇高版本艾船,沒有使用yum直接安裝,導(dǎo)致如果現(xiàn)在直接用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