How to install MySQL on different Port?
Posted on 2004-11-10
I'm having a very difficult time trying to install MySQL as a Servicee on a port other than 3306 (Default).
If I can get one to work then I can get 2 to work which is the ultimate goal.
I have trieed to install MySQL on Win2K Pro, and Win2k3 Standard Server both giving me the same exact problem.
First of which I install c:\mysql\bin into the path and triedd the following
c:\mysqld --install mysqld1 defaults-file=c:\my1.cnf
The item mysqld1 is listed in the Services List, but will not start
Gives and error #2.. cannot finnd specified file
same on 2Kpro as on 2k3 server
I then tried a different way.
I typed the entire path and got further
c:\mysql\bin\mysqld --install mysqld1 defaults-file=c:\my1.cnf
This time the service did much better at starting.. got up to 75%, then failed
Does anyone know what the trick is to install MYSQL as a Service on Windows to a different Port?
also tried to include 2 entries in the standard my.ini
each using different ports: 3308, 3310
Any help would be much appreciated.
Thanks - Glen