HostMonster Web Hosting Help

MySQL Triggers

Problem:

Do you allow the SUPER privilege on MySQL 5.x.x so I can use triggers ?

Solution:

Sorry, no. This requires MySQL root of the server. If you try, you will get the error "Access denied; you need the SUPER privilege for this operation ".This means we do not allow triggers, even though they are supported in MySQL 5.x.x.

For a potential work-around to use MySQL trigger, please see Brintech.net.
Knowledgebase Article 52,032 views bookmark tags: mysql trigger (updated 1203 days ago)


Was this resource helpful?

Did this resolve your issue?


Please add any other comments or suggestions about this content:





Recommended Help Content

I am prompted to set a new MySQL password. What does this mean and how do I change it? (updated 1067 days ago)
Knowledgebase Article 67,413 views tags: connect database mysql password phpmyadmin username

I get the following database connection error: Warning: mysql_connect() [function.mysql-connect]: Host 'host#.HostMonster.com' is blocked because of many connection errors; unblock with 'mysqlad (updated 94 days ago)
Knowledgebase Article 104,613 views tags: blocked connection host localhost mysql

Users having problems connecting to mysql database using SSH and/or putty/other client. (updated 1822 days ago)
Knowledgebase Article 62,219 views tags: connection ip mysql putty ssh whitelist

Related Help Content

This article will explain how to change or reset the password for a MySQL user. (updated 40 days ago)
Knowledgebase Article 504 views tags: change mysql password reset user

How do I make my MySQL database compatible with the version you provide? (updated 2123 days ago)
Knowledgebase Article 84,093 views tags: database mysql

How do I grant permissions to cPanel for my MySQL database administrator without giving them the domain password? (updated 2121 days ago)
Knowledgebase Article 85,137 views tags: access mysql password permission

How can I connect to our MySQL database from Dreamweaver? (updated 1132 days ago)
Knowledgebase Article 100,132 views tags: connecting database dream mysql weaver

This article will show a few MySQL errors along with explanations as to why they might be occurring. (updated 916 days ago)
Knowledgebase Article 15,218 views tags: errors mysql

This article will explain how to connect your scripts to your MySQL databases. (updated 919 days ago)
Knowledgebase Article 29,245 views tags: database mysql scripts

This article will explain MySQL database and user creation and deletion, and explain how to assign a user to a database. (updated 153 days ago)
Knowledgebase Article 471,365 views tags: creation database mysql

How do I create a MySQL backup? (updated 458 days ago)
Knowledgebase Article 155,249 views tags: backup database mysql