A tip on Xampp – PHP – SitePoint Forums


Thus, in all installations performed on any Linux distribution, the default root password is never set. You have to do it manually. To do this, you need to follow a few steps.

1.) Stop the MySQL service

sudo service mysql stop

2.) Then in the terminal using root access, navigate to /etc/mysql/. Then modify the my.cnf case. Add this configuration at the bottom of the file.


3.) Save and exit this file. Then restart the mysql service.

sudo service mysql restart

4.) After that, you can login to root account on MySQL without password.

mysql -u root

5.) After that, do USE mysql; change for the mysql table. Next, change the root account password by doing

UPDATE user SET authentication_string=PASSWORD('YOUR_PASSWORD_HERE') WHERE User="root";

Please change the password YOUR_PASSWORD_HERE the password you intend to use.

Optional: If you want to set the password type to the native mysql password, you can do this

UPDATE user SET plugin='mysql_native_password' WHERE User="root";

6.) If not, dump the privileges by doing FLUSH PRIVILEGES;.
7.) Finally, return to the my.cnf file and remove the lines below as we no longer need this configuration


8.) Restart the MySQL service

sudo service mysql restart

Then you should be able to log in with your new root password.

mysql -u root -p

You need to download it from phpmyadmin.net. You also need to set it up once downloaded. Once you are able to connect to the MySQL server using phpMyAdmin, you need to go to your phpMyAdmin folder and find the sql case. Next, copy all the contents of the create_tables.sql file in the SQL tab of phpMyAdmin, any SQL tab will do. Even if you are in a database that is not for phpMyAdmin, you can still run this SQL content and it will still put the data in the right place. It just eliminates that error you see at the bottom when you go to the dashboard, because phpMyAdmin relies on those tables to be created, because it’s the phpMyAdmin schema.

To be fair, it’s only simple because XAMPP and other one-button click solutions are just that. It’s a click of a button, so you barely need to know where to go to set it up. These solutions are generally intended for beginners.

I know how to install the entire PHP environment from Apache to SSL simply because I have done my extensive research on it and found the best possible ways to install it. I created video guides here https://www.sitepoint.com/community/t/installing-the-php-environment-spaceshiptrooper/320645 to install the entire PHP environment on Windows 7 and 10, macOS (all versions from Yosemite to Mojave), and finally even in Ubuntu.


Comments are closed.