• About Us
  • Contact Us
  • Privacy Policy
NSR-TECH
No Result
View All Result
  • Login
No Result
View All Result
NSR-TECH
No Result
View All Result
Home Tricks

MySQL you do not have the super privilege issue fix

nsr by nsr
January 19, 2021
in Tricks, Web Development
0
MySQL you do not have the super privilege issue fix

MySQL you do not have the super privilege issue fix

0
SHARES
173
VIEWS
Share on FacebookShare on Twitter

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.

READ ALSO

Upgrade PHP from 7.2 to 7.3 on Ubuntu OS

Enable CORS on Lumen API

Steps

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.

Check the latest posts

Tags: laravelmysql

Related Posts

Upgrade PHP from 7.2 to 7.3 on Ubuntu OS
Software Guides

Upgrade PHP from 7.2 to 7.3 on Ubuntu OS

February 8, 2021
Enable CORS on Lumen API
Laravel

Enable CORS on Lumen API

February 6, 2021
Quasar multiple file upload with laravel API
Laravel

Quasar multiple file upload with laravel API

January 21, 2021
Git branch not showing in Visual Studio Code fix
Others

Git branch not showing in Visual Studio Code fix

January 20, 2021
Laravel Specified Key Was Too Long Fix
Laravel

Laravel Specified Key Was Too Long Fix

January 19, 2021
how to seo vue.js site
Quasar

how to SEO vue.js site

January 10, 2021
Next Post
Laravel Specified Key Was Too Long Fix

Laravel Specified Key Was Too Long Fix

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

POPULAR POSTS

quasar-file-upload-img

Quasar file upload process with laravel API

January 21, 2021
lumen framework tutorial

Lumen framework tutorial for beginners

October 24, 2020

Run cordova without android studio

September 12, 2020
quasar google maps

Quasar Google maps with places

October 7, 2020
MySQL you do not have the super privilege issue fix

MySQL you do not have the super privilege issue fix

January 19, 2021

EDITOR'S PICK

Tools and techniques to create a website

Tools and techniques to create a website

November 24, 2020
Vue pagination with Laravel

Vue pagination with Laravel

October 10, 2020
website technologies

Website Technologies

November 24, 2020
how to seo vue.js site

how to SEO vue.js site

January 10, 2021

About

Nsrtech is a blog which brings you high quality and valuable articles to your life. All articles will be on different categories which all peoples can solve their issues in a single blog site.

Follow us

Categories

  • Laravel
  • Mobile Development
  • Networking Lessons
  • Others
  • Quasar
  • Quasar
  • Software Guides
  • Theories
  • Tricks
  • Vue
  • Web Development
  • Web Development Lessons

Recent Posts

  • Upgrade PHP from 7.2 to 7.3 on Ubuntu OS
  • Enable CORS on Lumen API
  • Quasar multiple file upload with laravel API
  • Git branch not showing in Visual Studio Code fix
  • Home
  • About Us
  • Contact Us
  • Privacy Policy

© 2020 NSR-TECH Blog .

No Result
View All Result
  • Homepages
    • Home Page 1
    • Home Page 2

© 2020 NSR-TECH Blog .

Welcome Back!

Login to your account below

Forgotten Password?

Create New Account!

Fill the forms bellow to register

All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In