can't connect locally to MySQL Server

[fleagle]

I've had this problem when trying to intall other CMS-type systems on my local server.

I have verified that the MySQL database server is up and running. I have MySQL Administrator, as well as YourSQL. Both connect successfully to MySQL database; however, when using the EXACT same login info for Pligg install (and I've also tried to install Joomla) it says

"Error: Cannot connect to the database server using the information provided."

Why am I not having any trouble connecting via MySQl Administrator, Your SQL, or even from the Terminal window, yet when trying to install Pligg, it says it cannot connect?

[kbeeveer46]

They key sentence is

I've had this problem when trying to intall other CMS-type systems on my local server.

which typically means there's something wrong with your server. There's not much we can help you with.

[savant]

try installing php my admin and see if you can login with that

[fleagle]

I tried, and get the following:

"#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)"


I'm starting to think that removing and re-installing the server is my only option. I just don't get why my other programs connect to the database fine and anything in my test server folder does not.

[fleagle]

Well, I uninstalled and re-installed the server, but still have the same problem. Obviously, something else is wrong.

[savant]

how did you create a new database and user in your mysql server?

[fleagle]

I used YourSQL. Connected to server and created a new user and database for Pligg. Then tested connection in MySQL Administrator. No problems. But Pligg install will not connect.

[savant]

does yoursql let you enter hosts? localhost / 127.0.0.1

[fleagle]

I'm not sure. I added the database under localhost. Should I not have?

[savant]

mysql -u root -p
Enter password

create database pligg;

GRANT ALL PRIVILEGES ON pligg.* TO 'pligg'@'localhost' IDENTIFIED BY 'pligg' WITH GRANT OPTION;

FLUSH PRIVILEGES;

That needs to be done on a command prompt ( Start > run > cmd )

That's what i do