Mysql Error 1045 Could Not Connect To The Specified Instance
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and mysql error number 1045 access denied for user using password yes policies of this site About Us Learn more about Stack Overflow the company error 1045 mysql access denied for user root@localhost Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users error 1045 mysql windows Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a
Error Code 1045 Mysql
minute: Sign up MySQL access denied 1045 error up vote 2 down vote favorite 2 I'm getting a very strange error, I've created a user 'testuser' with the following credentials: CREATE USER 'testuser'@'%' IDENTIFIED BY '123456'; GRANT ALL PRIVILEGES ON *.* TO 'testuser'@'%'; FLUSH PRIVILEGES; I have also modified my /etc/mysql/my.cnf not to bind to any single address. (Which afaik should could not connect to the specified instance mysql error number 2003 accept connections from anywhere?) And restarted mysql. And I can connect locally no problem. I am running inside a virtual box on ubunutu. Trying to connect from my windows machine, gives me MySQL error number 1045 Access denied for user 'testuser'@'192.168.0.22'. I'm confident that it's not a networking problem as changing the host or port gives a different error "Cannot connect to the specified instance" Logging in as root and looking at the users table - all looks as expected. (Single row, '%' for host and all permissions set.) I've been banging my head against the wall all afternoon... can anyone suggest any other possible causes for this error? Thanks for any help. mysql networking mysql-error-1045 share|improve this question asked Oct 31 '11 at 15:44 Chris 1,84162747 What is full error message? –Devart Oct 31 '11 at 15:52 "Could not connect to the specified instance. MySQL Error Number 1045 Access denied for user 'testuser'@'192.168.0.22' (using password: YES) If you want to check the network connection, please click the Ping button." (Clicking the ping button gives: "Pinging vbox Reply f
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss mysql error 1045 using password yes the workings and policies of this site About Us Learn more
Access Denied For User 'root'@'localhost' (using Password: Yes)
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators
#1045 - Access Denied For User 'root'@'localhost' (using Password: No)
Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and http://stackoverflow.com/questions/7956031/mysql-access-denied-1045-error learn from others in the community. 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 Could not connect to the specific instance. MySQL error number 1045. Access denied for user 'root'@'my public ip' (using password:YES) up http://dba.stackexchange.com/questions/137600/could-not-connect-to-the-specific-instance-mysql-error-number-1045-access-deni vote 0 down vote favorite I was using MySQL query Browser in my system and type the IP address of the remote Server and log in. I tried to create a store procedure and scheduled an event to call the procedure every two minutes. I got the error "Access denied for user 'root'@'%'". To solve this error I tried the below queries. GRANT ALL PRIVILEGES ON database.* TO 'root'@'%' IDENTIFIED BY 'PWD'; FLUSH PRIVILEGES; SHOW GRANTS FOR 'root'@'% select * from mysql.user where User='root'; Now after executing these queries the error was solved and the event scheduler worked. But now I am unable to login using the query browser in my system. I am getting another error when I try to login using the query browser from my system. The error I am getting when I try to login using the query browser from my system is this --> "Could not connect to the specific instance. MySQL error number 1045. Access denied for user 'root'@'my public ip' (using password:YES)". How can I solve this
which it now accepts each time I log on to sql console. However when I try to access mysqladmin it returns: 1045 - Access denied for user 'root'@'localhost' (using password: NO) Any help much appreciated.Thanks and kind regards,Dermot. https://www.sitepoint.com/community/t/1045-access-denied-for-user-root-localhost-using-password-no/3809 Ruben_K 2008-04-02 09:03:34 UTC #2 I don't want to state the obvious but the login mysqladmin uses is wrong. it appears mysqladmin logs in using username 'root' and password '' (blank) derm_w 2008-04-02 11:08:07 UTC #3 http://forums.mysql.com/read.php?11,34014,46593 Many thanks Ruben.When I first installed wamp2 I could access phpmyadmin. But once I created password in mysql console as it suggested I should for security reasons then phpmyadmin immediately hit me with above error.Do I need mysql error to reconfigure something somewhere?If so what and where?Sorry for being so slow.Kind regards,Dermot. longneck 2008-04-02 14:08:50 UTC #4 you have to specify the password in the config.inc.php file for phpmyadmin. derm_w 2008-04-02 22:48:28 UTC #5 Many thanks fellas.Thanks to you things are swimming again and everything is rosy.And Longneck I've left a pint of Guinness for you at the bar! For any other fellow newbies here is the whole fix:-mysql>UPDATE mysql.user ->SET Password=PASSWORD("*******") ->WHERE access denied for User="root";mysql>FLUSH PRIVILEGES; This is from Sitepoint's "Build your own Database Driven Website using PHP and MYSQL" And then as Longneck said specify the password in the config.inc.php file for phpmyadmin. Kind regards,Dermot. bbparis 2008-08-24 07:52:58 UTC #6 I'm just to confirm you that it's the solution. yesterday I tried to fix the problem, but the only think that was missing is the first line in MySQL command: UPDATE mysql.user I was writing ( UPDATE mysql ) : so please follow the next steps if you want to resolve your problem with ( #1045 - Access denied for user 'root'@'localhost' (using password: NO): 1 : go to your WAMP icon on your PC desktop screen and LEFT CLICK to open the menu, you will see MYSQL folder, CLICK to see MYSQL CONSOLE, open it. 2: now you have DOS screen ( a black screen ) : A: if you already set a password, type it B: if you did not do this step yet, write the following red text B1: use mysql; and click ENTER on your keyboard3: now write the following red text and click ENTER : UPDATE mysql.user ->SET Password=PASSWORD("*******") ->WHERE User="root"; don't worry about this sign ( -> ) , because for example when you write ( UPDATE mysql.user ) and you
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Install & Repo :: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) New Topic Advanced Search Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Posted by: Shawn Tucker () Date: September 27, 2005 12:40PM I had the same problem, this solution worked for me. You will need to reset the password. First start the mysql server instance or daemon with the --skip-grant-tables option. (security setting) Then Execute these statements. # mysql -u root mysql mysql> UPDATE user SET Password=PASSWORD('your_new_password') where USER='root'; mysql> FLUSH PRIVILEGES; Finally, restart the instance/daemon without the --skip-grant-tables option. You should be able to connect with your new password. # mysql -u root -p Enter password: your_new_password Hope this helps. Shawn Tucker Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Daniel Ho 07/12/2005 01:16PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Daniel Ho 07/12/2005 07:49PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) carminda timas 05/11/2007 02:20PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Eric Okorie 05/21/2007 10:57PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) pigeret john 07/22/2007 01:59AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Me izme 10/11/2007 08:04AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Christopher Armstrong 12/27/2007 07:40PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) kandy kavitha 09/01/2009 12:03PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Majid Farr Amini 06/23/2010 07:33AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Meenakshi Gaur 12/29/2010 08:14AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Jerod Weber 01/21/2011 09:17AM on linux jerry nickles 06/27/2009 08:29PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localh