MYSQL NOT STARTING MAMP PRO

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.

MYSQL NOT STARTING MAMP INSTALL

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!).Under the 'Create database' section, enter a name for your Drupal database in the 'Database name' field.On the phpMyAdmin page, click the 'Databases' tab.Under 'Tools', click the link to 'phpMyAdmin'.

MYSQL NOT STARTING MAMP DOWNLOAD

It is generally best to download and unzip Drupal directly in the document root (default is htdocs) so you don't miss the. htaccess file which is necessary for clean URLs to work. Note: if you use Finder you may miss moving the. Where yourdrupaldir is whatever you want the directory to be called. Mv drupal-x.x.x/* drupal-x.x.x/.htaccess /Applications/MAMP/htdocs/yourdrupaldir Move the directory containing the Drupal files into the MAMP htdocs directory: Open MAMP and click 'start servers,' then 'Open start page.' Download Drupal (This will install Apache, MySQL, and PHP in one step.)ĭownload and proceed through the installer to install MAMP.

MYSQL NOT STARTING MAMP MAC OS

This page is to be used in conjunction with the installation instructions for Drupal on Mac OS X.Īlso you may want to check out this video in the Videocasts section of the handbook: Installing a Local Web Server on Mac OS X. This will make Drupal much easier to install because the components don't have to be installed separately.

MYSQL NOT STARTING MAMP MAC OS X

MAMP creates a local server environment on Mac OS X by installing PHP, MySQL, and Apache right out of the box.

Mysql not starting mamp