Error 1045 In Mysql In Window 7
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 error 1045 mysql 28000 windows Overflow the company Business Learn more about hiring developers or posting ads with us error 1045 mysql 28000 access denied for user Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a error 1045 mysql access denied for user root@localhost community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error No. 1045 : While trying to connect to MySql up vote 0 down vote favorite error 1045 mysql ubuntu 1 I installed SQLYog Community edition for windows, a GUI tool for MySql. I had earlier installed MySql with XAMPP. Now when I am trying to connect , I see an error (as pointed): What could be the reason, I am getting this ? How do I connect to MySql and start using this GUI tool ? mysql windows sqlyog share|improve this question asked Jan 7 '13 at 16:25 Suhail Gupta
Mysql Error 1045 Using Password Yes
1 "Access denied" seems pretty clear, doesn't it? Do you have a user account "suhail" set up? –Pekka 웃 Jan 7 '13 at 16:26 @Pekka How do I connect to MySql. No –Suhail Gupta Jan 7 '13 at 16:28 You need to connect with an existing account and set up users first. XAMPP creates a default mySQL user account, IIRC it's "root" with no password. –Pekka 웃 Jan 7 '13 at 16:29 @Pekka the same result –Suhail Gupta Jan 7 '13 at 16:31 you can usually manage the users and connection with phpmyadmin: 127.0.0.1/phpmyadmin - you have to start xampp-apache and xampp-mysql first unless it is installed as an active service –Adder Jan 7 '13 at 16:33 | show 2 more comments 6 Answers 6 active oldest votes up vote 1 down vote accepted The message says access denied for suhail @localhost . These could be the issues : The user suhail does not exist at locahost. The password specified is wrong. MySql Server is not started. If it is started the port number is not 3306. These are some of the troubleshoot techniques. Also follow the comments on your question. share|improve this answer answered Jan 10 '13 at 11:52 Y.
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Install & Repo :: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) New Topic Advanced Search Re: Error Nr.
Mysql Admin Error 1045
1045 Access denied for user 'root'@'localhost' (Using password: NO) Posted by: mike gieson mysql server error 1045 () Date: January 05, 2006 05:01PM To overcome this issue: 1. Use the MySQL installer again and don't do anything mysql install error 1045 fancy, just click next, next, next, yes, yes, yes. This should install, set up and start MySQL. 2. Open the port using the Windows Firewall. Start > Control Panels > Windows Firewall http://stackoverflow.com/questions/14199931/error-no-1045-while-trying-to-connect-to-mysql > Exceptions tab. 3. Click the "Add Port" button: Name: mysql Port: 3306 4. Click the "Add Program" button. Browse to MySQL ( C:/Programs Files/mysql 5.x.x/bin/mysql.exe ) 5. If you want, reboot your computer (this is what I did, just in case). 6. Download the the MySQL Administrator program: http://dev.mysql.com/downloads/administrator/ or http://mysql.he.net/downloads/administrator/ 7. After unzipping, launch "MySQLAdministrator.exe" directly out of the unzipped directory by double clicking http://forums.mysql.com/read.php?11,39440,62685 on the MySQL Administrator.exe file. Server host: localhost Username: root Password: whatever Click "OK" 8. Click on the "Startup Variables" item on the left, then the "Security" tab. Check the checkbox for "Disable grant tables." 9. Click the "Service Control" item on the left and then the "Start/Stop Service" tab. 10. Click "Stop Service" -- once the services has stopped, click the button again to start the service. If you've got PHP installed on your system, I recommend using phpMyAdmin to maintain MySQL: http://www.phpmyadmin.net - mike www.wimpyplayer.com . Edited 1 time(s). Last edit at 01/05/2006 05:05PM by mike gieson. Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) l mh 08/13/2005 10:14PM Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) hahahaha268 10/29/2005 06:52AM Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) mega yasa 04/16/2007 01:59AM Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Chris Shellenberger 10/17/2007 09:25AM Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Ivan Atanasov 04/16/2009 12:51AM Re: Error Nr. 1045 Access denied for user 'root'@'local
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 http://serverfault.com/questions/424871/mysql-error-1045-28000 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: https://teamtreehouse.com/community/mysql-access-denied-error-1045-windows-8 Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top MySQL ERROR 1045 (28000) up vote 0 down vote favorite EDIT: I have found a solution, even if we can't talk error 1045 exactly of solution. Well, I used RevoUninstaller to remove the MySQL Server, then I've proceed with a standard installation and everything got solved. Then, I've repeated all the steps above, adding each time a customization. I finally found that the error comes out when I chose default character set to ucs2 instead of latin1. Even If the problem is solved, I'll leave the question open for further and more detailed answers. END EDIT. I've tried to update MySQL Server from version 5.1 error 1045 mysql to 5.5 to get rid of a bug in a program. After a first try, the situation was worst than I have expected: the program can't log in with root user anymore and so Workbench and console. In the latter case, the error was: c:\mypathtosql>mysql -u root -p Enter password:****** ERROR 1045 (28000): Yes, after ERROR 1045 (28000) there were no details. I decided to completely remove the package (which include a manual removing of all reg keys) and then to install it again. This workaround worked for Workbench, but my program can't do the user creation from a script with no error apparently (I get an error "Can't find any matching row in the user table", but I guess this happen late in the script when I log with the appropriate user), and also the console persist to give the error described above. Everything seems to work fine with MySQL Workbench... Hints, suggestions? Thank you in advance. windows mysql share|improve this question edited Sep 6 '12 at 13:03 quanta 36.4k682160 asked Sep 6 '12 at 9:41 IssamTP 14029 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote You can just reset the mysql root password, here are some links showing how to do that: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html http://www.cyberciti.biz/tips/recover-mysql-root-password.html share|improve this answer answered Sep 6 '12 at 10:06 Logic Wreck 1,28857 I've tried both links but nothing to do. Please, take a look to my edit. Tha
denied [ERROR 1045] (Windows 8) I'm (attempting) the migrations lesson in the ActiveRecord class, and I've run into an error I can't get around. I've gotten right past the part where we do rake db:create (after struggling and spending a bunch of time getting that to work). Now when I try mysql -u root I get this error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N O) I've spent a few hours searching for a bunch of possible solutions that ultimately didn't work, and I have no idea where to go from here. I'm on Windows 8.1 64-bit, running MySQL Server 5.6, Rails 4.1.6, and Ruby 1.9.3p545 Thanks in advance. Mike Pallas 12,246 Points Mike Pallas Mike Pallas 12,246 Points 2y ago Of course, as soon as I post this question I try mysql -u root -p and have it work. I'm not sure if that -p was the only mitigating factor to it not working before, but I seem to have it going now. Though, I would still welcome any insights into what was going wrong earlier. Gavin Ralston 28,710 Points Gavin Ralston Gavin Ralston 28,710 Points 2y ago I'm sure you're past this point now (looks like you asked quite a while ago) But, yeah, it was the -p flag that was holding you up. :) Posting to the forum is only allowed for members with active accounts. Please sign in or sign up to post. Our mission is to bring affordable, technology education to people everywhere, in order to help them achieve their dreams and change the world. Our Company About Us Contact Us Community Treehouse Stories Student Perks Treehouse Blog Affiliate Program Careers Topics HTML CSS Design JavaScript Ruby PHP WordPress iOS Android Development Tools Business Tracks Web Design Web Development Rails Development PHP Development iOS Development Android Development WordPress Development Starting a Business Treehouse Blog About Treehouse Privacy Policy Terms & Conditions © 2016 Treehouse Island, Inc. Sign in Email Address Password I forgot my password Sign in