Hello, I am accessing a database on ISPconfig 3 using Navicat, so I turned on the option for remote access for that specific database and everything works fine instead when I try to copy views from another database to the database on ISPconfig 3 (using Navicat) I get the error: 227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation How to grant a user of that database the super privileges in ISPconfing 3?
Which kind of super privelige do you mean? GRANT? The grant privelige wozld allow the user to give himself more rights and to access other databases. thats not suitable for a client as he would be able to take over your server then.
Is there an option to grant super privileges to one database only? I need to be able to work with Views in Navicat because it is much, much easier than phpmyadmin. And I would be the only client on this particular server.
There are some grant priveliges available on database level as well. You can try to cativate them in mysql.db table for this database and then run the command "flush privileges;" in mysql to apply it.
