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. Replace string in multiple files - Command line
  2. Solve Grunt error - Port 35729 is already in use by another process
  3. Install WP-CLI
  4. Install LAMP - Apache2 , MariaDB, PHP 7 on Debian 8
  5. Enable / Disable Magento 2 module using command line


Questions / Comments

If you found this article interesting, found errors, or just want to discuss about them, please get in touch. Send an email to hello@sarathlal.com & I like your words.