jverweijL/create-db-and-user.md

Last active July 6, 2018 08:15

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jverweijL/c9a218f101b6a1d4c593606c68092a93.js"></script>
Save jverweijL/c9a218f101b6a1d4c593606c68092a93 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

create-db-and-user.md

CREATE DATABASE liferay71;
CREATE USER 'lportal'@'localhost' IDENTIFIED BY 'my-strong-password-here';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON liferay71.* TO 'lportal'@'localhost';
FLUSH PRIVILEGES;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment