MySQL Create Database

To create a database using the MySQL command-line

/usr/local/mysql/bin/mysql -u root -p

create database abc;

MySQL – granting permissions

Grant access to everything locally

grant all on *.* to 'me' [identified by 'password']

Grant access to everything from any host

grant all on *.* to 'me'@'%' [identified by 'password']