MySQL adds the same permissions as root user

The following statement has the same permissions as the root user. We should have met when we were taking the station. Root user MySQL, can only be local to connect, external deny connection.

The following methods can help you solve this problem, the following statement function is to establish a user for the monitor Password Admin permissions for the same as root.

Allow any host to connect. This makes it easy for you to remotely manipulate the database locally.

CREATE USER ' monitor ' @ '% ' identified by ' admin ';

Grant all privileges on *.* to ' monitor ' @ '% ' identified by ' admin ' with GRANT OPTION max_queries_per_hour 0 max_connections _per_hour 0 Max_updates_per_hour 0 max_user_connections 0;

DROP USER ' monitor ' @ '% ';

DROP DATABASE IF EXISTS ' monitor ';

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/MySQL/