I have a dedicated server (CentOS 5.3) but I can't log on to mysql as admin from outside, however I can do that when I'm on server's command line. I assume there's a setting somewhere that can give me the access I need, but I don't know where.
There are several factors and your question doesn't include enough information to know which of these you are up against.
First make sure your server is listening on your network port. Listening on just
Next make sure you are using TCP networking at all. Mysql can use just local sockets, so make sure this line is commented out in your config:
That done you should have a mysqld daemon listening. You can test like this:
(Note that my sample output is only listening on localhost! Yours should read with your interface IP or
Lastly you need to have the right privileges setup in mysql itself. Each user has a host that it is allowed to connect from. If you ran your