Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Installation - Can'...
 
Notifications
Clear all

Installation - Can't connect to MySQL server on '127.0.0.1'

2 Posts
2 Users
0 Reactions
5,566 Views
(@ericcarson)
Posts: 1
New Member
Topic starter
 
[#3106]

Installing is giving me an error of

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

CentOS 7
MariaDB 5.5.44 (Mysql)
PHP version is 5.4.16

MySQL is monitoring the default port.
I have created a MySql database.
I have created a MySql user.
The projeqtor database has the user granted database-specific permissions, all but grant
The error occurs also with 'localhost'

I have double-checked the MySQL user
I have double-checked the MySQL user password

I'm at a loss right now...

the root user will not connect either. I'm thinking it may be related to the way in which MySQL is accessed. Hesk (a helpdesk/ticket system) and WordPress are installed and running on the system successfully.

Could this be related to SELinux? Is there a file I should be changing the context to httpd_sys_rw_content_t to allow read/write access for the configuration changes to actually be written?

Added all directories for projeqtor to the rw context
changed database host to localhost
error changed to access denied.
changed database user to root
SUCESS!

I still do not consider this solved. A perfectly good non-root user is available but does not authenticate?

# Privileges for `projeqtor`@`127.0.0.1`

GRANT USAGE ON *.* TO 'projeqtor'@'127.0.0.1' IDENTIFIED BY PASSWORD '*CENSORED';

GRANT ALL PRIVILEGES ON `projeqtor`.* TO 'projeqtor'@'127.0.0.1';

What am I missing everyone?


 
Posted : 27 Feb 2016 14H09
(@babynus)
Posts: 14952
Member Admin
 

Did you revert your configuration to 127.0.0.1 insted of localhost ?
Did you try grant usages to 'projeqtor'@'localhost' with access to localhost ?


 
Posted : 27 Feb 2016 18H53
Share:

Scroll to Top