[GH-ISSUE #284] Issue whilke Database Creation #231

New issue

Closed

opened 2026-02-26 09:36:56 +03:00 by kerem · 3 comments

kerem commented

2026-02-26 09:36:56 +03:00

Owner

Originally created by @Vaibhav4697 on GitHub (Mar 31, 2022).
Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/284

I have been following the steps and when I am trying to create the database with the command below, it throwing me such error.

Database Creation
Now that your configuration is set and you have setup a database and user in MySQL, you need to create the database schema:

cd $INSTALL_PATH
./bin/doctrine2-cli.php orm:schema-tool:create

Error:

Can you please give it a look, what is it about?

Originally created by @Vaibhav4697 on GitHub (Mar 31, 2022). Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/284 I have been following the steps and when I am trying to create the database with the command below, it throwing me such error. Database Creation Now that your configuration is set and you have setup a database and user in MySQL, you need to create the database schema: cd $INSTALL_PATH ./bin/doctrine2-cli.php orm:schema-tool:create Error: ![image](https://user-images.githubusercontent.com/30215969/161102359-580615dc-9e5a-405c-9144-73cf6ffa8f52.png) Can you please give it a look, what is it about?

kerem closed this issue

2026-02-26 09:36:56 +03:00

kerem commented

2026-02-26 09:36:56 +03:00

Author

Owner

@mfechner commented on GitHub (Mar 31, 2022):

I think the error message is very clear. The user vimbadmin does not have the permissions it requires.
Or you use a wrong password.

@mfechner commented on GitHub (Mar 31, 2022): I think the error message is very clear. The user vimbadmin does not have the permissions it requires. Or you use a wrong password.

kerem commented

2026-02-26 09:36:57 +03:00

Author

Owner

@Vaibhav4697 commented on GitHub (Apr 1, 2022):

Yeah, I know that but I have granted all the permission to this user in mysql and I have also verified the password many times.

@Vaibhav4697 commented on GitHub (Apr 1, 2022): Yeah, I know that but I have granted all the permission to this user in mysql and I have also verified the password many times.

kerem commented

2026-02-26 09:36:57 +03:00

Author

Owner

@barryo commented on GitHub (Apr 1, 2022):

In your application.ini file, you'll have config like:

resources.doctrine2.connection.options.driver   = 'pdo_mysql'
resources.doctrine2.connection.options.dbname   = 'vimbadmin'
resources.doctrine2.connection.options.user     = 'vimbadmin'
resources.doctrine2.connection.options.password = 'password'
resources.doctrine2.connection.options.host     = 'localhost'

Taking these exactly as they are and on the same server as ViMbAdmin, this should work:

mysql -h localhost -u vimbadmin -ppassword vimbadmin

@barryo commented on GitHub (Apr 1, 2022): In your `application.ini` file, you'll have config like: ``` resources.doctrine2.connection.options.driver = 'pdo_mysql' resources.doctrine2.connection.options.dbname = 'vimbadmin' resources.doctrine2.connection.options.user = 'vimbadmin' resources.doctrine2.connection.options.password = 'password' resources.doctrine2.connection.options.host = 'localhost' ``` Taking these exactly as they are and on the same server as ViMbAdmin, this should work: ``` mysql -h localhost -u vimbadmin -ppassword vimbadmin ```