How can I remotely access a MySQL database?

2 years ago
Olivia Parker
1 minute

To enable remote access to a database in MySQL, follow these steps:

  1. Access the MySQL database server:
mysql -u root -p
  1. Check the current MySQL user and their permissions using the following command:
SELECT user, host FROM mysql.user;
  1. To allow specific users to access the database remotely, you can create a new user and grant them remote access permissions using the following command.
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

This will create a new user named username and grant them permission to access all databases from any host (%).

  1. Could you please explain that concept further?
  2. user handle
  3. The IP address is 192.168.1.100.
CREATE USER 'username'@'192.168.1.100' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'192.168.1.100' WITH GRANT OPTION;
FLUSH PRIVILEGES;
  1. Finally, refresh the permissions using the following command and exit the MySQL session.
FLUSH PRIVILEGES;
EXIT;

Now, you should be able to access the MySQL database remotely with the new user. Please ensure to take appropriate security measures in the production environment, such as using strong passwords and limiting remote access permissions to reduce potential security risks.

bannerAds