Bitnami Drupal Installer

NOTE: Before running the commands shown on this page, you should load the Bitnami stack environment by executing the installdir/use_APPNAME script (Linux and Mac OS X) or by clicking the shortcut in the Start Menu under "Start -> Bitnami APPNAME Stack -> Application console" (Windows). Learn more.
NOTE: When running the commands shown on this page, replace the installdir placeholder with the full installation directory for your Bitnami stack.

Description

Drupal is a popular open source Content Management Systems (CMS.) Its modular architecture makes it flexible enough to securely and reliably create a wide variety of websites and applications.

First steps with the Bitnami Drupal Stack

Welcome to your new Bitnami application! Here are a few questions (and answers!) you might need when first starting with your application.

What are the system requirements?

Before you download and install your application, check that your system meets these requirements.

How do I install the Bitnami Drupal Stack?

Windows, OS X and Linux installer
  • Download the executable file for the Bitnami Drupal Stack from the Bitnami website.

  • Run the downloaded file:

    • On Linux, give the installer executable permissions and run the installation file in the console.
    • On other platforms, double-click the installer and follow the instructions shown.

Check the FAQ instructions on how to download and install a Bitnami Stack for more details.

The application will be installed to the following default directories:

Operating System Directory
Windows C:\Bitnami\APPNAME-VERSION
Mac OS X /Applications/APPNAME-VERSION
Linux /opt/APPNAME-VERSION (running as root user)
OS X VM
  • Download the OS X VM file for the Bitnami Drupal Stack from the Bitnami website.
  • Begin the installation process by double-clicking the image file and dragging the WordPress OS X VM icon to the Applications folder.
  • Launch the VM by double-clicking the icon in the Applications folder.

What credentials do I need?

You need application credentials, consisting of a username and password. These credentials allow you to log in to your new Bitnami application.

What is the administrator username set for me to log in to the application for the first time?

  • For Windows, Linux and OS X installers, the username was configured by you when you first installed the application.
  • For OS X VMs, the username can be obtained by clicking the Bitnami badge at the bottom right corner of the application welcome page.

What is the administrator password?

  • For Windows, Linux and OS X installers, the password was configured by you when you first installed the application.
  • For OS X VMs, the password can be obtained by clicking the Bitnami badge at the bottom right corner of the application welcome page.

How to start or stop the services?

Linux

Bitnami native installers include a graphical tool to manage services. This tool is named manager-linux-x64.run on Linux and is located in the installation directory. To use this tool, double-click the file and then use the graphical interface to start, stop or restart services. Server log messages can be checked in the "Server Events" tab.

Management tool

The native installer also includes a command-line script to start, stop and restart applications, named ctlscript.sh. This script can be found in the installation directory and accepts the options start, stop, restart, and status. To use it, log in to the server console and execute it following the examples below:

  • Call it without any service names to start all services:

      $ sudo installdir/ctlscript.sh start
    
  • Use it to restart a specific service only by passing the service name as argument - for example, mysql, postgresql or apache:

      $ sudo installdir/ctlscript.sh restart mysql
      $ sudo installdir/ctlscript.sh restart postgresql
      $ sudo installdir/ctlscript.sh restart apache
    
  • Obtain current status of all services:

      $ installdir/ctlscript.sh status
    

The list of available services varies depending on the required components for each application.

Mac OS X

Bitnami native installers include a graphical tool to manage services. This tool is named manager-osx on Mac OS X and is located in the installation directory. To use this tool, double-click the file and then use the graphical interface to start, stop or restart services. Server log messages can be checked in the "Server Events" tab.

Management tool

The native installer also includes a command-line script to start, stop and restart applications, named ctlscript.sh. This script can be found in the installation directory and accepts the options start, stop, restart, and status. To use it, log in to the server console and execute it following the examples below:

  • Call it without any service names to start all services:

    $ sudo installdir/ctlscript.sh start
    
  • Use it to restart a specific service only by passing the service name as argument - for example, mysql or apache:

     $ sudo installdir/ctlscript.sh restart mysql
     $ sudo installdir/ctlscript.sh restart apache
    
  • Obtain current status of all services:

     $ installdir/ctlscript.sh status
    

The list of available services varies depending on the required components for each application.

NOTE: If you are using the stack manager for Mac OS X-VM, please check the following blog post to learn how to manage services from its graphical tool.

