I have mySQL running as a service which starts automagically when windows starts. It loads
xampp\mysql\bin\mysql-nt.exe not
mysqld.exe as is loaded when you start it manually.
I also created a password for user
root so mySQL was secure.
Here is what I see under the relevant tabs in WinMySQLadmin:
Start Check tab (greyed out)
Thare is a my.ini file................... yes
Veryfying the my.ini file keys.
MySQL server path key............... OK
datadir....................................... OK
basedir....................................... OK
my.ini Setup tab (not greyed out)
#This File was made using the WinMySQLAdmin 1.4 Tool
#24/08/2006 2:22:44 PM
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=C:/xampp/mysql (this will be your path to mysql)
#bind-address=111.111.111.111 (this will be your IP)
datadir=C:/xampp/mysql/data (this will be your path to the data directory)
#language=C:/xampp/mysql/share/your language directory (same here)
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/xampp/mysql/bin/mysqld-nt.exe
user=root
password=myrootpasswordhere
Databases tab
a database tree.
MYComputerNameHere (111.111.111.111) - My IP in the brackets
database 1
database 2
database 3
etc.
etc.
I was able to replicate your problem by renaming the my.ini file that is stored in the C:/Windows directory.
I renamed it back again and opened WinMySQLadmin again and all was working fine.
It saves the my.ini automagically as indicated in the
my.ini Setup tab
Posted: 24. August 2006 04:17