Hi,
I'm trying to install multiple MySQL servers on a single PC.
The services must all listen on port 3306, and be accessible from local
intranet(10.10.x.x)
I have the following IP adresses:
10.10.150.11
10.10.150.20
I have made two .cnf files
my-11.cnf
[mysqld]
datadir = C:/MySQL/data_11/
port = 3306
server-id = 1
bind-address = 10.10.150.11
my-20.cnf
[mysqld]
datadir = C:/MySQL/data_20/
port = 3306
server-id = 1
bind-address = 10.10.150.20
and installed them with the following commands
mysqld-nt.exe --install mysql-11 --defaults-file="C:\MySQL\my-11.cnf"
mysqld-nt.exe --install mysql-20 --defaults-file="C:\MySQL\my-20.cnf"
But it don't work, I always get:
ERROR 1130: Host '10.10.150.11' is not allowed to connect to this MySQL server
when trying 'mysql -h 10.10.150.11 -u root'
please help.
Thanks in advance
Jesper