[Tech With Tim] How to Host a MySQL Server on Linux
*** Python에서 MySql과 Sql 사용하기 5
- Hosting a MySQL Server on a Linux
*** Download Putty: https://www.putty.org
*** Playlist: https://www.youtube.com/watch?v=3vsC0...
*** 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.
댓글
댓글 쓰기