Error 1045 Ubuntu Mysql
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 ubuntu mysql error 1045 access denied for user Official Documentation User Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu
Mysql Error 1045 Using Password Yes
PPAs: Ubuntu Web Upd8: Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum mysql error 1045 access denied for user 'root'@'localhost' 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 mysql error 1045 windows 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
Mysql Admin Error 1045
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/
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 Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about mysql server error 1045 hiring developers or posting ads with us Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question mysql install error 1045 _ Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute: Sign up Here's
Mysql 5.0 Error 1045
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 https://ubuntuforums.org/showthread.php?t=1836919 an answer here: #1045 Cannot log in to the MySQL server 1 answer I am new 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): http://askubuntu.com/questions/528998/error-1045-28000-on-mysql-server-installation 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 for user 'root'@'localhost' (using password: NO) –drakpasanger Sep 26 '14 at 19:38 I hope you are not still using a root terminal - that is as sudo su? If so, type exit then follow the steps in the linked question on how to reset your password. You seem to have forgotten your MySQL password. –Parto Sep 26 '14 at 19:41 add a comment| 2 Answers 2 active oldest votes up vote 3 down vote accepted To reset your mysqld password just follow these instructions : Stop the mysql demon process using this command : sudo /etc/init.d/mysql stop Start the mysqld demon process using the --skip-grant-tables option with this command sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking & Because you are not checking user privs at this point, it's safest to d
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://stackoverflow.com/questions/38207696/mysql-start-ubuntu-error-1045-28000-access-denied-for-user-usernameloca About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question 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 mysql start ubuntu error 1045 - ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: NO) up vote 0 down vote favorite I cant start mysql server on local machine. Run mysql start, display error: ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: NO) How solve this issue? mysql ubuntu share|improve this question edited Jul 7 at 17:04 scott_lotus 1,98572435 asked Jul 5 at 15:49 Dmitrij 174 mysql error 1045 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote try entering mysql -uroot -p it will ask you to put in your password then it looks like your MySql is running and if that doesnt work do mysql start -uroot -p alternatively look at this https://coolestguidesontheplanet.com/start-stop-mysql-from-the-command-line-terminal-osx-linux/ share|improve this answer answered Jul 5 at 16:02 Artem Ankudovich 15610 yes, i input myt password and enter. - "Welcome to the MySQL monitor. Your MySQL connection id is 44." why i cant run mysql server? –Dmitrij Jul 5 at 16:07 Your MySql is running if you can login. can you show what you get after inputting the password and may i ask why would you say it doesn't work. By the way Russian is ok if you are having issues translating. –Artem Ankudovich Jul 5 at 16:10 username@username-Lenovo-B590:~$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 44 Server version: 5.7.12-0ubuntu1.1 (Ubuntu) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and