1

I've got a locally installed MySQL database server that I want to use for development for my MVC 2 project. I installed the 64 bit version of MySQL and set up my schemas. I didn't change any of the defaults except for the root password. I've also installed the 32 bit .NET connector and I'm using VS2010.

I can't get VS to connect to MySQL. I set the server to "localhost" (also have tried 127.0.0.1), user name to "root", and the password. It can't connect. I've also tried specifying the database I want to connect to with no luck. I can, however, ping the server via "mysqladmin -h localhost -u root -p XXX ping".

Something interesting that I noticed was that when I opened the Advanced options, the connection string that the connector was building under the options didn't include a password, just "server=localhost;username=root" and whatever options I fiddled with. I'm guessing that's for security reasons, but if it's not adding the password to the connection string that's obviously a problem (that I don't know how to fix).

I have to admit that databases and networking aren't my strong suits, but I still didn't anticipate this much trouble. I'm beginning to think that I might have set up my database incorrectly, but I'm not sure what to look for.

Improve this question

3 Answers 3

Reset to default
1

I figured this out a good while back, should have updated this a long time ago. My MySQL server didn't install correctly for some reason, and reinstalling was a pain because the process kept failing when I tried to reinstall it. I did manage to find a solution to the problem here: https://serverfault.com/questions/214435/error-1067-the-process-terminated-unexpectedly-when-trying-to-install-mysql-o

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

I had the same error. I changed localhost for 127.0.0.1 instead and it seems to work for me.

I'm still looking for the reason why Windows doesn't let me use localhost (because, as I've read already, it's a Windows error).

Improve this answer

Comments

0

Localhost is ::1 in IPv6.

It tries to connect with IPv4, which is 127.0.0.1.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.