Shulou(Shulou.com)06/01 Report--

There are two big steps to open the remote login account of MySQL: 1. Make sure that the firewall on the server does not block port 3306. The default port of MySQL is 3306. You need to make sure that the firewall does not block port 3306, otherwise the remote cannot connect to MySQL through port 3306. If you specified a different port when you installed MySQL, open the port number you specified for MySQL in the firewall. If you don't know how to set up a firewall on your server, consult your server administrator. 2. Add allowing remote connection and authorization of MySQL users. 1) first log in to MySQL as a root account, click the start menu in the Windows host, run, type "cmd", enter the console, MySQL's bin directory, and then enter the following command. Enter the following command at the command prompt on the Linux host. > MySQL-uroot-p123456 123456 is the password of the root user. 2) create a remote login user and authorize > grant all PRIVILEGES on discuz.* to ted@'123.123.123.123' identified by '123456login; the above statement authorizes all permissions of the discuz database to the ted user, allows the ted user to log in remotely at the IP of 123.123.123.123, and sets the password of the ted user to 123456. Let's analyze all the parameters one by one: all PRIVILEGES means to grant all permissions to the specified user. Here, you can also replace them with specific permissions, such as select,insert,update,sqlserver/42947.htm target=_blank > delete,create,drop, which are separated by "," commas. Discuz.* indicates which table the above permissions are for, discuz refers to the database, and the following * means for all tables, it can be inferred that the authorization for all tables in all databases is "*. *", for all tables in a database is "database name. *", and for a table in a database is "database name. table name". Ted indicates which user you want to authorize, either an existing user or a non-existent user. 123.123.123.123 indicates the IP address that allows remote connections. If you want to not limit the IP of the link, set it to "%". 123456 is the user's password. After executing the above statement, then execute the following statement before it can take effect immediately. > flush privileges; remote login mysql some commonly used code snippets, you can refer to. 1. Allow root users to log in remotely anywhere and have any operation rights in all libraries. The specific actions are as follows: first, log in to mysql: mysql-u root-p "youpassword" using the root user on this machine to authorize the operation: mysql > GRANT ALL PRIVILEGES ON *. * TO 'root'@'%' IDENTIFIED BY' youpassword' WITH GRANT OPTION; overload authorization table: FLUSH PRIVILEGES Log out of mysql database: exit II. Allow root users to remotely log in to a specific IP and have any operation rights in all libraries. The specific actions are as follows: first, log in to mysql: mysql-u root-p "youpassword" using root users on this machine to authorize operations: GRANT ALL PRIVILEGES ON *. * TO root@ "172.16.152" IDENTIFIED BY "youpassword" WITH GRANT OPTION; overload authorization table: FLUSH PRIVILEGES Exit mysql database: exit III. Allow root users to log in remotely on a specific IP and have all library-specific operation permissions. The specific actions are as follows: first, log in to mysql: mysql-u root-p "youpassword" using the root user on the local machine for authorization operation: GRANT select,insert,update,delete ON *. * TO root@ "172.16.152" IDENTIFIED BY "youpassword"; reload authorization table: FLUSH PRIVILEGES Exit mysql database: exit 4. Delete user authorization, you need to use the REVOKE command, the specific command format is: REVOKE privileges ON database [. Table name] specific instance of FROM user-name;, first log in to mysql: mysql-u root-p "youpassword" to authorize the operation: GRANT select,insert,update,delete ON TEST-DB TO test-user@ "172.16.16.152" IDENTIFIED BY "youpassword", and then delete the authorization: REVOKE all on TEST-DB from test-user * * Note: this operation only removes the user's authorization for TEST-DB, but the "test-user" user still exists. Finally, clear the user from the user table: DELETE FROM user WHERE user= "test-user"; reload authorization table: FLUSH PRIVILEGES; exit mysql database: exit

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.