Using a stored funciton


show more Using a stored funciton provides you with in-depth training on Developer. Taught by Bill Weinman as part of the MySQL Essential Training show less
please wait ...

Using a stored funciton

The CRUD application uses a stored function for a feature that's not readily visible. In order to see it, we'll need to update the permissions for the web user in phpMyAdmin. So, if we come over here to phpMyAdmin, and I'm just going to select Users and the web at local host user, and we'll come out here. And this user has been set up with minimal permissions. Just these data permissions, but in order to actually run and create a stored function, it needs to have these three permissions over here: create routine, alter routine, and execute routine.

So, we'll add those, and go ahead and press the Go button, and those privileges have now been updated. And now, we're going to reload this, but before we do that, I want to come out here to the XAMPP Manager and just restart the database. It may or may not be necessary. Sometimes it is. Sometimes it isn't, but when you update the Permissions table, it's always a good idea. So, I'm going to restart the database. I've got M...

Using a stored funciton
Video duration: 4m 9s 4h 24m Beginner

Viewers:

Using a stored funciton provides you with in-depth training on Developer. Taught by Bill Weinman as part of the MySQL Essential Training

Subject:
Developer
Software:
MySQL
Author:
please wait ...