![]() ![]() Optional: Adjust PHP's memory limit for scripts Or in Mamp Pro you can change the MySQL password under the "MySQL" tab. If you see an error pop up when you run the MAMP app that says "Error: 1045: Access denied for user (using password: YES) when trying to connect", this should fix it. If you don't change this you can have zombie mysqld's running after you thought you stopped the server.Īs above, replace -proot with -pyourpassword. Note that it's important not to have a space between -p and the password itself. If you have.įind -proot and replace just the root part with your new password. NOTE: You might not have the line above in your file. and change the last parameter to your new password. and change the value 'root' to your new password, retaining the quotes. /Applications/MAMP/bin/phpMyAdmin-X.X.X/.Open a text editor and change the password in the four following files:.Once you have entered that, the MySQL password is changed. It will ask for the current password after you hit enter. Applications/MAMP/Library/bin/mysqladmin -u root -p password ![]() Open the terminal and type the following: Use command line to change the password (as documented in the MAMP start page FAQ).Only the first is documented in the MAMP start page FAQ, but if you don't do the second then you get an error message when you try to access anything from the MAMP start page. When you are changing the default user/password from root/root, you need to do two things. If you're connected to the internet, this is a must. The default username/password for your MySQL install is now root/root! For security purposes, it's always best to change this. Applications/MAMP/tmp/mysql/mysql.sock Changing your password You can also use a GUI such as Sequel Pro, just remember to use this as your Socket: Under the "Structure" section, make sure CREATE, INDEX, and DROP are selected.Under the "Data" section, make sure SELECT, INSERT, UPDATE, and DELETE are selected.This will take you to the Global settings for this user. Next to your new User name, click the "Edit privileges" link.Click the small home icon under the phpMyAdmin logo in the left-hand column.Under the "Database-specific privileges" section, make sure the following check boxes are selected: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX.This creates the user and takes you to the "Edit Privileges" for this new user on the new database. Leave the default settings for the remaining sections.Leaving it as "Any host" will not allow Drupal to connect to your local database and you'll get an error. Fill out the "Login Information" form, making sure to change the "Host" field to "Local". ![]()
0 Comments
Leave a Reply. |