MySQL Permissions
At my organization, each user is provided with a MySQL schema/database named the same as their userid. Users have full control of this and can create anything they like *within* this, but do not have permissions outside of this. When I try to create a new MySQL Data Source, it fails indicating that I do not have permissions within MySQL. Why can't I just create the required tables within my <userid> schema/database (although I do see about 15 tables that were created)? What else is the installation trying to configure? Is there a .sql file that I can look at to see what it is trying to do so that I can make a case to a DBA to grant me (temporary) permission?
All Comments (2)
I will send you the full MySQL script via private message. You can have a look at it. Step 1.2 has an operation on the schema (changing the character set). It think if you remove that one line the script should succeed.
Best regards,
Stéfane Lavergne
Thank you very much. I'll give this a try first thing tomorrow morning. You guys are the best!