SalientAnimal Posted August 16, 2012 Share Posted August 16, 2012 Hi All, I have installed a webservice using XAMPP. However I would like my MySQL directory to lie on a different hard drive, hence I installed MySQL prior to installing XAMPP. However I am now having issues access MySQL/Starting the service. Can someone tell me how I can point XAMPP to the correct location for my prefered MySQL installtion directory? Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/267169-mysql-directory-xampp/ Share on other sites More sharing options...
jazzman1 Posted August 16, 2012 Share Posted August 16, 2012 I think, you need to change executable path to the service. What OS you use - Linux, windows, mac? Quote Link to comment https://forums.phpfreaks.com/topic/267169-mysql-directory-xampp/#findComment-1369862 Share on other sites More sharing options...
SalientAnimal Posted August 16, 2012 Author Share Posted August 16, 2012 I'm running Windows Server 2008. Quote Link to comment https://forums.phpfreaks.com/topic/267169-mysql-directory-xampp/#findComment-1369868 Share on other sites More sharing options...
jazzman1 Posted August 16, 2012 Share Posted August 16, 2012 I don't have any experience with windows, but... try to change the path to a service. Quote Link to comment https://forums.phpfreaks.com/topic/267169-mysql-directory-xampp/#findComment-1369890 Share on other sites More sharing options...
Christian F. Posted August 16, 2012 Share Posted August 16, 2012 Check "php.ini", you'll find what you're looking for there. After all, it is PHP, and not the whole package, that you need to tell where the MySQL server can be found. Quote Link to comment https://forums.phpfreaks.com/topic/267169-mysql-directory-xampp/#findComment-1369909 Share on other sites More sharing options...
SalientAnimal Posted August 17, 2012 Author Share Posted August 17, 2012 What do I need to change in the php.ini file? I've lokoed through it, but I'm not sure what to configure/change. The Webserver (XAMPP) is installed on E:\XAMPP\.....(The entire package is then installed in the XAMPP default locations) I want the MySQL instance to run on F:\MySQL\.... Quote Link to comment https://forums.phpfreaks.com/topic/267169-mysql-directory-xampp/#findComment-1370078 Share on other sites More sharing options...
Christian F. Posted August 17, 2012 Share Posted August 17, 2012 You'll find all of the information you need in the PHP manual, in particular the section about MySQLi configuration. Quote Link to comment https://forums.phpfreaks.com/topic/267169-mysql-directory-xampp/#findComment-1370113 Share on other sites More sharing options...
PFMaBiSmAd Posted August 17, 2012 Share Posted August 17, 2012 Assuming you only want to use your own mysql server, instead of being able to use both yours and the one that xampp installs, you will need to stop (don't start) the mysql server that xampp installs and make sure that your mysql server is running (if two services are configured to listen on the same TCP port, only the first one will start.) Your mysql server will then be 'listening' on the default port and your php scripts will connect to it without any other changes. Quote Link to comment https://forums.phpfreaks.com/topic/267169-mysql-directory-xampp/#findComment-1370137 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.