jshwhitlow
- Total activity 4
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 1
Activity overview
Latest activity by jshwhitlow-
jshwhitlow commented,
SOLUTION: When moving offices, our external IP address changed. The Definer for stored procedures stores the user and external IP such as 'user@192.168.1.31', this means the definer must be change...
-
jshwhitlow commented,
UPDATE 1: It appears it may related to the DEFINER for all the stored procedures. Its the same user but a different IP that originally created the procedures and now we moved and have a different...
-
jshwhitlow created a post,
Can't Access MySQL Procedures - Insufficient Privileges
I suddenly am experiencing an issue where I cannot edit or access Stored Procedures on my Database. I checked privileges and got: GRANT USAGE ON *.* TO 'REDACTED'@'REDACTED' IDENTIFIED BY PASSWOR...