合规国际互联网加速 OSASE为企业客户提供高速稳定SD-WAN国际加速解决方案。 广告
### 1.连接数据库 ~~~ mysql -uroot -p密码 ~~~ ### 2.use mysql ~~~ use mysql select host,user from user; ~~~ +-----------+-----------+ | host | user | +-----------+-----------+ | localhost | mysql.sys | | localhost | root | +-----------+-----------+ ### 3-1 将root的host设置成本地IP则实现本机登录 ~~~ GRANT ALL PRIVILEGES ON *.* TO 'root'@'IP地址' IDENTIFIED BY '密码' 例如: GRANT ALL PRIVILEGES ON *.* TO 'root'@'144.0.182.180' IDENTIFIED BY '12345678' ~~~ ### 3-2 将root的host设置成%则实现任何电脑都可远登录 ~~~ GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '12345678' ~~~ ~~~ flush privileges; ~~~