Page 1 of 1

Problem connecting to MySQL on XAMPP 1.6.5 on Vista

PostPosted: 31. January 2008 15:12
by dormston
Hi

Got a new computer and running Vista. I've installed XAMPP 1.6.5 but, while I can run Apache fine and MySQL *seems* to start, I just can't connect to it. I get this message:
============
The connection to the database server could not be established.

The error message of the database server:
Access denied for user 'root'@'localhost' (using password: YES)
============

When I start the XAMPP interfact from localhost it tells me that:
============
A MySQL server is not running, or blocked by a firewall
============

whether or not I have a firewall running.

I've read several posts and tried uninstalling and re-installing, but no luck.

I'm so disappointed, this used to work so well on my XP machine.

Please can someone help?
D

Update

PostPosted: 31. January 2008 16:00
by dormston
Interesting, I seem to be able to work with databases using phpMyAdmin (i.e. can create databases and tables) but don't seem to be able to connect to MySQL any other way.

Most confusing, could do with some help please.

PostPosted: 31. January 2008 16:14
by Izzy
Access denied for user 'root'@'localhost' (using password: YES)
This usually means you are trying to connect using an incorrect password.
Check your password in the database configuration of what ever you are trying to connect to the database with.

This user/password for the database can be checked in phpMyAdmin under the privileges menu item - you can even change the passord for a database user in phpMyAdmin.

but don't seem to be able to connect to MySQL any other way.
What other way are you trying to connect to MySQL?

PostPosted: 19. February 2008 15:55
by dormston
For instance, if I use MySQL Administrator (I've got v.1.2.12 running) I get the following message:

'Could not find setting' . 'Either the server service or the configuration file could not be found. Startup variables and service section are therefore disabled'

If I click ok, then MySQL Administrator tells me that the MySQL Server is running, but I can't use the service control. There's a red message saying 'This section is only available when connected to localhost.

I'm so confused ... would appreciate any help.

Thx

Re: Problem connecting to MySQL on XAMPP 1.6.5 on Vista

PostPosted: 11. March 2009 05:15
by make-fun
Hi there,
guessing you still have this problem — or for those running into it some time in the future.
Have a look at his post http://community.apachefriends.org/f/viewtopic.php?f=16&t=33978
based on Win XP, but may point you in the right way…
Hope it'll be useful

Cheers