![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQl
云墨cloudMel
程序员一枚,专注前端,
搞过vue, react, angular,node,
在进阶后端SpringBoot,
专注MySQL, MSSQL
展开
-
Navicat Access denied for ‘password‘. Authentication that can continue: publ1045 - Access denied for
Navicat Access denied for 'password'. Authentication that can continue: publ1045 - Access denied for user 'root'@'139-218-163-195.sta.dodo.net.au' (using password: YES)用户名和密码正确,但是却没有在其他ip地址上访问的权限。需要登录MySQL然后修改ip访问权限。`GRANT ALL PRIVILEGES ON *....原创 2021-07-20 22:18:59 · 4508 阅读 · 0 评论 -
NAVICAT 2003 - Can't connect to MySQL server on '150.158.119
Navicat无法远程连接腾讯云服务器MySQL,2003 - Can't connect to MySQL server on '150.158.119....以及phpstorm报错:Warning: mysqli_connect(): (HY000/2002): Operation timed out首先, 定位问题,我一直认为是腾讯云的问题, 经过各种操作, ...转载 2020-04-08 10:52:56 · 204 阅读 · 0 评论 -
NAVICAT 1045 - Access denied for user 'root'@'localhost' (using password: NO)
Navicat ssh远程连接服务器数据库1045 - Access denied for user 'root'@'localhost' (using password: NO)报错, MySQL没有远程连接权限授权允许远程访问一、授权命令:grant all privileges on *.* to 'root'@'%' identified by 'password'...原创 2020-04-06 19:38:15 · 2234 阅读 · 1 评论 -
show databases;
show databases; 注意; 英文标点符号原创 2020-03-01 11:22:41 · 172 阅读 · 0 评论 -
MySQL学习
use myblog;-- show tables;insert into users (username,`password`,realname) values('zhangsan','123','张三');select*from users;select id,username from users;select * from users where username="zha...原创 2019-03-18 00:12:54 · 204 阅读 · 0 评论