Author Topic: phpMyAdmin -- #1045 Cannot log in to the MySQL server  (Read 7387 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
phpMyAdmin -- #1045 Cannot log in to the MySQL server
« on: July 19, 2016, 03:50:14 AM »
Dear Sir/Madam,

Please help. After I change php version from 5.4 to 5.6 then cannot login to phpMyadmin.

Thanks

Henry Vo

Offline
*
Re: phpMyAdmin -- #1045 Cannot log in to the MySQL server
« Reply #1 on: August 10, 2016, 01:48:58 PM »
that is correct. because the mysql structure changes which includes the password encryption.
i think it was they change from MD5 to salt or such thing. and default language is UTF-8 and not latin anymore. and for that he not understand your input. you have to make some reading on the mysql documentation in the section upgrade. their is clearly written what is to do. you get angry with that. so switched back to 5.4.
centos is simply not updating so quickly as other. example Roundcubemail centos installs Version 0.8.4.x on roundcube website you get version 1.20.0.1 as newest version. which not work well as we all know. they recommand version 1.0.9 as the lowest installation. Fedora has that in the repo but centos not. and that is why you try to update but the newest version hardly works well with centos. CWP installs Mysql 5.1 but version 5.7 is out. And that because of stability. the newest software is not always the best choice in stability.