This is a short introduction to help you setup and test access to your database using a local web server (XAMPP). For more information on SQL commands, please refer to database textbook(s).
(Please let me know if you find any errors or omissions in the document —Upsorn Praphamontripong, 27-January-2022)
XAMPP is an open source package that is widely used for PHP development. XAMPP contains MariaDB, PHP, and Perl; it provides a graphical interface for SQL (phpMyAdmin), making it easy to maintain data in a relational database.
read also : phpmyadmin sql dump pass password passwd pwd
If you have not installed XAMPP, please refer to XAMPP-setup to install and set up XAMPP.
Assuming that you have already set up XAMPP
Start the database server ("MySQL Database")
Start the PHP environment ("Apache Web Server")
Note: phpMyAdmin runs on a PHP environment. To use phpMyAdmin to manage databases, Apache Web server must be started.
Reminder: be sure to stop the server when you are done. Leaving the servers running consumes energy and may later prevent the servers from starting (in particular, MySQL server).
Access phpMyAdmin
Open a web browser, enter a URL http://localhost to access XAMPP dashboard
Select phpMyAdmin tab
Alternatively, you may access phpMyAdmin via the XAMPP manager / controller, click Go to Application button to access XAMPP dashboard.
The main page should look similar to the following
Top comments (0)