G
Database Security. Database Auditing. Database Caching. Database Masking. Get it nowmysql ERROR
Posted June 23rd, 2010 by semenov
in
I have it set up to the following:
Frontend IP: MY MAIN IP (removed for security)
Frontend port: 3305
Backend server name: localhost
Backend IP: 127.0.0.1
Backend port: 3306
It says this in the database section:
Database: MY DATABASE (removed for security)
Listener settings
Name: Default Proxy
Frontend: MY.MAIN.IP:3305
Backend: localhost:3306
Status: Listener is 'OK'
Type: mysql
1 mysql -h 127.0.0.1 -P 3305 -u root -p
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1'
i can connect only mysql -h (my.ip) -P 3305 -u root -p
i
Comments
it is normal :p because you
it is normal :p
because you have set your main ip as Frontend Ip :D.
if you want to be able to connect with your localhost address, you must set 127.0.0.1 in Frontend IP.
At the end, if you want to use both localhost and main ip, i think the only solution is to create two proxy (one with 127.0.0.1 in Frontend, and the other with your main ip)