Debian Error 1045
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 debian-sys-maint change password Learn more about Stack Overflow the company Business Learn more about hiring developers error 1045 28000 access denied for user using password yes or posting ads with us Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question _ Ask Ubuntu is a question and mysql create debian-sys-maint 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 access denied for user 'debian-sys-maint'@'localhost' (using password: yes) and rise to the top mysql error 1045(280000) access denied for user 'debian-sys-maint '@' localhost using password 'yes' up vote 0 down vote favorite I edited deian.cnf to change the password of mysql (ubuntu server) sudo vi /etc/mysql/debian.cnf I change user=debian-sys-maint password=* to user=debian-sys-maint password=mypassword then I tried to enter console of mysql mysql -udebian-sys-maint -p and inputed password 'mypassword' it reported mysql error 1045(280000) access denied for user
Access Denied For User 'root'@'localhost' (using Password: No)
'debian-sys-maint '@' localhost using password 'yes' I tried to remove mysql and reinstall, the error is same. Your comment welcome mysql share|improve this question asked Aug 7 '13 at 19:27 user262325 10626 I think you need to tell mysql about the password change by also changing the password in mysql. –dan08 Aug 7 '13 at 20:46 add a comment| 3 Answers 3 active oldest votes up vote 2 down vote The error message tell you that, your password is wrong or the account debian-sys-maint has no access to the database on host localhost. If you are sure your password is correct you should grant all privileges like this: login as root first mysql -u root -p
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings
Error 1046 (3d000): No Database Selected
and policies of this site About Us Learn more about Stack Overflow mysql access denied for user 'root'@'localhost' the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags reset mysql root password Users 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 http://askubuntu.com/questions/329873/mysql-error-1045280000-access-denied-for-user-debian-sys-maint-localhost takes 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 http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw 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 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 mage
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 http://serverfault.com/questions/449674/mysql-permission-access-denied-for-user-debian-sys-maintlocalhost more about Stack Overflow the company Business Learn more about hiring developers or posting http://serverfault.com/questions/672753/cant-grant-mysql-privileges-to-debian-system-maintenance-user ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. 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 access denied the top MYSQL Permission: Access denied for user 'debian-sys-maint'@'localhost up vote 0 down vote favorite Got a problem with a mysql server installation on Debian. (Not my server so I have no idea what caused this...) Installing new applications that add a database fail with error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I can log in with the user, I've flushed permissions... Then I access denied for can across this question: http://stackoverflow.com/questions/1709078/how-can-i-restore-the-mysql-root-users-full-privileges But when I try to stop mysql, it fails with error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)' mysql debian permissions share|improve this question asked Nov 17 '12 at 9:19 Jannemans 307519 add a comment| 2 Answers 2 active oldest votes up vote 4 down vote accepted Debian use debian-sys-maint account for management (start/stop etc.). Credentials are stored in /etc/mysql/debian.cnf - check if all are valid. share|improve this answer answered Nov 17 '12 at 15:56 Tomasz Olszewski 636616 add a comment| up vote 1 down vote There are many ways of restoring the debian-sys-maint user. Most easy to do is to reconfigure package mysql-server-5.5. That if you know the password for the root user of MySQL, you can try to restore the user and its password in /etc/mysql/debian.cnf. sudo dpkg-reconfigure mysql-server-5.5 To restore MySQL:s root password (or any MySQL-users password) you can use the debian-sys-maint account. You need to run mysql to get the password for the debian-sys-maint account. sudo mysql --defaults-file=/etc/mysql/debian.cnf mysql> UPDATE mysql.user SET Password=PASSWORD('secret') WHERE User='root'; mysql> FLUSH PRIVILEGES; mysql> QUIT; So, never remove the user debian-sys-maint, as it is used in Debian to administrate MySQL (shut it down, roll logs, upgrade packages, check existans of root user
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 Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. 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 Can't grant MySQL privileges to Debian system maintenance user up vote 1 down vote favorite I have a dedicated Debian 7 server running multiple websites with MySQL as the database server. When I tried to install the latest updates, MySQL couldn't be updated because the server failed to stop. I found someone with similar symptoms in this question: Debian - Can't stop MySQL; permissions? The answers to the above question suggest granting full privileges on all databases to 'debian-sys-maint'@'localhost', but when I try to grant the privileges I get an access denied error. mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY '...'; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost'; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Another weird thing is I now have two root users in my mysql.user table. Is this normal or could this be related to my problem? The localhost.localdomain one doesn't even have a password hash. I also have one user for each site I run but I left them out for clarity. +-----------------------+------------------+ | Host | User | +-----------------------+------------------+ | localhost | debian-sys-maint | | localhost | root | | localhost.localdomain | root | +-----------------------+------------------+ Edit: Running dpkg-reconfigure mysql-server says this: xxx@yyy:~$ sudo dpkg-reconfigure mysql-server /usr/sb