Mysql Error 1045 Mac
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 Learn more about mac access denied for user root localhost using password yes hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask mac error 1045 (28000): access denied for user 'root'@'localhost' (using password: yes) 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 sudo: mysqld_safe: command not found them; it only takes a minute: 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 error mysql server pid file could not be found mac 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 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
Stop Mysql Server Mac
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> use mysql; see Note1 below for next line. mysql> UPDATE user SET password=PASSWORD('YOUR_NEW_PASSWORD_HERE') WHERE user = 'root'; mysql> exit; Now kill the mysqld_safe process and restart mysqld normally: $ sudo service mysqld start Note1: password is the column name in table mysql.user prior to version 5.7. After which it became authentication_string. Change your update statement accordingly. share|improve this answer edited Aug 15 at 5:41 answered Nov 20 '12 at 19:10 Drew 19.7k71951 4 $ sudo service mysql stop returns sudo: service: command not found –jmitchel3 Nov 20 '12 at 22:11 running the daemon in sudo mysqld_safe -
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the
Mysqli_real_connect(): (hy000/1045): Access Denied For User 'root'@'localhost' (using Password: Yes)
workings and policies of this site About Us Learn more about mac error 2002 (hy000): can't connect to local mysql server through socket '/tmp/mysql.sock' (2) Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions how to reset mysql root password mac Jobs Documentation Tags Users Badges 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. http://stackoverflow.com/questions/13480170/access-denied-for-mysql-error-1045 Join them; it only takes a minute: Sign up Unable to access MySQL after it automatically generated a temporary password up vote 25 down vote favorite 7 I have erased and installed OSX 10.11 El Capitan and I have been following through this tutorial to get MySQL up and running on the new OS X. The first step was http://stackoverflow.com/questions/33326065/unable-to-access-mysql-after-it-automatically-generated-a-temporary-password/33332443 to download MySQL For Mac OS X 10.9 (x86, 64-bit), DMG Archive (works on 10.11, they recommended in the tutorial). While I were finishing installing the MySQL, I got the message saying that : 2015-10-25T02:10:54.549219Z 1 [Note] A temporary password is generated for root@localhost: R>gFySuiu23U If you lose this password, please consult the section How to Reset the Root Password in the MySQL reference manual. That was weird, I have never seen that kind of message. After that, I started MySQL via the Preference Pane and then use /usr/local/mysql/bin/mysql -v command on the terminal for another step. I got an error message saying that : ERROR 1045 (28000): Access denied for user 'cheetah'@'localhost' (using password: NO) I have also tried to access database through Sequel Pro using root as username and blank password, I got access denied message saying that : Unable to connect to host 127.0.0.1 because access was denied. Double-check your username and password and ensure that access from your current location is permitted. MySQL said: Access denied for user 'root'@'localhost' (using passwor
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Newbie :: Brand new http://forums.mysql.com/read.php?10,640045,640183 install of 5.7.10 on Mac OS X - ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) New Topic Advanced Search Re: http://superuser.com/questions/603026/mysql-how-to-fix-access-denied-for-user-rootlocalhost Brand new install of 5.7.10 on Mac OS X - ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Posted by: access denied Antonio De Marchi () Date: December 15, 2015 09:50AM Had the same problem with 5.7.9 and took me a long time to figure out the correct procedure to reset the 'root' password. Follow these instructions (taken with some minor corrections) from http://www.artfulsoftware.com/infotree/tip.php?id=784. Thanks to the author of access denied for artfulsoftware.com for this 1. In a terminal window stop MySQL (or use control panel) sudo /usr/local/mysql/support-files/mysql.server stop 2. Start the MySQL without privilege tables sudo mysqld_safe --skip-grant-tables 3. IN ANOTHER COMMAND WINDOW start the mysql client mysql 4. Find name of admin user (probably 'root'), update the password: select user,host,authentication_string from mysql.user; 5. reset authentication_string; for admin user 'root' (or whatever the name is). Note: you cannot create users when running with skip-grant-tables) update mysql.user set authentication_string=PASSWORD('new_pass') where user='root'; flush privileges; exit; 6. Stop mysqld, in another command window mysqladmin shutdown 7. Restart MySQL: sudo /usr/local/mysql/support-files/mysql.server start Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted Brand new install of 5.7.10 on Mac OS X - ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Chris Jenkins 12/11/2015 06:15AM Re: Brand new install of 5.7.10 on Mac OS X - ERROR 1045 (28000): Access denied for user 'root'@'localhost' (usin
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 Super User Questions Tags Users Badges Unanswered Ask Question _ 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 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 | | 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-accoun