Author Topic: How to add/use remote mysql ?  (Read 1526 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
How to add/use remote mysql ?
« on: February 18, 2017, 07:23:39 AM »
Hello, i need to add a database with remote mysql allowed for a ip. How to do it ? Thanks !

Offline
*****
Re: How to add/use remote mysql ?
« Reply #1 on: February 19, 2017, 06:48:58 AM »
the process is the same, google it you'll find many tutorials

Offline
**
Re: How to add/use remote mysql ?
« Reply #2 on: February 21, 2017, 10:00:30 AM »
Hello, i need to add a database with remote mysql allowed for a ip. How to do it ? Thanks !

- Open port 3306 in your firewall (IN/OUT)

MYSQL:
Quote
Grant user permission on a Database
GRANT ALL PRIVILEGES ON mydb.* TO user@'localhost' IDENTIFIED BY 'password';

Grant remote access to specific IP All Database
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'1.2.3.4' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

Revoke permision:
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'USERNAME'@'1.2.3.4';


Check permission
SELECT * from information_schema.user_privileges where grantee like "'USERNAME'%";