raymondorta wrote:
Hello jmsalazarjr, your are right.
sorry my apologies.

It's nothing to worry about, Orta, I just ask that now that we're both talking to Edwin, that the conversations remain separate. I hope that you got/will get what you need, good luck! It really seems like a good product, once we get it set up the way we need.

When you use PHPMyAdmin, you have to go in the "privileges" menu that appear when you are root.
If you don't have this "privileges" menu, this is because you are not root.

If you have the "privileges" menu, you can see all the users.
There you can check the permission and which actions are autorised by the users.
You also have to check the host or IPs that are autorised for the users.
You also have to check the DB that are autorised.
Sometimes you also have to verify the content of the MySQL DB itself and the parameters in the "db" table to check the permissions.

Maybe you could state precisely what you would do to those users' permissions, if you did have phpMySQL access to my DB server.

I already know everything you stated above. What I don't know is, what privileges does the user need?

The user for my master DB already has global permissions CREATE, CREATE USER, GRANT, and UPDATE. What global privileges does this user need, in order to execute the following query

Create User error [1044]: Query = [GRANT ALL PRIVILEGES ON `template2010`.* TO `template2010`@`localhost` IDENTIFIED BY '**************' WITH GRANT OPTION;], DB Message = [Access denied for user 'integration'@'localhost' to database 'template2010' SQL=GRANT ALL PRIVILEGES ON `template2010`.* TO `template2010`@`localhost` IDENTIFIED BY '**************' WITH GRANT OPTION;]

Give a root user and ALL the privieleges on ALL the domain and all the host.
Perhaps the user is not defined on the correct host or IP, or something else.

If you want that we have a look on your server and setup your MySQL user, you can order our billable support at
www.jms2win.com/download?page=shop.produ...35&category_id=1

If you're just going to make the root user responsible, then no thanks. I already have this working according to your advice to put root credentials into multisites.cfg.php.

But, if you're saying that billable support can result in the master website's DB user able to grant proper permissions to dynamically-created DB users for new slave sites, and I won't have to have root credentials on cfg.php, then, I would be interested.

We are not responsible of the permission that your hosting provider gives you when you create a MySQL user.
We can just tell you where the problem is located.
We are not your hosting provider.
You should contact him to explain that you don't have the permission to do what you expect in your DB.
All we can do is to explain you which permission is required to make it works.