Koozali.org: home of the SME Server

MYSQL - Can't drop user(s)

Offline Teviot

  • *
  • 610
  • +0/-0
MYSQL - Can't drop user(s)
« on: September 23, 2006, 05:53:32 AM »
Hi Guys

I am still learning SME Server, Linux and Mysql.  I using MYPHPADMIN v 2.8.2 with MYQSL v4.1.20.  I am having trouble dropping user that aren't needed any more.  The error I get is


Quote
Error
SQL query:

DROP USER 'joomla'@ 'localhost';



MySQL said:  

#1268 - Can't drop one or more of the requested users


Can anyone help me ?

Adrian
Regards
M0GLJ
......................................................
I am new to SAIL SME Server v8b6 and have been using SME for many years.
I have already done some research and only ask questions if I still can't work it out.

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
MYSQL - Can't drop user(s)
« Reply #1 on: September 23, 2006, 07:19:34 AM »
Go into the MySQL database.

Select the user table.

Select Browse tab and delete the unwanted user.

Go to Privileges and reload the privileges.
Regards,
William

IF I give advise.. It's only if it was me....

Offline Teviot

  • *
  • 610
  • +0/-0
MYSQL - Can't drop user(s)
« Reply #2 on: September 23, 2006, 08:29:08 AM »
Thanks ... That worked and I learned something.

Thank you very much william_syd

Regards
Adrian
Regards
M0GLJ
......................................................
I am new to SAIL SME Server v8b6 and have been using SME for many years.
I have already done some research and only ask questions if I still can't work it out.

Offline Teviot

  • *
  • 610
  • +0/-0
MYSQL - Can't drop user(s)
« Reply #3 on: September 23, 2006, 08:32:02 AM »
Sorry Duplicate posting
Regards
M0GLJ
......................................................
I am new to SAIL SME Server v8b6 and have been using SME for many years.
I have already done some research and only ask questions if I still can't work it out.

Offline william_syd

  • *****
  • 1,608
  • +0/-0
  • Nothing to see here.
    • http://www.magicwilly.info
MYSQL - Can't drop user(s)
« Reply #4 on: September 23, 2006, 08:39:29 AM »
Quote from: "teviot"
Thanks ... That worked and I learned something.

Thank you very much william_syd

Regards
Adrian


I only had the same problem first time this week.

I might ask on the MySQL/PMA forums as to why.
Regards,
William

IF I give advise.. It's only if it was me....