Mysql Installation Error Nr. 1045
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 no 1045 in mysql access denied for user root@localhost Overflow the company Business Learn more about hiring developers or posting ads with us
Mysql Error Number 1045 Access Denied For User Using Password Yes
Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community
Error 1045 Mysql Windows 8
of 6.2 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
Error 1045 Mysql Using Password Yes Windows
me 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 error no 1045 access denied for user 9,53413153 asked 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 contro
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Install & Repo :: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using mysql error 1045 access denied for user 'root'@'localhost' windows password: NO) New Topic Advanced Search Re: Error Nr. 1045 Access mysql error no 1045 access denied for user denied for user 'root'@'localhost' (Using password: NO) Posted by: mike gieson () Date: January 05, 2006 05:01PM error 1045 mysql using password no To overcome this issue: 1. Use the MySQL installer again and don't do anything fancy, just click next, next, next, yes, yes, yes. This should install, set http://stackoverflow.com/questions/10374962/error-1045-mysql-during-setup up and start MySQL. 2. Open the port using the Windows Firewall. Start > 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 http://forums.mysql.com/read.php?11,39440,62685 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 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:5
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 http://serverfault.com/questions/1923/how-should-i-diagnose-error-1045-during-mysql-installation 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 http://superuser.com/questions/299519/how-to-install-mysql-on-windows-7 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 access denied are voted up and rise to the top How should I diagnose ERROR 1045 during MySQL installation? up vote 1 down vote favorite 1 I recently setup a MySQL server and encounted the following error when I ran the mysql console (and incidentally the administrator GUI tool): ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) I had done a standard installation and reached the last access denied for page in the configuration wizard when the security check stage failed with an error suggesting that the MySQL port was blocked by a firewall. closed the wizard, checked there was no firewall running and then and tried running mysql and the administrator GUI and found the same error in both cases. Can anyone suggest a solution to the problem or perhaps resources for diagnosing MySQL problems. mysql share|improve this question edited Jan 7 '10 at 1:29 asked May 1 '09 at 0:05 RedBlueThing 122138 MySQL 1045 is explained here: webyog.com/faq/content/23/18/en/… –Ashwin A Aug 10 '12 at 12:14 add a comment| 3 Answers 3 active oldest votes up vote 1 down vote accepted You may need to reset your root password. I had a similar problem a while back. Details: How to reset the root password The basic process involves stopping the server and restarting it with a special initialization script. share|improve this answer answered May 1 '09 at 4:48 Steven Richards 13613 Thanks, this worked perfectly. I do wonder what the installer did to incorrectly set the root password. I would blame myself using the wrong password, but it actually failed from the config wiz
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 Super User Questions Tags Users Badges Unanswered Ask Question _ Super User is a question and answer site for computer enthusiasts and power users. 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 How to install MySQL on Windows 7 up vote 1 down vote favorite Please help me how to install MySQL on Windows 7. When I tried to install, I am getting errors as: The security settings could not be applied to the database because the connection has failed of the following errors ERROR NR:1045 Access denied for user 'root@'localhost(using password yes). I tried to uninstall MySQL completely and install again, but it shows this error again and again. I have changed my firewall setting also and tried unstalling antivirus sotware too. But it also did not work. windows-7 installation mysql share|improve this question edited Jun 20 '11 at 8:29 slhck 125k38316362 asked Jun 20 '11 at 5:31 akash gupta migrated from stackoverflow.com Jun 20 '11 at 8:14 This question came from our site for professional and enthusiast programmers. what is your root password? does it even have a password? –Yasser Souri Jun 20 '11 at 5:37 Think he has just installed and doesnt know where to change –Balanivash Jun 20 '11 at 5:38 its pwd error..not Windows 7 security error.. –thecodejack Aug 7 '12 at 7:06 add a comment| 4 Answers 4 active oldest votes up vote 1 down vote I had this problem, and explicitly running the MySQL installer as Administrator (right-click, select 'Run as Administrator') fixed it for me. share|improve this answer answered Jul 7 '13 at