Not sure why I had to take this mysterious detour - probably something local to my machine, but if you're having trouble after following the guide above, see if it helps. Are you seeing Fatal error: Can’t open and lock privilege tables: Incorrect file format ‘host’ Following is what I did removed mysql-server (yum remove mysql-) re-installed mysql-server (yum install. Just to be clear, leave the original file where it is, untouched and unharmed throughout this step. Cannot start mysqld (Fatal error: Can’t open and lock privilege tables: Incorrect file format ‘host’ ) by robin When MySQL is installed on Linux, Unix, or Mac, a script is sometimes installed that you can use to start and stop the server, with one of the following. Since out Xserve has mySQL built in, we will use that. We are wanting to start looking into developing some web applications and use SQL for the databases. 4 Comments 1 Solution 511 Views Last Modified.
I chose it to start up every time my Mac starts up, however this doesn't work, I have restarted MySQL many times, but it will not start up at all which I require to start up manually. Cannot connect to mySQL server on Mac OS 10.5 server. After which, I was able to delete the duplicated file and everything now works without issue. In the System Preferences panel, I have the MySQL there.
What I did was duplicate that file in the same folder and changed the duplicate's name to 'index.html', leaving the original in situ.īoth local and user sites then loaded. Dump all tables: mysqldump -A > dump.sql. This contains the text "It works!" referred to in the post. (they suggest 4, but its best to start with 1 and increment if it wont start) Restart mysqld ( service mysql start ).
However, if, like me, you still can't get the local host site to load, try the following: You should find a file at /Library/WebServer/Documents/. I tried logging out and back in (still no joy), then restarting the mac (still no joy). Just a note, in case anyone has the same issue.