The user specified as a definer (' root ' @ '% ') does not exist

The user specified as a definer (' root ' @ '% ') does not exist This type of error is mainly caused by access to the view file (no permissions)

Workaround:

2. Before you enter the MySQL installation path, make sure that your MySQL service is turned on;

Enter the mysql-hlocalhost-uroot-p password in the DOS command window

Analytical:::

In the DOS command window input mysql-hlocalhost-uroot-p Enter the MySQL database ,

Where- h indicates the server name, localhost indicates local;

- u is the database user name, root is the MySQL default username;

- p for the password, if the password is set, you can directly after- p link input, such as:-p123456, the user does not set the password, display enter password, directly enter.

Note that if your MySQL is not installed in the C drive, you will need to use the DOS command to go to the bin directory in the MySQL installation directory.

The method is as follows: input D: Enter D, enter CD D:\Program Files (x86) \mysql\mysql Server 5.7\bin into the bin directory of MySQL can input mysql-h Localhost-uroot-p

3. Add permissions to MySQL

Analytical::::

Permissions issue, Grant root all SQL permissions

Mysql>Grant all privileges on * * to [e-mail protected] "%" identified by ".";
Query OK, 0 rows Affected (0.00 sec)

Mysql> flush Privileges;

Query OK, 0 rows Affected (0.00 sec)

The user specified as a definer (' root ' @ '% ') does not exist