MySQL super user - ISPconfig 3, Debian 7

Discussion in 'ISPConfig 3 Priority Support' started by inside83, Feb 20, 2015.

  1. inside83

    inside83 Member HowtoForge Supporter

    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?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    You might have to do that in phpmyadmin.
     
  3. inside83

    inside83 Member HowtoForge Supporter

    So, it is not possible to assign SUPER privileges to MySQL user?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  5. inside83

    inside83 Member HowtoForge Supporter

    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.
     
  6. inside83

    inside83 Member HowtoForge Supporter

    @till
    Please,
    This is very important.
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     

Share This Page