View Full Version : installing mysql on remote comp
04-14-2009, 03:08 AM
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
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?
04-14-2009, 03:53 AM
i have the access to server using remote connection
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.
Powered by vBulletin® Version 4.2.2 Copyright © 2015 vBulletin Solutions, Inc. All rights reserved.