How do I use MySQL through XAMPP?

XAMPP only offers MySQL (Database Server) & Apache (Webserver) in one setup and you can manage them with the xampp starter.

After the successful installation navigate to your xampp folder and execute the xampp-control.exe

Press the start Button at the mysql row.

Now you’ve successfully started mysql. Now there are 2 different ways to administrate your mysql server and its databases.

But at first you have to set/change the MySQL Root password. Start the Apache server and type localhost or 127.0.0.1 in your browser’s address bar. If you haven’t deleted anything from the htdocs folder the xampp status page appears. Navigate to security settings and change your mysql root password.

Now, you can browse to your phpmyadmin under http://localhost/phpmyadmin or download a windows mysql client for example navicat lite or mysql workbench. Install it and log in to your mysql server with your new root password.

Related Posts:

  1. Locally restoring a ManageWP full site backup
  2. How can I view my site directly from WordPress dashboard?
  3. Search and Replace in Windows XAMPP site
  4. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  5. Unknown column in ‘field list’ error on MySQL Update query
  6. MySQL – Operand should contain 1 column(s)
  7. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  8. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  9. How can I do a FULL OUTER JOIN in MySQL?
  10. MySQL query String contains
  11. What’s the difference between VARCHAR and CHAR?
  12. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  13. How to declare a variable in MySQL?
  14. MySQL Cannot Add Foreign Key Constraint
  15. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  16. How to split the name string in mysql?
  17. How do I import an SQL file using the command line in MySQL?
  18. mysql Foreign key constraint is incorrectly formed error
  19. MySQL “WITH” clause
  20. MySQL Multiple Joins in one query?
  21. Cannot access to localhost/xampp/index.php
  22. Error Code: 2013. Lost connection to MySQL server during query
  23. Localhost is not working
  24. localhost/xampp/ or http://localhost/index.php can’t be accessed
  25. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  26. How do I run a file on localhost?
  27. MySQL combine two columns into one column
  28. Xampp MySQL not starting – “Attempting to start MySQL service…”
  29. MySQL Error 1264: out of range value for column
  30. PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given [duplicate]
  31. How to store arrays in MySQL?
  32. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  33. Remove duplicate rows in MySQL
  34. Create mysql table directly from CSV file using the CSV Storage engine?
  35. Cast from VARCHAR to INT – MySQL
  36. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  37. How do you force mysql LIKE to be case sensitive?
  38. ERROR 1148: The used command is not allowed with this MySQL version
  39. Insert into a MySQL table or update if exists
  40. How to round down to nearest integer in MySQL?
  41. MySQL starts with searching issue
  42. MySQL error: key specification without a key length
  43. Check if MySQL table exists without using “select from” syntax?
  44. How to solve “Error: MySQL shutdown unexpectedly”?
  45. MySQL equivalent of DECODE function in Oracle
  46. mysql update column with value from another table
  47. The used SELECT statements have a different number of columns
  48. How to delete from multiple tables in MySQL?
  49. MySQL: Can’t create table (errno: 150)
  50. How to copy a row and insert in same table with a autoincrement field in MySQL?
  51. Join vs. sub-query
  52. Alternative to except in MySQL
  53. Equivalent of explode() to work with strings in MySQL
  54. ROW_NUMBER() in MySQ
  55. MySQL – Get row number on select
  56. MySQL error: Unknown column in ‘where clause’
  57. How to truncate the text returned for a column in a MySQL query
  58. Using union and order by clause in mysql
  59. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  60. WordPress Subdomain MultiSite on localhost XAMPP on :8080 with IIS taking port 80
  61. WP Asking for FTP Credentials with XAMPP Localhost
  62. error importing localhost export file to server
  63. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  64. How to do a MySQL dump from production site without using a search and replace script for local development?
  65. After finishing building a site on localhost, how do I transfer everything to a client’s server?
  66. I have a desktop and a laptop: What’s the best way to move between local installations?
  67. Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
  68. WordPress on a local machine redirecting to xampp dashboard page [closed]
  69. WordPress php mysql errors – errcode: 13 permission denied
  70. Error: MySQL shutdown unexpectedly [closed]
  71. Setting up a local copy from a production site
  72. change wordpress upload url to subdomain on xampp local
  73. Why don’t WP themes download completely on my localhost (XAMMP)?
  74. Absolute Hyperlinks in WordPress Website Will Not Work In the Local Server
  75. Plugin not working locally, but works on server
  76. Local install not loading template images but is loading everything else XAMPP
  77. Installing local to live WP into subdirectory
  78. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  79. Cloning blog to localhost via WAMP
  80. my wordpress configuration locally vs live server
  81. Multisite Dashboard Always Redirects to Main Dashboard
  82. call to undefined function mysql_connect
  83. Recovery – Restore Database after moving folder location locally
  84. How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
  85. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  86. XAMPP internal server error
  87. Error Connecting to Database WHEN Installing WordPress on XAMPP [Tried All the Usual Stuff] (Pics Included)
  88. Page 404 Error on Localhost
  89. WordPress asks to install, but is already installed?
  90. 403 Forbidden home on localhost with nginx server
  91. Testing localhost WordPress site over LAN with iPad, iPhone
  92. Why is local wordpress install calling live site executions?
  93. WordPress installation didn’t install any default data and returned empty rows!
  94. Setting up XAMPP and Sendmail to enable WordPress emails on localhost
  95. wordpress multisite duplicator plugin clon to localhost(xampp) but image not show
  96. cannot log in to the mysql server (wamp and wordpress)
  97. WordPress migration from live server to localhost having 404 error? [closed]
  98. Error Message when logging into WordPress on Xampp
  99. Failed to upload image on localhost
  100. running an existing WordPress site from Visual Studio Code?

Leave a Comment