Description

As mentioned before, phpMyAdmin handles authentication using MySQL credentials. This means that to log into phpMyAdmin, you use the same username and password you would normally use to connect to the database using the command line or with an API. If you need help creating MySQL users, check out this guide on How To Manage an SQL Database.

Note: Logging into phpMyAdmin as the root MySQL user is discouraged because it represents a significant security risk. This guide will outline how to disable logins as the root MySQL user in Step 3 of this guide.
Your phpMyAdmin installation is completely functional at this point. However, by installing a web interface, you’ve exposed your MySQL database server to the outside world. Because of phpMyAdmin’s popularity, and the potential for it to provide access to large amounts of sensitive data, installations like these are common targets for attacks. In the following sections of this guide, we’ll go over a few different methods by which you can make your phpMyAdmin installation more secure.

Step 2 — Changing phpMyAdmin’s Default Location

One way to protect your phpMyAdmin installation is by making it harder to find. Bots will scan for common paths, like /phpmyadmin/pma/admin/mysql, and other similar names. Changing the interface’s URL from /phpmyadmin to something non-standard will make it much harder for automated scripts to find your phpMyAdmin installation and attempt brute-force attacks. In the previous step, you created a symbolic link in your Nginx web document root pointing to /usr/share/phpmyadmin, where the actual phpMyAdmin application files are located. You can rename this symbolic link to change phpMyAdmin’s interface URL. To do this, navigate to the Nginx document root directory:

MoHERST in partnership with UNESCO

Get your student access to Campus Assist's books and publications

MoHERST UNESCO FUZION

Students also bought

About the Author

ODUM-IGWE SAMUEL
ODUM-IGWE SAMUEL
Nationality - Gambian

Rebecca is a #1 New York Times, USA Today, Sunday Times, and Wall Street Journal bestselling author of over fifteen novels, including FOURTH WING, and is always ready to bring on the emotions. She's also the recipient of the Colorado Romance Writer’s Award of Excellence in New Adult for Eyes Turned Skyward from her Flight and Glory series.

She lov...

es military heroes and has been blissfully married to hers for twenty-one years. She’s the mother of six children and lives in Colorado with her family, their stubborn English bulldog, feisty chinchillas, and Maine Coon cat who rules them all. Having fostered then adopted their youngest daughter, Rebecca is passionate about helping children in the foster system through her nonprofit, One October.

Become an Instructor, Share your knowledge

Create an online video course, reach students across the globe, and earn money