How to create an additional MySQL database for ee site?



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.



Access root of global db using

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

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