By default, XAMPP has no passwords set and it is not recommended to run XAMPP with this configuration as it is accessible to others.
XAMPP MySQL and phpMyAdmin helps a developer to arrange and manage database of a website or web application efficiently. The operations like database creation, imorting/exporting database, tables, columns, indexes users etc are perfectly handled by XAMPP MySQL and phpMyAdmin. How do I install XAMPP for Mac OS X? To install XAMPP, follow these steps: Open the DMG-Image. Double-click the image to start the installation process. XAMPP is now installed below the /Applications/XAMPP directory. Does XAMPP include MySQL or MariaDB? Since XAMPP 5.5.30 and 5.6.14, XAMPP ships MariaDB instead of MySQL. How to Install XAMPP on MacOS. Introduction XAMPP is a free and open-source, cross-platform web server solution stack which is developed by Apache Friends. XAMPP supports most of the operating systems including Windows, MacOS and Ubuntu. It stands for Cross-Platform(X), Apache, MySQL, MariaDB, PHP and Perl which are also the main components of the stack package. PhpMyAdmin 5.0.2. Released 2020-03-21, see release notes for details. Current version compatible with PHP 7.1 and newer and MySQL 5.5 and newer. So I am trying to log in to phpMyAdmin using my root password (Username: root Password:.), however, I continue to receive the error: #2002 Cannot log in to the MySQL server I am pretty sure I know the root password, as I have typed into terminal on Mac OS X the line.
Simply type the following command (as root) to start a simple security check:
sudo /Applications/XAMPP/xamppfiles/xampp security
Now you should see the following dialog on your screen:
XAMPP: Quick security check...
XAMPP: MySQL is accessable via network.
XAMPP: Normaly that's not recommended. Do you want me to turn it off? [yes] yes
XAMPP: Turned off.
XAMPP: Stopping MySQL...
XAMPP: Starting MySQL...
XAMPP: The MySQL/phpMyAdmin user pma has no password set!!!
XAMPP: Do you want to set a password? [yes] yes
XAMPP: Password: ******
XAMPP: Password (again): ******
XAMPP: Setting new MySQL pma password.
XAMPP: Setting phpMyAdmin's pma password to the new one.
XAMPP: MySQL has no root passwort set!!!
XAMPP: Do you want to set a password? [yes] yes
XAMPP: Write the passworde somewhere down to make sure you won't forget it!!!
XAMPP: Password: ******
XAMPP: Password (again): ******
XAMPP: Setting new MySQL root password.
XAMPP: Setting phpMyAdmin's root password to the new one.
XAMPP: The FTP password for user 'nobody' is still set to 'lampp'.
XAMPP: Do you want to change the password? [yes] yes
XAMPP: Password: ******
XAMPP: Password (again): ******
XAMPP: Reload ProFTPD...
XAMPP: Done.
(1) Setting a password will protect the XAMPP demo pages (http://localhost/xampp/) using this password. The user name is 'lampp'!
Macos Catalina Apache
After running this command, your XAMPP installation should be more secure.