MySql LAN connection permission problem solution: you only need to execute a command on the MySql console, that is, assign the LAN connection permission command: grant all privileges on *. * to identified by '1'; Explanation: you can log on to the localhost with the user's joe password 1. ** 192.168.1.19 can be any host in the LAN.
Explain the explain command: mysql> grant permission 1, permission 2 ,... Permission n on Database Name. table name to user name @ user address identified by 'password; permissions: www.2cto.com select, insert, update, delete, create, drop, index, alter, grant, references, reload, shutdown, process, file, and other 14 permissions: all privileges or all indicates that all permissions are granted to the user .? Table Selection: database name. Table Name, *. * indicates all tables of all databases
Example: mysql> grant select, insert, update, delete, create, drop on vtdc. employee to joe@10.163.225.87 identified by '000000'; example explanation: open, vtdc database, employee table, select, insert, update, delete, create, drop permission, to 10.163.225.87 users, username: joe password: 123 Author: wanzongsheng