How to Host a MySQL Server on Linux

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:    • Python MySQL Tutorial - Setup & Basic...  

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:   / tech_with_tim  
🌎 Website https://techwithtim.net
📱 Twitter:   / techwithtimm  
⭐ Discord:   / discord  
📝 LinkedIn:   / tim-rusci.  .
📂 GitHub: https://github.com/techwithtim
🔊 Podcast: https://anchor.fm/tech-with-tim

💵 One-Time Donations: https://www.paypal.com/donate/?token=...
💰 Patreon:   / 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