How to Configure MySQL in XAMPP

Save

XAMPP installations include an application called "phpMyAdmin" that you can use to configure your MySQL databases. PhpMyAdmin is accessed through any Web browser on your computer and offers an interface that you can use to create, edit and delete MySQL databases. The ability to make changes to your MySQL databases in this fashion simplifies the process of using them in your websites and Web applications. The phpMyAdmin application can even allow you to use your databases with very little knowledge of MySQL.

  • Launch XAMPP, then click the "Start" buttons to the left of "Apache" and "MySQL" to start both services.

  • Open a Web browser window.

  • Type "http://localhost/phpmyadmin" into the address bar at the top of the window, then press "Enter" on your keyboard.

  • Type the user name and password that you defined when installing XAMPP, then click "Go." If you have not set a user name or password, then you will instead be taken directly to the phpMyAdmin home page.

  • Click the MySQL database that you want to configure from the list at the left side of the window.

  • Click the "Browse" icon to the right of a table in your database to browse or edit the data stored in that table, or click one of the tabs at the top of the window to make any changes to the database. For example, if you wanted to modify the user privileges for the database, you could click the "Privileges" tab at the top of the window, then click the user whose privileges you wish to modify.

  • Click the "Go" or "Save" button at the bottom of the window when you have made your changes. Note that most changes to your MySQL databases cannot be undone.

Tips & Warnings

  • If you are unable to access phpMyAdmin using the method described, then you may need to modify your "Hosts" file. Right-click the "Notepad" program, then click "Run as Administrator." Click "File," click "Open" and browse to your Hosts file. The file is located in the "C:\Windows\System32\drivers" directory. Locate the line that says "127.0.0.1 localhost," then add "xampp" to the end of the line, so that it reads "127.0.0.1 localhost xampp." Click "File" at the top of the window and click "Save" to apply your changes.

References

Promoted By Zergnet

Comments

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!