Friday, 22 April 2011

Manage users in MySQL


## show all users
mysql> select host, user, password from mysql.user;

## create user
mysql> CREATE USER 'micharg'@'%' IDENTIFIED BY 'micharg1234';

## delete user
mysql> drop user micharg;

No comments:

Post a Comment