MySQL environment deployment and problem solving under Linux

Connect MySQL User: mysql-u root-p Enter password

Create DATABASE: "Database name"

Copy data: Navicat Transfer data function

Problems that occur during the process:
1, open the table, reported 1018,can ' t read dir of '. xxxx ' (errno:13) Workaround:
View the MySQL directory properties and discover that the owner of the directory is an Oracle user, not MySQL. Check which group the MySQL user belongs to (groups MySQL), find the MySQL group, modify the directory owner Chown-r Mysql:mysql/u01/mysql

2, the root login does not have permission to resolve the method:
Although Root has all the permissions, but the IP of the remote connection does not have permission to give the connected IP rights
Grant all privileges the on Library name. Table name to ' user name ' @ ' IP address ' identified by ' password ' with GRANT option;
such as: GRANT all privileges on . To ' root ' @ ' 192.168.x.x ' identified by ' password ' with GRANT OPTION;
Then be sure to perform the update flush privileges;

MySQL environment deployment and problem solving under Linux