Page 1 of 1

ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'pma'@'localhost'

Posted: Sun May 22, 2016 8:38 pm
by nik
Base install - CentOS 6.7 x32

phpmyadmin - warning
Configuration of pmadb… not OK
General relation features Disabled

Ran

Code: Select all

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma.sh && chmod +x pma.sh && ./pma.sh
But got
ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'pma'@'localhost'

Re: ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'pma'@'localhost'

Posted: Mon May 23, 2016 7:10 am
by skurudo
nik wrote:Base install - CentOS 6.7 x32

Code: Select all

phpmyadmin - warning 
Configuration of pmadb… not OK
General relation features Disabled
You need mysql root pass for database in script (yeah, you can edit and add it manually) or in /root/.my.cnf

nik wrote:

Code: Select all

But got 
ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'pma'@'localhost'
Two reasons of "DROP failed":
- you don't have PMA user
- you don't have access to db to drop user.

You need mysql root pass for database in script (yeah, you can edit and add it manually) or in /root/.my.cnf