There is a difference between accepting remote connections and your user being able to login remotely.
Try telnetting to the server remotely e.g. Telnet servername 3306 If you get a connection you then know it's about setting your user to have remote access privileges. A On Thursday, 1 September 2011, Matt C <[email protected]> wrote: > This was solved by manually running the commands... > > # /usr/sbin/groupadd mysql > # /usr/sbin/useradd -r -g mysql mysql > # chown -R mysql . > # chgrp -R mysql . > > Now OpenBDJam will successfully and fully start up, but I can't access > Mysql from outside localhost. I'm assuming certain options were > defaulted to work like this out of security concerns, but I am trying > to enable outside TCP/IP connections. I've editted the /etc/my.conf > file to include "bind-address = *" and I verified the line that > disables Mysql networking was disabled. I created a passworded user > in Mysql that has access from any host. I added a rule to our > firewall to allow connections to port 3306. Any idea what I might be > missing? One thing that piques my attention is that the following > command... > > mysqladmin -h `hostname` --port=3306 version > > results in... > > Server version 5.1.49 > Protocol version 10 > Connection localhost.localdomain via TCP/IP > TCP port 3306 > Uptime: 15 hours 40 min 19 sec > > Does "localhost.localdomain" imply that I'm still only accepting local > connections in Mysql? > > On Aug 31, 10:25 am, Matt C <[email protected]> wrote: >> Sorry to post again so soon. I've now got OpenbdJam installed, but >> when I navigate to the directory and use the command "./openbdjam >> start", I get the following output... >> >> ------------- >> MySQL user has not been setup ... doing it now >> /opt/openbdjam/bin/runOnce: line 16: groupadd: command not found >> /opt/openbdjam/bin/runOnce: line 17: useradd: command not found >> chown: `mysql': invalid user >> chgrp: invalid group `mysql' >> chown: `mysql': invalid user >> Starting MySQL5.1... >> Starting Jetty7.1... >> Starting Apache2.2... >> [root@localhost openbdjam]# >> ------------ >> >> If I try to start mysql manually by going into its bin directory and >> running "./mysqld start", I get... >> >> ----------- >> 110831 10:23:18 [ERROR] Can't find messagefile '/usr/local/mysql/share/ >> english/errmsg.sys' >> 110831 10:23:18 [Warning] Can't create test file /usr/local/mysql/data/ >> localhost.lower-test >> 110831 10:23:18 [Warning] Can't create test file /usr/local/mysql/data/ >> localhost.lower-test >> ./mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2) >> 110831 10:23:18 [ERROR] Aborting >> >> 110831 10:23:18 [Note] >> ----------- >> >> What I suspect might be the problem is that I cannot log in directly >> to our VM as root. I logged in as my user, then su'd. Can anyone >> verify if this is my problem? > > -- > official tag/function reference: http://openbd.org/manual/ > mailing list - http://groups.google.com/group/openbd?hl=en > -- Alex Skinner Managing Director Pixl8 Interactive Tel: +448452600726 Email: [email protected] Web: pixl8.co.uk -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
