MySQL has gathered a tremendous audience due its ease of use to handle the databases. It is often referred to as Relational Database Management System (RDBMS). The reason behind its popularity is that it is compatible with almost every platform like BSDi, FreeBSD, Microsoft Windows, Oracle Solaris, Linux, etc.
MySQL operates as a client-server software, there can be numerous clients which can query to a server system, changes can also be made by a client system to the data on the front-end but not on the back-end. MySQL stores data using the database engines, but the user will not interact with it. They only deal with the database.
Why MySQL in Ubuntu?
If we talk about the use of MySQL in Ubuntu, we must know that the server administration can be best handled by the Linux operating system, therefore, many people prefer to handle their Databases via MySQL. Now you may be thinking of why not SQL Server 8 because it’s not directly handled through the Linux system. For that we have to install Wine, that may not be your choice. There are various features of MySQL due to which you may opt for this database handler, some of them are:
- Easy to Use
In order to have a Graphical tool for designing the database and administrating it, you must use MySQL Workbench. However, you can go for phpmyadmin also, but the major difference between the two is that, ‘MySQL Workbench’ provides the comfort to administrate multiple Databases and better customizing options as compared to the ‘phpmyadmin’. Your perception matters a lot.
Steps to Install MySQL in Ubuntu using Terminal
Step 1: Firstly, you should install the update using the “Advance Packaging Tool” which is a package management tool, if you have recently installed Ubuntu, then type “sudo apt-get update” and press enter, so that all the packages get updated.
Step 2: In order to install “MySQL Server”, just type “sudo apt-get install mysql-server”, and press enter. Through “apt” it is easy to install MySQL Server.
Step 3: Once you press enter, some sort of processing will be done, you may get information about the amount of extra memory needed. Type “y” to continue.
Step 4: Soon the installation will get started, it may take a while to properly install the mysql server. Then, it will ask you to set a password so as to personalize the server. It is optional, you can set it later on using the command “mysql_secure_installation”.
Here, I have set the password and selected “OK” using the arrow keys.
Step 5: In the next step you are required to repeat the password and click “OK.”
Step 6: Now, it’s properly configured. You can safely interact with the client program using the command “mysql -u root -p”. Press enter.
Step 7: Provide the password which you have already set for MySQL.
Step 8: In case you are required to change or have forgotten the password, use the command “dpkg-reconfigure mysql-server”.
Step 9: “MySQL >” will be visible to you, now you can create the database and manage it accordingly.
To go back to Ubuntu, press “Ctrl + d”.
Step 10: To stop the server, write “sudo mysql service stop” and press enter. Similarly, you can use, start or restart in place of stop to again start it.
It’s done, enjoy the experience of handling the databases with this free software.