当我wordpress安装进行到第二步的时候会报如下wordpress安装错误:
We were able to connect to the database server (which means your username and password is okay) but not able to select the wordpress database.
Are you sure it exists?
Does the user root have permission to use the wordpress database?
On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem?
If you don’t know how to set up a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.
解决以上问题很简单(how to deal?),如下。
1:检查你的mysql是否有远程连接的权限,如果没有的话,当你在本地navicate登录时就会报2003 - cant connect to MySQL server on x.x.x.x(10038)错误的,请先给root授权远程登录权限,授权方法请查看:http://www.tpyyes.com/a/mysql_oracle/2017/0223/72.html
2:如果已经有远程登录权限之后,请先手动新建一个名为wordpress的数据库,这样就一定ok了!wordpress安装程序好像不能自己新建数据库,我是如何看出来的?请看这句:
but not able to select the wordpress database.Are you sure it exists?
上面的英文表示:你确认wordpress数据库已经存在了吗?因此我就试了一下,果然可以继续安装wordpress网站程序了。
具体wordpress让你新建什么数据库名称,以图片的Database Name为准,如图所示。