Error 1045 2800
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and mysql error 1045 access denied for user 'root'@'localhost' policies of this site About Us Learn more about Stack Overflow the
Mysql Error 1045 Using Password No
company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users mysql error 1045 access denied for user 'root'@'localhost' windows Badges Ask Question x 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 takes
#1045 - Access Denied For User Phpmyadmin
a minute: Sign up MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) up vote 238 down vote favorite 116 First let me mention that I've gone through many suggested questions and found no relevent answer. Here is what I'm doing. I'm connected to my Amazon EC2 instance. I can login with MySQL root with this command: mysql #1045 phpmyadmin 000webhost -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 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,86581738 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 prom
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
Error 1045 Mysql Windows
Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu
1045 - Access Denied For User 000webhost
OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Specialised #1045 - access denied for user 00webhost 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 http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw 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 https://ubuntuforums.org/showthread.php?t=1836919 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:24 [Warning] Can't create test file /var/lib/mysql/jeremy-laptop.lower-test 110831 20:57:24 [Warning] One can only use the --user switch if running as root Does anyone ever
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 http://askubuntu.com/questions/401449/error-104528000-access-denied-for-user-rootlocalhost-using-password-no about Stack Overflow the company Business Learn more about hiring developers or posting ads with http://askubuntu.com/questions/528998/error-1045-28000-on-mysql-server-installation 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 error 1045 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 access denied for 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,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
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| 2 Answers 2 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