Helpful ReplyLocked[FAQ]Debian 4.0 mysql issue

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

Debian 4.0 mysql issue

hi,

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 ?
#1
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
support@hostingcontroller.com
http://hostingcontroller.com
+1-213-341-1419
#2
patrick
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

#skip-external-locking

#bind-address = 127.0.0.1

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