Run XAMPP and "local" installation of MySQL

[pir]

Hi!
I'm pretty new to databases and started to use XAMPP and it works great. I have a local website that is using a database. I would like to be able to run PHP scripts in my terminal which updates the database used by the website. When I run my scripts in the terminal the following warning is printed: "PHP Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock) ". I guess that this is because XAMPP has installed MySQL in some other location than the one normally used by the PHP installation on my Mac.

What I'm thinking is that I should install MySQL "locally" on my Mac. What I am wondering is if this would create problems with my MySQL databases which are accessed from XAMPP. Can I access the same databases from both my XAMPP installation of MySQL and my "local" installation of MySQL. I still want to use XAMPP since I using it when testing my website. So I want the two installations of MySQL function in parallell using the same databases.
Or is there some other more easier solution to my problem?

Please tell me if my question is unclear or if I'm doubleposting a question. I have searched the forum, but without any success.

thanks
pir

[MegaChriz]

Hi pir,

I have no experience with running PHP scripts in the Terminal (I usually place PHP-scripts that I want to run in a folder accessible by the webserver - for example the htdocs folder - and then run the script within a browser).

However, I do know where the mysql that comes with XAMPP is located:
/Applications/XAMPP/xamppfiles/var/mysql

Although I have no experience with it, I think it will be hard to install MySQL on a different location and then link XAMPP with it. I've read that some of the paths in XAMPP are hardcoded (but I don't know which ones), so it might be even impossible.

I guess it's the easiest to point to /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock in the Terminal, if that works.

MegaChriz

[pir]

Thanks MegaChriz!
It worked really well. What I did was to set the mysql default socket to point to the mysql.sock located in /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock, as you wrote, in the php.ini on my system. That was the only change I needed to do. This saves me a lot of time not needing to run my database scripts in the browser.

BR
pir