error no 1045 while installing mysql
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
Error 1045 Mysql WindowsStack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community mysql error 1045 windows 7 Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error No.
Error 1045 Mysql 28000 Windows1045 : 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 with XAMPP. Now when I am trying to connect , an error occurred while installing mysql 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 @Pekka How do I connect to MySql. No –Suhail Gupta Jan 7 '13 at 16:28 erro 1045 mysql windows 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 this answer edited Apr 12 '13 at 1:02 answered Apr 12 '13 at 0:56 footyboy 112 add a comment| up vote 0 down vote error 1045 is a common authentication erro
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
Error No 1045 In Mysql Access Denied For User Root@localhostTopic Advanced Search Re: Error Nr. 1045 Access denied for user 'root'@'localhost' error no 1045 access denied for user using password yes (Using password: NO) Posted by: mike gieson () Date: January 05, 2006 05:01PM To overcome this issue: 1.
Error 1045 Mysql Using Password Yes WindowsUse the MySQL installer again 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 http://stackoverflow.com/questions/14199931/error-no-1045-while-trying-to-connect-to-mysql 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 I did, just in case). 6. Download the the MySQL Administrator http://forums.mysql.com/read.php?11,39440,62685 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: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 Acce
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 http://serverfault.com/questions/424871/mysql-error-1045-28000 developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question http://askubuntu.com/questions/528998/error-1045-28000-on-mysql-server-installation _ 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: 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 error 1045 we can't talk 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 error no 1045 MySQL Server from version 5.1 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.4k683160 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 n
communities company blog Stack Exchange Inbox Reputation and Badges sign up 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 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 Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question _ Ask Ubuntu is a question and answer site for Ubuntu users and developers. 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 (28000) on mysql-server installation [duplicate] up vote 0 down vote favorite This question already has an answer here: #1045 Cannot log in to the MySQL server 1 answer I am new to Ubuntu trying to install MySQL. sudo apt-get install mysql-server php5-mysql then to create database directory structure sudo mysql_install_db Then to secure I use sudo mysql_secure_installation and then it ask me to Enter current password for root I am logged as root by using sudo su but when I try entering the password it give me error:Enter current password for root (enter for none): ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) By typing y for yes also it is giving the same error. please help me. password sudo mysql share|improve this question edited Sep 26 '14 at 19:54 Apurv 58637 asked Sep 26 '14 at 19:18 drakpasanger 85210 marked as duplicate by Eric Carvalho, muru, KasiyA, g_p, Volker Siegel Oct 19 '14 at 0:11 This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question. @Parto when I am running mysql -u root it again give error, ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) –drakpasanger Sep 26 '14 at 19:38 I hope you are not still using a root terminal - that is as sudo su? If so, type exit then follow the steps in the linked question on how to reset your password. You seem to have forgotten your MySQL password. –Parto Sep 26 '14 at 19:41 add a comment| 1 Answer 1 active oldest votes up vote 3 down vote accepted To reset your mysqld password just follow these instructions : Stop the mysql demon process using this command : sudo /etc/init.d/mysql stop Start the mysqld demon process using the --skip-grant-tables option with this command sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking & Because you are not checking user privs at this point, it's safes