Error No 1045 Access Denied
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 more about hiring developers error 1045 access denied for user 'root'@'localhost' (using password no) or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x
Error 1045 Access Denied For User 'root'@'localhost' Centos
Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only error 1045 access denied for user 'root'@'localhost' using password yes takes a minute: Sign up MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) up vote 240 down vote favorite 117 First let me mention that I've gone through many suggested questions and found no relevent answer.
Error 1045 Access Denied For User Mysql
Here is what I'm doing. I'm connected to my Amazon EC2 instance. I can login with MySQL root with this command: mysql -u root -p Then I created a new user bill with host % CREATE USER 'bill'@'%' IDENTIFIED BY 'passpass'; Granted all the privileges to user bill: grant all privileges on *.* to 'bill'@'%' with grant option; Then I exit from root user and try to login with bill: mysql -u bill -p entered the correct password and got sql error 1045 access denied for user this error: ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) mysql access-denied share|improve this question edited Sep 6 at 17:44 Jaap 1,2101431 asked Apr 24 '12 at 13:42 Ali 1,88081738 14 Did you FLUSH PRIVILEGES? –eggyal Apr 24 '12 at 14:10 1 Nope. Let me try that –Ali Apr 24 '12 at 14:15 1 Okay, I tried this without any success. Any other suggestion please. –Ali Apr 25 '12 at 4:35 1 What version of the server are you running? I've seen 5.1 behave oddly about this. –Poodlehat Jun 27 '12 at 14:27 1 This happened to me while installing Magento and I made a much sillier mistake. Putting 'mysql -u magento -p magento' was prompting me for a password and instead of the default password I was putting the root password in. –AmirHd Oct 29 '13 at 3:26 | show 4 more comments 26 Answers 26 active oldest votes up vote 282 down vote accepted You probably have an anonymous user ''@'localhost' or ''@'127.0.0.1'. As per the manual: When multiple matches are possible, the server must determine which of them to use. It resolves this issue as follows: (...) When a client attempts to connect, the server looks through the rows [of table mysql.user] in sorted order. The server uses the first row that matches the client host name and user name. (...) The server uses sorting rules that order row
#1045 - Access denied for user 'root' in phpmyadmin E Angkor SubscribeSubscribedUnsubscribe1,0211K Loading... Loading... Working... Add to Want to watch this again later? Sign in to add this video to a playlist. Sign in Share More Report Need to report the
Mysqlcheck Got Error 1045 Access Denied For User Root Localhost
video? Sign in to report inappropriate content. Sign in Statistics 61,108 views 59 Like
#1045 - Access Denied For User 000webhost
this video? Sign in to make your opinion count. Sign in 60 22 Don't like this video? Sign in to make your #1045 - access denied for user 000webhost phpmyadmin opinion count. Sign in 23 Loading... Loading... Loading... Rating is available when the video has been rented. This feature is not available right now. Please try again later. Published on Oct 17, 2015#1045 - Access denied http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw for user 'root'@'localhost' (using password: NO or YES), if have problem like this , please try Category Education License Standard YouTube License Show more Show less Loading... Advertisement Autoplay When autoplay is enabled, a suggested video will automatically play next. Up next MySQL said: Cannot connect invalid settings error | XAMPP Phpmyadmin - Duration: 3:28. Abdel Tutors 8,967 views 3:28 How to solve mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) https://www.youtube.com/watch?v=oz6BTvpn3qY - Duration: 4:53. Mohammad Sheam 56,033 views 4:53 How to remove phpMyAdmin Access denied Error #1045 in wamp server - Duration: 2:46. Solution Cone 75,311 views 2:46 Erro #1045 - Access denied for user 'root'@'localhost' (using password: NO) - Duration: 9:53. Marcio Ribeiro 649 views 9:53 XAMPP mysql error Solved - Duration: 3:36. Solution Cone 23,542 views 3:36 wamp phpMyAdmin error #1045 - Access denied for user root@locahost Fixed! - Duration: 4:56. locslikes 35,134 views 4:56 How to install PHPmyadmin for 000webhost - Duration: 6:29. jozsi jozsika 16,860 views 6:29 xampp mysql password reset full tutorial | with phpMyadmin - Duration: 4:43. wordpress blog 10,351 views 4:43 MySQL Error number:1045 Resolved - Duration: 4:39. RGN TAMIL 74,467 views 4:39 how to solve #1045 - Access denied for user 'root'@'localhost' (using password: YES) - Duration: 2:29. Abhishek Gakhar 4,451 views 2:29 How to fix phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection - Duration: 2:28. Jhon Smith 25,599 views 2:28 Making and hosting a free website on 000webhost - Duration: 4:29. Hacks And Security 18,938 views 4:29 Error establishing a database connection in 000webhost - Duration: 1:53. Learner's TV 19,476 views 1:53 How to upload a MySQL database to 000webhost - Duration: 7:15. Nassos Kranidiotis 14,256 views 7:15 Xampp M
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 http://askubuntu.com/questions/401449/error-104528000-access-denied-for-user-rootlocalhost-using-password-no this site About Us Learn more about Stack Overflow the company Business Learn https://ubuntuforums.org/showthread.php?t=1836919 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 access denied 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 access denied for 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,8561439 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,92721846 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 pass
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 Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The 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 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 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 thin