how to verify mysql settings to ensure proper working

Problems with the Windows version of XAMPP, questions, comments, and anything related.

how to verify mysql settings to ensure proper working

Postby dsdsdsdsd » 28. April 2015 07:20

hello ...

I installed HeidiSQL on my local winXP, but it cannot connect to my database. My HeidiSQL error is: SQL Error (2003) in statement #0: Can't connect to MySQL server on '127.0.0.1' (10061)

... by the way ... my browser-based phpMyAdmin connects fine

What kind of checks can I do using my XAMPP to verify proper setup of my MySQL?


- thanks, Shannon
dsdsdsdsd
 
Posts: 11
Joined: 11. February 2011 12:57

Re: how to verify mysql settings to ensure proper working

Postby mark.mcdonald » 28. April 2015 15:02

What user privileges did you set with HeidiSQL to log into your MySQL DB? Did you set a username and password for HeidiSQL to get into your MySQL?
Even though you are running on your localhost you will still need to put in a username and password. PHPMyAdmin usually works on
Username: root
Password:

phpmyadmin works based on already knowing the username and password built in from xampp (assuming you didn't change it during setup).
mark.mcdonald
 
Posts: 160
Joined: 13. March 2015 15:48
Location: Edmonton
Operating System: Windows Server 2012 R2


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 59 guests