![]() Enter your MySQL password when prompted.Choose YES when asked about whether to Configure the database for phpmyadmin with dbconfig-common.Once the process starts up, follow these steps: Sudo apt-get install phpmyadmin apache2-utilsĭuring the installation, phpMyAdmin will walk you through a basic configuration. The easiest way to install phpMyAdmin is through apt-get: If you don't have the Linux, Apache, MySQL, PHP stack on your server, you can find the tutorial for setting it up here. We believe this guide will help you to manage your MySQL database better.Before working with phpMyAdmin you need to have LAMP installed on your server. For security reasons, never configure your websites to run using the root user of your MySQL database.Īlso, you should consider installing an SSL certificate to protect your phpMyAdmin login details from landing into the wrong hands especially if you are logged into to your server on a public network. ![]() You have now configured phpMyAdmin on your Ubuntu 18.04 server and managing your databases will be a breeze. If the details are correct, you will get the below phpMyAdmin User Interface and you can now manage your database by creating tables, adding fields, indexes, inserting, updating and deleting record. You should see a screen similar to the one belowĮnter your username and password to proceed. Remember to change the IP address with your public IP address associated with your Ubuntu 18.04 server or domain name. You can visit the url on your server to test the installation. If you followed the above steps, your phpMyAdmin installation should be successful. If you miss any of the steps below, you can reconfigure phpMyAdmin by running the command below: $ sudo dpkg-reconfigure phpmyadminĪlso if you want to completely remove phpMyAdmin and start all over, run the command below: $ sudo apt-get purge phpmyadmin You will be prompted to confirm the password one more time as shown below. Then press TAB and and Enter to proceed as shown below: Kindly type a strong password with a mix of lower case letters, upper case, numbers and symbols for security purposes. Next, create an application password for phpMyAdmin. Select ‘ Yes’ and press Enter to proceed. On the next screen, you will be prompted to configure a database that phpMyAdmin will use for administration purposes. Choose apache2, then click TAB and Enter to proceed as shown below: The first step prompts you to choose a server from apache2 and Lighttpd. ![]() You will be taken through a series of steps to configure your phpMyAdmin installation. $ sudo apt-get install mysql-server Step 1: Go to HostAdvice’s best PHP hosting, best VPS hosting, or best Linux Hosting to find the best rated web hosts in these categories. Special note: If you haven’t yet purchased a hosting plan, we recommend that you consult with HostAdvice’s expert and user reviews before doing so. You can run the command below to install MySQL on your Ubuntu 18.04 server if you haven’t done so. In this guide, we will show you how you can install phpMyAdmin on your Ubuntu 18.04 server Prerequisites MySQL and phpMyAdmin are the de facto standards for managing most modern web applications databases. MySQL is quickly replacing commercial database management system and is considered as one of the best database software for a production environment. This is where phpMyAdmin comes in to help you manage tables, columns, indexes, users, permissions and more using a graphical user interface. The portable web application can manage both MySQL and MariaDB.Įxecuting commands and managing MySQL database from the command line is not very intuitive especially if you are performing a lot of database tasks. PhpMyAdmin is one of the most popular open-source database administration software written in PHP.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |