Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

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

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
2 posts • Page 1 of 1
nik
Posts: 13
Joined: Wed May 07, 2014 10:19 pm

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

Post by nik » Sun May 22, 2016 8:38 pm

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'
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

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

Post by skurudo » Mon May 23, 2016 7:10 am

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
Top


Post Reply
  • Print view

2 posts • Page 1 of 1

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password