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".Under the "New" section, click on "Add user account".Look on the left-hand column under the phpMyAdmin logo and make sure that your new database is selected.Select "utf8_general_ci" from the "Collation" drop-down (must be utf8!).
0 Comments
Leave a Reply. |