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

Mysql authorization

Application scenario: separation of database and application

After the deployment of the mysql server, it is sometimes inconvenient to connect to the database remotely

However, authorization is required to remotely

Configure mysql to allow remote connections

After localhost logs in to mysql

Change the "host" entry in the "user" table in the mysql database

# mysql-u root-p

# use mysql

# update user set host ='% 'where user =' root'

# select host, user from user

# flush privileges; updates

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.