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.
privileges problem on database
-
- Posts: 9
- Joined: Thu Jun 27, 2019 2:09 am
- Os: CentOS 5x
- Web: nginx + php-fpm
privileges problem on database
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
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
-
- Support team
- Posts: 1111
- Joined: Tue Jul 30, 2013 10:18 pm
- Contact:
- Os: CentOS 6x
- Web: nginx + php-fpm
Re: privileges problem on database
Use VestaCP for manage databases/users, not PHPMyAdmin.direktor05 wrote: ↑Fri Aug 02, 2019 6:55 pmHello,
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
-
- Posts: 9
- Joined: Thu Jun 27, 2019 2:09 am
- Os: CentOS 5x
- Web: nginx + php-fpm
Re: privileges problem on database
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
As they told you, access is per user, not global. You must manage the databases one per user.