Access Control in MySQL Stored Routines: DEFINER, INVOKER & SQL SECURITY

Kedar
January 30, 2012

MySQL Stored Routines (functions and procedures) are not only used for improving performance but also they’re handy when it comes to enhancing security and restricting user access. This post briefs…

View Post

Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines

Kedar
September 24, 2022

In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a “Friday”, so much so that they cannot believe…

View Post

MySQL 8 Resource Group – introduction and dynamic allocation

Kedar
September 7, 2018

Introduction to resource groups in MySQL 8 and dynamical allocation to threads

View Post

How to fix definer does not exist error 1449 MySQL

Kedar
March 23, 2015

Explaining and providing solutions of MySQL error 1449: The user specified as a definer does not exist using SQL SECURITY INVOKER and DEFINER.

View Post

19 comments

How To Generate Random test Data In MySQL

Kedar
July 5, 2012

Are you tired of manually generating test data for your MySQL tables? If you’re looking for random data generator, look no further! Introducing the MySQL Random Data Generator, a powerful…

View Post

Kedar’s Blog Performance Statistics-Year 2010

Kedar
January 21, 2011

This post is dedicated to blog performance and statistics by analytical numbers. So, how did the blog perform in 2010? Below is the simple statistics to explain the blog performance…

View Post