MySQL DB Server Issues

RomeoS · 2 Mar 2006 at 19:10

I have a Apache2 webserver running on 10.0.0.102 (Running Windows 2003 Standard) and a MySQL DB Server on 10.0.0.70 (Running Windows 2000 SP4).

On the webserver (10.0.0.102), I have set up a forum that can be accessed via a no-ip domain. What I want is the forums DB to be installed on 10.0.0.70. I have enabled remote root access and made sure its running on port 3306 (netstat confirmed).

On forums install, I select MySQL version 5 and enter the IP instead of localhost and fill the username and password.

Regardless of what I try, I get "Can not connect to the Database".

What am I doing wrong? I seperated MySQL because its going to be used pretty heavily and now need a dedicated box for it.

MySQL version: 5.0.18

RomeoS · 2 Mar 2006 at 19:40

Hi mate,

Does port 3306 need access to the external world? Neither the Apache or the MySQL box have firewalls running, they sit behind the routers firewall.

How would I allow the DB user (root in this case) to accept connections from .102? During the MySQL config, I enabled "allow remote root access" which I would have thought ment user "root" could connect from .102?

RomeoS · 2 Mar 2006 at 21:43

Firefox can't find the server at sunsite.mff.cuni.cz.

Ive tried adding another user and giving it full priviliages but no luck

RomeoS · 2 Mar 2006 at 22:14

That page you linked to, firefox cant find it

Ah its working now, I've already given root full privilages

RomeoS · 2 Mar 2006 at 22:57

Just tried some of those instructions again but still cant get it to connect

Compleatly baffled now

RomeoS · 2 Mar 2006 at 23:58

burbleflop said:
From the 2K3 box, what happens if you telnet to port 3306 on the 2k box? Ie, start, run, cmd, 'telnet 10.0.0.70 3306'

If it works you should get a message showing you the MySQL Server version.

Yup, get MySQL version> at the command prompt followed by some random characters, then disconnection.

You can check where root can connect from if you do:

select Host,User from mysql.user where User="root";

If you don't get back a record listing either the IP/DNS name of the 2k3 box or a record with % (meaning anywhere) as the host, then root can't connect from the 2k3 box.

Dont have enough milliseconds to copy paste that before I get disconnected because of above problem.

Personally I'd not connect to the DB as root from an application since root has control over everything, not just the DB you're working on. I'd do this:

grant all privileges on forumdb.* to [email protected] identified by 'password';

That way you have a user called forum_user who can connect from 10.0.0.102 only, using the password you specified. The user has full access to all the tables in the db called forumdb but no access to anything else. If you knew exactly what privs the forumdb user needed you could just grant it those.

Left it as root for now to eliminate any permission problems that may arrise, once its up and running i'll set up a limited user

RomeoS · 3 Mar 2006 at 18:04

Tried that on the machine, root can connect locally fine as I can also log into phpmyadmin

RomeoS · 3 Mar 2006 at 19:33

I see two copies of user "root"

One is root@% other is root@localhost

RomeoS · 4 Mar 2006 at 18:48

Bought a copy of this:

http://www.navicat.com/

VERY user friendly and a top software package. It connects fine localy to the MySQL Server.

Also have PHPMyAdmin installed which connects fine

RomeoS · 4 Mar 2006 at 19:18

Yup, they both connect fine locally, if I go to 10.0.0.102 and type in http://10.0.0.70/phpmyadmin, I get the phpmyadmin screen

RomeoS · 5 Mar 2006 at 00:17

I cant get phpmyadmin to work from 10.0.0.102 but I can log in to MySQL server using the navicat software.

Possible problem with the actual webserver software?