# phpMyAdmin login fails with Percona Tools optimization of my.cnf

**URL:** <https://forums.percona.com/t/phpmyadmin-login-fails-with-percona-tools-optimization-of-my-cnf/2019>\
**Category:** Other MySQL® Questions\
**Created:** [March 17, 2013, 2:51pm UTC](https://forums.percona.com/t/phpmyadmin-login-fails-with-percona-tools-optimization-of-my-cnf/2019 "2013-03-17T14:51:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jan\_SEO](https://avatars.discourse-cdn.com/v4/letter/j/ebca7d/32.png) [@Jan\_SEO](https://forums.percona.com/u/Jan_SEO)\
**Post date:** [March 17, 2013, 2:51pm UTC](https://forums.percona.com/t/phpmyadmin-login-fails-with-percona-tools-optimization-of-my-cnf/2019/1 "2013-03-17T14:51:22Z")

</div>

After installing an optimized version of my.cnf from [tools.percona.com](http://tools.percona.com) the phpMyAdmin login fails for both regular MySQL users and the root user (based on Plesk admin login).

The error returned by phpMyAdmin is:

#1130 Cannot log in to the MySQL server

When I restore the old my.cnf, the error is gone and login succeeds.

The my.cnf from [tools.percona.com](http://tools.percona.com) is the following:

# Generated by Percona Configuration Wizard version REL5-20120208[mysql]# CLIENT #port = 3306socket = /var/lib/mysql/mysql.sock[mysqld]# GENERAL #user = mysqldefault\_storage\_engine = InnoDBsocket = /var/lib/mysql/mysql.sockpid\_file = /var/lib/mysql/mysql.pid# MyISAM #key\_buffer\_size = 32Mmyisam\_recover = FORCE,BACKUP# SAFETY #max\_allowed\_packet = 16Mmax\_connect\_errors = 1000000skip\_name\_resolvesql\_mode = sysdate\_is\_now = 1innodb = FORCEinnodb\_strict\_mode = 1# DATA STORAGE #datadir = /var/lib/mysql/# BINARY LOGGING #log\_bin = /var/lib/mysql/mysql-binexpire\_logs\_days = 14sync\_binlog = 1# CACHES AND LIMITS #tmp\_table\_size = 32Mmax\_heap\_table\_size = 32Mquery\_cache\_type = 0query\_cache\_size = 0max\_connections = 500thread\_cache\_size = 50open\_files\_limit = 65535table\_definition\_cache = 1024table\_open\_cache = 2048# INNODB #innodb\_flush\_method = O\_DIRECTinnodb\_log\_files\_in\_group = 2innodb\_log\_file\_size = 128Minnodb\_flush\_log\_at\_trx\_commit = 1innodb\_file\_per\_table = 1innodb\_buffer\_pool\_size = 2G# LOGGING #log\_error = /var/lib/mysql/mysql-error.loglog\_queries\_not\_using\_indexes = 1slow\_query\_log = 1slow\_query\_log\_file = /var/lib/mysql/mysql-slow.log

Does anyone have an idea what option is the cause?

---

<div class="post-metadata">

**Author:** ![gmouse](https://avatars.discourse-cdn.com/v4/letter/g/b9e5f3/32.png) [@gmouse](https://forums.percona.com/u/gmouse)\
**Post date:** [March 18, 2013, 6:46am UTC](https://forums.percona.com/t/phpmyadmin-login-fails-with-percona-tools-optimization-of-my-cnf/2019/2 "2013-03-18T06:46:00Z")

</div>

Different data directory perhaps? What is your old config file?

---

<div class="post-metadata">

**Author:** ![Jan\_SEO](https://avatars.discourse-cdn.com/v4/letter/j/ebca7d/32.png) [@Jan\_SEO](https://forums.percona.com/u/Jan_SEO)\
**Post date:** [March 18, 2013, 7:10am UTC](https://forums.percona.com/t/phpmyadmin-login-fails-with-percona-tools-optimization-of-my-cnf/2019/3 "2013-03-18T07:10:17Z")

</div>

Dear gmouse,

Thanks a lot for the reply!

The old config is the following:

[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysql# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Semisynchronous Replication# [MySQL :: MySQL 8.0 Reference Manual :: 17.4.10 Semisynchronous Replication](http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html#) uncomment next line on MASTER;plugin-load=rpl\_semi\_sync\_master=semisync\_master.so# uncomment next line on SLAVE;plugin-load=rpl\_semi\_sync\_slave=semisync\_slave.so# Others options for Semisynchronous Replication;rpl\_semi\_sync\_master\_enabled=1;rpl\_semi\_sync\_master\_timeout=10;rpl\_semi\_sync\_slave\_enabled=1# [dev.mysql.com/doc/refman/5.5/en/performance-schema.html;performance\_schema[mysqld\_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid](http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html;performance_schema%5Bmysqld_safe%5Dlog-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid)

When I return this config (and delete ib\_logfile0 and ib\_logfile1 files) and restart MySQL, I am able to login to phpMyAdmin again. (using regular authentication via a form)