Database permission problems

The database permission problem is that there is a formal website on the mysql database server. now I want to get a test website because the database is too large to be imported, so I copied a copy of the database on the server and changed the database name to copy the original website and changed the website configuration file, the database user name and password have not changed. now you can view the test website and find that you can query the database. However, if you update the database, you will be prompted that you do not have the update permission.

Reply to discussion (solution)

Set permissions if you do not have permissions

Set permissions if you do not have permissions

The copied database username and password use a general account. you should not have the update permission to add, delete, modify, and query the original database.

Since it is a test website, the permission is set to a maximum of 777

After modifying user information, submit the following message: update command for database username @ localhost denied

The reason is not the total account. the database is accessed anonymously after being copied.