Windows

Bitnami native installers include a graphical tool to manage services. This tool is named manager-windows.exe on Windows and is located in the installation directory. To use this tool, double-click the file and then use the graphical interface to start, stop or restart services. Server log messages can be checked in the "Server Events" tab.

Management tool

The Windows native installer creates shortcuts to start and stop services created in the Start Menu, under "Programs -> Bitnami APPNAME Stack -> Bitnami Service". Servers can also be managed from the Windows "Services" control panel. Services are named using the format APPNAMESERVICENAME, where APPNAME is a placeholder for the application name and SERVICENAME is a placeholder for the service name. For example, the native installer for the Bitnami WordPress Stack installs services named wordpressApache and wordpressMySQL.

These services will be automatically started during boot. To modify this behaviour, refer to the section on disabling services on Windows.

How to change the interface language?

Drupal 7

Bitnami Drupal has already installed English and Spanish translations currently and we will work on adding more languages. Change the Drupal language from the administration interface as follows:

  • Configuration -> Modules -> Enable Locale module.
  • Configuration -> Languages -> Add a Language.
  • Choose your language.

Drupal 8

Change the Drupal language from the administration interface as follows:

  • Under the "Extend" tab, find the "Multilingual" section and enable the following modules:

    • Configuration Translation
    • Content Translation
    • Interface Translation
    • Language

Enabling translation modules

  • Click "Install" to install the modules.

  • Under the "Configuration" tab, select the "Regional and Language -> Languages" section.

Selecting Languages options

  • Click the "Add language" button.

Add new language

  • Select the language to be added from the selection list and click the "Add language" button.

    Once the language has been imported, you can use it by selecting it as the default language in the "Regional and Language -> Languages" section.

Select new language as default

How to access the administration panel?

Access the administration panel by browsing to http://localhost/user/login.

How to configure outbound email settings?

Drupal 7 and earlier

Install and configure the SMTP Authentication Support module for Drupal 7, as follows:

  • Download the SMTP Authentication Support module for Drupal to your Drupal installation's sites/all/modules directory and extract. Previous Drupal versions have the module already installed in the modules/ directory.

  • The PHPMailer package is included in Drupal 7. For older versions, follow these additional steps:

    • Create a phpmailer/ directory in the new sites/all/modules/smtp directory.

    • Download the PHPmailer package from Github and extract it to the sites/all/modules/smtp/phpmailer directory.

  • Log in to the Drupal 7 administration panel.

  • Go to the "Administer -> Site Building -> Modules" section and enable "SMTP Authentication Support".

  • Now go to the "Administer by Module" tab, scroll down to the "SMTP Authentication Support" section and click the "SMTP Authentication Support" option.

  • Enter the following configuration options. For example, if using a Gmail account, replace USERNAME and PASSWORD with your Gmail account username and password respectively.

     SMTP Server - smtp.gmail.com
     SMTP backup server - leave blank
     SMTP port - 465
     Use encrypted protocol - Use SSL
     Username - USERNAME@gmail.com
     Password - PASSWORD
     Email from address - USERNAME@gmail.com
     E-mail from name - the name you want emails to appear to be from (e.g. 'Yourdomain Support' or your real name)
    
  • Send a test email.

Drupal 8

Install and configure the SMTP Authentication Support module for Drupal 8, as follows:

  • Download the SMTP Authentication Support module for Drupal to your Drupal installation's modules directory and unzip.

  • Log in to the Drupal 8 administration panel.

  • Navigate to the "Extend" tab and enable "SMTP Authentication Support".

  • Navigate "Configuration" tab, scroll down to the "SMTP Authentication Support" section and select it.

  • On the resulting page, turn the module "On" and enter the SMTP configuration options. For example, if using a Gmail account, replace USERNAME and PASSWORD with your Gmail account username and password respectively.

     SMTP Server - smtp.gmail.com
     SMTP backup server - leave blank
     SMTP port - 465
     Use encrypted protocol - Use SSL
     Username - USERNAME@gmail.com
     Password - PASSWORD
     Email from address - USERNAME@gmail.com
     E-mail from name - the name you want emails to appear to be from (e.g. 'Yourdomain Support' or your real name)
    
  • Enter a test email address.

  • Click "Save configuration" to save your changes and send a test email.

