Mysql Administrator

[pirateMike]

I've been using Uniform Server off and on for a number of months quite successfully. Previously I had Mysql Administrator installed and it worked normally. I have recently been forced to wipe and reinstall windows. Since windows has been re-installed I tried to re-install Mysql Administrator but this time get an error msg when launched.

 

Error msg reads: "Either the server service or configuration file could not be found. Startup variables and service section are therefore disable."

 

I'm running XP sp3. The service pack was not installed when it worked previously so I don't know if that could be causing the problem. My dad also uses Uniform Server on a Windows 2000 system and said he has had the same problem since he first started using it.

 

I have uninstalled and re-installed the GUI Tools several time using several versions and all give the same error. Also, I have searched the web and it seems WAMP users have this problem as well, but I was not able to find a solution on any of the sites I read through. I use the Mysql GUI Tools quite a bit, so for me not using it is not an option. Any help is appreciated.

 

Thanks in advance,

Mike

[Ric]

I tried the following, it worked, and unfortunately when I restarted the PC it was back to square one. Hence I am afraid not a solution. (XP-Home SP2)

 

1) Install clean version of US

2) Apply bug fix 6

3) Go to plugins Services and run Run.bat installs US as service

4) Go to folder c:\UniServerX.X and run Uninstall.bat

 

5) Navigate to folder C:\UniServerX.X\usr\local\mysql\bin

 

Rename file mysqld-opt.exe to mysqld-nt.exe

 

6) Navigate to folder C:\UniServerX.X edit Install.bat as follows:

 

Change line : copy usr\local\mysql\bin\my-small.cnf c:\my.cnf

To: copy usr\local\mysql\bin\my-small.cnf c:\my.ini

 

Change line: c:/UniServerX.X/usr/local/mysql/bin/mysqld-opt.exe --install

To: c:/UniServerX.X/usr/local/mysql/bin/mysqld-nt.exe --install MySQL

 

7) Still in folder C:\UniServerX.X edit Uninstall.bat as follows:

 

Change line: usr\local\mysql\bin\mysqld-opt.exe --remove

To: usr\local\mysql\bin\mysqld-nt.exe --remove

 

Change line: del C:\my.cnf

To: rem del C:\my.ini

Note: This line is rem'ed out hence my.ini is not deleted its there as

a reminder. It needs to remain so MySQLAdministrator can pick it up!

When you uninstall US and delete it you need to manually remove this file.

 

8) Run Install.bat check both servers are running

Run Uninstall.bat this stops and removes servies ready for the next step

 

9) Run MySQLAdministrator.exe DO NOT login.

The button, bottom tight displays "Cancel"

Press key "ctrl" the button will now display "Skip"

With "Skip" displayed left mouse click on it.

 

10) Service Control (top left) is highlighted if not click on link.

11) To the right click of "Configure Service" tab.

12) All the boxes are greyed out, at the bottom of this page click "Install new service"

13) In the pop-up click OK (default Service name MySQL)

14) Un-check "Launch MySQL server on system start"

 

Navigate to Config Filename (displayed in red) delete every thing in this box and

add c:\my.ini (changes to black)

 

Navigate to "Path to binary" again displayed in red. Click button to the right labeled "..."

Use this to navigated to the binary C:\UniServerX.X\usr\local\mysql\bin\mysqld-nt.exe

 

Click on "Apply Changes button"

Close program File > Close

 

15) Navigate to C:\UniServerX.X and run Install.bat

 

16) Run MySQLAdministrator.exe and login

 

At this point thought I had cracked it, after restarting PC it failed, back to square one!

 

I think the real problem is with error checking it expects to find

mysqld-nt.exe and my.ini any deviation and it aborts. I have no idea where it stores its configuration data. The above may be of use or at least give a starting point.

 

All the best

Ric

[pirateMike]

Thanks alot for your efforts Ric. I'll keep trying to find a way around this and will post any success I have.

 

Mike

[Ric]

I was never happy with the final outcome on this. However with 3.6 running as a service you will find MySQLAdministrator works fine. MySQLAdministrator really is excellent piece of kit.

 

All the best

Ric