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@example.com
, 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 ;-)