[PornesianParapio]

Hi all.

Can anyone enlighten me how to connect the database? I already tried to configure it so many times but the result is unsuccessful.

This is the message I've got

Thank you

[PornesianParapio]

No one can help me to solve this?

[amosbatto]

First verify that the username and password in MySQL are correct from the command line of your ProcessMaker server. Open a terminal (and go to the directory where Mysql is installed if using Windows) and enter the following command:
mysql -h ADDRESS -u USER -pPASSWORD DATABASE

Replace the parts in italics. For example:
mysql -h 127.0.0.1 -u jdoe -pP@sSw0rD my_database

If you aren't able to login, then you might have a priveleges problem. Login as your "root" user in mysql and then use the GRANT command to set the password for the user and set that the user can login on the machine 127.0.0.1:
grant all on DATABASE.* to 'USER'@'ADDRESS' identified by 'PASSWORD' with grant option;

Replace the parts in italics. For example:
grant all on my_database.* to 'jdoe'@'127.0.0.1' identified by 'P@sSw0rD' with grant option;

If it still doesn't work, then verify that you don't have a firewall that is blocking port 3306. It is a good idea to turn off any firewall when testing. You can use netstat -tln in Linux or netstat -tn in Windows to verify if your server is using port 3306 and MySQL is listening.

Here is what I see on my Linux machine:

Code: Select all

# netstat -tln
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State      
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN     
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN 

You can check your my.cnf file for the port being used by MySQL.