Create database and user mysql

$ mysql -u root -p
> create database _db_ CHARACTER SET utf8;
> grant usage on *.* to [email protected] identified by '_dbpass_';
> grant all privileges on _db_.* to [email protected] ;

Replace

_db_ - database name
_dbusr_ - db username
_dbpass_ - db password

Or consider CLI tool:

mysqladmin create _db_

Nov 06, 2016

by Ivan Borshchov

Did it help you?

Yes !

Best related

SQL Query Optimization: Understanding Key Principle

How to reset mysql root password on ubuntu

How to backup SQL Database [Simple ready to use script]