sequel 连接不上,命令行能连上
Sequel pro won't connect anymore
I'm running into some trouble right now. I worked yesterday on my db using sequel pro for TigerV1 (for an old OS X 10.4 powerpc). The problem is, this morning, sequel pro won't connect anymore. I deleted my "Favorite" and than retyped the host-user-password.
It's not letting me acces my db.
This is the error message : Unable to connect to host xxx.xxxxx.ca, or the request timed out.
Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 30 seconds).
MySQL said: Access denied for user 'root'@'xx-xx.xx.xxxxxxx.ca' (using password: YES)
MySQL version did not change since yesterday, nor my version of sequel pro. Pleaze help.
Most likely some permissions are out of sync. Did you create this user or change any permissions yesterday? It's possible that the privilege tables were flushed in between yesterday and today, making whatever changes you made take effect.
Some possible issues:
- The username/password has changed.
- Remote connections have been disabled.
- You don't have permission to access the DB you're trying to connect to.
- MySQL has an IP or hostname whitelist which your IP or hostname is not on.
Some things to try:
- Try connecting via the console if you have SSH access. If it lets you connect, check your user permissions really well. Be sure that remote connections are allowed and that you've whitelisted your IP address. Be sure to
FLUSH PRIVILEGES;
when you're done. - If you do not have SSH access, double check all the permissions in the control panel.
- Try restarting MySQL server.
最新文章
- 跨域之同源策略 Same-origin policy
- Linux 进程间通讯详解四
- PHP的继承方法如何获取子类名
- char、wchar_t、strlen、wcslen
- 数据结构作业——brothers(二叉树)
- Study Emgu VoteForUniqueness
- Orchard Express Oracle v1.7.2 发布
- Leetcode 26 Remove Duplicates from Sorted Array STL
- Winform开发框架之客户关系管理系统(CRM)的开发总结系列1-界面功能展示
- Java compiler level does not match the version of the installed Java project facet.(转)
- 自己保留:data provider
- 【Python】使用 boto 调用 S3 对象存储API
- Houdini Krakatoa Render Plugin
- 3143: [Hnoi2013]游走 - BZOJ
- JQuery的插件
- 【LeetCode练习题】Reverse Linked List II
- Qt:添加点击事件的Label并显示图片
- ubuntu软件使用汇总
- Spark2.2.0分布式集群安装(StandAlone模式)
- lvs 负载均衡 NAT模式