mysql problem....

yenonn · 10-22-2003, 01:06 AM

hi,

i have a mysql working so well in my rh8. and then, now, what if i want to allow a user from internet(outside the firewall) to access my db? what should i do? how do i define the user account???
user@???WHAT IS THE PROPER IP???....
and another thing is that, how should i make a secure connection, making sure only the allowable user are accessing the db??pls advise...thanks....

Cheers,
yenonn

uthlekan · 10-22-2003, 12:01 PM

Try

user@localhost

ra_adi · 10-22-2003, 01:00 PM

I think you should try something like phpMyAdmin. It is easy to use and to configure access to users on certain data bases.

markus1982 · 10-22-2003, 01:12 PM

i suggest you read the mysql docs:

http://www.mysql.com/doc/en/index.html

also connecting from the internet to a database without ssl is insecure and also slow if the machines are not both on broadband connection. you should rather host the scripts, etc on the same machine or at lease a machine close to your machine.

tcp/ip connections are 10% slower btw!