History Download

MySQL create user and database

These sql statements should be executed by root.
Adds a user + database + flushes privileges.

by humancoder 2 years ago and tagged with: mysql mysql-hacks sql 
1
2
3
 
GRANT ALL PRIVILEGES ON `new_database`.* TO 'user'@'localhost' IDENTIFIED BY 'password';
CREATE DATABASE new_database;
FLUSH PRIVILEGES;

Currently 0 comments

To post a comment, you must login.