ThinkChat2.0新版上线,更智能更精彩,支持会话、画图、视频、阅读、搜索等,送10W Token,即刻开启你的AI之旅 广告
### 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; ~~~