Access MySQL DB from internet

[tamilnandhu]

Hi, i installed MySQL in my linux.

I want to access this Database from Internet Or from local LAN.

So can u pls help, how to do this..?

In my linux machine, i use 'mysql -u root -p' to get into MySQL DB.

But through nternet or LAN, how to do this..?

[duncanusher]

I have found a handy utility called Navicat

You can get it here http://www.navicat.com/download.html

[ak1dnar]

PhpMyAdmin also a good one. and open source too.

[beppeilbuono]

Hi, i installed MySQL in my linux.

I want to access this Database from Internet Or from local LAN.

So can u pls help, how to do this..?

In my linux machine, i use 'mysql -u root -p' to get into MySQL DB.

But through nternet or LAN, how to do this..?

hi, sorry for my english .......blah,blah,blah
in a lan
server
you must create or modify user to able it to connect from a remote client
sintax: grant <privileges(all for all)> on <dbname.*(*-* for all) to '<user>'@'<ip of remote machine (%=all ips)' identified by '<password>'
ex
grant all on *.* to 'master'@'%' identified by 'mypwd''

client
you must have mysql.exe(windows) on the client (or what you use in linux). Do not install it !
type
mysql -umaster -pmypwd -h<ip address of the remote server> -P<port> (if not standard port 3306)
add 'with grant options ' to ability grants to remote client to create/modify/delete other users
also you can use the MySqlAb's utility from
http://dev.mysql.com/downloads/gui-tools/5.0.html