Mysql user creation - setting up a MySQL new user account
When you try to access MySQL database server from client such as mysql or even programming language such as php or perl you need a user account. MySQL has sophisticated user management system that controls who can access server and from which client system. It uses special tables in mysql database. In order to create a new user account you need a MySQL root account password.
Next you need to use the GRANT SQL command to set up the MySQL user account.
Finally, use the account's name and password to make connections to the MySQL server.
Please note that MySQL user accounts are different from UNIX/Linux login accounts. For example, the MySQL root user and the Linux/Unix root user are separate and have nothing to do with each other, even though the username is the same in each case.
Procedure for setting up a MySQL user account
Login in as mysql root user (at shell prompt type following command:):
$ mysql -u root -p
OR
$ mysql -u root -h myserver-sever.com -p
Create a new mysql database called demo
mysql> CREATE DATABASE demo;
Create a new user called user1 for database demo
mysql> GRANT ALL ON demo.* TO user1@localhost IDENTIFIED BY 'mypassword';
Note: GRANT ALL means all privileges i.e. user is permitted do anything. She can read, modify or delete data, but only on tables in the demo database. She cannot access any other database.
How do I connect to MySQL server using user1 account?
User user1 can connect to mysql server demo database using following command:
$ mysql -u user1 -p demo
OR
$ mysql -u user1 -h mysql.server.com -p demo
Where,
- -u user1: MySQL Username
- -h : MySQL server name (default is localhost)
- -p : Prompt for password
- demo: demo is name of mysql database (optional)
Subscribe to our free e-mail newsletter or RSS feed to get all updates.
You can Email this page to a friend.
Related Other Helpful FAQs:
- How do I access MySQL server from the shell prompt (command line)?
- MySQL startup script under BSD/Linux
- Securing MySQL server
- PHP not connecting to a MySQL database server
- MySQL Change root Password
Leave a Reply
We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Thank you very much for stopping by our site!
Tags: create_mysql_user, Linux, mysql_command, mysql_database_server, mysql_server, UNIX, user_accounts
Recent Comments
Today ~ 5 Comments
Today ~ 1 Comment
Yesterday ~ 1 Comment
Yesterday ~ 2 Comments
Yesterday ~ 10 Comments