Help Accessing Mysql Server

[slevytam]

Hi,

Just a quick question. I have setup a mysql server on my windows server 2003 box. The mysql server works fine and is running on port 3306.

For some reason I can't figure out how to connect to this server from another computer. Do I have to enable telnet capabilities or is there another way of doing this?

Thanks,

SL

[TheDefender]

What methods have you tried for connecting to the server from other computers?

[slevytam]

Thanks for your reply.

The only way I know of is to allow telnet access to the system. I would rather not do this for security reasons...

--SL

[Drakla]

What kind of connections are you after?

Another php script, or the command line version of mysql on another machine?

[slevytam]

command line access would probably suit me best

thanks,

sl

[Drakla]

Well you just have to set up a new user and allow them access from whatever host they're on...

so for all privileges on all tables from the host somewhere.com do

GRANT ALL ON . TO 'someuser'@'somewhere.com' identified by 'password';

or if you want access from any host do:

GRANT ALL ON . TO 'someuser'@'%' identified by 'password';

You can even include a group of IP values with

GRANT ALL ON . TO 'someuser'@'212.32.44.%' identified by 'password';

then do FLUSH PRIVILEGES and they can logon via their own mysql command line by putting in your host and whatever password/username you've set up.

[MikeA]

Drakla,

Is it possible to do something like:

GRANT ALL ON . TO 'someuser'@'somewhere.com'

leaving off the IDENTIFIED by?