We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Database created without user
Database created without user
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?
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?
Re: Database created without user
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
You can try fixes -> https://github.com/serghey-rodin/vesta/ ... eea84f8461
and
viewtopic.php?f=20&t=13239
Re: Database created without user
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
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
Re: Database created without user
I cant reproduce this problem
Can you try run in mysql as root
Can you try run in mysql as root
Code: Select all
SELECT user FROM mysql.user;
Re: Database created without user
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.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
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 ;-)
Re: Database created without user
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
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