Mega Code Archive

 

Categories / MySQL / User Permission

 

Connecting to the server as cbuser from a host named xyz com, the GRANT statement should look like this

mysql> GRANT ALL ON cookbook.* TO 'cbuser'@'xyz.com' IDENTIFIED BY 'cbpass';