Database Permissions Issues

is the MySQL database server has a formal website now want to get a test site because the database is too large to import, so into the server to copy a database changed the database name of the original site also copied a copy, changed the site's configuration file, the database user name and password has not changed now browse the test site Discovery can query but update will prompt without update permission to ask what might be the reason

Reply to discussion (solution)

Permission is set without permission

Permission is set without permission

Copy of this database user name and password is the total account should not have the right to update the original database additions and deletions can be changed

If you're testing a Web site, set the permissions to a maximum of 777.

Modify user Information After you modify the submission prompt update command for database user name @localhost denied

Found the reason is not the total account, copy the database after the anonymous access

