WinMySQL Professional - Getting started

Software installation

WinMySQL Professional is packaged in two versions : an autosetup version and a zipped version compressed with PKZip 2.04g.

Obviously, to install the autosetup version, you only need to double-click on «wmpsetup.exe» and follow the instructions.

To install the zipped package, create a directory where you want to put WinMySQL Professional (the dirname doesn't really matter), then use a PKUnzip 2.04g or compatible software to extract at least two files : «wmyspro.exe » (the program) and «wmyspro.dll» (its shared library) and put them into the directory that you have created.

WinMySQL Professional can work properly with only these two files but its actual format requires a third file : «wmyspro.hlp», the file that you are reading for the time ! In the original package, you also will find two additional files («register.exe» and «register.hlp») for e-mail, mail, fax, phone ... registration.

You can note WinMySQL Professional is so compact that its installation is very easy with no DLL copied in \WINNT or \WINDOWS\SYSTEM, with no entry into the register database ... WinMySQL Professional can be installed on a floppy disk and doesn't need to be packaged on a CD-ROM. An enormous work during WinMySQL Professional development was to take care to the code size and the software stability even in critical cases (such as connections killed during a query ...)

WinMySQL Professional performs its transactions with the servers under TCP/IP network protocol. Check wether this protocol is installed and configured on your station. In Microsoft® Windows® 95, TCP/IP was supplied on the install disk but wasn't default installed ! For further informations on «How to install and configure a TCP/IP stack ?», please, refer to your operating system manual.

At the first launch, WinMySQL Professional runs as an unregistered shareware copy, with the slowing mechanism. To register, please, refer to the «Submenu ?>Register» section.

MySQL® server requirements before the first launch

Before any use of WinMySQL Professional, you must manually demand to the MySQL® server to allow the stations where WinMySQL Professional is installed. If the server is hosted by Microsoft® Windows® NT® and WinMySQL Professional is installed on the same machine, you can skip this step because, by default, the «root» user can do everything from «localhost». Otherwise, follow this procedure :

[1] Connect to the server with telnet.

[2] At the OS prompt, type mysql –u root –p mysql to launch the MySQL® command line client.

[3] At the mysql client prompt :

if the MySQL® server uses the old privileges system (such as the GPL version), type :

insert into user values ('%','yourname',password('yourpassword'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

otherwise :

insert into user values('%','yourname',password('yourpassword'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

[4] Then, quit the mysql client :

exit

[5] Refresh the MySQL® server to reload privileges. At the OS prompt :

mysqladmin –u root –p reload

[6] Disconnect from server.

Now, WinMySQL Professional is allowed to connect from any station over the world with user «yourname», password «yourpassword», with all privileges on all databases of this server.

Of course, you can restrict the connection range with portion of IP address or with a domain name at the place of «%» in the «insert» query, but anyway, you can now also, use WinMySQL Professional to do it with some clicks of mouse !

For further informations on «How do the MySQL® privileges work ?», please, refer to the MySQL® user's manual.