- SSH into the server.
- mysql -u root -p
- enter password
- SHOW GRANTS FOR 'username'@'localhost';
- GRANT ALL PRIVILEGES ON . TO 'username'@'ip_address' IDENTIFIED BY 'password';
- FLUSH PRIVILEGES;
- Try to connect database using mysql client
Manish Chaudhary
Posted on
How to connect to remote database using ip address
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)