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?
Support us on Capterra
