error 1045 in mysql in window 7
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 error 1045 mysql 28000 windows developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask error 1045 mysql 28000 access denied for user Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join
Error 1045 Mysql Access Denied For User Root@localhostthem; it 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
Error 1045 Mysql Ubuntuearlier 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 1 "Access denied" seems pretty clear, doesn't it? Do you have a user account "suhail" set up? –Pekka 웃 Jan 7 mysql error 1045 using password yes '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.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 t
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Install & Repo :: Error Nr. 1045 Access denied for user 'root'@'localhost'
Mysql Admin Error 1045(Using password: NO) New Topic Advanced Search Re: Error Nr. 1045 mysql server error 1045 Access denied for user 'root'@'localhost' (Using password: NO) Posted by: mike gieson () Date: January 05, 2006 mysql install error 1045 05:01PM 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, http://stackoverflow.com/questions/14199931/error-no-1045-while-trying-to-connect-to-mysql set 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 http://forums.mysql.com/read.php?11,39440,62685 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 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 pass
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 http://superuser.com/questions/299519/how-to-install-mysql-on-windows-7 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 error 1045 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 error 1045 mysql 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 125k38312360 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 2:04 E.Z. Hart 1113 add a comment| up vote 0 down vote Was the provided password correct? Otherwise please check here: http://forums.mysql.com/read.php?11,39440,417422#msg-417422 share|improve this answer answered Jun 20 '11 at 5:39 Atique 1034 add a comment| up vote 0 down vote # /etc/init.d/mysql stop # mysqld_safe --user=mysql --skip-grant-tables --skip-networki