问题原文
原帖链接 · mySun · CC BY-SA 3.0
IP my Website: 192.168.19.33 and IP Database server is: 192.168.19.41.
How to create user account in phpmyadmin for the connection between the two servers?
And how to edit this setting:
DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=website
DB_USERNAME=root
DB_PASSWORD=123456
to this setting:
DB_CONNECTION=mysql
DB_HOST=192.168.19.41
DB_PORT=3306
DB_DATABASE=website
DB_USERNAME=username
DB_PASSWORD=password
已采纳解答
原帖链接 · Michael Yaeger · CC BY-SA 3.0
Create the remote connection
To create a remote connection:
On your database server, as a user with
rootprivileges, open your MySQL configuration file.To locate it, enter the following command:
mysql --helpThe location displays similar to the following:
Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnfSearch the configuration file for
bind-address.If it exists, change the value as follows.
If it doesn’t exist, add it anywhere except the
[mysqld]section.bind-address = 192.168.19.33Save your changes to the configuration file and exit the text editor.
Restart the MySQL service:
service mysql restart
Grant access to a database user
To enable your web node to connect to the database server, you must grant a web node database user access to the database on the remote server.
This example grants the root database user full access to the database on the remote host.
To grant access to a database user:
- Log in to the database server.
- Connect to the MySQL database as the
rootuser. Enter the following command:
GRANT ALL ON website.* TO [email omitted] IDENTIFIED BY 'password';
Verify database access
On your web node host, enter the following command to verify the connection works:
mysql -u username -h 192.168.19.41 -p
If the MySQL monitor displays as follows, the database is ready for use by the website:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 213
Server version: 5.6.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Source: http://devdocs.magento.com/guides/v2.0/install-gde/prereq/mysql_remote.html
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
