ILIAS-7-Install-Tutorial for Ubuntu 20.04
Database and DB-User
How to Create MySQL-Databases
Do NOT use the sign/type hypen - in dbnames or passwords along with mysql!
Create a Database
- You need several Databases for all the services you want:
- Every ILIAS-Installation needs one
- One for Etherpad-Lite
- ..
mysql- Create Database "etherpadlite1": mysql>
CREATE DATABASE ilias CHARACTER SET utf8 COLLATE utf8_unicode_ci;
- exit mysql: mysql>
exit
Create a user for a database and assign him to the ILIAS database
For now we run our ILIAS client with mysql root rights. So this is very unsecure. Every client should have its own Database user. So we create one.
mysql- 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'; exit
Other MySQL instructions
- 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 '