Mysql Start Error 1045
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 mysql error 1045 28000 access denied for user root localhost using password no the company Business Learn more about hiring developers or posting ads with us Stack Overflow error 1045 access denied for user 'root'@'localhost' windows Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 access denied for user 'root'@'localhost' mysql million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) up vote 50 down vote favorite 37 I mysqladmin: connect to server at 'localhost' failed am an electrical engineering who mainly play around with power system instead of programming. Recently, I have been following a manual to install a software suite on Ubuntu. I have no knowledge on mySQL at all, actually. I have done the following installations on my Ubuntu. sudo apt-get update sudo apt-get install mysql-server-5.5 sudo apt-get install mysql-client-5.5 sudo apt-get install mysql-common sudo apt-get install glade sudo apt-get install ntp Then I do
Mysql Error 1045 Using Password No
me@ubuntu:~/Desktop/iPDC-v1.3.1/DBServer-1.1$ mysql -uroot -proot <"Db.sql" I ended up with the following error message. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) How may I fix it and continue? mysql linux ubuntu share|improve this question asked Feb 21 '14 at 20:52 Sibbs Gambling 3,2621042104 1 This does not seem to be strictly programming-related to me. I flagged it for migration to SuperUser –Uli Köhler Feb 21 '14 at 20:55 add a comment| 12 Answers 12 active oldest votes up vote 54 down vote accepted The default root password is blank (i.e. empty string) not root. So you can just login as: mysql -u root You should obviously change your root password after installation mysqladmin -u root password [newpassword] In most cases you should also set up individual user accounts before working extensively with the DB as well. Update: For MySQL 5.7+ please see answer from @Anshu to this question. That contains more current information. share|improve this answer edited Aug 29 at 13:40 answered Feb 21 '14 at 20:54 Mike Brant 51.7k54670 Thanks for the quick answer. Could you please explain what the -proot <"Db.sql part does? –Sibbs Gambling Feb 21 '14 at 20:57 @FarticlePilter The -p flag specifies the password, so after you change your root password you wou
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
Error 1054 (42s22): Unknown Column 'password' In 'field List'
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs error 1045 sqlstate 28000 access denied for user 'root'@'localhost' Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, access denied for user 'root'@'localhost' (using password yes) windows just like you, helping each other. Join them; it only takes a minute: Sign up MySQL - ERROR 1045 - Access denied up vote 29 down vote favorite 23 In some way I have managed to get http://stackoverflow.com/questions/21944936/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y this error when I try to access into MySQL via the command line: [root@localhost ~]# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I have tried resetting the password without any luck using this HowTo. I have uninstalled mysql completley and reinstalled but I still get asked for a password. I have no idea why this is the case! Can someone please help me get http://stackoverflow.com/questions/489119/mysql-error-1045-access-denied a default install of MySQL. Environment Fedora Core 10, Full Root Access, Apache and PHP installed Thank you for any help!! EDIT To all those that would like to save themselves a few hours of "blood coughing" - when you uninstall MySQl completely delete everything that is left behind. If you don't do this, it will never be a FRESH install. mysql linux passwords mysql-error-1045 share|improve this question edited Jan 8 '10 at 5:28 OMG Ponies 199k37360417 asked Jan 28 '09 at 20:12 Abs 13.3k68208356 2 MySQL error 1045 explained here: webyog.com/faq/content/23/18/en/… –Man_k Aug 6 '12 at 11:01 add a comment| 6 Answers 6 active oldest votes up vote 63 down vote accepted If you actually have set a root password and you've just lost/forgotten it: Stop MySQL Restart it manually with the skip-grant-tables option: mysqld_safe --skip-grant-tables Now, open a new terminal window and run the MySQL client: mysql -u root Reset the root password manually with this MySQL command: UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'; If you are using MySQL 5.7 (check using mysql --version in the Terminal) then the command is: UPDATE mysql.user SET authentication_string=PASSWORD('password') WHERE User='root'; Flush the privileges with this MySQL command: FLUSH PRIVILEGES; From http://www.tech-faq.com/reset-mysql-password.shtml (Maybe this isn't what you need, Abs, but I figure it could be useful for people stumbling across this
have one accepted answer. Are you sure you want to replace the current answer with this one? Yes, I'm sure. Changed your mind? You previously marked this answer as accepted. 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 Are you sure you want to unaccept it? Yes, I'm sure. Sign Up Log In submit Tutorials Questions Projects 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 on Ubuntu Droplet getting error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) December 3, error 1045 2015 28.3k 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 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 access denied for 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 more clarity or context around a question. To answer a question, use the “Answer” field below. Log In to Comment 5 Answers 5 CrypticDesigns December 3, 2015 Which one-click-setup did you use? You can check the configuration files probably and find the password. If you can't find it, neither root without pass is working you can