Database Programming 02b: Setting up your Linux Development Environment

This video will show you how to get your Linux operating system setup for MySQL C/C++, Java and Python database development. If you wish to learn how to setup a Virtualized Linux on your Mac or Windows, here is a video to show you how to do that: 1) Setting up your BIOS: https://youtu.be/u_m1NO7uHOU 2) Installing VirtualBox and Linux: https://youtu.be/jo-6duFVFQE Video 01 (Previous): Introduction to Database Programming: https://youtu.be/Go_xB486y2c Video 02a: Setting up your Windows Development Environment: https://youtu.be/r7rabuf-_pk Video 02c: Setting up your Apple Mac Development Environment: Coming Soon Linux Commands to get most everything installed - Open a Terminal - Type the following commands: sudo apt update sudo apt upgrade sudo apt install -y build-essential sudo apt install -y mysql-server sudo apt install -y mysql-client sudo apt install -y default-libmysqlclient-dev sudo apt install -y libmysqlcppconn-dev sudo apt install -y python3-pip pip install mysql-connector-python - Download the Ubuntu connector: https://dev.mysql.com/downloads/connector/j/ - Right click on the file and open it in the application installer - Download MySQL Workbench: https://dev.mysql.com/downloads/workbench/ - Do not select dbsym version(s) - Right click on the file and open it in the application installer - To configure your MySQL, Open a Terminal and type the following: sudo mysql -u root drop user 'root'@'localhost'; create user 'root'@'localhost' identified by 'password'; grant all privileges on *.* to 'root'@'localhost' with grant option; create user 'root'@'*' identified by 'password'; grant all privileges on *.* to 'root'@'*' with grant option; flush privileges; exit - Back in terminal, type the following commands: sudo mysql_secure_installation Press ENTER on everything except the last Press Y for reload privileges - To install the test Employees database: Download the employee test database: https://dev.mysql.com/doc/employee/en/ Click on the Employees on Github link Code, Download Zip Unzip the file From a terminal, type: mysql -u root -p -t xx employees.sql The xx should the the less than sign (YouTube won't let me use that symbol) Exit the terminal