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