To configure the application to use other third-party SMTP services for outgoing email, such as SendGrid or Mandrill, refer to the FAQ.

NOTE: If you are using Gmail as the outbound email server and have experienced issues trying to send emails correctly, check the How to troubleshoot Gmail SMTP issues to learn the causes of these issues and how to solve them.

How to install a module on Drupal?

Drupal 7

To install a module in Drupal 7, copy and uncompress it in the installdir/apps/drupal/htdocs/modules folder. Then, enable the module in the "Modules" section of the Drupal administration panel.

Drupal 8

To install a module in Drupal 8, follow these steps:

  • Locate and filter the module you want to install. Find a list of available modules at the Drupal module directory.

  • Download it to your local computer.

  • Use the filter options in order to find the module. Once you find it, click on the module name to see the details. Select the version and the file format. Here's an example.

Download new module from Drupal module directory

  • Visit your site and log into your Drupal 8 admin interface. In the Administration menu navigate to the "Extend" tab. Click the "+Install new module" button.

Install new module

  • Browse to the downloaded file and select it. Click the "Install" button to complete the installation.

Select new module

  • Once the installation is complete a popup window shows a confirmation message:

New module is installed

  • Return to the modules list in the "Extend" page and locate your module. Enable it and click the "Install" button.

Enable new module

How to install and configure the Auth0 module?

NOTE: The steps below assume that you have an Auth0 account. If not, register for a free Auth0 account.

First, create a new Auth0 application as follows:

  • Log in to the Auth0 website and navigate to the "Clients" menu. Click the "Create client" button and choose "Regular Web Application" as the client type.

Create client

  • Browse to the "Settings" tab for the application in the Auth0 dashboard and note the domain, client ID and client secret.

Client credentials

  • In the same "Settings" tab, update the "Allowed Callback URLs" field and set it to the value http://DRUPAL_SITE_ADDRESS/auth0/callback. Replace the DRUPAL_SITE_ADDRESS placeholder with the actual IP address of your Drupal host. Save the changes.

Client callback

Next, install and configure the Auth0 module in your Drupal host as follows:

  • Log in to the server console, change to the application directory and update Composer:

     $ cd installdir/apps/drupal/htdocs/
     $ sudo composer self-update
    
  • Install the Auth0 module and its dependencies with Composer:

     $ composer require auth0/auth0_drupal:^2.0.0
    
  • Log in to the Drupal administration panel as an administrator.

  • From the "Extend" menu, select the Auth0 plugin, which should appear in the list of available plugins. Install the plugin by clicking the "Install" button.

Module installation

  • From the "Configuration -> System" menu, select the Auth0 plugin and configure it with the domain, client ID and client secret obtained from the Auth0 website. Click "Save" to save the changes.

Module configuration

  • Log out of the Drupal administration panel.

You should now be able to log in to Drupal using Auth0 user credentials. The Drupal login page should also change to reflect Auth0 as a login option.

Drupal Auth0 login

How to create a full backup of Drupal?

The Bitnami Drupal Stack is self-contained and the simplest option for performing a backup is to copy or compress the Bitnami stack installation directory. To do so in a safe manner, you will need to stop all servers, so this method may not be appropriate if you have people accessing the application continuously.

NOTE: If you want to create only a database backup, refer to these instructions for MySQL and PostgreSQL.

Backup on Linux and Mac OS X

Follow these steps:

  • Change to the directory in which you wish to save your backup.

     $ cd /your/directory
    
  • Stop all servers.

     $ sudo installdir/ctlscript.sh stop
    
  • Create a compressed file with the stack contents.

     $ sudo tar -pczvf application-backup.tar.gz installdir
    
  • Start all servers.

     $ sudo installdir/ctlscript.sh start
    
  • Download or transfer the application-backup.tar.gz file to a safe location.

You should now download or transfer the application-backup.tar.gz file to a safe location.

Backup on Windows

Follow these steps:

  • Stop all servers using the shortcuts in the Start Menu or the graphical manager tool.

  • Create a compressed file with the stack contents. You can use a graphical tool like 7-Zip or WinZip or just right-click the folder, click "Send to", and select the "Compressed (zipped) folder" option.

  • Download or transfer the compressed file to a safe location.

  • Start all servers using the shortcuts in the Start Menu or the graphical manager tool.

Restore on Linux and Mac OS X

