Mamp Got 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 of this site About Us Learn more about Stack Overflow the company Business Learn more about mamp reset mysql password hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges mamp access denied for user 'root'@'localhost' Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each
Mamp Phpmyadmin Access Denied
other. Join them; it only takes a minute: Sign up Reset MySQL root password to “default” - MAMP up vote 4 down vote favorite 4 I changed my root level password on phpMyAdmin. I was unsure where to enter
Mamp Mysql Default Password
the password itself, as it did not give me the option (login form). I wondered if it was the php.ini file but users with read privileges could read it if I placed the password in there. Now, the mysql doesn't run as I tried various online resources to fix the problem. If needs be I would delete mamp and re-install but I do not want to lose my database files. Ideally I would revert the password to default, mamp change phpmyadmin password which I believe was nothing, except now I cannot connect to phpmyadmin, or the mamp start page: Error: Could not connect to MySQL server! Any help would be great. UPDATE - Error message from mamp: /Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect mysql phpmyadmin terminal mamp share|improve this question edited Apr 15 '13 at 15:10 asked Apr 15 '13 at 14:46 m33bo 4911413 add a comment| 3 Answers 3 active oldest votes up vote 11 down vote accepted This seemed to have fixed it when using terminal to reset the password: /Applications/MAMP/Library/bin/mysqladmin -u root -p password newpassword Found on mamp faq. share|improve this answer answered Apr 15 '13 at 15:52 m33bo 4911413 add a comment| up vote 1 down vote Look in the files: checkMysql.sh quickCheckMysqlUpgrade.sh repairMysql.sh stopMysql.sh The important one in this case is "quickCheckMysqlUpgrade.sh". All the files are located in the /Applications/MAMP/bin/ directory. In these files you'll find something like # /bin/sh /Applications/MAMP/Library/bin/mysqlcheck --quick --check-upgrade -u root -proot --socket=/Applications/MAMP/tmp/mysql/mysql.sock mysql When you see -proot that is the password MAMP will try to use, -p{password}. -p means "password" and whatever comes after is the password. So change "-proot" to eg. "-pmysecret" or whatever your password is. share|improve this answer answered Oct 1 '14 at 12:54 Christoffer 8112 add a comment| up vote 0 down vote I was being annoyed by th
that make connections all over the world. Join today Community Community Home Getting Involved Chat Forum SupportPost installation Problems with MAMP Posted by Bsmithwbtv on
Mamp Phpmyadmin Config
March 5, 2012 at 11:25pm Hello So I've had this problem mamp cannot connect: invalid settings. for quite awhile now (/Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying phpmyadmin tried to connect to the mysql server and the server rejected the connection. mamp to connect). I'm trying to start up my website & can't start until I access my Mysql files in MAMP. I've tried going into index.php & changing the proot password http://stackoverflow.com/questions/16018201/reset-mysql-root-password-to-default-mamp although I don't think I'm doing that right? please help!! Log in or register to post comments ⋅ Categories: Drupal 7.x Comments MAMP mcfilms commented March 6, 2012 at 5:45pm You will need to use the Terminal App and follow the directions at:http://canuckamerica.blogspot.com/2008/01/reseting-your-mysql-password-i... A list of some of the Drupal sites I have designed and/or developed can be viewed at https://www.drupal.org/node/1469542 motioncity.com Log in or register to post comments Unfortunately this doesn't Bsmithwbtv commented March 6, 2012 at 10:06pm Unfortunately this doesn't work either, accessing my terminal just gives me an error report the same as if im trying to log on in MAMP Log in or register to post comments , mcfilms commented March 6, 2012 at 10:50pm Do you just have a red dot next to MySql? Maybe try this: http://twob.net/journal/fix-for-mamp-mysql/ I notice that MAMP and MySql error out a lot more on my laptop. If this is not the case and it is truly just the root password, I think you will have to google around about resetting the password. A list of some of the Drupal sites I have designed and/or developed can be viewed at motioncity.com Log in or register to post comments No red dots both are green, I Bsmithwbtv commented March 6, 2012 at 11:55pm No red dots both are green, I think it's the root password to, but I've changed the password from root to another, I changed it ba
you familiar with MAMP will no doubt know that MAMP's MySQL root user password is set to root by default and changing it is not as straightforward as it http://www.tech-otaku.com/local-server/resetting-mamp-mysql-root-user-password/ perhaps should be.I've previously described a way of successfully changing the root user password providing, of course, that you know the current password. If you've forgotten it, this method will not https://www.ostraining.com/blog/coding/error-1045-phpmyadmin/ work and a way of re-setting the password is required.I'll be using the Terminal to reset the root password, but first we need to ensure that MAMP's MySQL server is not running.If access denied MAMP is running and the Stop Servers when quitting MAMP option is checked then quitting MAMP will suffice. MAMP's Start/Stop OptionsIf not, click the Stop Servers button. Stop MAMP's Apache and MySQL ServersNext, start MAMP's MySQL server from the Terminal with the --skip-grant-tables option. As this option allows anyone to connect without a password and and with all privileges — albeit temporarily — the mamp got error --skip-networking option is included to prevent remote access.Copy and paste the following command into a Terminal window 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 & When Terminal displays the following message, press enter again to return to the Terminal prompt. mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql At the prompt type the following command to access the MySQL command line: /Applications/MAMP/Library/bin/mysql You should see the MySQL command line prompt: mysql>Type the following, replacing NewPassword with the password of your choice: UPDATE mysql.user SET Password=PASSWORD('NewPassword') WHERE User='root'; Press enter, then type: FLUSH PRIVILEGES; Press enter. Then, to quit the MySQL command line type: \q You should be returned to the Terminal prompt. Type the following command to shutdown MAMP's MySQL server. You'll be prompted for the new root password when you press enter. /Applications/MAMP/Library/bin/mysqladmin --socket=/Applications/MAMP/tmp/mysql/mysql.sock shutdown -u root -p Having reset the root user password you should follow the instructions here regarding updating the necessary files in MAMP with the new password.These instructions were adapted from the official MySQL documentation. About the AuthorA native Brit exiled in Japan, Steve spends too much of his time struggling
phpMyAdmin, you could possibly encounter the error: #1045 Access Denied for user 'root'@'localhost' (using password: YES).If root@localhost wasn't granted the necessary rights to access the database or you provided the wrong password, you will then encounter this error.Following this tutorial will help guide you on bypassing this error, for any local host server using phpMyAdmin.If you get an Error #1045 in phpMyAdmin it will look like the image below:Step 1: Open your MySQL console. Using WAMP, left click your WAMP icon located at the bottom right of your desktop and click on MySQL Console. Guide to accessing MySQL using XAMPP Guide to accessing MySQL using MAMP. Step 2: Enter the Provided Command LinesIf you have a password, you can ignore this part. Type in: use mysql; Press Enter. Set your MySQL Password: UPDATE mysql.user SET Password=PASSWORD("EnterYourPasswordHere") WHERE User="root"; Replace "EnterYourPasswordHere" with your new chosen password. Press Enter. Flush the privileges: FLUSH PRIVILEGES; Exit by typing: Exit Press Enter. Step 3: Open and edit your config.inc.php file located in your local server files Using a text editor, such as Notepad++, open your config.inc.php file. Go to My Computer > C Drive > (Your Local Server Folder, WAMP/MAMP/XAMPP) > APPS > PHPMYADMIN > config.inc.php Find this line of code: $cfg['Servers'][$i]['password'] = ''; // MySQL password Change 'password' to the new chosen password you created from Step 2. Click Save. Step 4: Access phpMyAdmin You can access phpMyAdmin by going to http://localhost/phpMyAdmin/. Congratulations! You are now able to access your databases. View the discussion thread. blog comments powered by DISQUS back to top Blog Categories WordPress TutorialsDrupal TutorialsJoomla TutorialsCoding TutorialsOSTraining NewsWeb Design TutorialsBlog LicenseAll our blog posts are published under the Creative CommonsAttribution-NonCommercial license: You can re-use these tutorials. You can modify these tutorials. You must link back to our original tutorial. You can't use these tutorials commercially. Full license details.Our Training Video Training Books On-Site Trainin