The Problem

It can seem to be an ongoing battle. Trying to remember how you did something after you realize you did work it out “once upon a time” .

So they are

  1. Remembering that you already worked out a solution to a problem in the past.
  2. Remembering where you can find the answer again.

So what to do!

Well first thing to do is to write out the problem and the solution. The next thing is to have a place to put this information so it can be found again. This really comes down to making the writing part a habit so that it becomes natural.

Anyway, I’m working on a few solutions to this because I Have To if I’m going to use my time wisely and profitably.

Problem:

(I’m writing my own PHP/Mysql Website Script for a Project soley using Stored Procedures as the interface between the PHP and the Database so this might sound Geeky but it’s the only way to fly to do things correctly)

Now I’ve just managed to circumvent an issue phpmyadmin has with creating Stored Procedures for MySQL. The answer is, don’t use it as it messes up permissions.

The answer.

Use a PHP Script that connects to the databae using the same database connection data the script is going to use and send the Stored Procedure SQL commands that way. Then after it’s all done – go back into Cpanel and revoke all permissions for that user. Simple huh!

Well I’d best get back to the help desk and let them know of my solution to my own problem.

On the "off chance" that you actually liked this post,
how about liking us on Facebook?...

Powered By Facebook Like Post Plugin