(Jan 22) Release 0.9.8-19 with bug fixes available now. Run this command for update v-update-sys-vesta-all

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
Forum rules
Before creating a new topic or reply on the forum you should fill out additional fields "Os" and "Web" in your profile section.
In case of violation, the topic can be closed or response from the support will not be received.
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: 7808
Joined: Fri Dec 26, 2014 2:23 pm
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: 7808
Joined: Fri Dec 26, 2014 2:23 pm
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 2 guests

cron