Page 1 of 1

cant login in user after upgrade mysql to 5.7 in vesta panel /centos 6.7 32bit

Posted: Tue Aug 29, 2017 11:30 am
by dimahna
i upgrade mysql to 5.7 in vesta panel / centos 6.7
i login to my panel i can create user but the users can't connect in phpmyadmin any help

Image

i check phpmyadmin with root i can find the database and the user but i think its issus in MD5!!
Image

i need help please

Re: cant login in user after upgrade mysql to 5.7 in vesta panel /centos 6.7 32bit

Posted: Tue Aug 29, 2017 11:39 am
by skurudo
I hope this topic can help you
viewtopic.php?t=13239

Re: cant login in user after upgrade mysql to 5.7 in vesta panel /centos 6.7 32bit

Posted: Tue Aug 29, 2017 12:33 pm
by dimahna
not working i check database with root i cant find the users of mysql check here im try to make it with phpmyadmin manual noting else !
check :
Image
Image

Re: cant login in user after upgrade mysql to 5.7 in vesta panel /centos 6.7 32bit

Posted: Tue Aug 29, 2017 12:40 pm
by skurudo
Did you use mysql_upgrade as PMA suggest?

Re: cant login in user after upgrade mysql to 5.7 in vesta panel /centos 6.7 32bit

Posted: Tue Aug 29, 2017 1:32 pm
by dimahna
skurudo wrote:Did you use mysql_upgrade as PMA suggest?
i follow all this tutorial : viewtopic.php?t=13239 but there still not resolve any help here

Re: cant login in user after upgrade mysql to 5.7 in vesta panel /centos 6.7 32bit

Posted: Tue Aug 29, 2017 3:21 pm
by dimahna
dimahna wrote:
skurudo wrote:Did you use mysql_upgrade as PMA suggest?
i follow all this tutorial : viewtopic.php?t=13239 but there still not resolve any help here
Image

see the image when i try to patch user any help