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

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
dimahna
Posts: 6
Joined: Tue Aug 29, 2017 11:16 am

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

Postby dimahna » Tue Aug 29, 2017 11:30 am

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

skurudo
VestaCP Team
Posts: 7798
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

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

Postby skurudo » Tue Aug 29, 2017 11:39 am

I hope this topic can help you
viewtopic.php?t=13239
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

dimahna
Posts: 6
Joined: Tue Aug 29, 2017 11:16 am

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

Postby dimahna » Tue Aug 29, 2017 12:33 pm

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

skurudo
VestaCP Team
Posts: 7798
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

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

Postby skurudo » Tue Aug 29, 2017 12:40 pm

Did you use mysql_upgrade as PMA suggest?
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

dimahna
Posts: 6
Joined: Tue Aug 29, 2017 11:16 am

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

Postby dimahna » Tue Aug 29, 2017 1:32 pm

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

dimahna
Posts: 6
Joined: Tue Aug 29, 2017 11:16 am

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

Postby dimahna » Tue Aug 29, 2017 3:21 pm

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


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 4 guests

cron