Control Web Panel

WebPanel => How to => Topic started by: Carbonzxc on February 18, 2017, 07:23:39 AM

Title: How to add/use remote mysql ?
Post by: Carbonzxc 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 !

Title: Re: How to add/use remote mysql ?
Post by: Sandeep on February 19, 2017, 06:48:58 AM

the process is the same, google it you'll find many tutorials

Title: Re: How to add/use remote mysql ?
Post by: locvfx on February 21, 2017, 10:00:30 AM

Quote from: Carbonzxc 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 !

- 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'%";