MySQL is not working, MySQLi is working.

[Pilovali]

Hello,

I have a problem with the MySQL server.
I want to install SMF (Forum software) and it is giving me this error:
Access denied for user 'pirus'@'localhost' (using password: NO)

pirus is the VestaCP username, not the database name.

I did some research and I found this interesting link: http://stackoverflow.com/questions/7671 ... -with-that

It seems that it is using the unix username instead of the username I put in the config.
This problem is not happening with MySQLi, so things like the SMF beta and WordPress works just fine.

Could someone help me with this? I searched for DAYS!

I am using VestaCP 0.9.8.12 on Ubuntu 14.04 and I have PHP-APC and Google Pagespeed installed.

[skurudo]

Wait, wait, wait... Do you create user - it's ok, do you create database / database user / password and then use for connect SMF forum and this don't work, correct? You copy all field right?

PHP have at least two connectors for database - mysql and mysqli (check in /etc/php5/conf.d) - http://php.net/manual/en/mysqli.overview.php

[Pilovali]

Wait, wait, wait... Do you create user - it's ok, do you create database / database user / password and then use for connect SMF forum and this don't work, correct? You copy all field right?

PHP have at least two connectors for database - mysql and mysqli (check in /etc/php5/conf.d) - http://php.net/manual/en/mysqli.overview.php

I created the user and database on the VestaCP, it works if I want to install WordPress (uses MySQLi), but not SMF (uses MySQL).

This is the content of the conf.d:

*******@******:~# ls /etc/php5/apache2/conf.d/
05-opcache.ini 20-geoip.ini 20-mysql.ini 20-readline.ini
10-pdo.ini 20-intl.ini 20-mysqli.ini 20-sqlite3.ini
20-apcu.ini 20-json.ini 20-pdo_mysql.ini
20-curl.ini 20-mcrypt.ini 20-pdo_sqlite.ini
20-gd.ini 20-memcached.ini 20-pspell.ini

[skurudo]

I made test SMF installation and don't see error. All work just fine and you have 20-mysql.ini connector. Mysql and Mysqli is overthinking. May be site error log can say us something?

[Pilovali]

Error log of the website is emtpy, MySQL log shows nothing regarding to that.
Could it be because of something I installed? Like APC or Pagespeed? I didn't had this problem before.

[skurudo]

Most likely Pagespeed (for apache2?), thy disable this module, restart apache2 and then try again.

[Pilovali]

Most likely Pagespeed (for apache2?), thy disable this module, restart apache2 and then try again.

Nope, I disabled it and it didn't solved this issue.

[skurudo]

May be you can some screenshot of installation process or url/database settings in PM?

[Pilovali]

May be you can some screenshot of installation process or url/database settings in PM?

I've send you a PM with credentials of the VestaCP user, perhaps you can take a look.

UPDATE:
I re-checked the MySQL logs and it's spamming this error:
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process

I tried this: https://serverfault.com/questions/47744 ... 1-error-11 but it keeps spamming.

[skurudo]

Check this - http://forum.vestacp.com/viewtopic.php? ... ta1#p20701