Mamp Error 1045 Access Denied For User
Contents |
back/reset. Was working through the Bootstrap to Wordpress project, and had everything up and running, until I changed the password of the database. The password and user were both mamp reset mysql password set to 'root' as in the video, before I edited everything. When I
Access Denied For User 'root'@'localhost' Mamp
click on phpMyAdmin from the MAMP start page I get the following error: 1045 - Access denied for user 'root'@'localhost' (using
Mamp Mysql Default Password
password: YES) I've checked google/you tube/stack overflow and can't find a solution which I understand. When I go to localhost in a browser, I can still access and edit the localwp site I set
Mamp Change Phpmyadmin Password
up from the Local Wordpress Development project. When I click on my bootstrap_to_wp folder in the directory it displays 'error establishing a database connection'. Is there a way to undo my actions? 15 Answers PRO Chris Pauciello Pro Student 26,598 Points Chris Pauciello Chris Pauciello Pro Student 26,598 Points over 2 years ago To shutdown MAMP's MySQL server from the terminal you unfortunately need to use the root user/password mamp phpmyadmin config /Applications/MAMP/Library/bin/mysqladmin -u root -p shutdown Without that, it yells at you. $ /Applications/MAMP/Library/bin/mysqladmin shutdown /Applications/MAMP/Library/bin/mysqladmin: shutdown failed; error: 'Access denied; you need (at least one of) the SHUTDOWN privilege(s) for this operation Instead just go ahead and click the 'stop servers' button in MAMP. or If you have the 'Stop Servers when Quitting MAMP' selected under preferences, you can just go ahead and quit MAMP to stop it. With the MAMP servers stopped, you can start the MySQL server from the terminal using the MySQL Server Startup Script with the options --skip-networking-tables for unrestricted access to all of the databases and --skip-networking to stop remote access. Copy and paste the following into the terminal and press enter. /Applications/MAMP/Library/bin/mysqld_safe --skip-grant-tables --skip-networking --socket=/Applications/MAMP/tmp/mysql/mysql.sock --lower_case_table_names=0 --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid & Something similar to the following should pop up in your terminal, press enter when it does to get back to the command prompt. YourUsername at YourComputer in ~ $ 140529 01:36:32 mysqld_safe Logging to '/Applications/MAMP/db/mysql/nopenopenope.err'. 140529 01:36:32 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql You should now be able to access the MySQL client from the terminal by entering the following. /Applications/MAMP/Library/bin/mysql You should see a welcome message, and the command prompt replaced with the MySQL Command Prompt 'mysql>', l
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 mamp cannot connect: invalid settings. posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss phpmyadmin tried to connect to the mysql server and the server rejected the connection. mamp 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 mamp change mysql password windows takes a minute: Sign up #1045 - Access denied for user 'root'@'localhost' (using password: YES) MAMP MySQL access denied up vote 0 down vote favorite I'm trying to copy a live WordPress site to my local server. I went to https://teamtreehouse.com/community/mamp-phpmyadmin-error-1045-after-i-changed-my-root-password-not-sure-how-to-change-it-backreset import the database from the live site through MAMP, and I received an error message when trying to connect to phpMyAdmin: #1045 - Access denied for user 'root'@'localhost' (using password: YES) I have a couple local WP installations running already, and I'm able to access them through the localhost:8888/sitename path just fine. I haven't changed any passwords or messed around with any configurations in phpMyAdmin. In fact, it was all working fine just yesterday. I had to re-boot my computer because http://stackoverflow.com/questions/36192071/1045-access-denied-for-user-rootlocalhost-using-password-yes-mamp-mys it froze on me this morning, and that's when the issues began. I even went into the config.inc.php file in Applications/MAMP/phpMyAdmin, and the usernames and passwords match what I had originally. (It definitely wasn't 'YES') I'm stumped at this point. Could anyone help? mysql wordpress phpmyadmin mamp mysql-error-1045 share|improve this question asked Mar 24 at 2:08 bibliofille 13 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Can you try resetting the MySQL server password using this guide. Then put the new password in the PHPMyAdmin config? using password: YES Means that you attempted to login using a password, not that the password used is 'YES' Its referring to the different options for logins like certificates etc. share|improve this answer answered Mar 24 at 2:15 Nick 706211 Would I use the generic instructions from the MySQL guide you sent? I'm using OSX. –bibliofille Mar 24 at 2:25 Yes, MAMP still is just a plain old MySQL server behind the scenes, Does anything else connect to this database using the root account? because if you reset it keep in mind you will need to update the password in any other configs that connect to this database. But from what you describe it sounds like a fresh install. –Nick Mar 24 at 2:32 Hmm. I got the following error when entering "--skip-grant-tables" into terminal: -bash: --skip-grant-tables: command not found –bibliofille
recently changed my local testing server environment from XAMPP to MAMP v2.0.5 I wanted to change http://www.tech-otaku.com/local-server/changing-mysql-root-user-password-mamp/ the password for the MySQL root user. By default it's set to root.Changing the MySQL password for the root user was straightforward enough, but locating and editing the files to reflect the new password was a different story. Failure to update all the necessary files results in MAMP reporting the following error:/Applications/MAMP/Library/bin/mysqlcheck: Got error: access denied 1045: Access denied for user ‘root'@'localhost' (using password: YES) when trying to connectInformation on MAMP's own site appeared incomplete and other documentation I found — while helpful — was for versions of MAMP prior to version 2.These instructions are for changing a known password for the root user. If you've forgotten it please refer access denied for to Resetting MAMP’s MySQL Root User Password.These instructions are for the free version of MAMP not MAMP Pro. They are applicable to both MAMP v2.x and v3.x but be aware of the slight difference in the changes required.For MAMP versions 2.x and 3.xTo change the MySQL password for root ensure that MAMP's MySQL server is running then open Terminal and type the following, replacing NEWPASSWORD with the password of your choice: /Applications/MAMP/Library/bin/mysqladmin -u root -p password NEWPASSWORD You'll be prompted for the current root password: Enter password:CURRENTPASSWORD Next, all the occurrences of the old password root need to be changed to the new password NEWPASSWORD in the following files. For files marked * an easy way to locate the old password is to search for the string -proot where -p is the password option and root is the old password.File: /Applications/MAMP/bin/checkMysql.sh * # /bin/sh /Applications/MAMP/Library/bin/mysqlcheck --all-databases --check --check-upgrade -u root -pNEWPASSWORD --socket=/Applications/MAMP/tmp/mysql/mysql.sock File: /Applications/MAMP/bin/quickCheckMysqlUpgrade.sh * # /bin/