Navicat Error 1130
Contents |
time, as long as the computer localhost, log mysql, change the "MySQL" database "user" and "host", "localhost" mysql error number 1130 host is not allowed to connect was renamed from"%" mysql -u root -p mysql>use mysql; mysql>update user
Mysql Error 1130 Host Is Not Allowed To Connect Windows
set host = '%' where user = 'root'; mysql>select host, user from user; The 2 Authorization error 1130 sqlyog Act. For example, you want to use myuser mypassword to connect to the MySQL server from any host. GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY
Mysql Error No 1045
'mypassword' WITH GRANT OPTION; FLUSH PRIVILEGES; If you want to allow the user to myuser from the IP to the MySQL server for the 192.168.1.6 host is connected, and use mypassword as the password GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; FLUSH PRIVILEGES; If you want to allow the user mysql error number 1130 windows to myuser from IP to MySQL server DK database for the 192.168.1.6 host is connected, and use mypassword as the password GRANT ALL PRIVILEGES ON dk.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; FLUSH PRIVILEGES; The first method I use, were just beginning to find not, checked on the Internet, less executes a statement mysql> FLUSH RIVILEGES for the changes to take effect. It Another method, but I have not personally tried, found on the csdn.net, can look at Running on the machine where MySQL is installed: 1, d:/mysql/bin/>mysql -h localhost -u root //So should be able to access the MySQL server 2, mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION //Given any host access to the data 3, mysql>FLUSH PRIVILEGES //The amendment shall enter into force 4, mysql>EXIT //Exit the MySQL server So that it can be in any other host log in as root! [source] Posted by Chad at May 12, 2014 - 8:33 PM ©2016 Programering
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
Mysql Error Number 1045
developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question
Mysql 1045
x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join host 'localhost' is not allowed to connect to this mysql server them; it only takes a minute: Sign up Error 1130 in mysql up vote 7 down vote favorite 5 when i am trying to log on mysql using my ip address i am getting error 1130 qht can i do http://www.programering.com/a/MzM2AzMwATE.html for this mysql mysql-error-1130 share|improve this question edited Jun 28 '11 at 16:12 OMG Ponies 199k37360417 asked May 18 '10 at 13:01 ratty 5,302215888 add a comment| 2 Answers 2 active oldest votes up vote 4 down vote accepted Your client IP is not allowed to connect to this server, you must add it to allowed client account For exemple, assuming you add an user account having all rights in one database : grant all on db.* to 'username'@'192.168.0.1'; http://stackoverflow.com/questions/2857446/error-1130-in-mysql Where db is database name, username the username , and your clients IP is 192.168.0.1 See docs for details of user account creation share|improve this answer answered May 18 '10 at 13:07 Benoit 2,6831315 1 whr i have to add this –ratty May 18 '10 at 13:08 this is SQL query to run on server with an account with enough privileges to do grant queries on the table –Benoit May 18 '10 at 14:10 add a comment| up vote 29 down vote On your server run mysql from command line: mysql -u root -p -h localhost -P 3306 Then run this command in mysql shell: >use mysql >GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'pass'; >FLUSH PRIVILEGES; Have a nice time. share|improve this answer answered Dec 18 '12 at 8:19 Saeed Zarinfam 3,48732743 2 This is the best answer! Thanks! –zur4ik Apr 25 '14 at 22:42 This one should be the best answer imo. Nice thing, this "%" :) –Vlad Nicula Aug 31 '14 at 14:48 Except it is a bad advice security-wise. One should always use the most precise rule, here specifying the client IP address as a host or its NAT public IP, or a rule matching his DHCP subnet ('192.168.1.%" for example) –mveroone May 3 at 7:59 add a comment| Your Answer draft saved draft discarded Sign up or log in Si
1130 If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: http://www.ac-web.org/forums/showthread.php?2326-Navicat-error-1130 click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 11 of 11 Thread: Navicat error 1130 Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-05-2007,07:36 AM #1 azrael View Profile View Forum Posts Private Message View Articles Join Date mysql error May 2007 Posts 16 Navicat error 1130 REGISTER! (FREE) Registered members see less ads and also gain access to other great features. How can I access my server from my other computer? Help would mean the world to me. Reply With Quote 08-05-2007,07:42 AM #2 ismails Guest meybe remote assistance but there should be other way tho Reply With Quote 08-05-2007,07:46 AM #3 azrael mysql error number View Profile View Forum Posts Private Message View Articles Join Date May 2007 Posts 16 I know there's another way, but I'm not good at searching for info. Something about opening a port or allowing access, but I don't know where or how. Reply With Quote 08-05-2007,07:48 AM #4 ismails Guest ol here they are www.gotomypc.com https://secure.logmein.com/home.asp?lang=en i hope these both link helped you Last edited by ismails; 08-05-2007 at 07:51 AM. Reply With Quote 08-05-2007,07:51 AM #5 azrael View Profile View Forum Posts Private Message View Articles Join Date May 2007 Posts 16 Well, the thing is I want to use Navicat on this computer to control an SQL server on my other computer. I know it's possible. Google "Navicat error 1130" or something.. Tell me if you find anything better then what I found. Reply With Quote 08-05-2007,07:53 AM #6 ismails Guest links arent for you ? Reply With Quote 08-05-2007,07:54 AM #7 azrael View Profile View Forum Posts Private Message View Articles Join Date May 2007 Posts 16 Your links? No. I'm not looking for remote assistance, I'm looking for a solution for error 1130. Reply With Quo