Os X Mysql Error 1045
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 mac access denied for user root localhost using password yes of this site About Us Learn more about Stack Overflow the company mac error 1045 (28000): access denied for user 'root'@'localhost' (using password: yes) Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges mac stop mysql server Ask Question x 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 only takes a minute:
Sudo: Mysqld_safe: Command Not Found
Sign up Access Denied for MYSQL ERROR 1045 up vote 6 down vote favorite 2 I just got a new macbook pro (OS X 10.8.2) and am attempting to get mysql set up on it. So far I've been able to get it installed but I cannot get my root user access (or any user for that matter). I plan on using mac error 2002 (hy000): can't connect to local mysql server through socket '/tmp/mysql.sock' (2) this for Python, on my other computer I only use MYSQL (no MAMP) and I prefer to keep it that way. For reference, I did the following: $ alias mysql=/usr/local/mysql/bin/mysql $ sudo /Library/StartupItems/MySQLCOM/MySQLCOM start $ alias mysqladmin=/usr/local/mysql/bin/mysqladmin When i enter mysql or mysql -u root -p it gives me this: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) or ERROR 1045 (28000): Access denied for user 'jmitch'@'localhost' (using password: NO) Depending on which phrasing I use MYSQL is running in my system preferences. Thank you for your help. mysql osx terminal osx-mountain-lion mysql-python share|improve this question asked Nov 20 '12 at 18:57 jmitchel3 1411312 howtoforge.com/reset-forgotten-mysql-root-password –Drew Nov 20 '12 at 19:18 add a comment| 4 Answers 4 active oldest votes up vote 16 down vote Maybe updating the package the updater overwrote the root password. To restore it: Stop mysqld deamons. $ sudo service mysqld stop Go to mysql/bin directory $ cd /usr/bin Start a mysql deamon with this option: $ sudo mysqld_safe --skip-grant-tables Open another terminal and open a mysql session to execute this: $ mysql mysql> us
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 error mysql server pid file could not be found mac Stack Overflow the company Business Learn more about hiring developers or posting ads with
Mysqli_real_connect(): (hy000/1045): Access Denied For User 'root'@'localhost' (using Password: Yes)
us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is
How To Reset Mysql Root Password Mac
a community of 6.2 million 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: NO) on MAC OSX http://stackoverflow.com/questions/13480170/access-denied-for-mysql-error-1045 up vote 1 down vote favorite I'm trying to reinstall mysql on my MAC OS X Yosemite. for this I followed the instruction as mentioned below sudo rm /usr/local/mysql sudo rm -rf /usr/local/mysql* sudo rm -rf /Library/StartupItems/MySQLCOM sudo rm -rf /Library/PreferencePanes/MySQL* vim /etc/hostconfig and removed the line MYSQLCOM=-YES- rm -rf ~/Library/PreferencePanes/MySQL* sudo rm -rf /Library/Receipts/mysql* sudo rm -rf /Library/Receipts/MySQL* sudo rm -rf /var/db/receipts/com.mysql.* I also tried brew uninstall mysql after http://stackoverflow.com/questions/32858216/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-n this I installed mysql using homebrew using command brew install mysql. After installation when I tried to run mysql -u root It throws the following error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I didn't set password for mysql.I don't know what's going wrong.Any suggestion will be appreciated. Thank you mysql osx share|improve this question asked Sep 30 '15 at 5:09 Bibek Sharma 1,5881126 Try password reset: dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html –James Jithin Sep 30 '15 at 5:24 Did you tried mysql -u root -p? –scherard Sep 30 '15 at 6:57 yes I tried it.but it ask for password and on pressing entering it raise above error –Bibek Sharma Sep 30 '15 at 7:01 1 refer to stackoverflow.com/questions/33326065/… –Kumar Nitin Jan 21 at 12:29 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Now sql generates an aliatory password that appears in the last screen. sudo mysql -u root -h 127.0.0.1 -p Enter password: (aliatory password) we can change it ALTER USER 'root'@'localhost' IDENTIFIED BY 'new-password'; share|improve this answer answered May 11 at 19:04 Inês Gomes 294 how can you change it if you can't log into mysql? –Daniel Tate Aug 9 at
not post a blank message. Please type your https://discussions.apple.com/thread/6427081?start=0&tstart=0 message and try again. codeisfun Level 1 http://dba.stackexchange.com/questions/69029/how-to-fix-access-denied-for-user-rootlocalhost-error-for-mysql-using-mac (0 points) Q: Error 1045 mysql new installation on OSX 10.9.3 after new mysql-5.7.4-m14-osx10.7-x86_64 installation,I typed "/usr/local/mysql/bin/mysql" I got "ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: NO)" I access denied type "ps auxww | grep mysql", I got"_mysql 224 0.0 6.6 3188416 552216 ?? S 7:58pm 0:01.50 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/Dongs-MacBook-Pro.local.err --pid-file=/usr/local/mysql/data/Dongs-MacBook-Pro.local.pid --socket=/var/mysql/mysql.sock --port=8888root 65 0.0 0.0 2461016 1064 ?? Ss 7:58pm 0:00.04 /bin/sh /usr/local/mysql/bin/mysqld_safe --user=mysqldongzhong 594 access denied for 0.0 0.0 2432784 604 s000 S+ 8:56pm 0:00.00 grep mysql"I type "sudo nano /Library/LaunchDaemons/com.mysql.mysql.plist", I got
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 hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a 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 How to fix “Access denied for user 'root'@'localhost'” error for MySQL using Mac OS X? up vote 0 down vote favorite 1 After reading a few of the similar problems to mine and none of them working, I thought I'd attempt to be more specific to see if my root problem needed to be fixed differently than the others. I've been using MySQL for about a year now and it's always worked fine -- but I got a new Macbook Pro (10.9.3) yesterday, and everything migrated and runs great except for MySQL. It's running: My root user is enabled and I checked to see that the password is the same as my user login (and the same as it's always been) -- but every time I try to run it, whether it be through Terminal or through Sequel Pro, I always get the same: Access denied for user 'root'@'localhost' (using password: YES) I also traditionally use Sequel Pro -- which migrated over from my old computer without any problems, and retained the connection details its always had: But I'm getting the same error message through Sequel Pro as I am through Terminal: Does anybody have any ideas of things I can try? After attempting some of the other similar questions on here, I've unfortunately come up with nothing. Thanks! mysql mac-os-x share|improve this question asked Jun 25 '14 at 16:32 Ryan 2038 @MaximeFOUILLEUL But if I take out the password it just says Access denied for user 'root'@'localhost' (using password: NO) instead? –Ryan Jun 25 '14 at 19:57 add a comment| 1 Answer 1 active oldest votes up vote -1 down vote Run this /usr/bin/mysql_upgrade -u root -p This should reset the rights and grant access with u logged in as 'root'@'localhost' Thereafter run this /usr/bin/mysql -u root -p... et viola! share|improve this answer answered Sep 30 '15 at 17:38 Saraansh 1 add a comment| Your Answer draft saved draft discarded Sign up or