In this tutorial you will learn how to install and test MySQL on Ubuntu Server.
Code used during this tutorial:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
# Install MySQL on Ubuntu Server # Install some other "helper" packages that will assist us in getting our components to communicate with each other sudo apt-get update sudo apt-get install mysql-server php5-mysql # Tell MySQL to create its database directory structure where it will store its information sudo mysql_install_db # Run a simple security script that will remove some dangerous defaults and lock down access to our database system a little bit sudo mysql_secure_installation # Connect to MySQL using CLI mysql -uroot -p mysql -uroot -ppasswd show databases; # Test using MySQL Workbench Start New Connection (+ icon) Connection name: http.liviubalan.com Connection Method: TCP/IP over SSH SSH Hostname: http.liviubalan.com:22 SSH Username: liviu Password: Store in Keychain ... # For better performance you may have a dedicated MySQL machine Useful links: https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-14-04 |
Useful links:
https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu-14-04