Here’s how to grant the user access (I’m assuming you already created the user wpadmin on the MySQL server and given it password %u#098Tl3). On the MySQL server, you must grant access to the wordpressdb to that user from that IP address. Let’s say you have your WordPress server set up (running on IP address 192.168.1.100) to access a MySQL database named wordpressdb on the MySQL server with user wpadmin. Systemctl restart rvice Step two: Granting access to the user Restart the MySQL server with the command: To change this, you need to open the /etc/mysql//mysqld.cnf file and change the line: Out of the box, MySQL will only allow access from the localhost address 127.0.0.1. SEE: Remote access policy (Tech Pro Research) Step one: Allowing access

I’ll be working from a 16.04 instance of Ubuntu Server, but the process is quite similar on almost every Linux platform hosting MySQL. Let’s dig in and configure your MySQL server to accept remote connections. The process is fairly simply, and you can even lock down that MySQL server so it is only reachable from specific users on specific IP addresses. Out of the box, Ubuntu Server does not allow this, so you have to manually configure MySQL to allow remote connections. Say, for example, you have servers set up specifically for database and web: Your web server hosts an instance of WordPress that needs to be able to access the remote MySQL server. The next SQL Server: Interview with Asad Khan of Microsoft How to set, change, and recover your MySQL root password How to create a virtual machine in Google Cloud Platform More about data centersĭata warehouse services: What to consider before choosing a vendor If you work with MySQL, there will be instances in which you need to give remote access to the server. If you need to allow remote connections to your MySQL server, see how you can easily accomplish that task.

How to set up MySQL for remote access on Ubuntu Server 16.04

Download navicat ubuntu