How to use Etherpad Lite with MySQL

How to use Etherpad Lite with MySQL

1. Connect to mysql by opening a command prompt and typing the following: mysql -u root -p
2. Once logged in, issue the following command to create the database: create database etherpad-lite;
3. Grant permissions to a new database account. Replace and with your own values. grant all privileges on etherpad-lite.* to '<user>'@'localhost' identified by '<password>';
4. Leave the mysql client exit
5. Edit settings.json in your Etherpad Lite root folder and change the database settings (if you have a non-default port configured for MySQL you will have to add the "port" setting).
6. Run etherpad lite
7. Exit, and run:

ALTER DATABASE `etherpad-lite` CHARACTER SET utf8 COLLATE utf8_bin; ALTER TABLE `store` CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;