Error Number 1045 Mysql
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 mysql error number 2003 the company Business Learn more about hiring developers or posting ads with us Stack
Mysql Error Number 1130
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of mysql error number 1045 access denied 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error 1045 MySQL during setup up vote 10 down vote favorite 2 Could anyone explain to me mysql administrator error number 1045 error 1045 during MySQL setup. I'm getting this error after reinstalling. I 'm trying to install on windows 7. On the last stage of installation (i.e apply security settings) I'm getting the following message: The security settings could not be applied. Error Number 1045. Access denied for user 'root' @ 'loaclhost'(usinf password: NO). How can I get around this? mysql share|improve this question edited Jun 9 '14 at 21:01 pdobb 9,52613153 asked
Mysql Error Number 1045 Access Denied For User
Apr 29 '12 at 18:52 Falconx 96117 Hope this would be helpful faq.webyog.com/content/23/18/en/… –Sathish D Dec 26 '12 at 12:29 What is loaclhost? –Izkata Jun 9 '14 at 21:03 add a comment| 9 Answers 9 active oldest votes up vote 27 down vote accepted What worked for me on a 64 bit Windows 7 was Uninstall Remove C:\Program Files\MySQL Remove C:\ProgramData\MySQL (This folder may be hidden) Reinstall share|improve this answer edited May 28 '13 at 8:51 Chathura Priyankara 734 answered Dec 18 '12 at 11:19 Torben 1,8161019 add a comment| up vote 4 down vote This is a solution, Error 1045 MySql Instalation. Stop MySql from running{control panel | Administrative Tools | Services} Make sure to uninstall the previous MySql from control panel remove all mysql directories and names from window explorer even those are hidden, In th case that there are some applications which are using mysql and are always on run and you can not remove the mysql dependencies from, you rename them. For example you have Ruby1.9, go head just rename it to RubyBack1.9 and rename them back once you finish with mysql installation. Or other alternative is you kill the process once you reach to step 9 go to firewall from control panel, click on advanc
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 mysql query browser error number 1045 or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x mysql error number 1045 root Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it
Mysql Error Number 1045 Using Password Yes
only takes a minute: Sign up Error No. 1045 : While trying to connect to MySql up vote 0 down vote favorite 1 I installed SQLYog Community edition for windows, a GUI tool for MySql. I had earlier installed MySql http://stackoverflow.com/questions/10374962/error-1045-mysql-during-setup 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 6,26938105190 "Access denied" seems pretty clear, doesn't it? Do you have a user account "suhail" set up? –Pekka 웃 Jan 7 '13 at 16:26 http://stackoverflow.com/questions/14199931/error-no-1045-while-trying-to-connect-to-mysql @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.E.P 46441132 add a comment| up vote 1 down vote I had exactly same error message, however, it is resolved by means of using admin password on my machine. The message I get is as follows: Connection info Connection successful! MySQL version: 5.1.54-community Then I clicked ok to continue. See if this works for you! share|improve thi
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: http://forums.mysql.com/read.php?11,39440,62685 Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO) Posted by: mike gieson () Date: January 05, 2006 05:01PM To overcome this issue: 1. Use the MySQL installer again https://teamtreehouse.com/community/mysql-access-denied-error-1045-windows-8 and don't do anything 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 > error number Control Panels > Windows Firewall > 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 error number 1045 out of the unzipped directory by double clicking 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'@'local
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,712 Points Gavin Ralston Gavin Ralston 28,712 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