-4

When I changed my development machine to a Mac, it created case sensitivity problems with the database on my XAMPP server. I was attempting a solution offered here: MySQL case sensitivity table name on MacOS with case insensitive file system to solve this, which to summarise is to create a case-senstive volume on the disk, move the mysql directory to this volume and create a symlink to it. As instructed I made a backup of the mysql directory. I got this message when I tried to access the database with PhpMyAdmin:

 mysqli::real_connect(): (HY000/2002): No such file or directory

I removed the symlink, restored the mysql directory and then found the MySQL server would not start.

Improve this question
4
  • Moving MySQL files around can be problematic, especially if you don't stop MySQL first. You might look at this question, but if that doesn't help you, ask on Database Administrators. Get the MySQL error log before you post there. Commented 2 days ago
  • Is that error from PHP or from MySQL error.log? Commented 2 days ago
  • 1
    Another problem is that xampp replaced mysql with mariadb years ago. Commented 2 days ago
  • Thank you everyone for trying to help. It was late at night (UK time) and I should have realised that it was a permissions problem. All fixed with chmod. Commented yesterday
Related questions
1200
How can I start PostgreSQL server on Mac OS X?
902
Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server
875
Duplicating a MySQL table, indices, and data
Load 4 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.