Mysql user permission management many people have problems with authorization on the Internet, especially because there are no quotation marks for the IP address ..... most people COPY it .. log on to mysql with the root local account and add the SQL code insert into mysql. user (Host, User, Password) values ('%', 'admin', 'abc123'); -- add the admin account (Password abc123 ), this account can be accessed from any IP address, but does not include localhost (version: 5.5.9), version: 5.7.1%, or localhost access insert into mysql. user (Host, User, Password) values ('localhost', 'admin', 'abc123'); -- add the admin account (Password abc123 ), this account can only access the authorized SQL code grant all privileges on * from localhost *. * to 'admin' @ '%' identified by 'abc123'; -- grant the permission on the database. table to 'account' @ 'IP' identified by 'abc123' grant all privileges on *. * to 'admin' @ 'localhost' identified by 'abc123'; -- pay attention to the punctuation refresh permission. SQL code FLUSH PRIVILEGES; -- refresh authorization