Mysql Error 1045 Help
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 Learn
Mysql Error 1045 Access Denied For User 'root'@'localhost'
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags mysql error 1045 using password no 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 Sqlstate 28000 Access Denied For User 'root'@'localhost'
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 error when I error 1045 access denied for user 'root'@'localhost' windows 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 install of MySQL. Environment Fedora access denied for user 'root'@'localhost' mysql 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 199k37360417 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|improve this answer edited May 4 '15 at 18:10
Get Kubuntu Get Xubuntu Get Lubuntu Get UbuntuStudio Get Mythbuntu Get Edubuntu Get Ubuntu-GNOME Get UbuntuKylin Ubuntu Code of Conduct Ubuntu Wiki Community Wiki Other Support Launchpad Answers Ubuntu IRC Support AskUbuntu
Mysql Error 1045 Access Denied For User 'root'@'localhost' Windows
Official Documentation User Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: error 1045 mysql windows Ubuntu Web Upd8: Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The
Mysql Error 1045 Access Denied For User Root@localhost Password No
Ubuntu Forum Community Ubuntu Specialised Support Ubuntu Servers, Cloud and Juju Server Platforms [SOLVED] mySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost Having an Issue With Posting ? Do you want to help http://stackoverflow.com/questions/489119/mysql-error-1045-access-denied us debug the posting issues ? < is the place to report it, thanks ! Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 16 Thread: mySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode September 1st, 2011 #1 BlackWhiteAndRed View Profile View Forum https://ubuntuforums.org/showthread.php?t=1836919 Posts Private Message First Cup of Ubuntu Join Date Aug 2011 Beans 3 mySQL ERROR 1045 (28000): Access denied for user 'root'@'localhost I can't get mySQL to run even though I have the correct password. I was having problems directing a localhost and I tried fixing things in myphpadmin. I deleted my root directory/privileges in phpmyadmin and then things took a turn for the bad. mySQL could no longer run and I have no idea how to fix it. I've tried reinstalling phpmyadmin and everything related to mySQL and still do not have any luck getting it to run. I know mySQL is running because when I type in: ps -ef | grep mysql I get mysql 1149 1 0 20:23 ? 00:00:00 /usr/sbin/mysqld jeremy 2314 2283 0 20:34 pts/0 00:00:00 grep mysql When I type in: "mysql -u root -p" and enter the password I get reset I get the message: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I've tried using an init file and loading it from there, resetting passwords and using dkpg to reset things but still have no luck. If I type the command: mysqld --skip-grant-tables I get 110831 20:57:24 [Warning] Can't create test file /var/lib/mysql/jeremy-laptop.lower-test 110831 20:57:
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Install & Repo :: ERROR 1045 (28000): http://forums.mysql.com/read.php?11,34014,46593 Access denied for user 'root'@'localhost' (using password: NO) New Topic http://askubuntu.com/questions/528998/error-1045-28000-on-mysql-server-installation Advanced Search Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Posted by: Shawn Tucker () Date: September 27, 2005 12:40PM I had the same problem, this solution worked for me. You will need to reset the error 1045 password. First start the mysql server instance or daemon with the --skip-grant-tables option. (security setting) Then Execute these statements. # mysql -u root mysql mysql> UPDATE user SET Password=PASSWORD('your_new_password') where USER='root'; mysql> FLUSH PRIVILEGES; Finally, restart the instance/daemon without the --skip-grant-tables option. You should be able to connect with your access denied for new password. # mysql -u root -p Enter password: your_new_password Hope this helps. Shawn Tucker Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Daniel Ho 07/12/2005 01:16PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Daniel Ho 07/12/2005 07:49PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) carminda timas 05/11/2007 02:20PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Eric Okorie 05/21/2007 10:57PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) pigeret john 07/22/2007 01:59AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Me izme 10/11/2007 08:04AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Christopher Armstrong 12/27/2007 07:40PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) kandy kavitha 09/01/2
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 comma