Mysql Error Number 1045 Access Denied For User Root
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss access denied for user 'root'@'localhost' mysql the workings and policies of this site About Us Learn more
Error: 'access Denied For User 'root'@'localhost' (using Password: No)'
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Super User
Access Denied For User 'root'@'localhost' (using Password Yes) Windows
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:
Access Denied For User 'root'@'localhost' (using Password Yes) When Trying To Connect
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: +--------------------+ | mysql access denied for user using password yes 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 reins
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 Official access denied for user ''@'localhost' to database 'mysql' Documentation User Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu mysqladmin: connect to server at 'localhost' failed Web Upd8: Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu error 1045 access denied for user 'root'@'localhost' windows Forum Community Ubuntu Official Flavours Support General Help [SOLVED] ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Having an Issue With Posting ? Do you want to help us debug the posting http://superuser.com/questions/603026/mysql-how-to-fix-access-denied-for-user-rootlocalhost issues ? < is the place to report it, thanks ! Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 20 Thread: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode January 9th, 2016 #1 jakr2 View Profile View Forum Posts Private Message https://ubuntuforums.org/showthread.php?t=2309309 Visit Homepage Just Give Me the Beans! Join Date Jan 2016 Beans 46 DistroUbuntu ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Code: An error occurred while installing the database: │ │ │ │ ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Get this when trying to install phpmyadmin im 100% certain im using the right password. Adv Reply Reply With Quote January 9th, 2016 #2 QDR06VV9 View Profile View Forum Posts I Ubuntu, Therefore, I Am Join Date Jun 2005 BeansHidden! Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YE Hi jakr2 Install phpMyAdmin Have you set-up a password? This error pops-up when the password has not been set-up.. You should change your root password after installation if you have not.. Code: mysqladmin -u root password [newpassword] Or you can change your password via Code: sudo dpkg-reconfigure mysql-server-5.5(Or your version) Which will change the root password. Adv Reply Reply With Quote January 9th, 2016 #3 jakr2 View Profile View Forum Posts Private Message Visit Homepage Just Give Me the Beans! Join Date Jan 2016 Beans 46 DistroUbuntu Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YE Code: # mysqladmin -u root password *
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Install & Repo :: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) New Topic Advanced Search Re: ERROR 1045 (28000): http://forums.mysql.com/read.php?11,34014,46593 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 http://askubuntu.com/questions/401449/error-104528000-access-denied-for-user-rootlocalhost-using-password-no the 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> access denied FLUSH PRIVILEGES; Finally, restart the instance/daemon without the --skip-grant-tables option. You should be able to connect with your 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 access denied for 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/2009 12:03PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Majid Farr Amini 06/23/2010 07:33AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Meenakshi Gaur 12/29/2010 08:14AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Jerod Weber 01/21/2011 09:17AM on linux jerry nickles 06/27/2009 08:29PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Benedikt Schackenberg 10/28/2009 08:10AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Mandla Mwelase 11/05/2007 05:33AM Re: ERROR 1045 (28000): Access denied for us
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) : Access denied for user 'root@localhost' (using password: no ) up vote 32 down vote favorite 10 I'm trying to install queXS cati app on my Ubuntu desktop and I installed MySQL server and PHP 5 and I cannot login into MySQL server as root without password: mysql -u root it says ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no ) But it's okay when I enter mysql -u root -p I can't figure out what the problem is. permissions mysql share|improve this question edited May 12 at 8:31 oerdnj 3,8661440 asked Jan 7 '14 at 10:42 user232705 161123 6 Try this: mysql -u root -p mysql Enter password: and you will get: mysql> –user273774 Apr 24 '14 at 18:47 add a comment| 3 Answers 3 active oldest votes up vote 29 down vote That is the normal behaviour. You set a root password for your database so from now on you can't access it without password. That is why it reports: Access denied for user 'root@localhost' (using password: no ) Obviously when you give the password with the -p switch you succeed. share|improve this answer answered Jan 7 '14 at 10:47 falconer 9,94721846 add a comment| up vote 2 down vote In simple words your "root" session do not know password to mysql root user. If you want to make easier to access your mysql create .my.cnf in /root/ and put in it [mysqladmin] user = root password = mysqlrootpassword [mysql] user = root password = mysqlrootpassword [mysqldump] user = root password = mysqlrootpassword where offcourse mysqlrootpassword is your password for mysql's root password so when you execute mysql it uses this password Remeber about safety of this file - put secure rights, so nobody on your server can read it! share|improve this answer answered Jan 16 '14 at 22:25 pl_ 491 1 It's bad to encourage others to put root passwords plaintext on disk. By deduction, that badness property propagates to the person doing it. –Eric Leschinski Dec 31 '15 at 11:49 add a comment| up vote -1 down