View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - New installation cannot connect to MySQL database - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

New installation cannot connect to MySQL database

More
05 Juil 2022 09:28 #1 by Broad
Just downloaded this app for an evaluation
Using Centos, installed Apache, PHP and the Plugins, and MySQL demon
Unpacked the zip file under the document root
Opened the first time installation page to configure, tweaked the PHP setting as recommended
I cannot save the configuration as it is failing to connect to the MySQL server

SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (13)
dsn = mysql:host=127.0.0.1;port=3306

On the CLI I can connect to the MySQL server using the root user and the password I configured for it (not the default)
I can see via the client that it is running on the default port 3306
It does not look like there is a database for this application (what would it's name be) and I assume the configuration process I am trying to do creates it?

Is there something else I need to setup or configure? Where should I be looking for the problem?
The application is producing no logs yet and the MySQL log has no relevent information about attempted logins.
 

Please Connexion or Create an account to join the conversation.

More
05 Juil 2022 23:03 #2 by babynus
I think the password is incorrect.
Check the access must be granted to root@localhost

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
09 Sep 2022 21:32 #3 by MocniMax
Hi,

I had exactly the same issue few day ago and I solve it by using a localhost as host name, not 127.0.0.1.
Reason for it is in fact that mysql on CentOS is storing root user as root@localhost and using 127.0.0.1 will not find a match.

As babynus wrote, mysql root user is root@localhost.
The following user(s) said Thank You: babynus

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.261 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.