Page 1 of 1
privileges problem on database
Posted: Fri Aug 02, 2019 6:55 pm
by direktor05
Hello,
I created a database inside Vesta but in PHPAdmin the database is nowhere to be seen. In PHPAdmin I can't create a new user, I can't create a new database - it says 'admin'@'localhost' doesn't have permission to create a new database. There is no tab to create new user. How do I create new database users, grant them privileges and create a new database in PHPAdmin?
Regards, Bogomil
Re: privileges problem on database
Posted: Sat Aug 03, 2019 7:17 am
by grayfolk
direktor05 wrote: ↑Fri Aug 02, 2019 6:55 pm
Hello,
I created a database inside Vesta but in PHPAdmin the database is nowhere to be seen. In PHPAdmin I can't create a new user, I can't create a new database - it says 'admin'@'localhost' doesn't have permission to create a new database. There is no tab to create new user. How do I create new database users, grant them privileges and create a new database in PHPAdmin?
Regards, Bogomil
Use VestaCP for manage databases/users, not PHPMyAdmin.
Re: privileges problem on database
Posted: Sat Aug 03, 2019 10:47 am
by direktor05
The problem is any database or user created in VestaCP is not shown in PHPAdmin. PHP won't connect to database created with VestaCP. Also in VestaCP I can't add fields to database. I managed to solve the problem yesterday by manually creating new user and granting privileges on CentOS Terminal. Then the database created with VestaCP miraculously showed in PHPAdmin. But I can't replicate this to create the second database.
Re: privileges problem on database
Posted: Fri Aug 30, 2019 2:51 am
by sysdop
As they told you, access is per user, not global. You must manage the databases one per user.