GreenSQL
mysql ERROR
Wed, 06/23/2010 - 10:39
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
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)