Create MySql database and user - command line

The MySql server is a commonly used database server in web applications. To manage database and content, we have too many GUI tools like phpMyAdmin and adminer etc.

But it is essential to familiarize basic commands to manage a MySql server via command line.

Login to mysql as root user.

mysql -u root -p

it will ask for mysql root password

If you entered correct password, you should now be at a MySQL prompt that looks very similar to this:

mysql>

Then create our database.

CREATE DATABASE IF NOT EXISTS sample_database;

To view the database you’ve created, use the following command.

SHOW DATABASES;

Your result should be similar to this:

mysql> SHOW DATABASES;

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
| sample_database    |
+--------------------+
4 rows in set (0.00 sec)

Create new user with password

CREATE USER 'db_user'@'localhost' IDENTIFIED BY 'my_password';

Grand permission to new user on new database.

GRANT ALL PRIVILEGES ON sample_database.* TO 'db_user'@'localhost' IDENTIFIED BY 'my_password';

Once you have finalized the permissions that you want to set up for your new users, always be sure to reload all the privileges.

FLUSH PRIVILEGES;

Recent Posts

1. Disabling Payment Methods in WooCommerce Based on Conditions
2. How to Update Product Quantity in WooCommerce Using Custom Code
3. Dynamically Generating a Table of Contents in WordPress
4. Direct Checkout in WooCommerce - Add Product to Cart from Checkout Page & Skip Shop, Product, and Cart Pages
5. Understanding the Impact of git reset --hard Command

This article was published on May 27, 2016

Your Questions / Comments

If you found this article interesting, found errors, or just want to discuss about it, please get in touch.