Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SHELL

connect to Remote MySQL server

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;
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #connect #Remote #MySQL #server
ADD COMMENT
Topic
Name
1+1 =