SQL

How to create database and user in MySQL

How to create database and user in MySQL

Most web hostings have GUI for database management by when we don’t have GUI it is necessary to know how to create database and user in MySQL from terminal.

Here is a simple example of how to do it in MySQL.

In ssh terminal enter theMySQL:

After successful login type following rows to create database and user in MySQL:

Where:

DB_NAME  – database name

my_user  – user for database

my_password  – password for user

3 thoughts on “How to create database and user in MySQL

  1. Excellent post. Keep posting such kind of info on your page.
    Im really impressed by your site.
    Hi there, You’ve performed a fantastic job. I will certainly digg it and
    personally recommend to my friends. I am confident they’ll be benefited from this site.

Leave a Reply

Your email address will not be published. Required fields are marked *