How to remotely access MYSQL on another PC (DB access, Permission granted)

For a simple test, DB installed on your local PC is enough.

However, if you have more PCs to work on and need to work remotely, it's not easy to have DB separated from each local PC.

So, I will tell you how to connect to MYSQL DB installed remotely on another PC.

 

---

MYSQL remote access method

 

In fact, the method is simple. In the Hostname/IP entry, enter the IP of the computer.
However, if you type it, it will say you don't have permission.

If access is not made through permission, there is a risk of data leakage as it becomes accessible to anyone in the event of IP leakage.

 

 

 

Permission granted 

Select the Tools tab and select 'User Manager'.

 

Select root and press the 'Add Object' button

 

 

Then you can see your database.

In my case, I will allow the blog DB to be authorized, and if you want, you can select only certain tables.

 

 

 

 

DB can give you permission to manipulate data.

For example, I just want to be able to look up the data, but if I give you all the permissions, the data may have been modified without knowing it.
If you are going to use it only you, you select all the check boxes and press Save.
(You must also enter a password.)

 

---

 

If you have completed this task, you will be able to access it remotely if you enter your IP.

If you want to know your PC IP, type IPCONFIG in the CMD window

The IP of your PC comes out.