FireDevil Posted December 5, 2009 Share Posted December 5, 2009 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. Quote Link to comment https://forums.phpfreaks.com/topic/184117-connection-problems/ Share on other sites More sharing options...
rajivgonsalves Posted December 5, 2009 Share Posted December 5, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/184117-connection-problems/#findComment-972077 Share on other sites More sharing options...
Zane Posted December 5, 2009 Share Posted December 5, 2009 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. Quote Link to comment https://forums.phpfreaks.com/topic/184117-connection-problems/#findComment-972081 Share on other sites More sharing options...
FireDevil Posted December 6, 2009 Author Share Posted December 6, 2009 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? Quote Link to comment https://forums.phpfreaks.com/topic/184117-connection-problems/#findComment-972169 Share on other sites More sharing options...
FireDevil Posted December 6, 2009 Author Share Posted December 6, 2009 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. Quote Link to comment https://forums.phpfreaks.com/topic/184117-connection-problems/#findComment-972172 Share on other sites More sharing options...
Zane Posted December 6, 2009 Share Posted December 6, 2009 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. Quote Link to comment https://forums.phpfreaks.com/topic/184117-connection-problems/#findComment-972181 Share on other sites More sharing options...
FireDevil Posted December 6, 2009 Author Share Posted December 6, 2009 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. Quote Link to comment https://forums.phpfreaks.com/topic/184117-connection-problems/#findComment-972219 Share on other sites More sharing options...
FireDevil Posted December 14, 2009 Author Share Posted December 14, 2009 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 Quote Link to comment https://forums.phpfreaks.com/topic/184117-connection-problems/#findComment-976664 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.