"Alfredeen, Johan" <[EMAIL PROTECTED]> wrote: > My webhost recently migrated my site over to a new server and IP. Everything > looks ok, except that all my MySQL tables now are read-only (at least that's > the error I get when trying to delete or insert records). How do I change > the tables back to write? Can I switch individual tables to write or is > there a setting to set the whole db instance to write? > > I am using MySQL 3.23.32 and phpAdmin 2.2.0rc3. I appreciate your help.
It sounds like your user doesn't have all the privileges you need, or at least doesn't have all of the privileges you need for that specific database. Ask your web host to give you the necessary privileges in the user and db tables of the mysql database. If the web host is clueless ask them to send you the output of the following and post to the list so we can help. SELECT * FROM mysql.user WHERE user = 'yourusername'; SELECT * FROM mysql.db WHERE user = 'yourusername'; BTW, this is really a purely MySQL problem and is better suited for the mysql mailing list. See mysql.com if you'd rather take the topic there. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
