How to Host a MySQL Server on Linux

From the creator

In this video I will be showing how to host a MySQL server on a linux server. This involves downloading and installing MySQL on the linux server and configuring it so that it can be connected to remotely. In the last parts of the video I will demonstrate how to connect to the server from python code. Thanks to linode for sponsoring this video! Take advantage of a free $20 credit towards a linode with the code "TWT19". https://linode.com/techwithtim Download Putty: https://www.putty.org Playlist: https://www.youtube.com/watch?v=3vsC05rxZ8c&list=PLzMcBGfZo4-l5kVSNVKGO60V6RkXAVtp- Process and Linux Commands Once you have logged into the linux server run the following: sudo apt-get install mysql-server sudo mysql_secure_installation utility sudo ufw enable # allows remote access sudo ufw allow mysql sudo systemctl start mysql sudo systemctl enable mysql cd to /etc/mysql/mysql.conf.d/mysqld.cnf change bind to 0.0.0.0 sudo systemctl restart mysql # restart mysql Now obtain your PUBLIC IPV4 Address from the machine you want to connect with. mysql -u root -p create database Test Get ip address GRANT ALL ON fooDatabase.* TO fooUser@'PUBLIC IPV4 ADDRESS' IDENTIFIED BY 'some password' Then you can connect to the linux servers ip address as the host attribute for the MySQL connection. Use the username you set in the last command and the password. ◾◾◾◾◾ 💻 Enroll in The Fundamentals of Programming w/ Python https://tech-with-tim.teachable.com/p... 📸 Instagram: https://www.ins

Published 2019-10-11 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.