Set database user name and password

Set database user name and password#813779

By sabinsunny - Sun Mar 25, 2018 3:16 am

- Sun Mar 25, 2018 3:16 am #813779

Hi team

i installed processmaker on my server locally and its working fine but i forget to set databse password by default the user name is root once i try to open 127.0.0.1/phpmyadmin it directly opening the database i need to set password for it

Re: Set database user name and password#813780

By programerboy - Mon Mar 26, 2018 4:57 am

- Mon Mar 26, 2018 4:57 am #813780

Hi,

When you install your processmaker your database password is your admin passoword.

Or

You can see your database info in this file : "\shared\sites\workflow\db.php"

Thanks

Re: Set database user name and password#813783

By amosbatto - Mon Mar 26, 2018 11:00 am

- Mon Mar 26, 2018 11:00 am #813783

To set the root password in MySQL from the command line:
mysqladmin -u root password NEWPASSWORD
or:
mysqladmin -u root -pOLDPASSWORD password NEWPASSWORD

Note: If you are using Windows or a Bitnami installation, first change to the directory where MySQL is installed. For example:
cd /opt/processmaker-3.1.3.b1-0/mysql/bin
./mysqladmin -u root password P4sSw0rD

See:
https://www.techrepublic.com/article/ho ... -password/

Then, go to Admin > Settings > Cases List Cache Builder and change the MySQL root password in the PM interface. See:
http://wiki.processmaker.com/index.php/ ... ot.22_user