Vesta don't create user in Percona 5.7
Vesta don't create user in Percona 5.7
Hello
After install clear vesta and replace mariadb on percona 5.7 I have problem with create new database.
If I use vesta to create new database I can do it with any error, but inside database vesta create only database without user.
If I run command:
I see all my database but if I try
I see only default users ( root / admin_default / roundcube )
The same problem I have with Percona 5.6, now I have 5.7 on server or if I use v-add-database
Why this doesn't work ?
Information about system:
Server version: 5.7.19-17 Percona Server (GPL), Release 17, Revision e19a6b7b73f
CentOS Linux release 7.4.1708 (Core)
After install clear vesta and replace mariadb on percona 5.7 I have problem with create new database.
If I use vesta to create new database I can do it with any error, but inside database vesta create only database without user.
If I run command:
Code: Select all
show databases;
Code: Select all
use mysql;
select * from user;
The same problem I have with Percona 5.6, now I have 5.7 on server or if I use v-add-database
Why this doesn't work ?
Information about system:
Server version: 5.7.19-17 Percona Server (GPL), Release 17, Revision e19a6b7b73f
CentOS Linux release 7.4.1708 (Core)
-
- Support team
- Posts: 1096
- Joined: Sat Sep 06, 2014 9:58 pm
- Contact:
- Os: Debian 8x
- Web: apache + nginx
Re: Vesta don't create user in Percona 5.7
Percona is Drop-in replacement so it should not have such problem. please tell your Linux Distro and version
Take a backup up of DBs and may be try "Rebuild DB" for the user ? That should restore vesta's control over the configs
Take a backup up of DBs and may be try "Rebuild DB" for the user ? That should restore vesta's control over the configs
Re: Vesta don't create user in Percona 5.7
I gave the OS version at the previous post.
I think my mistake is related to other errors:
viewtopic.php?f=14&t=14354
But in addition to empty passwords MD5 = '', my vesta does not create a user in the database.
I don't need create backup because I have fresh install my server with vesta and rebuild don't help me.
I think my mistake is related to other errors:
viewtopic.php?f=14&t=14354
But in addition to empty passwords MD5 = '', my vesta does not create a user in the database.
I don't need create backup because I have fresh install my server with vesta and rebuild don't help me.