moonbench.blogg.se

Access database for a mac
Access database for a mac




  1. #Access database for a mac mac os x
  2. #Access database for a mac mac os

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!).
  • access database for a mac

  • 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".
  • 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.

    access database for a mac

    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.

    #Access database for a mac 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.

    #Access database for a mac mac os x

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






    Access database for a mac