Create LMS database on MySQL

To install ensure the LMS can store data, first of all we are going to create a database and a user. To create a user and database login to mysql as root. Enter the below command.

sudo mysql -u root -p

1. Create a database by entering the command below. Note down the details. (Replace <database_name> with an actual name for the database)

create database <database_name>;

2. Create a user and grant permissions needed. (Replace <user> and <password> with actual details).

GRANT ALL PRIVILEGES ON <database_name>.* TO ‘<user>’@’localhost’ IDENTIFIED BY ‘<password>’;

FLUSH PRIVILEGES;

NOTE: If you perhaps get a syntax error of some sort, delete and retype the quote marks.

3. Exit the mysql shell by typing out exit

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.