Mysql

From XPUB & Lens-Based wiki
Revision as of 17:05, 26 June 2019 by Michael Murtaugh (talk | contribs) (Created page with "== Create a database + user for a project == <source lang="bash"> sudo su mysql -u root </source> <source lang="mysql"> create database FOO; grant all on FOO.* to FOOUSER@'l...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Create a database + user for a project

sudo su
mysql -u root
create database FOO;
grant all on FOO.* to FOOUSER@'localhost' identified by 'FOOPASS';

This creates a database named FOO with user FOOUSER and password FOOPASS;