Create a mysql database

$> mysql -u 'root' -p

mysql> create database atestdatabase;
mysql> create user 'myuser'@'localhost' identified by 'secret';
mysql> grant all on atestdatabase.* to 'myuser'@'localhost';

Leave a Reply