How to Add and Drop MySQL Users

Most MySQL users manage their databases using some type of graphical user interface (GUI), whether it is a web-based tool like phpMyAdmin or a desktop tool like MySQL Administrator. For a dedicated server system administrator, however, there are times when it may actually be more convenient to use queries in the MySQL text-only command line interface.

You can easily add and drop users from MySQL, each with a single command string. Assuming you are already logged into your server via the physical console or SSH, the first thing you need to do is login to the MySQL command interface.

# mysql -p

You will then be prompted for your MySQL password. Type it and press Enter. If the login is successful, your normal shell prompt will be replaced by the MySQL prompt:

mysql>

To add a user, type the following string at the prompt:

mysql> CREATE USER user@host IDENTIFIED BY 'password';

Replace “user” with the username you want to create and “host” with your server IP or “localhost” for the current machine.

To remove a user, type the following:

mysql> DROP USER user@host;

Related Posts











Comments: