Helpful ReplyLocked[FAQ]Debian 4.0 mysql issue

Premium Member
2008/01/22 03:30:48 (permalink)

Debian 4.0 mysql issue


I have setup dedicated debian machine for one of my reseller. I have installed HC7 linux build8 and configured it into HC cluster. But I am not able to create mysql db through HC panel. Even I have granted root user on debian machine Ip using below command

mysql> grant all privileges on *.* to root@ipaddress identified by 'rootpassword' with grant option;

Still nothing helping me... I will appreciate for any assistance ?
HC Team
Hosting Controller
RE: Debian 4.0 mysql issue 2008/01/22 05:51:42 (permalink)
In Debian by default Mysql can not listen remotely on localhost therefore you need to set 'bind-address' as machine IP in this file /etc/mysql/my.cnf of your linux server.

HC Support Team
Premium Member
☄ Helpful
RE: Debian 4.0 mysql issue 2009/06/06 01:05:09 (permalink)
FYI, In ubuntu you can configure remote mysql using instructions

skip following line in /etc/mysql/my.cnf


#bind-address =

  Restart mysql service /etc/init.d/mysql restart
Jump to: