![]() (There are different ways to go about this step but I choose password)Ħ. In the authentication tab, disable Public Key authentication, and make Password authentication required. This will be the port your MySQL workbench connects into.ĥ. You could probably choose any available port. (This will be the IP that your MySQL Workbench client will connect into.Ĥ. For listen address choose 0.0.0.0 (all interfaces) or any appropriate IP address. Right click the icon in system tray and choose settings.ģ. This should start the program and put an icon in your system tray.Ģ. Moreover, the system tray icon was the only place I could find that allowed you to edit the config file in GUI format.ġ. At first I installed this as a service, but for whatever reason I had trouble accessing the system tray icon when run as a service. This program needs to be installed on the server. Workstation: Windows 7 Professional running MySQL Workbench (5.2.30) Server: Windows 2000 Server running MySQL Community 5.1.45-community So here is how I got MySQL Workbench to connect to a Windows 2000 server using SSH. However my server is a Windows 2000 box and MySQL Workbench (5.2.30) does not run on that OS. So I figured that I could just log into my server and install Workbench and then for the admin tasks just remote into the server. With MySQL Workbench any administrator tasks (restarting server, GUI edit of config file, viewing logs) needs to be done locally on the server or if done remotely, through SSH. I could run all management tasks from MySQL administrator through a connection to port 3306 (main MySQL port). In my development environment I had MySQL administrator on my workstation and the MySQL Database on my server. So I decided to make the switch to MySQL Workbench, which after getting used to, works fine except managing the database remotely becomes a little more challenging in a windows environment. This tool has since been replaced by MySQL Workbench. To manage my databases (and perform queries) for years I used a tool called MySQL administrator. I use MySQL for many of my development projects in a Windows environment.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |