Installing the WinMySQLadmin tool
Installing and Settings of WinMySQLadmin on Win9x

Important:

If the MySQL server is running, stop it.

If you have already the my.cnf or my.ini file on your environment, you need to rename this file with other name, because the WinMySQLAdmin tool creates its own my.ini file.

Run WinMySQLAdmin.exe, once started WinMySQLAdmin will try to locate the ‘my.ini’ file in the Windows directory. If the ‘my.ini’ file is not found the Quick Setup screen is launched:

Enter your user name and password text boxes then click on the create button.

The my.ini file will be created, one user will be added to the grant table and a shortcut will be added to the start menu. If you are using a registered version of MySQL, mysqld-opt is the Server is the one that is chosen. The location of my.ini should be e.g. c:\windows.

If you are using the shareware distribution of MySQL mysqld-shareware is the Server is the one that is chosen.

The Quick Setup screen will close and WinMySQLAdmin will install an icon on the System Tray.

Clicking on the WinMySQLAdmin icon on the System tray using either the left or right mouse button will bring up a pop-up menu.

The red light means that the MySQL Server is stopped. To run the Server click over the icon and selecting the item Start the Server.

If the green traffic light is showing, this means that the server is up and running, which allows you to use any of the MySQL client utility i.e: c:\mysql\bin\mysql –u <your username> -p<yourpassword>

To access the main screen, click on the ‘Show Me’ menu item.

To have access to the pop-up menu on the main screen, right click.

On the Start Menu of the Windows System you should see the icon for the WinMySQLadmin tool.

This means that in the next boot of the machine, the tool will be launched and starting the server.


Starting NT
Installing and Settings of WinMySQLadmin as Service on WinNT

Important:

If the MySQL server is running, stop it and remove the service is it already installed.

If you have already the my.cnf or my.ini file on your environment, you need to rename this file with other name, because the WinMySQLAdmin tool creates its own my.ini file.

Run WinMySQLAdmin.exe, once started WinMySQLAdmin will try to locate the ‘my.ini’ file in the Windows directory. If the ‘my.ini’ file is not found the Quick Setup screen is launched:

Enter your user name and password text boxes then click on the create button.

The my.ini file will be created, one user will be added to the grant table and a shortcut will be added to the start menu. If you are using a registered version of MySQL, mysqld-nt is the Server is the one that is chosen. The location of my.ini should be e.g. c:\winnt.

If you are using the shareware distribution of MySQL mysqld-shareware is the Server is the one that is chosen.

The Quick Setup screen will close and WinMySQLAdmin will install an icon on the System Tray.

Clicking on the WinMySQLAdmin icon on the System tray using either the left or right mouse button will bring up a pop-up menu.

The red light means that the MySQL Server is stopped. To install the service click over the icon and selecting the item Install the Service.

To run the Service, click over the item Start the Service.

If the green traffic light is showing, this means that the server is up and running, which allows you to use any of the MySQL client utility i.e: c:\mysql\bin\mysql –u <your username> -p<yourpassword>

To access the main screen, click on the ‘Show Me’ menu item.

To have access to the pop-up menu on the main screen, right click.

On the Start Menu of the Windows System you should see the icon for the WinMySQLadmin tool.

This means that in the next boot of the machine, the tool will be launched.


Standalone
Installing and Settings of WinMySQLadmin as Standalone on WinNT

Important:

If the MySQL server is running, stop it and remove the service is it already installed.

If you have already the my.cnf or my.ini file on your environment, you need to rename this file with other name, because the WinMySQLAdmin tool creates its own my.ini file.

Run WinMySQLAdmin.exe, once started WinMySQLAdmin will try to locate the ‘my.ini’ file in the Windows directory. If the ‘my.ini’ file is not found the Quick Setup screen is launched:

Enter your user name and password text boxes then click on the create button.

The my.ini file will be created, one user will be added to the grant table and a shortcut will be added to the start menu. If you are using a registered version of MySQL, mysqld-nt is the Server is the one that is chosen. The location of my.ini should be e.g. c:\winnt.

If you are using the shareware distribution of MySQL mysqld-shareware is the Server is the one that is chosen.

The Quick Setup screen will close and WinMySQLAdmin will install an icon on the System Tray.

Clicking on the WinMySQLAdmin icon on the System tray using either the left or right mouse button will bring up a pop-up menu.

The red light means that the MySQL Server is stopped. To run the Server click over the icon and selecting the item Start the server Standalone.

If the green traffic light is showing, this means that the server is up and running, which allows you to use any of the MySQL client utility i.e: c:\mysql\bin\mysql –u <your username> -p<yourpassword>

To access the main screen, click on the ‘Show Me’ menu item.

To have access to the pop-up menu on the main screen, right click.

On the Start Menu of the Windows System you should see the icon for the WinMySQLadmin tool.

This means that in the next boot of the machine, the tool will be launched but without Starting the MySQL Server. As Standalone the only way to Start the MySQL Server is using the pop-up menu Start the Server Standalone item.


Editing my.ini File
Editing the my.ini File

Click on my.ini Setup tab.

The my.ini file screen displays a memo object which allows you to make whatever modification you feel necessary. Changes can be saved to the my.ini file pressing the Save Modification button.


Changing the Server File

Changing the MySQL Server file

When the tool is loaded searchs on the bin folder for the server files options. If you have the registered distribution you have the mysqld.exe, mysqld-opt.exe and the mysqld-nt.exe. If you want to change the Server file, edit the my.ini file as follows:

On Win9x

Stop the server if already is running.

On the group option for mysqld, select the option that you want and press the Save Modification button.

Right click and selecting the Start Server menu, start the new MySQL server option.

On WinNT

Stop the service if already is running or stop the server standalone.

Remove the service. Reboot the machine.

On the group option for mysqld, select the option that you want and press the Save Modification button.

Right click and select the Install the Service menu.

Rigth click and select the Start Service menu.


Menu Options

Right click on any point of the main screen to see the pop-up menu.

Hide me	Puts WinMySQLAdmin onto the System Tray
ShutDown this Tool	Closes the WinMySQLAdmin application (the Server isn’t affected)
Start/Stop the Service	Start/Stop the MySQL using the SC Manager when run as a Service
Install/Remove the Service	Install/Remove MySQL from the SC Manager
Start/Stop the Server Standalone	Stop/Start MySQL as a stand-alone application

NOTE

The standalone option menu is enabled only enabled when the service is not running.


Err file
The MySQL.err File Screen

The MySQL.err Screen displays the last 16 error log entries.


Server Status
The Server Status Screen

The Server Status screen displays the current state of the MySQL server


Server Variables
The Server Variables Screen

The Server Variable screen display a list of all the current Server Startup Variables


Process
The Process Screen

The Process Screen displays a list of all current processes.

Right clicking on the grid row you access the kill process  option.


Database Screen
The Database Screen

The Databases Screen displays all the databases, their tables together with the columns and indexes, present on your system.

Right clicking on the database tree you access the flush menu and the database options.


Report Screen
The Report Screen

On the Report Screen you can create a Report with Server/Variables values and the err.file.

You have also the option to save the Report as text file.


TODO List
The TODO List

-	Creating/Altering Tables (nearest future)

-	Wizard to create Tables with pre-defined structures

-	Import structure/data from others vendors databases

-	Clients capabilities

-	Administration for local/remote MySQL Server