Mysql Error 1045 Localhost
Contents |
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 error 1045 sqlstate 28000 access denied for user 'root'@'localhost' Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! Ubuntu Ubuntu Insights Planet
Error 1045 Mysql Windows
Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Specialised Support Ubuntu Servers, Cloud and Juju mysql drop anonymous user 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
Mysql Access Denied For User Using Password Yes
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 error 1045 access denied for user 'root'@'localhost' windows 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 had this happen to them or know how to fix it? Adv Reply September 1st, 2011 #2 Wim Sturkenboom View Profile View Foru
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
#1045 Access Denied For User Localhost Using Password Yes
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x
Access Denied For User 'root'@'localhost' Mysql
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 mysqladmin: connect to server at 'localhost' failed 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 am an electrical engineering who mainly play around with power system instead of programming. Recently, https://ubuntuforums.org/showthread.php?t=1836919 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 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: http://stackoverflow.com/questions/21944936/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y 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 would do like mysql -u root -p[newpassword]. The < [filename] is using std input to execute an SQL file at the path given via the user credential you provide. –Mike Brant Feb 21 '14 at 21:00 3 I tried as told mysqladmin -u root passw
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. Are you sure you 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 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, 2015 28.3k views MySQL Hi guys, I am very access denied 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 cannot seem to solve this issue. Am I missing something? I have tried access denied for 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 reset it: Commands sudo /etc/init.d/mysql stop Now start up MySQL in safe mode, so you'll skip the privileges table: sudo mysqld_safe --skip-grant-tables & Login with