creating a mysql user with remote access

[lkbryant]

Hi, Im trying to add a mysql user that has access from anywhere (not just localhost)

So, it says that % is the way to go.

However, even after I added a user with % as host, I still can't seem to get the user logged in from different host.

I recall getting this to work on some other server but not on this server (with the directadmin package install)

How can I get this thing to work?

is there some kind of firewall setting im not aware of? i don't seem to have any firewall as far as i know.

this is a fedora core 3 btw.

anyone got experience on this?


anyone wanna give me a mysql command with an example to create a remote anywhere access for mysql?
I'd really appreciate it.

 

[jmstacey]

It could be a firewall, either on your server or the server that's trying to connect remotely to MySQL's remote port. Or remote access might have been disabled on your server for some reason (a master overide from the access hosts list).

 

[lkbryant]

welp, i figured it out.

it seems that mysql 4.x and greater uses a different type of password algorithm.

Therefore , I had to UPDATE my user with the OLD_PASSWORD function.

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;