我有一个Wordpress (php/nginx)服务器,非常新鲜。在CentOS上运行。我也有一个码头容器,由普通的mysql-服务器映像构建。
MySQL配置
它在端口3306上运行,所有MySQL用户都在MySQL中注册,主机172.17.0.1 (例如root@172.17.0.1)是停靠者的网关IP。码头容器是使用一个可操作的剧本来安装的。所有配置设置都是参数化的,这些参数在任何适当的地方都会使用,包括WordPress配置文件和环境变量,这些变量在MySQL停靠器安装期间填充根密码之类的内容。下面是我配置相关数据库的地方:
WordPress配置:
这分为两个部分,其中我将包括相关的部分。在我的ansible剧本中,这段代码设置了WordPress表和用户(成功):
- name: Create WordPress database
mysql_db:
name: '{{ wp_db_name }}'
state: present
login_user: root
login_password: '{{ mysql_root_password }}'
login_host: '{{ docker_mysql_ip }}'
- name: Create WordPress database user
mysql_user:
name: '{{ wp_db_user }}'
password: '{{ wp_db_password }}'
priv: '{{ wp_db_name }}.*:ALL'
state: present
login_user: root
host: '{{ docker_gateway_ip }}'
login_password: '{{ mysql_root_password }}'
login_host: '{{ docker_mysql_ip }}'以及相关的wp-config.php:
define('DB_NAME', 'wordpress');
define('DB_USER', '{{ wp_db_user }}');
define('DB_PASSWORD', '{{ wp_db_password }}');
define('DB_HOST', '{{ docker_mysql_ip }}');
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');当我导航到specific时,特定的问题声明为"Warning: mysql_connect(): Permission denied in /srv/wordpress/wp-includes/wp-db.php on line 1473",标题是“建立数据库连接错误”,状态代码500。
令人困惑的部分
当我检查wp-config.php文件时,用户名、密码和数据库名称都与它们完全相同。当我将主机、用户和密码从wp-config.php复制/粘贴到命令行的各自位置(例如mysql -u wordpress -p -h 172.17.0.2)时,我可以连接,也可以查看Wordpress数据库。
要而论之
MySQL在使用命令行时能够正确连接,但Wordpress无法连接。我也不太熟悉Wordpress或PHP,所以任何关于与问题相关的日志在哪里可以找到的想法都会受到欢迎。
发布于 2017-07-29 12:06:52
我刚刚在使用MariaDB的Debian9.1上遇到了这个问题,但是在Oracle MySQL中应该是一样的。我可以轻松地从命令行登录,但PHP无法访问数据库。
我花了几分钟才弄清楚,但我记得以前我在一台旧服务器上使用Arch (顺便说一句,这是个愚蠢的想法),需要命令mysql_secure_installation才能让它接受连接。
试试看,这个对我有用。
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.
Set root password? [Y/n] n
... skipping.
By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
... Success!
By default, MariaDB comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MariaDB
installation should now be secure.
Thanks for using MariaDB!https://stackoverflow.com/questions/44685984
复制相似问题