Anytime I attempt to change the permissions of any users, PHPmyadmin gives me "#1045 - Access denied for user '******'@'%' (using password: YES)". Any workarounds for this fucker? :food-smiley-010:
1045 MySQL Error
- Thread starter UrbanFarmer
- Start date
You need to do it from a user account that has GRANT privileges. If you are on a shared host/VPS, generally it will be the first mySQL account you were given when you set up the account.
Also, rootacct@localhost may not necessarily be the same as rootacct@%
as you see, there would be 2 separate entries in the users table.
Also, rootacct@localhost may not necessarily be the same as rootacct@%
as you see, there would be 2 separate entries in the users table.