469,658 Members | 1,680 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,658 developers. It's quick & easy.

Access MySQL DB from internet

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..?
Oct 11 '07 #1
3 1688
I have found a handy utility called Navicat

You can get it here http://www.navicat.com/download.html
Oct 12 '07 #2
ak1dnar
1,584 Expert 1GB
PhpMyAdmin also a good one. and open source too.
Oct 13 '07 #3
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
Oct 13 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Otto Krüse | last post: by
9 posts views Thread by Daven Thrice | last post: by
2 posts views Thread by Beda Christoph Hammerschmidt | last post: by
2 posts views Thread by areejan2000 | last post: by
49 posts views Thread by Mell via AccessMonster.com | last post: by
3 posts views Thread by Kevin Killion | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.