MySQL 1449: the user specified as a definer (‘root ‘@’%) does not exist solution

Sqlexception: access denied for @’localhost ‘(using password: no)

Sqlexception: access denied for @’localhost ‘(using password: no)

Solutions grant all privileges on *. * to joe@localhost identified by ‘1’;

flush privileges;

Log in with Joe 1

Attached:

mysql> Grant permission 1, permission 2,… Permission n on database name
permission 1, permission 2,… Permission n represents 14 permissions, such as select, insert, update, delete, create, drop, index, alter, grant, references, reload, shutdown, process and file
when permission 1, permission 2,… Permission n is replaced by all privileges or all, it means that the user is given all permissions
when the database name and table name are replaced by *. *, it means that the user is given permission to operate all the tables of all databases on the server
the user address can be localhost, IP address, machine name and domain name. You can also use ‘%’ to indicate a connection from any address
“connection password” cannot be empty, otherwise the creation fails

mysql> grant select,insert,update,delete,create,drop on vtdc.employee to [email protected] identified by ‘123′;
assign the user Joe from 10.163.225.87 the permission to select, insert, update, delete, create and drop the employee table of the database vtdc, and set the password to 123
mysql> grant all privileges on vtdc.* to [email protected] identified by ‘123′;
the user Joe from 10.163.225.87 is assigned permission to perform all operations on all tables of the database vtdc, and the password is set to 123
mysql> grant all privileges on *.* to [email protected] identified by ‘123′;
assign the user Joe from 10.163.225.87 the permission to operate all tables in all databases, and set the password to 123
mysql> grant all privileges on *.* to joe@localhost identified by ‘123′;
assign the local user Joe permission to perform all operations on all tables in all databases, and set the password to 123