23 pointsStarting to get into this DEV thingI'm new here
chrchcol
Member
—
6th January 2012 (4 months ago)
We have installed multi db. Created the databases. An now we need to assign permissions. We installed the multidb to use 4096 databases on a cpanel server.
However
We are having to add permissions for the single user to all the databases one by one.
Is there a way to add the user to all databases at once.
I have root access, I went to mysql and granted the user permissions to all the databases. Yet cpanel does not recognize it.
We have installed multi db. Created the databases. An now we need to assign permissions. We installed the multidb to use 4096 databases on a cpanel server.
However
We are having to add permissions for the single user to all the databases one by one.
Is there a way to add the user to all databases at once.
I have root access, I went to mysql and granted the user permissions to all the databases. Yet cpanel does not recognize it.
With cpanel no - you will have to ssh (or telnet) in and run the grant permissions directly on mysql (which it sounds like you have done), and then make sure you run a flush on the priviledges.
I'm not that familiar with how cpanel syncs with mysql, so it may never reflect what you have done manually, but if you can connect to one of the db's with your new user and password then you should be ok.
7257 pointsLike some sort of WPMU DEV GodMindblowingly helpful memberLifetime member
Support Chimp
—
17th January 2012 (4 months ago)
#
Hey there!! I hope you are well! :-)
We haven't heard form you on this in a while. So I'm going to presume your all fixed up now and don't need any further assistance.
However if you have more questions or need some more help then please feel free to respond in this thread or create a new one and we will be more than happy to offer assistance. :-)
Responses (2)
Developer — 6th January 2012 (4 months ago) #
With cpanel no - you will have to ssh (or telnet) in and run the grant permissions directly on mysql (which it sounds like you have done), and then make sure you run a flush on the priviledges.
I'm not that familiar with how cpanel syncs with mysql, so it may never reflect what you have done manually, but if you can connect to one of the db's with your new user and password then you should be ok.
Support Chimp — 17th January 2012 (4 months ago) #
Hey there!! I hope you are well! :-)
We haven't heard form you on this in a while. So I'm going to presume your all fixed up now and don't need any further assistance.
However if you have more questions or need some more help then please feel free to respond in this thread or create a new one and we will be more than happy to offer assistance. :-)
Take care.
Become a member