ILIAS 6 and 5.4 Install-Tutorial for Ubuntu 18.04
Create Databases and DB-Users
How to Create MySQL-Databases
- You need several Databases for all the services you want:
- Every ILIAS-CLient needs one
- One for Etherpad-Lite
- ..
mysql- Create Database "ilias": mysql>
CREATE DATABASE ilias CHARACTER SET utf8 COLLATE utf8_unicode_ci; - Create Databaseuser "dbuser1": mysql>
CREATE USER 'dbuser1'@'localhost' IDENTIFIED BY 'USER_PASSWORD'; - Give user "dbuser1" rights to database "Ilias": mysql>
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON ilias.* TO 'dbuser1'@'localhost' IDENTIFIED BY 'USER_PASSWORD';
- If you want do delete a user: mysql>
DROP USER dbuser1@localhost; - Change user password:
mysql> SET PASSWORD FOR 'dbuser1'@'localhost' = PASSWORD('NEW_USER_PASSWORD'); - If you want to delete a database: mysql>
DROP DATABASE ilias;
- Show all Databases: mysql>
SHOW DATABASES; - Show all Users: mysql>
SELECT User FROM mysql.user;
- exit mysql: mysql> exit
- For database names and passworts I recommend to use only the following characters:
- [a-z], [A-Z], [0-9]
- Avoid chars like $%&/ - etc. If you use them, try this quotes ` instead of '