0 Members and 1 Guest are viewing this topic.
Hello, i need to add a database with remote mysql allowed for a ip. How to do it ? Thanks !
Grant user permission on a DatabaseGRANT ALL PRIVILEGES ON mydb.* TO user@'localhost' IDENTIFIED BY 'password';Grant remote access to specific IP All DatabaseGRANT 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 permissionSELECT * from information_schema.user_privileges where grantee like "'USERNAME'%";