Connection Problems!!!!

[FireDevil]

Ok, I ave ad MySQL running fine on this computer a few years ago. It got uninstalled and gone and te computer has been reformatted once or twice since then. But recently I tried to install MySQL again with SAM2 broadcaster. MySQL installed properly and fine, but after the installation is complete, and it goes back to the SAM2 installation I get an error that says:

 

Unable to connect to MySQL. Please make sure that MySQL is installed AND running. Also make sure you are using the correct MySQL login information.

                                        -OK-

 

I clicked 'OK' and looked back at the screen, and in the SAM2 screen it says:

 

> MySQL was successfully installed at E:\mysql\

> Can't connect to MySQL server on 'localhost' (10061)

> Can't connect to MySQL server on 'localhost' (10061)

 

This was using the root username and a blank password. I changed the password back when I had MySQL before so it should not matter, but I tried it anyway and got the same error. I am not a big techy person so I need some help cuz I am tired of looking for solutions that dont help.

Thank you.

 

[rajivgonsalves]

you have to check your configuration, also check that the mysql server is running on your pc, sometimes the set up is such that its takes your pc name instead of localhost

 

hope it helps

[Zane]

instead of using SAM2 (a third party software) to test your installation.  Try using the actual mysql console.

 

Assuming you're running Windows

Go to Start > Run > type "cmd"

Then type "mysql" and push Enter.  If this fails then it means MYSQL is not in your system path.

 

reply with your results.

[FireDevil]

Not quite sure how to check my configuration, but I went to Services and checked to see if there was a MySQL running. I found one just named "MySQL" and it was not going, it was stoped. So I started it and and error poped up saying

 

Could not start the MySQL service on Local Computer.

Error 3: The system cannot find the path specified.

                                  -OK-

 

So then I pressed 'OK' and right-clicked the programs to see the path it was going to. It is trying to go into E:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld"  and that is not where I tried to install MySQL too. Is there anyway to change the path or make a new service with the right path?

[FireDevil]

After my above procedures seemed to fail I used the command and got this:

 

E:\Documents and Settings\****\MYSQL

'MYSQL' is not recognized as an internal or external command, operable program or batch file.

 

So between bot this post and the last one, Im guessing something got mixed up and its trying to reach someplace that MySQL was not installed at. When I installed it, the default folder to install at was C:\ but my main drive that is used on my comp is the E:\ so I changed it to E:\mysql and that is where it installed currently.

 

Any more suggestions?  And thank you guys for the quick replies. I am glad I came to this forum.

[Zane]

go into your command prompt again

start run.. "cmd"..

 

then type in this order:  For each line push enter

e:

cd mysql/bin

mysql

then tell us what happens.  If that works.. then your installation is good and It's like I said... your classpath (environment variables) are not set to have MySQL..  Most likely that is the problem. In fact. I'd say that is the problem, but it's not really a problem.. it just means you need to specify your path.

[FireDevil]

That may be my problem but Im not sure how to fix it. Like I said before Im not that tech savy. =P But here are my results:

 

I ran the command and inputed 'e:' and pressed enter but noting happened.

Then i typed in 'cd mysql/bin' and the response said, "the system cannot find the path specified"

And just to be sure I then just typed in 'mysql' next and got the same response as before.

[FireDevil]

It is my guess that I need to specify which folder it is in. The problem is, Im not quite sure how to do that. I read the help thing for downloading MySQL, and it sayed that I had to like make a new file called my.cnf or something with a little text in it to specifiy. All i need is some quick help on making this file to see if it will solve my problem. =P