Assign MySQL Root Password Using XAMMP Security Page

A fresh installed MySQL has a blank password. So, my scenario is that my MySQL server was installed by XAMPP 1.8.1, and I wanted to assign a root password to it. Instead of doing that in a traditional way, I chose to use XAMPP Security Page.

  1. Open XAMPP Control Panel
  2. Start Apache Server and MySQL Server
  3. Open a Web browser and point to the address: http://localhost/security
  4. Change the Language to English.
  5. Click on the link http://localhost/security/xamppsecurity.php on that page.
  6. Enter the new root password for MySQL
  7. Check on http radio button for the phpMyAdmin authentication
  8. Click on Password changing button
  9. Point browser to the address http://localhost/phpmyadmin/, you will be presented with a pop-up window for entering username and password
  10. enter “root” as a username, and whatever that you just set it up for password.
Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s