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

Add remote control user (transfer) [@ more@] to MySql. After installing MySql, there is only one super administrative user ROOT, and ROOT restrictions can only be used on the local database. What if we want to remotely manage MySql? So in fact, we need to add a super user with super administrative privileges and possible remote access, and there are two ways to do this in MySql. Let's take the addition of a super rights management user admin as an example.

You can add new users by issuing a GRANT statement: first log in to MySql as a ROOT user on the local database (I don't have to tell you how to log in, do I? ), then:

CODE: mysql > GRANT ALL PRIVILEGES ON *. * TO admin@localhost IDENTIFIED BY 'something' WITH GRANT OPTION

Mysql > GRANT ALL PRIVILEGES ON *. * TO admin@ "%" IDENTIFIED BY 'something' WITH GRANT OPTION

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.