...

View Full Version : installing mysql on remote comp



Mirror_Image
04-14-2009, 02:08 AM
hi ,


Currenlyt i am using localhost and wamp to check php/mysql code.

We have one server in company where all shared files are on there.

Is there any way to install mysql on that remote server and then use that on client computers as database server

bdl
04-14-2009, 02:34 AM
Absolutely. In fact this is preferred, in my opinion.

Do you need help installing it on a server that is "literally remote", i.e. you have no access to it from where you are? Or just the concept in general?

Mirror_Image
04-14-2009, 02:53 AM
i have the access to server using remote connection

bdl
04-14-2009, 04:10 AM
Ok. Well, if you have the ability to install software on the machine remotely, then by all means go ahead and install MySQL on it. Just remember that when you do, you must enable TCP/IP instead of pipes (on Windows) or a socket (on UNIX/Linux). The standard MySQL TCP port is #3306. Once you've got networking enabled, you have to then consider how to set the users up. What I'd do is leave the 'root' user on localhost (i.e. the remote server's loopback 127.0.0.1 address), and always login to the remote server first, then login to MySQL as the 'root' user on the server itself. Otherwise, be sure to tighten down the 'root' access to a single IP address, maybe your desktop. Then you can create as many users as you require to connect from different nodes on the LAN, either using the IP/MASK type configuration, or specific IP addresses for each user, or just '%' to allow them to connect from any host. The latter is the lazy way; just be sure to lock your LAN down and not allow inside access to the MySQL server machine.

Check the MySQL manual (http://dev.mysql.com/doc/refman/5.1/en/) for installation and user admin info.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum