Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: Teviot on September 23, 2006, 05:53:32 AM

Title: MYSQL - Can't drop user(s)
Post by: Teviot 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

Title: MYSQL - Can't drop user(s)
Post by: william_syd 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.

Title: MYSQL - Can't drop user(s)
Post by: Teviot on September 23, 2006, 08:29:08 AM

Thanks ... That worked and I learned something.

Thank you very much william_syd

Regards
Adrian

Title: MYSQL - Can't drop user(s)
Post by: Teviot on September 23, 2006, 08:32:02 AM

Sorry Duplicate posting

Title: MYSQL - Can't drop user(s)
Post by: william_syd 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.