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

Database created without user

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
6 posts • Page 1 of 1
syph
Posts: 6
Joined: Tue Nov 10, 2015 6:01 am

Database created without user
  • Quote

Post by syph » Wed Dec 14, 2016 8:30 am

Hi,

im having an issue when creating a database, I add the user name and password and the database is made but if i look at the privileges on phpmyadmin users of the name name are not created as they once were.

im not sure if updating to the latest vestacp 0.9.8-17 or if mysql update did it

Server version: 5.7.16-0ubuntu0.16.04.1 - (Ubuntu)

Does anyone have any ideas?
Top

skamasle
Collaborator
Posts: 592
Joined: Mon Feb 29, 2016 6:36 pm

Re: Database created without user
  • Quote

Post by skamasle » Wed Dec 14, 2016 9:01 pm

There is an issue whit mysql 5.7

You can try fixes -> https://github.com/serghey-rodin/vesta/ ... eea84f8461

and

viewtopic.php?f=20&t=13239
Top

syph
Posts: 6
Joined: Tue Nov 10, 2015 6:01 am

Re: Database created without user
  • Quote

Post by syph » Thu Dec 15, 2016 3:25 am

Hi skamasle,

Thanks for the info, I have already tried this and the issue still persists. its weird, i also connected a newly installed remote database server running 5.6 and i have the same issue.. it will create a database but no users.

im not sure where to even start with this
Top

skamasle
Collaborator
Posts: 592
Joined: Mon Feb 29, 2016 6:36 pm

Re: Database created without user
  • Quote

Post by skamasle » Thu Dec 15, 2016 10:03 pm

I cant reproduce this problem

Can you try run in mysql as root

Code: Select all

SELECT user FROM mysql.user;
Top

Falzo
Posts: 60
Joined: Mon Mar 28, 2016 8:49 am

Re: Database created without user
  • Quote

Post by Falzo » Tue Mar 28, 2017 7:42 pm

syph wrote:Hi skamasle,

Thanks for the info, I have already tried this and the issue still persists. its weird, i also connected a newly installed remote database server running 5.6 and i have the same issue.. it will create a database but no users.

im not sure where to even start with this
just a quick follow up on this, because I just stumbled across the very same problem. probably your remote database has by default multiple root users set up. [email protected], root@localhost and root@% <- every host, the latter would be the one used by remote logins.

if you take a closer look on the permissions only the local root users are granted ALL privileges, but not root@% for remote connections... so this user simply can't GRANT rights to users, therefore also not even create them.

you could either change the permissions for that root@% to ALL or maybe create another user with another name@% which you then give persmissions including GRANT and use it for vesta in conjunction with v-add-database-host ;-)
Top

hanif81
Posts: 7
Joined: Mon Sep 03, 2018 4:05 am

Os: CentOS 6x
Web: apache + nginx
Re: Database created without user
  • Quote

Post by hanif81 » Fri Oct 04, 2019 4:57 pm

Sorry seem old topic.

I got some error for remote connections. I was successfully connect to remote SQL but cannot create user using VESTACP Panel. My problem was VESTACP can create db but cannot create user and associate with db like some missing command to send remote SQL server.

I check git-hub seems some bugs but mark was done ? i check with latest VESTACP seems not same code again. Did it fix or not ? coz i hav same problem like this https://github.com/serghey-rodin/vesta/issues/1348
Top


Post Reply
  • Print view

6 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