Mamp 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 of this site About mamp reset mysql password Us Learn more about Stack Overflow the company Business Learn more about hiring developers mamp access denied for user 'root'@'localhost' (using password: yes) or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack
Mamp Phpmyadmin Access Denied
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: Sign up Reset MySQL root password to “default” -
Access Denied For User 'root'@'localhost' (using Password: No) Mamp
MAMP up vote 4 down vote favorite 4 I changed my root level password on phpMyAdmin. I was unsure where to enter 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 mamp mysql default password 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, 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/Li
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings
Mamp Change Phpmyadmin Password
and policies of this site About Us Learn more about Stack mamp phpmyadmin config Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs mamp cannot connect: invalid settings. 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. Join them; http://stackoverflow.com/questions/16018201/reset-mysql-root-password-to-default-mamp 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 on it. So far I've been able to get it installed but I cannot get my root user access (or any user http://stackoverflow.com/questions/13480170/access-denied-for-mysql-error-1045 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 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 Ope
problem is that every time I launch MAMP PRO and start the servers, when the MySQL server attempts to start I get this message… Error message: /Applications/MAMP/Library/bin/mysqlcheck: https://css-tricks.com/forums/topic/major-problem-mampmysql-help/ Got error: 1045: Access denied for user ‘root'@'localhost' (using password: YES) when trying to connect Then I try out of curiosity the webstart button to attempt to open the MAMP start page… and I http://www.nyayapati.com/srao/2011/03/mamp-mysqlcheck-got-error-1045/ get this error Error: Could not connect to MySQL server! Finally I use the "Launch PhpMyAdmin Button".. and I get this error Error MySQL said: #1045 - Access denied for user ‘root'@'localhost' (using password: access denied YES) Unknown language: en-iso-8859-1. phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server. This all seems to have happened when I stupidly tried to create a new user in PHP myadmin and I think I have access denied for entirely messed up the "root" account - However with this kind of topic this is as far as my knowledge goes… I am baffled.. How can I restore everything to normal so that I can access the MAMP start page, phpmyadmin etc ??? Ive tried completely uninstalling MAMP/MAMP PRO, nothing.. I've looked high and low on Google and all I can find are pages of words that are double dutch to me… I dont understand what the problem is basically. This will probably sound really stupid to alot of you but I really do not know what to do here I would just like MAMP PRO to work again.. when ive tried to read all of these "fixes" they talk about the root account, but since i edited the root account in phpmyadmin - what account are they talking about, a database account, the root account of the computer itself?? I really don't even care enough to know all I want is it to work again … im SO confused.. Can someone please explain to me in laymens terms whats happened here and how I can fix it? I would be so greatful… Alen # April 17, 2013 at 9:49 pm You will
This began after I changed the root password for my MAMP installation on my MBP. /Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect It turns out that the default password is hard coded in different scripts under ‘/Applications/MAMP/bin'. In my case the script quickCheckMysqlUpgrade.sh. Just edit the script to have the correct password and you wont see the annoying messageagain. Posted by srini Mon 28 March 2011 php Tweet Comments Please enable JavaScript to view the comments powered by Disqus. Srinivas Nyayapati I am a technologist at heart. This blog covers my two biggest passions.. Technology and food. It's the place I collect my thoughts, work and findings. Categories misc (6) recipes (54) restaurants (12) software (91) Recent Posts How to install MongoDB on a Mac Pindi Chole sambar Bellam Menthikai Coconut Chutney Tags ant, autosys, bash, blogger, boston, chicken, cli, csh, cygwin, django, eclipse, enthought, epd, event, events, family-recipes, find, flask, food, food chicken, ftp, games, github, goat, growl, India, iphone, ipod, itunes, Java, lamb, linux, m2ts, mac, macosx, mkv, mongodb, mpeg, music, mutton, nginx, nihari, oracle, pasta, pdf, pelican, php, plugin, python, qmail, Ramen, ramen food, saag, salmon, script, spam, spinach, sqlserver, struts, tar, tech, tips, tomcat, travel, travis-ci, unix, vi, videos, vim, virus, vmware, windows, Wordpress, xbmc, xbox Follow @shireenrao Copyright © 2004-2016 - Srini - Powered by Pelican