Advanced Search

mysql make access global

/ Published in: MySQL
Save to your folder(s)
This commands are useful in creating a username in mysql and it can be used to access the mysql globally with this username.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
  2. mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
  3.     ->     WITH GRANT OPTION;
  4. mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
  5. mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
  6.     ->     WITH GRANT OPTION;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.