Arch Linux

Intrepidus

Member

Registered: 2007-02-08

Posts: 54

Remote MySQL [SOLVED]

I'm trying to connect to MySQL from another machine in the network, and not having much luck. What I've done so far:

- Added a line to /etc/hosts.allow that reads 'mysqld: 10.10.0.', also tried explicitly adding the machine, 'mysqld: 10.10.0.98'.
- Commented the 'skip-networking' line from /etc/my.cnf, and restarted the daemon.

This is how I made it function on a Gentoo box, as far as I know, so I'm thinking I'm forgetting something. Not sure what though. Every time I make a connection attempt I get:

Host 10.10.0.98 is not allowed to connect to this MySQL server

So obviously it's rejecting me. Any thoughts? Did I forget something?

Last edited by Intrepidus (2007-08-15 13:20:43)

mucknert

Member

From: Berlin // Germany

Registered: 2006-06-27

Posts: 510

Re: Remote MySQL [SOLVED]

Log in on the Server via Localhost and create a User that is actually permitted to access the Server. Read up on 'CREATE USER' and maybe 'GRANT' for that.

---

Todays mistakes are tomorrows catastrophes.

Intrepidus

Member

Registered: 2007-02-08

Posts: 54

Re: Remote MySQL [SOLVED]

Well I feel intelligent. I thought root had remote access by default...guess not. Sorry.