Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

Vesta don't create user in Percona 5.7

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
3 posts • Page 1 of 1
rgawron
Posts: 12
Joined: Wed Feb 18, 2015 10:15 am

Vesta don't create user in Percona 5.7
  • Quote

Post by rgawron » Tue Nov 07, 2017 9:44 am

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:

Code: Select all

show databases;
I see all my database but if I try

Code: Select all

use mysql;
select * from user;
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)
Top

mehargags
Support team
Posts: 1096
Joined: Sat Sep 06, 2014 9:58 pm
Contact:
Contact mehargags
Website Skype

Os: Debian 8x
Web: apache + nginx
Re: Vesta don't create user in Percona 5.7
  • Quote

Post by mehargags » Tue Nov 07, 2017 4:06 pm

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
Top

rgawron
Posts: 12
Joined: Wed Feb 18, 2015 10:15 am

Re: Vesta don't create user in Percona 5.7
  • Quote

Post by rgawron » Wed Nov 08, 2017 1:56 pm

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.
Top


Post Reply
  • Print view

3 posts • Page 1 of 1

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password