How to create user and grant access to mysql database

On a default settings, mysql root user do not need a password to authenticate from localhost. In this case, you can login as root on your mysql server using:

$ mysql -u root

If a password is required, use the extra switch -p:

$ mysql -u root -p
Enter password:

Now that you are logged in, we create a database:

mysql> create database sample_db;
Query OK, 1 row affected (0.00 sec)

We allow user dbuser to connect to the server from localhost using the password dbpasswd:

mysql> grant usage on *.* to dbuser@localhost identified by 'dbpassword';
Query OK, 0 rows affected (0.00 sec)

And finally we grant all privileges on the sample_db database to this user:

mysql> grant all privileges on sample_db.* to dbuser@localhost ;
Query OK, 0 rows affected (0.00 sec)

And that’s it. You can now check that you can connect to the MySQL server using this command:

$ mysql -u dbuser -p'dbpassword' sample_db
Your MySQL connection id is 12
Server version: 5.0.38-Ubuntu_0ubuntu1-log Ubuntu 7.04 distribution
 
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
 
mysql>
Advertisements

One thought on “How to create user and grant access to mysql database

  1. Pingback: Creating Secure File Upload/Download sites using UBUNTU Server | Andrew's blog of things

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s