Follow these steps:

  • Change to the directory containing your backup:

    $ cd /your/directory
    
  • Stop all servers.

    $ sudo installdir/ctlscript.sh stop
    
  • Move the current stack to a different location:

    $ sudo mv installdir /tmp/bitnami-backup
    
  • Uncompress the backup file to the original directory:

    $ sudo tar -pxzvf application-backup.tar.gz -C /
    
  • Start all servers.

    $ sudo installdir/ctlscript.sh start
    
IMPORTANT: When restoring, remember to maintain the original permissions for the files and folders. For example, if you originally installed the stack as the root user on Linux, make sure that the restored files are owned by root as well.

Restore on Windows

  • Change to the directory containing your backup:

       $ cd /your/directory
    
  • Stop all servers using the shortcuts in the Start Menu or the graphical manager tool.

  • Uninstall the previous services by executing the following command:

        $ serviceinstall.bat
    
  • Create a safe folder named Backups in the desktop and move the current stack to it. Remember to replace PATH with the right location of your folder:

        $ move installdir \PATH\Backups
    
  • Uncompress the backup file using a tool like 7-Zip or Winzip or just double-click the .zip file to uncompress it, and move it to the original directory.
  • Install services by running the following commands from an elevated command prompt:

      $ cd installdir
      $ serviceinstall.bat INSTALL
    
  • Start all servers using the shortcuts in the Start Menu or the graphical manager tool.

How to upgrade Drupal?

Drupal 7

It is advisable to create a backup before starting the update process. If you have important data, create and try to restore a backup to ensure that everything works properly.

Upgrade using Drush

You can upgrade the application only without modifying any other stack components. Starting with Drupal v7.12-3, the Bitnami Drupal Stack ships drush, a command-line shell and scripting interface for Drupal. To upgrade Drupal with drush, use the following commands:

$ cd installdir/apps/drupal/htdocs/
$ drush update

More information is available on the Drush website.

Upgrade using built-in tools

