MySQL Installation on ubuntu Server – Learn more about MySQL and master how to use it.
What is MySQL?
MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use.
Remember the best way to learn any new technical skill, is to play around and see how things work. Get comfortable you’re few steps in right direction. Click HERE to Order Your VPS NOW! so that you can gain the practical experience needed.
Now 50% OFF! VPS hosting solutions optimized for you: Click HERE to Order NOW!
Now, to install MySQL, run the following command from a terminal prompt:
root@gs2~# apt-get install mysql-server && apt-get install mysql-client
During the installation process you will be prompted to enter a password for the MySQL root user.
Once the installation is complete, the MySQL server should be started automatically. You can run the following command from a terminal prompt to check whether the MySQL server is running:
root@gs2~# netstat -tap | grep mysql
When you run this command, you should see the following line or something similar:
tcp 0 0 localhost:mysql *:* LISTEN 2194/mysqld
If the server is not running, nothing will be displayed, you can type the following command to start it:
root@gs2:~# service mysql start && service mysql restart mysql start/running, process 2611 mysql stop/waiting mysql start/running, process 2700 root@gs2:~#
You can edit the /etc/mysql/my.cnf file to configure the basic settings: log file, port number, etc.
That’s it for today,
In the next guide I will provide a basic step-by-step guide on how to improve the security of your MySQL installation!!!