Error 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 this site About Us Learn more about Stack Overflow the mysql error 1045 access denied for user root localhost company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions got error 1045 access denied for user root localhost Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million error 'access denied for user 'root'@'localhost' (using password no)' 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 36 I am
Error 1045 (28000) Access Denied For User 'mysql'@'localhost' (using Password No)
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 me@ubuntu:~/Desktop/iPDC-v1.3.1/DBServer-1.1$ mysql -uroot error 1045 (28000) at line 1 access denied for user -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,2031040103 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.6k54670 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
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies access denied for user 'root'@'localhost' (using password no) of this site About Us Learn more about Stack Overflow the company Business
Mysqlcheck Got Error 1045 Access Denied For User Root Localhost
Learn more about hiring developers or posting ads with us Super User Questions Tags Users Badges Unanswered Ask Question
Error 1045 Access Denied For User 'root'@'localhost' Centos
_ 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 http://stackoverflow.com/questions/21944936/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y a question Anybody can answer The best answers are voted up and rise to the top mysql how to fix Access denied for user 'root'@'localhost' up vote 52 down vote favorite 31 Before I screw up something, when login using $ mysql -u root -p, and show databases: +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | http://superuser.com/questions/603026/mysql-how-to-fix-access-denied-for-user-rootlocalhost game_data | | test | +--------------------+ Then I try to create a new user and notice something is wrong with the PRIVILEGES. So I deleted the new users, and I guess I removed the 'root' and 'Admin' accidentally. Then I try to create 'root' again, but get Access denied error when doing grant all privileges. mysql> CREATE USER 'root'@'localhost' IDENTIFIED BY 'password'; mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'password' with grant option; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) If I login mysql again using $ mysql -u root -p, and show databases, +--------------------+ | Database | +--------------------+ | information_schema | +--------------------+ All the other databases are gone. How do I fix mysql now? I cannot cannot find the database 'mysql', cannot create database, create user, anything I try to do will get an error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES). Should I reinstall mysql using macports? If reinstall, I will lost the database 'game_data', right? mysql user-accounts login privileges share|improve this question edited Dec 31 '15 at 11:36 Eric Leschinski 2,71542642 asked Jun 3
Du kan ändra inställningen nedan. Learn more You're viewing YouTube in Swedish. You can change this https://www.youtube.com/watch?v=oz6BTvpn3qY preference below. Stäng Ja, behåll den Ångra Stäng Det här videoklippet är inte tillgängligt. VisningsköKöVisningsköKö Ta bort allaKoppla från Läser in ... Visningskö Kö __count__/__total__ Ta reda på varförStäng How to fix error #1045 - Access denied for user 'root' in phpmyadmin E Angkor PrenumereraPrenumerantSäg upp995995 Läser in ... Läser in ... access denied Arbetar ... Lägg till i Vill du titta på det här igen senare? Logga in om du vill lägga till videoklippet i en spellista. Logga in Dela Mer Rapportera Vill du rapportera videoklippet? Logga in om du vill rapportera olämpligt innehåll. Logga in Statistik 60 210 visningar 59 Gillar du videoklippet? Logga in och access denied for gör din röst hörd. Logga in 60 20 Gillar du inte videoklippet? Logga in och gör din röst hörd. Logga in 21 Läser in ... Läser in ... Läser in ... Rankning kan göras när videoklippet har hyrts. Funktionen är inte tillgänglig just nu. Försök igen senare. Publicerades den 17 okt. 2015#1045 - Access denied for user 'root'@'localhost' (using password: NO or YES), if have problem like this , please try Kategori Utbildning Licens Standardlicens för YouTube Visa mer Visa mindre Läser in ... Annons Automatisk uppspelning När automatisk uppspelning är aktiverad spelas ett föreslaget videoklipp upp automatiskt. Kommer härnäst MySQL said: Cannot connect invalid settings error | XAMPP Phpmyadmin - Längd: 3:28. Abdel Tutors 8 230 visningar 3:28 How to solve mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) - Längd: 4:53. Mohammad Sheam 55 023 visningar 4:53 Erro #1045 - Access denied for user 'root'@'localhost' (using password: NO) - Längd: 9:53. Marcio Ribeiro 436 visningar 9:5