Mysql Error 1045 Fresh Install
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 company Business mysql error 1045 using password yes Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation mysql error 1045 access denied for user 'root'@'localhost' Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like mysql error 1045 using password no you, helping each other. Join them; it only takes a minute: Sign up “Access denied for user 'root'@'localhost'” on a fresh install of MySQL 5.6.15 on Windows after uninstalling an older version of MySQL up vote 0
Mysql Error 1045 Windows
down vote favorite 1 So, I've just installed MySQL 5.6.15 on my Windows machine, but for some reason I can't log in using "root" with no password. C:\web\mysql-5.6.15-win32\bin>mysql.exe -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) However I can login with "ODBC" and no password: C:\web\mysql-5.6.15-win32\bin>mysql.exe Welcome blah blah blah mysql> SELECT USER(); +----------------+ | USER() | +----------------+ | ODBC@localhost | +----------------+ 1 row in set (0.00 sec) Why can't mysql fresh install access denied I log in with "root" with no password? I've tried uninstalling MySQL and installing it again, to no avail. mysql passwords root share|improve this question edited Dec 19 '13 at 21:32 asked Dec 19 '13 at 18:54 user2534880 13116 Usually, during installation, a password for the root user must be specified. –marekful Dec 19 '13 at 18:58 Ah, but to install MySQL, I unzipped the archive, and ran "mysqld.exe --install". I didn't use an installation wizard. –user2534880 Dec 19 '13 at 19:01 Then you cannot login as root. –marekful Dec 19 '13 at 19:27 Why? Is that something new in version 5.6? I remember installing older versions (e.g. 5.1) and the default was a "root" account without password. –user2534880 Dec 19 '13 at 20:14 Sorry that was just a guess. I never used windows version but it surprises me that the default root password is empty. In linux that never happens. –marekful Dec 19 '13 at 20:23 add a comment| 3 Answers 3 active oldest votes up vote 2 down vote I still don't know why there isn't a "root" account without password by default, but here's how I solved the problem: Stop the MySQL service (mysqld.exe) Start the MySQL service with the following parameter: --skip-grant-tables Log in to MySQL (mysql.exe) as root: mysql.
communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have mysql error 1045 (28000) Meta Discuss the workings and policies of this site About Us Learn
How To Stop Mysql
more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us
Error 1045 Mysql Ubuntu
Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question _ Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a http://stackoverflow.com/questions/20689494/access-denied-for-user-rootlocalhost-on-a-fresh-install-of-mysql-5-6-15-o 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 ERROR 1045 (28000) on mysql-server installation [duplicate] up vote 0 down vote favorite This question already has an answer here: #1045 Cannot log in to the MySQL server 1 answer I am new http://askubuntu.com/questions/528998/error-1045-28000-on-mysql-server-installation to Ubuntu trying to install MySQL. sudo apt-get install mysql-server php5-mysql then to create database directory structure sudo mysql_install_db Then to secure I use sudo mysql_secure_installation and then it ask me to Enter current password for root I am logged as root by using sudo su but when I try entering the password it give me error:Enter current password for root (enter for none): ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) By typing y for yes also it is giving the same error. please help me. password sudo mysql share|improve this question edited Sep 26 '14 at 19:54 Apurv 58637 asked Sep 26 '14 at 19:18 drakpasanger 85210 marked as duplicate by Eric Carvalho, muru, KasiyA, g_p, Volker Siegel Oct 19 '14 at 0:11 This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question. @Parto when I am running mysql -u root it again give error, ERROR 1045 (28000): Access denied
Start 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 http://serverfault.com/questions/181529/mysql-fresh-install-asking-for-root-password About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is https://ubuntuforums.org/showthread.php?t=1814704 a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best error 1045 answers are voted up and rise to the top mysql fresh install asking for root password up vote 0 down vote favorite 1 A couple of years back i tried to install apache, php and mysql on my mac. I got it all working but in the end i got fed up of doing everything on the command line so switched to mamp Now I'm fed mysql error 1045 up with the sluggishness of mamp and want to get better at using the command line. I'm trying to set it up my self (well, with mac ports) but i forgot the password for the mysql root user. No big problem, no data on there I need, I'll just reinstall. I uninstall of mysql, re-installed mysql and ran: sudo -u _mysql mysql_install_db5 /opt/local/share/mysql5/mysql/mysql.server start All worked fine but doing mysqladmin5 -u root -p ping asks me for a password and mysqladmin5 -u root ping doesn't work. mysql installation root share|improve this question edited Sep 15 '10 at 18:55 jscott 19.5k64974 asked Sep 15 '10 at 18:35 msaspence 131126 migrated from stackoverflow.com Sep 15 '10 at 18:43 This question came from our site for professional and enthusiast programmers. 1 Have you tried "root" as the password? –Jergason Sep 15 '10 at 18:37 Or "" (blank) ? –Jordan Sep 15 '10 at 18:38 yes and yes still no luck –msaspence Sep 15 '10 at 21:18 add a comment| 4 Answers 4 active oldest votes up vote 2 down vote From dev.mysql.com/doc/refman/5.1/en/default-privileges.html : The mysql.user grant table defines the initial MySQL user accounts and
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 Server 5.1 Access Denied Having an Issue With Posting ? Do you want to help us debug the posting issues ? < is the place to report it, thanks ! Results 1 to 6 of 6 Thread: MySQL Server 5.1 Access Denied Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode July 30th, 2011 #1 dmubu View Profile View Forum Posts Private Message 5 Cups of Ubuntu Join Date Jul 2011 Beans 22 MySQL Server 5.1 Access Denied I have just installed the LAMP stack for Ubuntu. When I run: Code: mysql -u root -p or Code: mysql -h localhost -u root -p I receive: Code: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) What should I do? Since I cannot set up the database, I cannot install phpMyAdmin correctly. Thank you! Adv Reply July 30th, 2011 #2 karlson View Profile View Forum Posts Private Message Has an Ubuntu Drip Join Date Dec 2008 Location Deep Woods of PA Beans 699 DistroKubuntu 11.10 Oneiric Ocelot Re: MySQL Server 5.1 Access Denied Originally Posted by dmubu I have just installed the LAMP stack for Ubuntu. When I run: Code: mysql -u root -p or Code: mysql -h localhost -u root -p I receive: Code: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) What should I do? Since I cannot set up the database, I cannot install phpMyAdmin correctly. Thank you! Do you type in the password? Did you set it when you installed the package? Regards, Karlson Adv Reply July 30th, 2011 #3 fdrake View Profile View Forum Posts Private Message V