This script will ask you to set the root user password, restrict root access to localhost, remove anonymous users, and remove the test database. Purging your config/data too.
I even attempted to install mysql 5.7, but no dice there either. This will remove the mariadb-server package and any other dependant packages which are no longer needed.
On Ubuntu systems running MariaDB 10.3, the root MariaDB user is set to authenticate using the unix_socket plugin by default rather than with a password.
The views, information and opinions Uninstall mariadb-server and its dependencies sudo apt-get remove --auto-remove mariadb-server.
Remove the MariaDB package from the system using the purge command. Follow these steps to uninstall completely existing MySQL from server.
If you want to remove MariaDB, the packages will be named differently: mariadb-server mariadb-client.
This allows for some greater security and usability in many cases, but it can also complicate things when you need to allow an external program (e.g., phpMyAdmin) administrative rights.
It is perfectly compatible with MySQL and is available in most Linux distributions. It is maintained and developed by the MariaDB Foundation including some of the original developers of the MySQL.. I installed mariadb 10.3 on my Ubuntu 16.04 server, and then managed to break it. You can verify it by typing:To install MariaDB 10.3 on your Ubuntu 18.04 server perform the following steps:First add the MariaDB GPG key to your system using the following command:To be able to install packages from the MariaDB repository you’ll need to update the packages list:Now that the repository is added install the MariaDB package with:The MariaDB service will start automatically, to verify it type:The script will prompt you to set up the root user password, remove the anonymous user, restrict root user access to the local machine and remove the test database.