jameskane
asked on
mysql community installed workbench - problem - mysql workbench not connecting to mysql server
Follow on question to recent support from LajuanTaylor.
I am using the "mysql community installer" to install mysql and mysql workbench on a windows 7 pc. All components appear to install correctly. The workbench launches but does not succeed in connecting with the mysql server. See embedded file below
I have tried to start the server from the workbench, but this has failed. See two images below
The following is a status from the community installer showing what has been installed. Seems to be ok ?
Appreciate someone taking a look and hopefully identifying the stupid mistake I am making
PS - I have several other installations on windows 10 pcs which work perfectly. Hopefully its not a windows 7 problem !!
I am using the "mysql community installer" to install mysql and mysql workbench on a windows 7 pc. All components appear to install correctly. The workbench launches but does not succeed in connecting with the mysql server. See embedded file below
I have tried to start the server from the workbench, but this has failed. See two images below
The following is a status from the community installer showing what has been installed. Seems to be ok ?
Appreciate someone taking a look and hopefully identifying the stupid mistake I am making
PS - I have several other installations on windows 10 pcs which work perfectly. Hopefully its not a windows 7 problem !!
ASKER
Thanks for responding Tomas !
Did you run the installers with the "Run as Administrator" privilege ? : There is only one account on this pc and it has administrator privilages. Also, although I did not mention it previously, I have had workbench/mysql server connected. So in the past an installation has been achieved. /
Is there any firewall blocking the 3306 port on the computer ? : I have the firewall turned off during this installation
Make sure that the service is using the Local System account as the account responsible for running the server : - Don't think this is the problem as I have, as mentioned above, no problems with the previous installation.
As indicated above, I have had the application using mysql server running on this same machine. Then I lost some functionality. Specifically, I was not able to do backup and restore from the application coldfusion code . Not able to find a solution, I uninstalled everything and went for a complete re-install - which is where I am now.
On reflection, I think I may have created my own problem by trying to install XAMPP server to support some python work. There seemed to be a conflict with mysql workbench, so I stopped. I have uninstalled xampp. It was shortly after that I discovered the backup restore problem.
thanks again for your time
james
Did you run the installers with the "Run as Administrator" privilege ? : There is only one account on this pc and it has administrator privilages. Also, although I did not mention it previously, I have had workbench/mysql server connected. So in the past an installation has been achieved. /
Is there any firewall blocking the 3306 port on the computer ? : I have the firewall turned off during this installation
Make sure that the service is using the Local System account as the account responsible for running the server : - Don't think this is the problem as I have, as mentioned above, no problems with the previous installation.
As indicated above, I have had the application using mysql server running on this same machine. Then I lost some functionality. Specifically, I was not able to do backup and restore from the application coldfusion code . Not able to find a solution, I uninstalled everything and went for a complete re-install - which is where I am now.
On reflection, I think I may have created my own problem by trying to install XAMPP server to support some python work. There seemed to be a conflict with mysql workbench, so I stopped. I have uninstalled xampp. It was shortly after that I discovered the backup restore problem.
thanks again for your time
james
ASKER
I have tried reinstalling again and installation seemed correct. Like lastime though I got to a configuration window as shown below. You can see there are no buttons at the bottom of this window - like NEXT - consequently having made the selection shown, the only thing to do is exit by clicking the X top left - which is what I have been doing. Clearly I have never finished the configuration !
Went back to the community installer and discovered (see below) that there was a problem with visual studio install - message reads
HAS FAILING REQUIREMENTS - visual studio version
2012,2013,2015,2017 must be installed. Did a search and could not find (apart from version 2017 which must be purchased) any free download file.
Thanks for any help.
Can anyone point me to a free download for visual studio which I can use ?
Can I possibly do the configuration from the mysql shell ? (which of course demonstrates my lack of experience in this area)
,
Went back to the community installer and discovered (see below) that there was a problem with visual studio install - message reads
HAS FAILING REQUIREMENTS - visual studio version
2012,2013,2015,2017 must be installed. Did a search and could not find (apart from version 2017 which must be purchased) any free download file.
Thanks for any help.
Can anyone point me to a free download for visual studio which I can use ?
Can I possibly do the configuration from the mysql shell ? (which of course demonstrates my lack of experience in this area)
,
Hi!
Is the Visual Studio feature a requirement for you ?
If not you can press the edit and select only the parts of the install you need.
Regards,
Tomas Helgi
Is the Visual Studio feature a requirement for you ?
If not you can press the edit and select only the parts of the install you need.
Regards,
Tomas Helgi
ASKER
Hi Tomas, NO, I just made the assumption that not having it was causing the buttons not to appear on the configuration window of the mysql installer. Because of this I am unable to complete the configuration of mysql/workbench and thats why I can't get mysql connected up with the workbench
james
james
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
it solved the problem
Did you run the installers with the "Run as Administrator" privilege ?
Is there any firewall blocking the 3306 port on the computer ?
Make sure that the service is using the Local System account as the account responsible for running the server.
Regards,
Tomas Helgi