LU01.S03 - Installation and configuration of the MySQL database

• The result is fully functional database which that runs on your PC.
• The function test includes a sucessful login as a database-root user and a response from the database in form of a system date.

1. create a file .bash_profile under home
2. create a export link to you mysql Installation
3. Connect with the db: mysql -u root -p
4. Type in you root Password, which was chosen while the installation of mysql
5. Check the basic functionality of your installation by displaying all databases that are currently installed on the db.
6. Command, which is needed in the terminal: „SHOW DATABASES;“

In order to connect our operting system with our db we need to register the installation path from MySQL in the variables of Windows.

1. find the installation path of MySQL > bin and copy it, e.g. „C:\Program Files\MySQL\MySQL Server 8.0\bin“
2. Press WINDOWS-Button + env
3. Select the Button „Umgebungsvariablen“, which is located on the bottom of the presented window.
4. Create a new Variable by pressing the „Neu“ Button.
5. Add PATH + the copied path of MySQL/bin + Save the new enviroment variable
6. Open a cmd-box (commandline) and connect to the database with your database credentials by typing: „mysql -u root -p“ + password + enter. Hopefully you were successful.

1. Check the basic functionality of your installation by displaying all databases that are currently installed on the db. Command, which is needed in the terminal: „SHOW DATABASES;“

Volkan Demir