To upgrade Drupal without drush, use Drupal's built-in mechanism for upgrades by following the steps below:

  • Log in to the Drupal administration panel.

  • Browse to the "Administration -> Configuration -> Development -> Maintenance mode" section. Enable the "Put site into maintenance mode" checkbox and save the configuration.

  • At the server console, download the new Drupal version:

    $ wget http://ftp.drupal.org/files/projects/drupal-X.Y.tar.gz
    $ tar -xzvf drupal-X.Y.tar.gz
    
  • Create a backup of the .htaccess and settings.php files:

    $ cp installdir/apps/drupal/htdocs/.htaccess /home/bitnami/.htaccess.backup
    $ cp installdir/apps/drupal/htdocs/sites/default/settings.php /home/bitnami/settings.php.backup
    
  • Overwrite the old Drupal installation with the new files:

    $ sudo cp -R drupal-X.Y/* installdir/apps/drupal/htdocs/
    
  • In case your older installation used custom .htaccess or settings.php files, restore them from backup.

  • In the Drupal administration panel, browse to the "Report -> Status" section and run the database update script if necessary.

    Drupal upgrade

  • Browse to the "Administration -> Configuration -> Development -> Maintenance mode" section and disable maintenance mode.

Drupal 8

Upgrade using Drush

You can update Drupal core with a minor version change using drush a command-line shell and scripting interface for Drupal that is already included in Bitnami Drupal Stack. To upgrade Drupal with drush, follow the steps below:

  • Log in to the Drupal administration panel.

  • Browse to the "Administration -> Configuration -> Development -> Maintenance mode" section. Enable the "Put site into maintenance mode" checkbox and save the configuration:

Drupal Maintenance mode

Enable the Maintenance mode

  • Create a backup of the .htaccess, settings.php and robots.txt files:

      $ cp installdir/apps/drupal/htdocs/.htaccess /home/bitnami/.htaccess.backup
      $ cp installdir/apps/drupal/htdocs//sites/default/settings.php /home/bitnami/settings.php.backup
      $ cp installdir/apps/drupal/htdocs//robots.txt /home/bitnami/robots.txt.backup
    
  • Change your working directory to the Drupal application:

      $ cd installdir/apps/drupal/htdocs/
    
  • Upgrade the application using drush updating command:

      $ drush pm-update
    
  • In the Drupal administration panel navigate to the "Report -> Status" section to check that your site has been successfully updated.

Drupal Report Status: successful update

  • You can also check it in the "Report -> Available updates -> Update" section.

Drupal projects are up to date

  • Restore the backup of the .htaccess and robots.txt files:

      $ cp /home/bitnami/.htaccess.backup installdir/apps/drupal/htdocs/.htaccess
      $ cp /home/bitnami/robots.txt.backup installdir/apps/drupal/htdocs/robots.txt
    
  • Browse to the "Administration -> Configuration -> Development -> Maintenance mode" section and disable maintenance mode.

How to create an SSL certificate?

OpenSSL is required to create an SSL certificate. A certificate request can then be sent to a certificate authority (CA) to get it signed into a certificate, or if you have your own certificate authority, you may sign it yourself, or you can use a self-signed certificate (because you just want a test certificate or because you are setting up your own CA).

Follow the steps below for your platform.

Linux and Mac OS X

NOTE: OpenSSL will typically already be installed on Linux and Mac OS X. If not installed, install it manually using your operating system's package manager.

Follow the steps below:

  • Generate a new private key:

     $ sudo openssl genrsa -out installdir/apache2/conf/server.key 2048
    
  • Create a certificate:

     $ sudo openssl req -new -key installdir/apache2/conf/server.key -out installdir/apache2/conf/cert.csr
    
    IMPORTANT: Enter the server domain name when the above command asks for the "Common Name".
  • Send cert.csr to the certificate authority. When the certificate authority completes their checks (and probably received payment from you), they will hand over your new certificate to you.

  • Until the certificate is received, create a temporary self-signed certificate:

     $ sudo openssl x509 -in installdir/apache2/conf/cert.csr -out installdir/apache2/conf/server.crt -req -signkey installdir/apache2/conf/server.key -days 365
    
  • Back up your private key in a safe location after generating a password-protected version as follows:

     $ sudo openssl rsa -des3 -in installdir/apache2/conf/server.key -out privkey.pem
    

    Note that if you use this encrypted key in the Apache configuration file, it will be necessary to enter the password manually every time Apache starts. Regenerate the key without password protection from this file as follows:

     $ sudo openssl rsa -in privkey.pem -out installdir/apache2/conf/server.key
    

Windows

NOTE: OpenSSL is not typically installed on Windows. Before following the steps below, download and install a binary distribution of OpenSSL.

Follow the steps below once OpenSSL is installed:

  • Set the OPENSSL_CONF environment variable to the location of your OpenSSL configuration file. Typically, this file is located in the bin/ subdirectory of your OpenSSL installation directory. Replace the OPENSSL-DIRECTORY placeholder in the command below with the correct location.

     $ set OPENSSL_CONF=C:\OPENSSL-DIRECTORY\bin\openssl.cfg
    
  • Change to the bin/ sub-directory of the OpenSSL installation directory. Replace the OPENSSL-DIRECTORY placeholder in the command below with the correct location.

     $ cd C:\OPENSSL-DIRECTORY\bin
    
  • Generate a new private key:

     $ openssl genrsa -out installdir/apache2/conf/server.key 2048
    
  • Create a certificate:

     $ openssl req -new -key installdir/apache2/conf/server.key -out installdir/apache2/conf/cert.csr
    
    IMPORTANT: Enter the server domain name when the above command asks for the "Common Name".
  • Send cert.csr to the certificate authority. When the certificate authority completes their checks (and probably received payment from you), they will hand over your new certificate to you.

  • Until the certificate is received, create a temporary self-signed certificate:

     $ openssl x509 -in installdir/apache2/conf/cert.csr -out installdir/apache2/conf/server.crt -req -signkey installdir/apache2/conf/server.key -days 365
    
  • Back up your private key in a safe location after generating a password-protected version as follows:

     $ openssl rsa -des3 -in installdir/apache2/conf/server.key -out privkey.pem
    

    Note that if you use this encrypted key in the Apache configuration file, it will be necessary to enter the password manually every time Apache starts. Regenerate the key without password protection from this file as follows:

     $ openssl rsa -in privkey.pem -out installdir/apache2/conf/server.key
    

Find more information about certificates at http://www.openssl.org.

How to enable HTTPS support with SSL certificates?

TIP: If you wish to use a Let's Encrypt certificate, you will find specific instructions for enabling HTTPS support with Let's Encrypt SSL certificates in our Let's Encrypt guide.
NOTE: The steps below assume that you are using a custom domain name and that you have already configured the custom domain name to point to your cloud server.

Bitnami images come with SSL support already pre-configured and with a dummy certificate in place. Although this dummy certificate is fine for testing and development purposes, you will usually want to use a valid SSL certificate for production use. You can either generate this on your own (explained here) or you can purchase one from a commercial certificate authority.

Once you obtain the certificate and certificate key files, you will need to update your server to use them. Follow these steps to activate SSL support:

  • Use the table below to identify the correct locations for your certificate and configuration files.

    Variable Value
    Current application URL https://[custom-domain]/
      Example: https://my-domain.com/ or https://my-domain.com/appname
    Apache configuration file installdir/apache2/conf/bitnami/bitnami.conf
    Certificate file installdir/apache2/conf/server.crt
    Certificate key file installdir/apache2/conf/server.key
    CA certificate bundle file (if present) installdir/apache2/conf/server-ca.crt
  • Copy your SSL certificate and certificate key file to the specified locations.

    NOTE: If you use different names for your certificate and key files, you should reconfigure the SSLCertificateFile and SSLCertificateKeyFile directives in the corresponding Apache configuration file to reflect the correct file names.
  • If your certificate authority has also provided you with a PEM-encoded Certificate Authority (CA) bundle, you must copy it to the correct location in the previous table. Then, modify the Apache configuration file to include the following line below the SSLCertificateKeyFile directive. Choose the correct directive based on your scenario and Apache version:

    Variable Value
    Apache configuration file installdir/apache2/conf/bitnami/bitnami.conf
    Directive to include (Apache v2.4.8+) SSLCACertificateFile "installdir/apache2/conf/server-ca.crt"
    Directive to include (Apache < v2.4.8) SSLCertificateChainFile "installdir/apache2/conf/server-ca.crt"
    NOTE: If you use a different name for your CA certificate bundle, you should reconfigure the SSLCertificateChainFile or SSLCACertificateFile directives in the corresponding Apache configuration file to reflect the correct file name.
  • Once you have copied all the server certificate files, you may make them readable by the root user only with the following commands:

     $ sudo chown root:root installdir/apache2/conf/server*
    
     $ sudo chmod 600 installdir/apache2/conf/server*
    
  • Open port 443 in the server firewall. Refer to the FAQ for more information.

  • Restart the Apache server.

You should now be able to access your application using an HTTPS URL.

How to force HTTPS redirection with Apache?

Add the following lines in the default Apache virtual host configuration file at installdir/apache2/conf/bitnami/bitnami.conf, inside the default VirtualHost directive, so that it looks like this:

<VirtualHost _default_:80>
  DocumentRoot "installdir/apache2/htdocs"
  RewriteEngine On
  RewriteCond %{HTTPS} !=on
  RewriteRule ^/(.*) https://%{SERVER_NAME}/$1 [R,L]
  ...
</VirtualHost>

After modifying the Apache configuration files:

  • Open port 443 in the server firewall. Refer to the FAQ for more information.

  • Restart Apache to apply the changes.

How to debug Apache errors?

Once Apache starts, it will create two log files at installdir/apache2/logs/access_log and installdir/apache2/logs/error_log respectively.

  • The access_log file is used to track client requests. When a client requests a document from the server, Apache records several parameters associated with the request in this file, such as: the IP address of the client, the document requested, the HTTP status code, and the current time.

  • The error_log file is used to record important events. This file includes error messages, startup messages, and any other significant events in the life cycle of the server. This is the first place to look when you run into a problem when using Apache.

If no error is found, you will see a message similar to:

Syntax OK

How to find the MySQL database credentials?

How to connect to the MySQL database?

You can connect to the MySQL database from the same computer where it is installed with the mysql client tool.

$ mysql -u root -p

You will be prompted to enter the root user password. This is the same as the application password.

How to debug errors in your database?

The main log file is created at installdir/mysql/data/mysqld.log on the MySQL database server host.

How to change the MySQL root password?

You can modify the MySQL password using the following command at the shell prompt. Replace the NEW_PASSWORD placeholder with the actual password you wish to set.

$ installdir/mysql/bin/mysqladmin -p -u root password NEW_PASSWORD

How to reset the MySQL root password?

If you don't remember your MySQL root password, you can follow the steps below to reset it to a new value:

  • Create a file in /home/bitnami/mysql-init with the content shown below (replace NEW_PASSWORD with the password you wish to use):

     UPDATE mysql.user SET Password=PASSWORD('NEW_PASSWORD') WHERE User='root';
     FLUSH PRIVILEGES;
    

    If your stack ships MySQL v5.7.x, use the following content instead of that shown above:

     UPDATE mysql.user SET authentication_string=PASSWORD('NEW_PASSWORD') WHERE User='root';
     FLUSH PRIVILEGES;
    
    TIP: Check the MySQL version with the command installdir/mysql/bin/mysqladmin --version or installdir/mysql/bin/mysqld --version.
  • Stop the MySQL server:

     $ sudo installdir/ctlscript.sh stop mysql
    
  • Start MySQL with the following command:

     $ sudo installdir/mysql/bin/mysqld_safe --pid-file=installdir/mysql/data/mysqld.pid --datadir=installdir/mysql/data --init-file=/home/bitnami/mysql-init 2> /dev/null &
    
  • Restart the MySQL server:

     $ sudo installdir/ctlscript.sh restart mysql
    
  • Remove the script:

     $ rm /home/bitnami/mysql-init
    

How to change the MySQL root password in Windows?

You can modify the MySQL password using the following command at the shell prompt. Replace the NEW_PASSWORD placeholder with the actual password you wish to set.

installdir\mysql\bin\mysqladmin.exe -p -u root password NEW_PASSWORD

How to reset the MySQL root password in Windows?

If you don't remember your MySQL root password, you can follow the steps below to reset it to a new value:

  • Stop the MySQL server using the graphic manager tool. Refer to the how to start or stop the services section.
  • Check the MySQL version:

    installdir\mysql\bin\mysqladmin.exe –version

  • Create a file named mysql-init.txt with the content shown below depending on your MySQL version (replace NEW_PASSWORD with the password you wish to use):
    • MySQL 5.6.x or earlier:

       UPDATE mysql.user SET Password=PASSWORD('NEW_PASSWORD') 
       WHERE User='root';
       FLUSH PRIVILEGES;
      
    • MySQL 5.7.x or later:

       ALTER USER 'root'@'localhost' IDENTIFIED BY 'NEW_PASSWORD'; 
      
  • Start MySQL server with the following command. Remember to replace PATH with the location in which you have saved the mysql-init.txt file:

     installdir " installdir\mysql\bin\mysqld.exe" --defaults-file=" installdir\mysql\my.ini" --init-file="\PATH\mysql-init.txt" --console
    
    • The --init file option is used by the server for executing the content of the mysql-init.txt file at startup, it will change each root account password.
    • The --defaults-file option is specified since you have installed MySQL using the Bitnami installer.
    • The --console option (optional) has been added in order to show the server output at the console window rather than in the log file.
  • After some minutes, hit Ctrl-C to force the shutdown.
  • Restart the MySQL server from the graphic manager tool.
  • After the server has restarted successfully, delete the mysql-init.txt file.

How to access phpMyAdmin?

You should be able to access phpMyAdmin directly, by browsing to http://127.0.0.1/phpmyadmin.

The username is root for phpMyAdmin, and the password is the one specified by you during the installation process.

How to modify PHP settings for Apache?

The PHP configuration file allows you to configure the modules enabled, the email settings or the size of the upload files. It is located at installdir/php/etc/php.ini.

For example, to modify the default upload limit for PHP, update the PHP configuration file following these instructions.

After modifying the PHP configuration file, restart both Apache and PHP-FPM for the changes to take effect:

$ sudo installdir/ctlscript.sh restart apache
$ sudo installdir/ctlscript.sh restart php-fpm

How to modify the allowed limit for uploaded files in Apache?

Modify the following options in the installdir/php/etc/php.ini file to increase the allowed size for uploads:

; Maximum size of POST data that PHP will accept.
post_max_size = 16M

; Maximum allowed size for uploaded files.
upload_max_filesize = 16M

Restart PHP-FPM and Apache for the changes to take effect.

$ sudo installdir/ctlscript.sh restart apache
$ sudo installdir/ctlscript.sh restart php-fpm    

How to optimize Drupal?

Drupal 7

Activate "Normal Caching mode" in the "Site Configuration -> Performance" section.

nativeInstaller

Bitnami Documentation