Easy step to fix the MySQL you do not have the super privilege issue.
Hello guys! In this article I am going to show you how to fix the MySQL you do not have the super privilege issue. Basically this is a common issue for developers. Especially for Laravel developers this issue may occur when migrating the normal tables or when using triggers on migrations. Most of the time this error will appear in servers but this has no guarantee that this error won’t appear in local development.
In detail, What this error describe is, In certain situations MySQL don’t allow users to create or alter tables in the database. Especially MySQL will be very strict in privilege’s in situations like triggering tables on a database. In that case you have to give the super privileges to do such things in database. If this occure in the server, you need the credentials of phpmyadmin to continue. Because in order to fix this issue you have to log into the phpadminpanel panel. The error will be look like following image.
1. Log into the phpmyadmin
2. Click on SQL tab
3. Add following line
SET GLOBAL log_bin_trust_function_creators = 1;
4. Click Go button.
Now you will grant super privilege to create, alter or make triggers to table in the database. The below image will be helpful in order to find the correct place to execute the command. And as an advise, If you are a normal user, please contact the administrator before executing this code to the MySQL phpmyadmin panel.
If that doesn’t work click on phpmyadmin logo on top and make sure you have not selected any databases and try that again.
That’s it!! If you have any questions please comment below. If you want to read more articles, click on below link.