Mysql Error 1045 Linux
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 mysql error 1045 access denied for user 'root'@'localhost' of this site About Us Learn more about Stack Overflow the company mysql error 1045 using password no Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges error 1045 access denied for user 'root'@'localhost' windows Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a access denied for user 'root'@'localhost' mysql minute: Sign up ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) up vote 50 down vote favorite 37 I 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
Error 1045 Sqlstate 28000 Access Denied For User 'root'@'localhost'
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 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
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
Mysql Error 1045 Access Denied For User 'root'@'localhost' Windows
Stack Overflow the company Business Learn more about hiring developers or posting ads with mysql error 1045 access denied for user root@localhost password no us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is error 1045 mysql windows a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) up vote http://stackoverflow.com/questions/21944936/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y 240 down vote favorite 118 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 -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 http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw 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,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 multip
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 https://ubuntuforums.org/showthread.php?t=1836919 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 http://superuser.com/questions/400331/mysql-start-error-1045-28000-access-denied-for-user-rootlocalhost-using 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 error 1045 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 access denied for 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 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
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 Super User Questions Tags Users Badges Unanswered Ask Question _ Super User is a question and answer site for computer enthusiasts and power users. 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 mysql start ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password no) in OpenSuse 12.1 up vote 1 down vote favorite running openSuse 12.1 . on a notebook... well i configured apache 2 and mysql - (after starting it on the runlevel. well - i did all i needed to do - but now i stuck.... after installing phpmyadmin . i tried to find the site ... i couldnt then i tried to start the mysql via command line - which failed ... duhhhhhh!!?? What can i do now - what is wrong here linux-wyee:/home/martin # mysql start ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) linux-wyee:/home/martin # hmmm i have no glue - probably i have messed up some passwords . what do you think! how can i make sure that all runs nice -and nothing - that means no pART OF the apache2, mysql and all that things quits to work propperly linux apache-http-server mysql webserver opensuse share|improve this question asked Mar 13 '12 at 19:05 zero 81419 Error 1045 is detailed here: webyog.com/faq/content/23/18/en/… –Ashwin A Aug 10 '12 at 12:15 add a comment| 2 Answers 2 active oldest votes up vote 2 down vote accepted maybe you should use systemctl to start the mysql server daemon sudo systemctl start mysql.service Also if you want to add the server to the suse standard runlevels you should use: sudo systemctl enable mysql.service Next up you must execute mysql_secure_installation as root. sudo mysql_secure_installation here you must follow the steps and enter the password for the root mysql user. note that this is not the root user of your linux box. Now simply use the mysql client. Simply issue mysql ^^And remember you are on suse. Something sugested like rcscript start would not work because suse is using systemd now. share|improve this answer edited Mar 13 '12 at 19:43 a