windows版mysql添加远程访问
发布时间:2020-12-14 02:00:26 所属栏目:Windows 来源:网络整理
导读:use mysql;##然后查看下当前连接允许情况 select host, user ,authentication_string,plugin from user ;##依次执行 CREATE USER ‘ root ‘ @ ‘ % ‘ IDENTIFIED BY ‘ root ‘ ; GRANT ALL PRIVILEGES ON * . * TO ‘ root ‘ @ ‘ % ‘ WITH GRANT OPTIO
use mysql; ##然后查看下当前连接允许情况 select host,user,authentication_string,plugin from user; ##依次执行 CREATE USER ‘root‘@‘%‘ IDENTIFIED BY ‘root‘; GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ WITH GRANT OPTION; ALTER USER ‘root‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘123456‘; ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘password‘ PASSWORD EXPIRE NEVER; FLUSH PRIVILEGES; ##再次查看连接情况 select host,plugin from user; 完成; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
相关内容
- Windows – PowerShell打开屏幕
- Leetcode 480. Sliding Window Median
- windows – 在远程服务器上复制文件的速度
- 如何从脚本本身获取Windows .bat脚本的名称?
- windows-8 – 如何在Windows 8 metro app live tile中禁用徽
- Windows – 作为虚拟机在硬盘上引导本机操作系统
- Windows – Server 2012,Jumbo Frames – 我应该遇到问题吗
- Windows 8中的视觉样式
- winapi – Windows API ANSI函数和UTF-8
- Windows主机和Linux Docker容器之间的通信