Mysql Error Number 1045 Solution
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta mysql error number 1045 access denied for user 'root'@'localhost' Discuss the workings and policies of this site About Us Learn more error 1045 mysql windows 7 about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack mysql error number 1045 access denied for user using password yes Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you,
Error 1045 Mysql Windows 8
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 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) how to solve error #1045 in phpmyadmin 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,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 pan
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 error no 1045 access denied for user the company Business Learn more about hiring developers or posting ads with us Stack
Error 1045 Mysql Using Password Yes Windows
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of
Mysql Error No 1045 Access Denied For User
6.2 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 1 I http://stackoverflow.com/questions/10374962/error-1045-mysql-during-setup 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 6,27938105190 http://stackoverflow.com/questions/14199931/error-no-1045-while-trying-to-connect-to-mysql "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.E.P 46441132 add a comment| up vot
2:49 Reporter: bhodi sol Email Updates: Status: Can't repeat Impact on me: None Category:MySQL Server: Config Wizard Severity:S2 (Serious) Version:5.1.54 OS:Microsoft Windows (2008 R2) Assigned to: https://bugs.mysql.com/bug.php?id=59988 View Add Comment Files Developer Edit Submission View Progress Log Contributions [7 Feb 2011 15:42] bhodi sol Description: Apply security is the problem in the configuration wizard. I have tried by opening http://superuser.com/questions/603026/mysql-how-to-fix-access-denied-for-user-rootlocalhost the port and uninstall & did a fresh installation by deleting the old mysql directory but I still get the error. Is there any permanent patch for this because this is a mysql error common error where most of the mysql users getting this error in common. How to repeat: mysql instance configuration wizard> error when applying security settings > Error Nr : 1045 - Access denied for user root@localhost (using password YES) Suggested fix: I have tried by opening the port and uninstall & did a fresh installation by deleting the old mysql directory but I still 1045 access denied get the error. Is there any permanent patch for this because this is a common error where most of the mysql users getting this error in common. [7 Feb 2011 15:49] Miguel Solorzano Could you please look for a file on your data install directory with your hots_name_computer.err and print here the error messages. Thanks in advance. [7 Feb 2011 16:25] bhodi sol There is no hots_name_computer.err in the installation directory, program files>Mysql>Mysql server 5.1> contains bin,Doc,lib,share directories in this there is no such .err file in any of these. [7 Feb 2011 16:37] Miguel Solorzano Please open in the installation directory the file my.ini and look the datadir variable which has the data directory, then in that datadir directory look for the *.err file. [8 Feb 2011 2:02] bhodi sol Apologize datadir was in the hidden folder, here is the error in the .err file when I initiated the configuration wizard. 110208 7:21:44 [Note] C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown 110208 7:21:44 [Note] Event Scheduler: Purging the queue. 0 events 110208 7:21:44 InnoDB: Starting shutdown... 110208 7:21:45 InnoDB: Shutdown completed; log sequence number 0 338136802 110208 7:21:45 [Note]
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 mysql how to fix Access denied for user 'root'@'localhost' up vote 52 down vote favorite 31 Before I screw up something, when login using $ mysql -u root -p, and show databases: +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | game_data | | test | +--------------------+ Then I try to create a new user and notice something is wrong with the PRIVILEGES. So I deleted the new users, and I guess I removed the 'root' and 'Admin' accidentally. Then I try to create 'root' again, but get Access denied error when doing grant all privileges. mysql> CREATE USER 'root'@'localhost' IDENTIFIED BY 'password'; mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'password' with grant option; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) If I login mysql again using $ mysql -u root -p, and show databases, +--------------------+ | Database | +--------------------+ | information_schema | +--------------------+ All the other databases are gone. How do I fix mysql now? I cannot cannot find the database 'mysql', cannot create database, create user, anything I try to do will get an error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). Should I reinstall mysql using macports? If reinstall, I will lost the database 'game_data', right? mysql user-accounts login privileges share|improve this question edited Dec 31 '15 at 11:36 Eric Leschinski 2,73742642 asked Jun 3 '13 at 7:32 Vogelsire 363146 migrated from stackoverflow.com Jun 3 '13 at 8:32 This question came from our site for professional and enthusiast programmers. Try accesing the server with 'root'@'127.0.0.1' which is diferent from 'root'@'localhost'. Then issue a command to create the user 'root'@'localhost' and grant all privileg