Mega Code Archive

 

Categories / MySQL Tutorial / Privilege

 

To allow a user to connect from anywhere you would use a wildcard %

GRANT ALL PRIVILEGES ON myDatabase.* TO newuser@'%' IDENTIFIED BY 'newpassword';