SQLyog MySQL remote connection error
Error 1: ERROR 2003
================================================== ====================
Symptom: Can not connect mysql
Error message: ERROR 2003 (HY000): Can't connect to MySQL server on 'hostxxxxx' (10061)
Reasons: mysqld does not start the database service.
Check: in the windows task manager, or unix / linux under ps-aux | grep mysql look. Confirm the service has started. Confirm that the service starts, check whether the port is error handling: Start mysqld service
================================================== ====================****************************** *************************************************
Linux view port command:
View Network ports netstat-an
lsof-i: port, use lsof-i: port will be able to see the program running the port specified, along with the current connection.
nmap port scan
Linux view mysqld service is started:
Check the service name for mysqld
************************************************** *****************************
Error 2: Error 1045
================================================== ====================
Symptom: Can not connect mysql
Error message: ERROR ): Access denied for user 'usera' @ 'localhost' (using password: YES)
Cause: The user account does not create a check: ROOT Administrator login, show grants for 'usera' @ 'localhost'; or select user from mysql. confirm the user account exists.
Processing: create a user account.
================================================== ====================
************************************************** *****************************
View user table in mysql database in user information
(1) connect mysql
Mysql-u username-p
Password: Enter password
(2) convert the database
(3) View user table in the user information
Select host, user, password from User
(4) view and if it does not comply with privilege to create a user with permission
grant select on database .* to username @ log host identified by &password&
(5) to change the host, so you can not limit remote access to mysql ip
update user set host = '%' where user = 'username'
(6) attempts to connect to the database '
************************************************** *****************************
Currently being encountered these two errors, since there is an error to continue to add
Please enable JavaScript to view the
Share this article is well summed up, to prevent the delete the original for backup References: /topic/621389 http://blog.csdn.net/JsuFcz/archive//5044932.aspx View CPU Information 1.ps command &br /& some of the view p
In general, the &System Monitor& under the windows equivalent of the &Task Manager.& But the two managers suspended animation in the system are difficult to tune out when. linux this time there own advantage. After all, it can use a TT
My oracle is installed inside a virtual machine, version 10.2.0, originally service is automatically started, and later, that memory is a little accounting canceled automatically. Changes, and then shut down restart, and then open the service, then t
My oracle is installed inside the virtual machine, version 10.2.0, originally service is automatically started, and later, that memory is a little accounting for the abolition of the automatic start. Changes, then shut down restart, then open the ser
这篇文章主要介绍了Windows平台的 PHP 报错 Fatal error: Class COM not found in 的解决方法,需要的朋友可以参考下 在 Win Server 08 往上搭载的 IIS 跑 php 性能提升不少,但还是觉得不太舒服... 某日在调试一个win上的php生产环境时,一段php代码返回了错误: Fatal error: Class 'COM' not found in XXXXXXXXX 没发现 COM 类,php代码主要是调用一些系统的信息,初想应该是ph
I used Linux command of help - Displays help information Bash builtin This link: /blog/804620 (reproduced please indicate the source) Use Description help command name suggests is to display help information, which is
这篇文章主要介绍了linux Shell入门:掌握Linux,OS X,Unix的Shell环境 ,需要的朋友可以参考下 在Linux或类Unix系统中,每个用户和进程都运行在一个特定环境中.这个环境包含了变量.设置.别名.函数以及更多的东西.下面是对Shell环境下一些常用命令的简单介绍,包括每个命令如何使用的例子,以及在命令行下设定你自己的环境来提高效率. 找出你当前的shell 在终端应用中输入下面命令中的任意一个: ps $$ ps -p $$ 或者 echo &$0& 输出范
Wrote a C program code to operate the database, test data found under Linux than Windows, actually about 10 times slower. Environment: The same machine configured to connect the same database, same code Different operating systems, one XP, one ubuntu
Wrote a C program code to operate the database, test data found under Linux than Windows, actually about 10 times slower. Environment: The same machine configured to connect the same database, same code Different operating systems, one XP, one ubuntu
Mainstream UNIX systems UNIX Divided into two categories, namely by vendor support systemV System BSD system , Specific : SYSTEM V System : SCO UNIX HP UNIX SUN UNIX (SOLARIS ) IBM UNIX (AIX) BSD System : FreeBSD OpenBSD NetBSD APPle UNIX(MAC OS bsd
Copyright (C) , All Rights Reserved.
版权所有 闽ICP备号
processed in 0.043 (s). 14 q(s)错误码:2003&不能连接到&MySQL&服务器在&&(10061)
今天在个人电脑上安装VMware,并在VMware上安装了ubuntu,并且自动安装了MySQL
Server.启动ubuntu并登录后，MySQL自动启动。
用secureCRT登录到ubuntu系统后，通过下面命令创建一个新用户luomiou
$mysql -uroot -p121212
mysql&grant all privileges on *.* to 'luomiou'@'%'
identified by '121212';
但是我从vista上的SQLyog企业版登录，报标题的那个错误“错误码:2003 不能连接到 MySQL
(10061)”，于是我在网上搜索，发现碰到这个问题的人还不少，但尝试了好些人给的办法，都没有办法解决。只好去看看MySQL的配制文件了，结果找到了/etc/f这个文件，幸好我的英文还没有全部还给老师，基本看懂了里边配置的意思，发现里边有一个配置：
# Instead of skip-networking the default is now to listen only
# localhost which is more compatible and is not less secure.
bind-address&&&&&&&&&&
= 127.0.0.1
这里的意思就是默认只能是本机进入ＭySQL,不能从其它机器登进。于是我把
bind-address&&&&&&&&&&
= 127.0.0.1这一行注释掉了，保存
#bind-address&&&&&&&&&&
= 127.0.0.1
现在重新启动MySQL:
$sudo /etc/init.d/mysql restart
再回到vista上的SQLyog重新登录，可以登录进去了。。YES--!!!
另外，如果在windows安装mysql，但是从其它系统访问不了，那么关掉运行mysql的windows系统的防火墙，有可能就可以访问了。
已投稿到：
以上网友发言只代表其个人观点，不代表新浪网的观点或立场。ERROR 1130: mysql 1130连接错误的有效解決方法_数据库技术_Linux公社-Linux系统门户网站
你好，游客
ERROR 1130: mysql 1130连接错误的有效解決方法
来源：Linux社区&
作者：ypf3027
在用sqlyog连接非本地的Mysql服务器的数据库，居然无法连接很奇怪，报1130错误，ERROR 1130: Host 192.168.3.100 is not allowed to connect to this MySQL server
猜想是无法给远程连接的用户权限问题。结果这样子操作mysql库，即可解决。特贴出来。。在本机登入mysql后，更改 &mysql& 数据库里的 &user& 表里的 &host& 项，从&localhost&改称'%'。。
mysql -u root -p
mysql&select 'host' from user where user='root';
mysql&update user set host = '%' where user ='root';
mysql&select 'host'&
from user where user='root';
第一句是以权限用户root登录
第二句：选择mysql库
第三句：查看mysql库中的user表的host值（即可进行连接访问的主机/IP名称）
第四句：修改host值（以通配符%的内容增加主机/IP地址），当然也可以直接增加IP地址
第五句：刷新MySQL的系统权限相关表
第六句：再重新查看user表时，有修改。。
记得Mysql服务需要重新启动（确保修改有效），否则可能修改的结果无法体现。
相关资讯 & & &
& (04/09/:28)
& (12/16/:02)
& (02/19/:38)
& (12/16/:41)
& (12/16/:35)
　　　同意评论声明
　　　发表
尊重网上道德，遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任
本站管理人员有权保留或删除其管辖留言中的任意内容
本站有权在网站内转载或引用您的评论
参与本评论即表明您已经阅读并接受上述条款