Error 1045 Access Denied For User Root@localhost Using Password No
Contents |
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 error 1045 access denied for user root localhost using password yes Overflow the company Business Learn more about hiring developers or posting ads with us
Error 1251 Client Does Not Support Authentication Protocol Requested By Server Consider Upgrading Mysql Client
Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question _ Ask Ubuntu is a question and answer site for Ubuntu users and
Got Error 1045 Access Denied For User Root Localhost
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' Mysql
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 mysqladmin: connect to server at 'localhost' failed I can't figure out what the problem is. permissions mysql share|improve this question edited May 12 at 8:31 oerdnj 3,8461439 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 28 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,91721846 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
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 Documentation User Documentation Social access denied for user 'root'@'localhost' (using password no) ubuntu Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! Ubuntu access denied for user 'root'@'localhost' (using password: no) mac Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Official Flavours Support General access denied for user 'root'@'localhost' (using password yes) windows 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 issues ? < is the place to report it, http://askubuntu.com/questions/401449/error-104528000-access-denied-for-user-rootlocalhost-using-password-no 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 Visit Homepage Just Give Me the Beans! Join Date Jan 2016 Beans 46 https://ubuntuforums.org/showthread.php?t=2309309 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 *****mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' I can do sudo dpkg-reconfigure mysql-server-5.5 And it works fine and le
have one accepted answer. Are you sure you want to replace the current answer with this one? Yes, I'm sure. Changed https://www.digitalocean.com/community/questions/setup-mysql-on-ubuntu-droplet-getting-error-error-1045-28000-access-denied-for-user-root-localhost-using-password-yes your mind? You previously marked this answer as accepted. Are you sure you want to unaccept it? Yes, I'm sure. Sign Up Log In submit Tutorials Questions Projects https://help.ubuntu.com/community/MysqlPasswordReset Meetups Main Site logo-horizontal DigitalOcean Community Menu Tutorials Questions Projects Meetups Main Site Sign Up Log In submit View All Results By: greg535417 Subscribe Subscribed Share 0 Setup MySQL access denied on Ubuntu Droplet getting error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) December 3, 2015 26.8k views MySQL Hi guys, I am very new to using a service like digitalocean (opposed to a one click setup of mediatemple or godaddy) and I am trying to setup and configure a new DB using MySQL but access denied for I keep getting the error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I have googled this, and searched the community for answers but cannot seem to solve this issue. Am I missing something? I have tried running it as root, and running it with sudo through another user and cannot get around it. If I offer no password it gives the same error but instead of using password: YES, it's NO. Thanks. 3 comments 0 mikionline20 January 19, 2016 I faced like this error while i want check my database ERROR 1045 (28000): Access denied for user 'user02'@'localhost' (using password: NO) do you have solution about this 0 CrypticDesigns January 19, 2016 Same solution, just login as root and then change password of the user: update user set password=PASSWORD("YOURPASSWORDHERE") where User='user02'; 0 sergeyvlasov July 3, 2016 Experienced the same problem. This particular explanation and solution made sense for me and helped as well: http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw Log In to Comment Leave a Comment Add comments here to get mor