How to Host a MySQL Server on Linux

Profile Picture
Published on Oct 11, 2019🌏 Public

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 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 [email protected]'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.instagram.com/tech_with_tim Website https://techwithtim.net Twitter: https://twitter.com/TechWithTimm Discord: https://discord.gg/pr2k55t GitHub: https://github.com/techwithtim Podcast: https://anchor.fm/tech-with-tim One-Time Donations: https://www.paypal.com/donate/?token=... Patreon: https://www.patreon.com/techwithtim * Please leave a LIKE and SUBSCRIBE for more content! Tags: - Tech With Tim - Python Tutorials - MySQL Tutorial - How to host a MySQL server on linux - Host mysql server on linux - Linux install mysql - Remote connection to mysql #Python #MySQL #MySQLLinuxServer