Setup New Database On My Sql

Posted by Weston Ganger

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;

Article Topic:Software Development - Linux

Date:April 28, 2014

Recommended Posts

Contact

604-309-8713
info@solidfoundationwebdev.com

Send Me A Message

I would love to get in touch and talk about your next project. Feel free to send a message and I will get back to you shortly.

Get Connected