The Ubuntu operating system is open source software that is not used by too many people. However, programmers know this is one of the best systems to do the system programming work. However, there are some who do not like all programs as in the case of MySQL.
For these reasons, it will be explained how to uninstall MySQL program from Ubuntu 20.04. We will also see the functions of this program in the various operating systems that exist.
What is the MySQL function in Ubuntu?
The MySQL program is a used software for creating and managing databases. It is widely used to make programming using open source. These features are the functions of the program in general and are suitable for all operating systems.
In Ubuntu is no exception, in fact, it works better, because both will use free code. The language that this program handles is indicated by its SQL name. Which is common create, modify, and extract information of the databases created in that program.
When you have the Ubuntu operating system you can have different programs which are common to other operating systems. For example, you can install Skype for Ubuntu 20.04.
How to connect to the remote MySQL server?
There are a few things you should install or uninstall MySQL on devices with Ubuntu 20.04. First of all, you must have downloaded and installed the Ubuntu operating system on your device, in the version mentioned above.
In the same way, with the system already installed and using it, you must have the program installed. The reasons for removing MySQL are inherent in each person. But if you’re a programmer you must have this application because is one of the best database servers out there.
To connect to the server, we must first know the IP address we are browsing that day. As, password and user data MySQL application required. The command described below must be entered to start as root in this software. Ssh [email protected]_DEL_SERVER after that, you need to enter the password associated with the root user.
Then you can continue to uninstall the database software. Also, because you are at the root, you can take advantage install other applications. For example, you can install Google Chrome on Ubuntu in a fairly simple way.
Can I back up this service?
All data that is created in MySQL are saved in a folder within the operating system. Therefore, you only need to search for this folder that contains the application data to find out where it is.
So no need to back up because the data is already stored. What you can do is make sure that you save that information so that it is not lost later.
So if you uninstall MySQL from Ubuntu and then reinstall it. You will be able to access the data that you have already saved in the same way that any database is open. Now, if you do not want to save data, then you need to delete the MySQL database. In this way, nothing is savedor and if you want to continue using the application, you need to recreate the databases and complete them.
In other words, if the command that deletes all data is used, then if you should back up. Therefore, you need to start by writing sudo tar –zcvf, then fill it in with ~ / msql_backup.tar.gz/etc/mysql/var/lib/mysql.
Steps to uninstall it from the terminal
To uninstall MySQL from your Ubuntu computer, type first sudo apt get. This is to make the call, which must be completed with purge mysql *.
After that, you have to type sudo again, but next to rm then copy -rfv / etc / mysql / var / lib / mysql. The next two lines start with the sudo apt command. The first one has to work accompanied by the word autoremove while the second will continue with the word autoclean. After all this, you will no longer have the MySQL program on your computer.
How to reinstall MySQL after uninstallation?
Once the program has been uninstalled you can reschedule to reinstall it. In this regard, a procedure similar to the previous one must be performed in order to have the software again.
So from the root terminal we have to copy the commands again start with sudo apt. After these words you need to write update to start the installation. After pressing Enter, you need to type sudo apt again, but now followed by installation.
The following command appears in the same line as the previous words mysql-server mysql-client. This command ends with the words – fix-broken – fix-missing in the same line as previously written. Then press Enter and start installing MySQL on the Ubuntu system.