Grant access from dynamic ip

[willjay]

I am trying to access mysql on a remote server over the internet. The odbc
driver says that

ro**@myCurrentIPaddress.com does not have access to mysql.

How do I grant access to root from a remote computer.

Thanks
wj

[ChrisP]

Go into mysql on the server and "use mysql" then
select user, host, password from user;
On a default install you will find two entries for root - both with no
password but one for localhost and one for % which is any IP - I suspect
you will be missing the % entry so just create a new user (look up the
syntax on mysql.com).

If you are accessing you systems remotely and don't have public access
you should seriously consider static IP and only allowing that through
your firewall.

willjay wrote:

I am trying to access mysql on a remote server over the internet. The odbc
driver says that

ro**@myCurrentIPaddress.com does not have access to mysql.

How do I grant access to root from a remote computer.

Thanks
wj

[ChrisP]

Go into mysql on the server and "use mysql" then
select user, host, password from user;
On a default install you will find two entries for root - both with no
password but one for localhost and one for % which is any IP - I suspect
you will be missing the % entry so just create a new user (look up the
syntax on mysql.com).

If you are accessing you systems remotely and don't have public access
you should seriously consider static IP and only allowing that through
your firewall.

willjay wrote:

I am trying to access mysql on a remote server over the internet. The odbc
driver says that

ro**@myCurrentIPaddress.com does not have access to mysql.

How do I grant access to root from a remote computer.

Thanks
wj