Error 1130 00000
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or error 1130 (hy000): posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join error 1045 28000 access denied for user root using password yes the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes host is not allowed to connect to this mysql server windows a minute: Sign up Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server up vote 300 down vote favorite 110 This should be dead simple, but I cannot get it to work for the life of me. I'm just host is not allowed to connect to this mysql server workbench trying to connect remotely to my MySQL server. connecting as mysql -u root -h localhost -p works fine, but trying mysql -u root -h 'any ip address here' -p fails with the error ERROR 1130 (00000): Host ''xxx.xx.xxx.xxx'' is not allowed to connect to this MySQL server In the mysql.user table, there is exactly the same entry for user 'root' with host 'localhost' as another with host '%'. I'm at my wits' end, and have no idea how to proceed. Any
Host 'localhost' Is Not Allowed To Connect To This Mysql Server
ideas are welcome. mysql mysql-error-1130 share|improve this question edited Jun 28 '11 at 16:16 Lightness Races in Orbit 217k35335582 asked Oct 13 '09 at 12:40 concept47 7,45092960 2 This link explains about the error: webyog.com/faq/content/23/36/en/… –Ashwin A Aug 6 '12 at 11:33 add a comment| 14 Answers 14 active oldest votes up vote 364 down vote accepted Possibly a security precaution. You could try adding a new administrator account: mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> WITH GRANT OPTION; mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass'; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' -> WITH GRANT OPTION; Although as Pascal and others have noted it's not a great idea to have a user with this kind of access open to any IP. If you need an administrative user, use root, and leave it on localhost. For any other action specify exactly the privileges you need and limit the accessibility of the user as Pascal has suggest below. Edit: From the MySQL FAQ: If you cannot figure out why you get Access denied, remove from the user table all entries that have Host values containing wildcards (entries that contain '%' or '_' characters). A very common error is to insert a new entry with Host='%' and User='some_user', thinking that this allows you to specify localhost to connect from the same machine. The reason that this does not work is that the default privi
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn
Host Machine Name Is Not Allowed To Connect To This Mysql Server
more about Stack Overflow the company Business Learn more about hiring developers or posting sqlstate[hy000] [1130] ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community host is not allowed to connect to this mariadb server Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error: Host xxx is not allowed to connect to this http://stackoverflow.com/questions/1559955/host-xxx-xx-xxx-xxx-is-not-allowed-to-connect-to-this-mysql-server MySQL server [duplicate] up vote 7 down vote favorite This question already has an answer here: Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server 14 answers I'm trying to connect remotely to MySQL server as following: below code works fine mysql -u root -h localhost -p below code returns me an error mysql -u root -h 'server ip_address here' -p ERROR 1130 (00000): Host xxx http://stackoverflow.com/questions/19288606/error-host-xxx-is-not-allowed-to-connect-to-this-mysql-server is not allowed to connect to this MySQL server Please help mysql database-connection share|improve this question edited Oct 10 '13 at 13:32 Madhura Jayaratne 1,041612 asked Oct 10 '13 at 6:29 user2865746 marked as duplicate by RobEarl, fancyPants, Achrome, greg-449, Michael Gardner Jul 17 '14 at 13:09 This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question. That is because MySQL is not allowing you to connect from that address. Default is that only localhost van connect –MKroeders Oct 10 '13 at 6:31 What help do you need: the message is clear enough. You need to grant access. –user1864610 Oct 10 '13 at 6:32 You should configure mysql to allow remote connections. And also you should grant permission to the database you are connecting to from remote IP –Deepak Oct 10 '13 at 6:32 add a comment| 2 Answers 2 active oldest votes up vote 15 down vote One has to create a new MySQL User and assign privileges as below in Query prompt via phpMyAdmin or command prompt: CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON *.* TO 'username'
获赠金笔:0支 赠出金笔:0支 荣誉徽章: 相关博文 更多>> 推荐博文 从张妈到张靓颖,时代终究在进步 50万老人走失:就让幸福感这样 苏州“房价4天跌 愤然谴责“南京大屠杀”的日本知 不知疲倦,没有节制,是他出类拔 史上最强调控风暴下,房价会大跌 为什么国产化妆品做不起来? 周蓬安:终身监禁 http://blog.sina.com.cn/s/blog_72e339cd0100wuw9.html 9岁女孩写“最悲伤”作文:如果 加拿大的出租车、专车和拼车管理 查看更多>> 谁看过这篇博文 加载中… 正文 字体大小:大 中 小 ERROR1130(00000):Host'X.X.X.X'isnotallowedtoconnecttothisMySQLserver (2011-08-22 15:55:18)转载▼ 标签: 杂谈 [root@ns1 http://serverfault.com/questions/92870/1130-host-localhost-is-not-allowed-to-connect-to-this-mysql-server ~]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; is not or g. Your MySQL connection id is 2 Server version: 5.0.45-log Source distribution Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> grant all on *.* to 'root'@'%' is not allowed identified by '19820126'; Query OK, 0 rows affected (0.01 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> quit Bye [root@ns1 ~]# 分享: 喜欢 0 赠金笔 阅读┊ 评论 ┊ 收藏 ┊转载 ┊ 喜欢▼ ┊打印┊举报 已投稿到: 排行榜 加载中,请稍候...... 前一篇:Linux系统管理与维护之-tar命令 后一篇:iptables命令的管理控制选项 评论 重要提示:警惕虚假中奖信息 [发评论] 评论加载中,请稍候... 发评论 登录名: 密码: 找回密码 注册 记住登录状态昵称: 分享到微博 评论并转载此博文 匿名评论 发评论 以上网友发言只代表其个人观点,不代表新浪网的观点或立场。 <前一篇Linux系统管理与维护之-tar命令 后一篇>iptables命令的管理控制选项 新浪BLOG意见反馈留言板 不良信息反馈 电话:4006900000 提示音后按1键(按当地市话标准计费) 欢迎批评指正 新浪简介 | About Sina | 广告服务 | 联系我们 | 招聘信息 | 网站律师 | SINA English | 会员注册 | 产品答疑 Copyright © 1996 - 2016 SINA Corporation, All Rights Reserved 新浪公司 版权所有
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top #1130 - Host 'localhost' is not allowed to connect to this MySQL server [closed] up vote 2 down vote favorite 3 I issued a command of DROP USER 'root'@'localhost'; GRANT ALL PRIVILEGES ON . TO 'root'@'%';in PhpMyAdmin, immediately after the execution, I was forced out PhpMyAdmin,I got an error #1130 - Host 'localhost' is not allowed to connect to this MySQL server, how to resolve my problem? mysql permissions share edited Feb 20 '15 at 22:33 HopelessN00b 44.3k1797166 asked Dec 10 '09 at 3:23 Steven locked by HopelessN00b Feb 20 '15 at 22:33 This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center. closed as off-topic by HopelessN00b Feb 20 '15 at 22:33 This question appears to be off-topic. The users who voted to close gave this specific reason:"Questions should demonstrate reasonable business information technology management practices. Questions that relate to unsupported hardware or software platforms or unmaintained environments may not be suitable for Serv