![]() ![]()
Optimize MariaDB (advanced users only)Īgain, same with MySQL, you can use MySQLTuner to check your MariaDB and get recommendations on how to improve it. You can enter the default for each prompt. Run the security script with the following command: mysql_secure_installationĪnd follow the prompts. #Mariadb phpmyadmin ubuntu 20.04 installInstall MariaDBĪfter you’ve added the MariaDB repository, you can install it by running the following command: apt-get install mariadb-serverĪnd that’s it. #Mariadb phpmyadmin ubuntu 20.04 updateNext, you need to update your package list again: apt-get updateĪnd move onto installing MariaDB. Sudo add-apt-repository 'deb focal main'Īgain, this command will be different depending on the distro you’re using and the version of MariaDB you want to install. We use Ubuntu 20.04 and we chose a random mirror, so we’ll run these commands to add the repository: sudo apt-get install software-properties-common dirmngr apt-transport-https Then, copy the commands you’ll get on the page. #Mariadb phpmyadmin ubuntu 20.04 upgradeUpdate Ubuntuįirst, update your Ubuntu server: apt-get update & apt-get upgrade Add the MariaDB repositoryīefore you can install MariaDB, you need to add the MariaDB repository.ĭepending on your Ubuntu release, you may need to run different commands, so go to the official MariaDB repository page, select your distro and choose a mirror closest to your server’s location. Now for our MariaDB installation instructions. There are other optimizations you can do on your server and databases, so do your own research if you want to further optimize MySQL. You can repair all your databases with a single command: mysqlcheck -A -auto-repair -u root -p You can also use mysqlcheck to repair your databases. If you don’t know what you’re doing, contact someone else and let them do it for you or just skip this. Do some research and use google for each recommendation. The script will only give you recommendations on how you can improve and optimize your MySQL.ĭownload and run the script with the following command: curl -L | perlĪnd check the recommendations. To optimize your MySQL, you can use the MySQLTuner script. You can respond with the default to each prompt. Start the script with the following command: mysql_secure_installationĪnd respond to the prompts. You should run the mysql_secure_installation script that will help you secure your MySQL. Now, you need to secure and configure it. You’ll get a prompt to enter a password for your root user. This command will install both the MySQL server and client. Then, install MySQL by running the following command: apt-get install mysql-server Update Ubuntuįirst of all, as always, before you do anything else, update your Ubuntu server by running the following command: apt-get update & apt-get upgrade Install MySQL If you want to install MariaDB, skip to the MariaDB instructions. You can check if they’re installed by entering “mysql” or “mariadb” and you should know based on the output. MySQL/MariaDB may already be installed on your server.You’ll need SSH enabled if you use Ubuntu or an SSH client like MobaXterm if you use Windows.You’ll likely have to if you use a non-root user. ![]() The commands below are all executed by a root user, so we didn’t have to append ‘sudo’ to each command.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |