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

6 comments

Killer Blog for MySQL Administrators

Kedar
December 9, 2024

This is by far the most killer MySQL blog that I wanted to write for really long as a part of a Killer DBA series. Time is hard to find,…

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