Notes for database migration in Linux

1. you can directly download the database from a Linux server and put it under the Directory of another database to complete the migration. Note the directory permission issue. After the migration, the directory permission belongs to the root group. here we want to change it to the mysql running user's & nbsp; chown-R & nbsp; mysql. mysql

1. you can directly download the database from a Linux server and put it under the Directory of another database to complete the migration. Note the directory permission issue.
After the migration, the directory permission belongs to the root group. here we will change it to the chown-R mysql. mysql databasename of the mysql running user.
2. after changing the IP address and password of the connection file in the program, the website still cannot be accessed normally. how can this problem be solved? Program error, cant select database
It may be because the root user in the program does not have access permissions in mysql on linux, so do the following:

Start mysql on linux to enter the client program and run the following command:
Use mysql;
Grant allprivileges on *. * to root@localhost.localdomain identified by "root password" with grant option;