Return to Snippet

Revision: 73343
at June 21, 2018 20:02 by surentharp


Initial Code
mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    ->     WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    ->     WITH GRANT OPTION;

Initial URL


Initial Description
This commands are useful in creating a username in mysql and it can be used to access the mysql globally with this username.

Initial Title
mysql make access global

Initial Tags
mysql

Initial Language
MySQL