: How to create user in phpmyadmin to connect two servers? 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

@Radia820

Create the remote connection

To create a remote connection:


On your database server, as a user with root privileges, open your MySQL configuration file.

To locate it, enter the following command:

mysql --help

The 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.cnf
Search 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.33
Save 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 root user.
Enter the following command:

GRANT ALL ON website.* TO username@192.168.19.33 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: devdocs.magento.com/guides/v2.0/install-gde/prereq/mysql_remote.html

Vote Up Vote Down