without password:
mysql> CREATE USER 'luna'@'localhost';
mysql> CREATE USER 'luna'@'localhost' IDENTIFIED BY 'maya'
If you want the user can access from anywhare of the client host, use
mysql> CREATE USER 'luna'@'%' IDENTIFIED BY 'maya';
Monday, March 7, 2011
MySQL - Creating User
There are many ways to create user in MySQL database:
without password:
with password:
If you want the user can access from anywhare of the client host, use
mysql> CREATE USER 'luna'@'%' IDENTIFIED BY 'maya';
without password:
If you want the user can access from anywhare of the client host, use
mysql> CREATE USER 'luna'@'%' IDENTIFIED BY 'maya';
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment