Youtor
How to Host a MySQL Server on Linux
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=WltqUaqxBH8
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
#############################
