![]() ![]() This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. To ease usage to a wide range of people, phpMyAdmin is being translated into 72 languages and supports both LTR and RTL languages. It provides a user friendly web interface to access and manage your databases. So if you want to use web interface for the database management on LAMP server then follow this tutorial properly and enjoy.PhpMyAdmin is web-based client written in php for managing MySQL and MariaDB databases. Now phpMyAdmin is an essential tool for any web developer to make database tasks easier. The user needs to use the tab options to perform various type important database operations, such as create or drop database or table, execute SQL, export or import database, create or drop trigger etc. The top of the right panel contains menu tab. This shows phpMyAdmin version and other related information. This panel shows information of web server, database client and PHP. ![]() This panel shows different information about the database server, such as, server name, type, version, connected username, charset etc. You change the language, theme, font size and other appearance related setting from this panel. You can use this panel to show the list of MySQL charset and change MySQL connection collation. The uses of these panels are explained shortly here. Five sub panels of cPanel page are General settings, Appearance settings, Database server, Web server and phpMyAdmin. Right panel contains different database server information and tab options to perform particular database tasks. You have to click on ‘+’ button of the particular database to show the tables, procedures and views. Left panel shows the list of all existing databases, tables, procedures and views. The following page will appear after login. Now, login to the server by providing root or newly created user credentials. Open any browser and type the following URL to check that phpMyAdmin is working properly or not. Configuration for root User:Ĭonnect with the database server and check the current authentication method of root user. You can also create new user account to access phpMyAdmin. If ‘ auth_socket’ plugin is loaded for root user then change the authentication method of root user from ‘ auth_socket’ to ‘ mysql_native_password’ for security purpose. root user can use ‘ auth_socket’ or ‘ mysql_native_password’ plugin to make connection with the server. If no password is set for root user when MySQL or MariaDB server is installed then it is necessary to set a password for the database server later. But it is better to use phpMyAdmin by making a connection as root user to perform all type of database operations. The default username is ‘ phpmyadmin’ and the password is the one that you have set in the previous step. Step-2: Setup Authentication and PrivilegesĪ default username and password are set at the time of installing phpMyAdmin for doing database tasks. Now, phpMyAdmin is installed properly and you can go for the next step to setup other configuration of phpMyAdmin. Run the following commands to check that Apache2, MySQL and PHP are installed and working.Ĭheck the current status of web server (Apache2). This tutorial will help you to install phpMyAdmin on Ubuntu.īefore starting the installation process, you must confirm that LAMP is working properly. But if you are using LAMP on Ubuntu then you have to install phpMyAdmin by downloading the package. It will be installed on XAMPP server by default when you will install XAMPP server. If you are using XAMPP server for Ubuntu then you don’t need to install phpMyAdmin separately. To do web development works, you can install XAMPP or LAMP. Import or export database or table or data from or to different formats. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |