Give a non-local user permissions on the database for use with remote clients. : Remote User « Privilege « MySQL Tutorial






  1. MySQL Tutorial
  2. Privilege
  3. Remote User
GRANT ALL PRIVILEGES
ON myDatabase.*
TO newuser@192.168.0.2
IDENTIFIED BY 'newpassword';

Now a user on the machine '192.168.0.2' can connect to the database.








27.5.Remote User
27.5.1.Give a non-local user permissions on the database for use with remote clients.
27.5.2.Designate an IP or host address from which the user can connect
27.5.3.To allow a user to connect from anywhere you would use a wildcard '%'