trouble installing mysql workbench

[droidus]

i am having trouble installing mysql workbench. i tried uninstalling it, then reinstalling it. i also tried repairing it. what is going on?

thanks.

[AlphaSupport]

I assume that you have a 64-bit windows installed?

If so try downloading & installing the 32-bit MSVC from the microsoft website. MySQL Workbench requires the 32 bit version of the MSVC runtime 2010.

[droidus]

wouldn't that automatically have been updated with windows update? i already have several of the 2005 and 2008's.

[AlphaSupport]

If you have a 64-bit OS, then it will probably only update the 64-bit version. The workbench needs the 32-bit version.

But don't take my word on this, i am not an expert on MS software installs & updates.

[droidus]

well, i'll give it a shot since i have no other options :p

works like a charm! :) thanks!

[droidus]

i tried to start up a database, and i get this error message now...



any ideas??

[AlphaSupport]

well, i'll give it a shot since i have no other options :p

works like a charm! :) thanks!

You're welcome, glad it worked for you.

i tried to start up a database, and i get this error message now...



any ideas??

I will need more information to troubleshoot this one.

Where are you running Workbench? (PC, a server?)
Where is MySQL installed? (On the same PC, a server)
Is MySQL running?
Do you have any firewall on your PC, or elsewhere in the connection, that might be blocking port 3306?

[droidus]

PC
same pc
the program, mysql? if so, it is. if not, how do i check?
I only use windows 7 firewall. i was able to get it to work before. i had wiped my system clean, and now i seem to be having issues. :p but i did have windows 7 firewall before, so there should be no conflict there.

i think it may be my login credentials... (U: root P: ...) could this be the issue, maybe? i was thinking of trying a password reset...

[AlphaSupport]

It could be a password issue, but i doubt it. The error message would most likely be different.

Cant you try doing a:

telnet localhost 3306

[droidus]

sorry, not familiar with this command. what do i do with it?

[AlphaSupport]

Telnet is a standard Terminal Emulator program that is (was) used to connect to the command line of a server. It takes a hostname (or IP) and optionally a port as parameters

You can not only communicate with a server shell with it (using the default port 23), but also to communicate with for example a mail server or in this case a MySQL server. It will simply send the input you give (keyboard) to the server and echo the responses.

Just open the windows commandline and type that command. You will quickly see if something is blocking the communications and if MySQL is running on that port.

If a MySQL is running you will see a response like:

B
5.1.47-community-log+^60.4ZH☻65IO2Lf?DxSs☺♦

If you do not get a response like the above, this means that there is no MySQL server running on that port. In this case you will need to troubleshoot your MySQL installation and see if the server is started. It could also mean that a firewall is blocking the access.

If you do get such a response, it means that the MySQL server is running and basic communication is possible. Next step would be to try to connect with the MySQL client to the server. You can do this again from the windows commandline with the command:

mysql -u root -p

(PS The mysql client might not be in your path. If so either go to the directory where it is installed, or start it from the Windows Start menu -> All Programs -> MySQL -> MySQL Server x.x -> MySQL Command Line Client)

[droidus]

I don't have server installed. i have workbench and connector.
and when i run the first command, it says that it's not recognized as an internal or external command.

[AlphaSupport]

Ahh i forgot that with Windows 7 telnet is not installed by default anymore.

Anyway if you do not have a MySQL server to talk to, either on your local PC or on a server, then it makes sense that you can not connect.

Please install a MySQL server.

[clydedoris]

:) interesting guys.