Mysql

Setup New Database On My Sql

Posted by Weston Ganger on April 28, 2014

In the mysql prompt:


CREATE DATABASE mydb;
CREATE USER user@localhost;
SET PASSWORD FOR user@localhost= PASSWORD("password");
GRANT ALL PRIVILEGES ON mydb.* TO user@localhost IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

Posted in Linux and Tagged with mysql database-setup 


Need help on your next project or application?

I specialize in Ruby-on-Rails, AngularJS, Javascript, Bootstrap, and Hybrid Mobile Apps with Cordova & Ionic.

Contact Me

Recommended Posts