MySQL Connection Issues after successful installation

[lightspeed]

I have a brand new Zabbix installation, was able to enter MySQL credentials for the zabbix localhost user, install script accepted it, did the install, but once it was finished and the server started the daemon I can login, but it consistently tells me in the web GUI that the zabbix server isn't running.

After looking at a few things I noticed in the logs the following message:

Access denied for user 'zabbix'@'localhost' (using password: YES)

I have verified from command line that I can in-fact login using the correct password and access the zabbix database and run operations. I have verified that the zabbix.conf.php file has the correct credentials and is pointing to localhost and I presume this file was pre-populated from the install script which worked fine so it should be fine. I have verified that mysql is still running and on the default port. I legitimately cannot imagine what the issue could be. Mysql logs show no errors. I am hitting an odd odd wall.

[Atsushi]

Have you set a password for DBPassword in zabbix_server.conf?

[tim.mooney]

I legitimately cannot imagine what the issue could be.

You haven't told us what version of Zabbix you installed or what platform it was installed upon. That can be useful information to know when trying to help someone.

Some versions of PHP's mysql extension look for the UNIX socket in a location that's different from where it was actually created. Make sure your PHP setting for "mysqli.default_socket" or "mysql.default_socket" (or whatever it's called on your platform, for your version of PHP) is pointing to the same place that the MySQL/MariaDB/Percona server is creating the socket. You can search these forums for other people that have had to specify that setting to get their frontend to connect to the database.