How to Set up a Remote MySQL Database Connection
How to Set up a Remote MySQL Database Connection.
Set Up A Remote Mysql Database Connection.
Connect to a MySQL database remotely.
How to Connect to the MySQL Database Remotely.
Remote Database Connection Setup.
Set up a remote MySQL database connection.
===================================================
Edit the File.
/etc/mysql/mysql.conf.d/mysqld.cnf
bind-address = 0.0.0.0
systemctl restart mysql.service
==================================
Log in to the MySQL server.
Log in to MySQL with the command
mysql -u root -p
Type the MySQL root user password.
MySQL command:
GRANT ALL ON testdb.* TO 'admin2018'@'192.168.1.100' IDENTIFIED BY 'Pass@1234' WITH GRANT OPTION;
Flush the MySQL privileges with the command
FLUSH PRIVILEGES;
Exit out of the MySQL prompt with the command
exit;