Yusuf Ozturk » How to create MySQL database and user via command line?

Blogroll

Badges

Community

How to create MySQL database and user via command line?

Posted in Linux Server | No Comment | 2,326 views | 27/12/2011 09:33

You can create MySQL database and user via command line.

CREATE DATABASE dbname;
CREATE USER 'dbusername'@'localhost';
SET PASSWORD FOR 'dbusername'@'localhost' = PASSWORD('PASSWORD');
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,ALTER,CREATE TEMPORARY TABLES,LOCK TABLES,REFERENCES ON dbname.* TO `dbusername`@`localhost` WITH GRANT OPTION;

That gives only localhost grant on MySQL server.

Tags: mysql create database, mysql create user