Description:
Dear Sir/Madam,
I have just installed MySQL 5.0 in WinXP with IIS 5.1 using the Windows x86 binary file (40,656KB), in my D:\MySQL\MySQL Server 5.0 directory, together with D:\MySQL\MySQL Administrator 1.0; D:\MySQL\MySQL Query Browser 1.1 and MyODBC 3.51.11 (with anonymous login just to see if the release had really improved MySQL). Please note that, as an individual developer I have important security, space and fragmentation reasons to AVOID installing the MySQL server (and others) in my C drive. Anyway, I found out that:
- After install, the Administrator could NOT login in the MySQL account, using the registered username and login, since it "Could not resolve hostname D:/MySQL/MySQL Server 5.0/bin".
- After install, the Query Browser could NOT login in the MySQL account, using the registered username and login, since it "Could not resolve hostname D:/MySQL/MySQL Server 5.0/bin".
In addition the following DOS command-line has the following response:
- Typing a "mysql" command in a DOS windows started the service correctly.
- Typing a "mysql \h" command in a DOS windows showed help correctly, and allowed to LOG IN the system as current user "ODBC@localhost" (This should NOT work like this).
- Typing a "mysql \s" command in a DOS windows showed status correctly.
-> Typing a "mysql --console" command did NOTHING !
-> Typing a "mysqladmin -u root shutdown" did NOTHING !
- Typing a "mysql \q" command exited correctly.
- Typing a "mysqlshow" command worked correctly.
- Typing a "mysqlshow mysql" command worked correctly.
- Typing a "mysql -e "SELECT Host,Db,User FROM db" mysql" command worked correctly.
Sincerely,
Luiz Cruz
How to repeat:
Just install it using the options: Detailed, Developer Machine, Multifunctional Database, Decision Support (DSS)/OLAP, enable TCP - Port 3306, Standard Character Set, set a root password for the server, create an anonymous user account for the first installation trial (not used in the final install), set the INI file in C:\Windows directory, install MySQL in D:\MySQL\MySQL Server 5.0. Next, install the other packages in the directories D:\MySQL\MySQL Administrator 1.0, D:\MySQL\MySQL Query Browser 1.1, and the ODBC 3.51.11 driver.
Now just test.
