Running on RH, Apache. I had this working on Win2K, then switched to Linux by copying the .MYD, .MYI, *.frm files over. SELECTs work fine, but not INSERTs. It failed from a php page, and then I telneted in, su to root, run MySQL, and issued the same INSERT that PHP failed on, and the error message is the above subject. I checked the file-level permissions, they are fine.

    8 months later

    Chad,

    Did you ever resolve the issue with your table permissions? I'm running into the same problem and tried everything like flush-privileges, flush-tables, etc. I'd be curious to hear what the problem is and how to solve it.

    Thanks,
    Dennis

      4 months later

      I meet such question in Windows 2K enviroment too.
      previously I install another mysql (which is on my F:\mysql),I stop it and install the mysql on C:\mysql; The path of mysql server
      points to C:\mysql\bin\mysqld-nt;
      But after I install C:\mysql\bin\winmysqladmin, I found in "my.ini Setup", "datadir=F:/mysql/data Server=F:/mysql/bin/mysqld-nt.exe", then I modified them to "datadir=c:/mysql/data Server=c:/mysql/bin/mysqld-nt.exe" and save it; reinstall mysql. Everything is ok!
      Good luck to you! 🙂

        3 years later

        For me, Iwhen I encountred this pb, I just restart Linux, and it was OK.
        So, the solution is in restarting perhaps only mysql service (I don't know exactly how), or simply to all restart (Linux).

        good work

          Write a Reply...