JeremyV
04-28-03, 05:34 PM
Just curious, I browsed the cpanel and phpmyadmin forums, but did not come across anyone else having this problem, so I'm afraid it is something f-ed up on my end.
I had a customer who signed up this afternoon submit a ticket regarding access denied errors when importing .sql files in phpMyAdmin. Curious.. I logged in and tried it myself, sure enough. Ok... so I run /usr/bin/fix_mysql_privilage_tables
Then, while logged into the shell I manually tried to import the .sql file. Not a problem, works fine. Sweet, so I assume that fixed it, and email him the resolution. 10 minutes later, he says he's getting the same errors :confused:
So, while logged into the shell again, I try to import another .sql file, and it gives me ACCESS DENIED.. blah blah. WTF? So, I run the fix privilage again.. and again, it lets me import the SQL data. Hmm... so curious, before contacting the customer I login to phpMyAdmin and try to upload the data from there... ACCESS DENIED!!! Argh. And right after trying it in phpMyAdmin.. it fudges up all access to the database even in the shell or scripts or anything.
So anyway.. I can import .sql files all day via shell, and get no problems at all. And, I can also edit, add, drop tables in phpmyadmin and it never complains about access denied... but the second you try to upload an SQL file, it kills that user and his permissions to do anything with his database.
So far no other users have complained about this... but I'm wondering if this is a known issue? Or has anyone seen this behavior before? Looks like phpmyadmin 2.5 is the latest version, so I may upgrade that and see if it helps.. but if there is another easy solution that would be better. :fork:
I had a customer who signed up this afternoon submit a ticket regarding access denied errors when importing .sql files in phpMyAdmin. Curious.. I logged in and tried it myself, sure enough. Ok... so I run /usr/bin/fix_mysql_privilage_tables
Then, while logged into the shell I manually tried to import the .sql file. Not a problem, works fine. Sweet, so I assume that fixed it, and email him the resolution. 10 minutes later, he says he's getting the same errors :confused:
So, while logged into the shell again, I try to import another .sql file, and it gives me ACCESS DENIED.. blah blah. WTF? So, I run the fix privilage again.. and again, it lets me import the SQL data. Hmm... so curious, before contacting the customer I login to phpMyAdmin and try to upload the data from there... ACCESS DENIED!!! Argh. And right after trying it in phpMyAdmin.. it fudges up all access to the database even in the shell or scripts or anything.
So anyway.. I can import .sql files all day via shell, and get no problems at all. And, I can also edit, add, drop tables in phpmyadmin and it never complains about access denied... but the second you try to upload an SQL file, it kills that user and his permissions to do anything with his database.
So far no other users have complained about this... but I'm wondering if this is a known issue? Or has anyone seen this behavior before? Looks like phpmyadmin 2.5 is the latest version, so I may upgrade that and see if it helps.. but if there is another easy solution that would be better. :fork: