Execution Error 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 Overflow the company Business phpmyadmin error 1045 Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation error 1045 (28000): access denied Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just
Sql Error 1045
like you, helping each other. Join them; it only takes a minute: Sign up MySQL - ERROR 1045 - Access denied up vote 29 down vote favorite 23 In some way I have managed to get this
Mysqldump Error 1045
error when I try to access into MySQL via the command line: [root@localhost ~]# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I have tried resetting the password without any luck using this HowTo. I have uninstalled mysql completley and reinstalled but I still get asked for a password. I have no idea why this is the case! Can someone please help me get a default error 1045 mysql install of MySQL. Environment Fedora Core 10, Full Root Access, Apache and PHP installed Thank you for any help!! EDIT To all those that would like to save themselves a few hours of "blood coughing" - when you uninstall MySQl completely delete everything that is left behind. If you don't do this, it will never be a FRESH install. mysql linux passwords mysql-error-1045 share|improve this question edited Jan 8 '10 at 5:28 OMG Ponies 199k37356416 asked Jan 28 '09 at 20:12 Abs 13.3k68208356 2 MySQL error 1045 explained here: webyog.com/faq/content/23/18/en/… –Man_k Aug 6 '12 at 11:01 add a comment| 6 Answers 6 active oldest votes up vote 63 down vote accepted If you actually have set a root password and you've just lost/forgotten it: Stop MySQL Restart it manually with the skip-grant-tables option: mysqld_safe --skip-grant-tables Now, open a new terminal window and run the MySQL client: mysql -u root Reset the root password manually with this MySQL command: UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'; If you are using MySQL 5.7 (check using mysql --version in the Terminal) then the command is: UPDATE mysql.user SET authentication_string=PASSWORD('password') WHERE User='root'; Flush the privileges with this MySQL command: FLUSH PRIVILEGES; From http://www.tech-faq.com/reset-mysql-password.shtml (Maybe this isn't what you need, Abs, but I figure it could be useful for people stumbling across this question in the future) share|
(importing) an sq ... 14 Oct: Feature Request: Export sql, but one fi ... 14 Oct: Uisng mySQL or importing mySQL 14 Oct: How to select different font and line h ... 14 Oct: Import SQL 14 Oct: BUG
Error 1045 Mysql 28000 Access Denied For User
- Unable to create auto_increment c ... 13 Oct: How to always show at error 1045 mysql windows first "Data" tab ... 13 Oct: Are sessions automatically closed at ha ... 13 Oct: How to export a Table error 1045 sqlstate 28000 access denied for user "Data" content as ... 13 Oct: "SHOW PROFILE[S]" is deprecated (and wi ... 13 Oct: unable to export database & max row lim ... 13 Oct: Save session in command line 13 Oct: No connection http://stackoverflow.com/questions/489119/mysql-error-1045-access-denied to MySQL server through S ... 12 Oct: BUG: Kill running query when user doesn ... 12 Oct: Title bar buttons flicker in Windows 10 12 Oct: Cross apply 12 Oct: Feature request: "Connect to" menu to u ... 11 Oct: Feature request: enable SSL & set SSL-C ... DonateHow to donate List of donors HelpRequirements Connecting to a server Command line switches The database tree Creating a table http://www.heidisql.com/forum.php?t=7568 Creating a view Creating a stored procedure Creating a trigger Creating a scheduled event The Data tab Running SQL queries SQL export HeidiSQL portable License Credits SQL Error (1045): Access denied for user 'root'@'localhost' (using password: YES) New topic Register Log in 1 posts nickoo1234 posted 6 years ago in Creating a connection When I try to connect to Heidi SQL for my World of Warcraft private server, I get this error message: SQL Error (1045): Access denied for user 'root'@'localhost' (using password: YES) Ive tried putting in NO password, I've tried ascent, AND I've tried root. Nothing works at all! Can somebody please help me fix this, this is very stressful. 34 posts Rapid-eraser posted 6 years ago If you can connect local with phpmyadmin it seams that your credentials don't have remote access ( or mysql server its self doesn't accept remote access) Try connecting through ssh tunneling where users don't have to be granted spacial remote access (read my posts for who to configuration plink+putty). If you don't want to use tunneling give remote access to your user reload privileges and try again. 785 posts kalvaro posted 6 years ago I assume you have forgotten the password you chose when you in
which it now accepts each time I log on to sql console. However when I try to access mysqladmin it returns: 1045 - Access denied for user https://www.sitepoint.com/community/t/1045-access-denied-for-user-root-localhost-using-password-no/3809 'root'@'localhost' (using password: NO) Any help much appreciated.Thanks and kind regards,Dermot. Ruben_K 2008-04-02 09:03:34 UTC #2 I don't want to state the obvious but the login mysqladmin uses is wrong. it appears mysqladmin logs in using username 'root' and password '' (blank) derm_w 2008-04-02 11:08:07 UTC #3 Many thanks Ruben.When I first installed wamp2 I could access phpmyadmin. But once I created error 1045 password in mysql console as it suggested I should for security reasons then phpmyadmin immediately hit me with above error.Do I need to reconfigure something somewhere?If so what and where?Sorry for being so slow.Kind regards,Dermot. longneck 2008-04-02 14:08:50 UTC #4 you have to specify the password in the config.inc.php file for phpmyadmin. derm_w 2008-04-02 22:48:28 UTC #5 Many thanks fellas.Thanks to you things error 1045 mysql are swimming again and everything is rosy.And Longneck I've left a pint of Guinness for you at the bar! For any other fellow newbies here is the whole fix:-mysql>UPDATE mysql.user ->SET Password=PASSWORD("*******") ->WHERE User="root";mysql>FLUSH PRIVILEGES; This is from Sitepoint's "Build your own Database Driven Website using PHP and MYSQL" And then as Longneck said specify the password in the config.inc.php file for phpmyadmin. Kind regards,Dermot. bbparis 2008-08-24 07:52:58 UTC #6 I'm just to confirm you that it's the solution. yesterday I tried to fix the problem, but the only think that was missing is the first line in MySQL command: UPDATE mysql.user I was writing ( UPDATE mysql ) : so please follow the next steps if you want to resolve your problem with ( #1045 - Access denied for user 'root'@'localhost' (using password: NO): 1 : go to your WAMP icon on your PC desktop screen and LEFT CLICK to open the menu, you will see MYSQL folder, CLICK to see MYSQL CONSOLE, open it. 2: now you have DOS screen ( a black screen ) : A: if you already set a password, type