Error Number 1045 Access Denied For User Root
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 error no 1045 access denied for user root@localhost this site About Us Learn more about Stack Overflow the company Business Learn
Error No 1045 In Mysql Access Denied For User Root@localhost
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question mysql #1045 - access denied for user 'root'@'localhost' (using password no) 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 a minute: Sign up error 1045 (28000) access denied for user 'admin'@'localhost' (using password yes) ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) up vote 50 down vote favorite 36 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 the following installations on my
Access Denied For User 'root'@'localhost' (using Password No)
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,2351041103 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 edit
Du siehst YouTube auf Deutsch. Du kannst diese Einstellung unten ändern. Learn more You're viewing YouTube in German. You can change this preference below. Schließen Ja, ich möchte sie behalten access denied for user 'root'@'localhost' (using password yes) how to solve Rückgängig machen Schließen Dieses Video ist nicht verfügbar. WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden access denied for user 'root'@'localhost' (using password n Wird geladen... Wiedergabeliste Warteschlange __count__/__total__ how to solve #1045 - Access denied for user 'root'@'localhost' (using
Access Denied For User 'root'@'localhost' (using Password No) On Server
password: NO) Maxamed Xuseen AbonnierenAbonniertAbo beenden4040 Wird geladen... Wird geladen... Wird verarbeitet... Hinzufügen Möchtest du dieses Video später noch einmal ansehen? Wenn du bei YouTube angemeldet bist, kannst http://stackoverflow.com/questions/21944936/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y du dieses Video zu einer Playlist hinzufügen. Anmelden Teilen Mehr Melden Möchtest du dieses Video melden? Melde dich an, um unangemessene Inhalte zu melden. Anmelden Statistik 131.898 Aufrufe 176 Dieses Video gefällt dir? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 177 208 Dieses Video gefällt dir nicht? Melde dich bei YouTube https://www.youtube.com/watch?v=dTZZGJbNkR0 an, damit dein Feedback gezählt wird. Anmelden 209 Wird geladen... Wird geladen... Wird geladen... Die Bewertungsfunktion ist nach Ausleihen des Videos verfügbar. Diese Funktion ist zurzeit nicht verfügbar. Bitte versuche es später erneut. Veröffentlicht am 08.02.2013I was writing ( UPDATE mysql ) : so please follow the next steps if you want to resolve your problem with ( #1045 - Access denied for user 'root'@'localhost' (using password: NO): Kategorie Menschen & Blogs Lizenz Standard-YouTube-Lizenz Mehr anzeigen Weniger anzeigen Wird geladen... Autoplay Wenn Autoplay aktiviert ist, wird die Wiedergabe automatisch mit einem der aktuellen Videovorschläge fortgesetzt. Nächstes Video MySQL Error number:1045 Resolved - Dauer: 4:39 RGN TAMIL 74.467 Aufrufe 4:39 How to fix error #1045 - Access denied for user 'root' in phpmyadmin - Dauer: 4:31 E Angkor 61.007 Aufrufe 4:31 How to solve mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) - Dauer: 4:53 Mohammad Sheam 56.033 Aufrufe 4:53 Error #1045 de Mysql generado en phpMyAdmin (Resuelto) - Dauer: 9:29 Roberto Ca
could possibly encounter the error: #1045 Access Denied for user 'root'@'localhost' (using password: YES).If root@localhost wasn't granted https://www.ostraining.com/blog/coding/error-1045-phpmyadmin/ the necessary rights to access the database or you provided the https://ubuntuforums.org/showthread.php?t=1836919 wrong password, you will then encounter this error.Following this tutorial will help guide you on bypassing this error, for any local host server using phpMyAdmin.If you get an Error #1045 in phpMyAdmin it will look like the image below:Step 1: Open your MySQL access denied console. Using WAMP, left click your WAMP icon located at the bottom right of your desktop and click on MySQL Console. Guide to accessing MySQL using XAMPP Guide to accessing MySQL using MAMP. Step 2: Enter the Provided Command LinesIf you have a password, you can ignore this part. Type in: use mysql; access denied for Press Enter. Set your MySQL Password: UPDATE mysql.user SET Password=PASSWORD("EnterYourPasswordHere") WHERE User="root"; Replace "EnterYourPasswordHere" with your new chosen password. Press Enter. Flush the privileges: FLUSH PRIVILEGES; Exit by typing: Exit Press Enter. Step 3: Open and edit your config.inc.php file located in your local server files Using a text editor, such as Notepad++, open your config.inc.php file. Go to My Computer > C Drive > (Your Local Server Folder, WAMP/MAMP/XAMPP) > APPS > PHPMYADMIN > config.inc.php Find this line of code: $cfg['Servers'][$i]['password'] = ''; // MySQL password Change 'password' to the new chosen password you created from Step 2. Click Save. Step 4: Access phpMyAdmin You can access phpMyAdmin by going to http://localhost/phpMyAdmin/. Congratulations! You are now able to access your databases. View the discussion thread. blog comments powered by DISQUS back to top Blog Categories WordPress TutorialsDrupal TutorialsJoomla TutorialsCoding TutorialsOSTraining NewsWeb Design TutorialsBlog LicenseAll our blog posts are published under the Creative CommonsAttribution-NonCommercial license: You can re-use thes
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 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 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 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 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/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?