How to specify the port number of mysql xampp during bitnami wordpress install?
I installed xampp and I changed the mysql port number from 3306 to 3307 (since 3306 is blocked for another application). Both apache and mysql work when I click start. By the way, I am using Windows
When I try to install the bitnami wordpress module, the installer cannot find mysql because the installer looks for it on port number 3306 instead of 3307. I checked bitrock_installer.log and found out that it is actually looking for mysql on port number 3306.
Log started 05/01/2017 at 14:36:22 Preferred installation mode : qt Trying to init installer in mode qt Mode qt successfully initialized Tried to find file "properties.ini" inside non-existent directory "C:\Bitnami" Executing C:/xampp\mysql\bin/mysql.exe -u root -P3306
-hlocalhost -e "show databases;" Script exit code: 1
Script output:
Script stderr: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Error running C:/xampp\mysql\bin/mysql.exe -u root -P3306 -hlocalhost
-e "show databases;": ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Is there a way to specify the mysql port number during the bitnami wordpress install so that it looks for mysql on the port number 3307 instead of 3306? Thank.
source to share
During the WordPress installation process, you have to choose the directory where your XAMPP is installed. If you choose a directory containing XAMPP installed using ports other than the default (eg Apache [81,444] and MySQL [3307]), the WordPress installation will use the same ports that are defined in the configuration files inside the XAMPP directory.
source to share
As of Jul 17, there is no way to specify the MySql port number. Below is the answer I got from Bitnami developer:
I'm afraid we don't support another port by default. my advice was to restart mysql on port 3306, execute and then switch it back to its own port. Note that you will also need to modify the wp-config.php file to use the correct database port. Will this work for you?
You can check this thread here: https://community.bitnami.com/t/xampp-bitnami-wordpress-module-custom-mysql-port/50538
source to share