Hmaal Posted November 3, 2014 Posted November 3, 2014 I think I kinda locked myself out of mysql. I can log in using phpMyAdmin under any of the names that I created for the databases in the cPanel, but I think I did something wrong yesterday when I was trying to access the database incorrectly and exceeded my attempts. I attempted to change the max number of attempts allowed and I don't exactly remember what all I did, but I think I tried to change some permissions or something along those lines and ended up changing the permissions of the root account and now none of the accounts have any permissions. I was wondering if you guys could reset my mysql database, and if possible, do so without removing my tables, or reset the permissions back to default. Thanks. username: hmaaldomain: maalstudios.heliohost.orgserver: johnny
Byron Posted November 3, 2014 Posted November 3, 2014 Did you go to MySQL Account Maintenance Manage User Privileges and change the privileges there? It would have looked something like the screenshot below.
Hmaal Posted November 3, 2014 Author Posted November 3, 2014 I tried that, and it didn't seem to do anything. The users still have no grant permissions in the table and if I try to do anything like "flush privileges" I continue to get access denied.
Hmaal Posted November 3, 2014 Author Posted November 3, 2014 It seems to be working better, thanks. Also, Is there a way to update phpMyAdmin to its latest version?
Byron Posted November 3, 2014 Posted November 3, 2014 Also, Is there a way to update phpMyAdmin to its latest version? I don't know. I'll escalate this to Krydos and maybe he'll give you an answer.
Hmaal Posted November 3, 2014 Author Posted November 3, 2014 Alright. Thanks for your help. Much appreciated.
wolstech Posted November 4, 2014 Posted November 4, 2014 Just a comment on the PMA update...I actually recommend against it for performance reasons. The new one is very heavy on Ajax and a slow connection or load time (e.g. caused by High Load issues) very easily makes it hang up, where as the older non-Ajax versions just take longer to post changes. I used 4.x on another server and hate it for this reason alone. Other issues include gripes like its refusal to let you do things old ones can, like edit indexless / keyless tables (bad form on the db designers part, but a lot of software does use such tables for things like configuration).
Hmaal Posted November 4, 2014 Author Posted November 4, 2014 OK. I was just curious. Thanks for clearing that up.
Krydos Posted November 14, 2014 Posted November 14, 2014 If you would like to use a different version of Phpmyadmin than what is default in cPanel it is possible for users to install a different version on their account.
Recommended Posts