How to create an additional MySQL database for ee site?


#1

Hi,

my EE site requires two databases instead just one. How do i create another one?
I tried via phpmyadmin but the user has no permissions to create new databases and i dont know where to find the root mysql password.

Thanks


#2

Access root of global db using https://easyengine.io/handbook/mysql-root-access

Then create the database and grant access to mysql user of site to that database.

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'%';