How do I delete a mysql user?
... and how do I stop a mysql user requiring a password?
On 2004-11-17 21:19:23 +0000 Chris Green chris@areti.co.uk wrote:
How do I delete a mysql user?
Either "drop user ..." or "delete from mysql.user where ..." depending on version.
See http://dev.mysql.com/doc/mysql/en/Removing_users.html
... and how do I stop a mysql user requiring a password?
Blank the password column in mysql.user, perhaps. Ask yourself: are you sure you want to do that?
Remember to "flush privileges;" after editing users.
On Thu, Nov 18, 2004 at 01:27:09AM +0000, MJ Ray wrote:
On 2004-11-17 21:19:23 +0000 Chris Green chris@areti.co.uk wrote:
How do I delete a mysql user?
Either "drop user ..." or "delete from mysql.user where ..." depending on version.
I couldn't find "drop user ..." in my O'Reilly mysql book, hence the question.
Is removing the entry from the mysql.user table guaranteed to remove the user, there seem to be 'User' columns in quite a few of the other mysql database tables.
... and how do I stop a mysql user requiring a password?
Blank the password column in mysql.user, perhaps. Ask yourself: are you sure you want to do that?
Yes, it's a SoHo system behind a NAT (plus more) firewall, no access to any users except members of the family and no information of any use to anyone in the database anyway.
Remember to "flush privileges;" after editing users.
Aha, now that I have been forgetting and it may well explain the strange behaviour I have been seeing of course.
On 2004-11-18 09:09:28 +0000 Chris Green chris@areti.co.uk wrote:
I couldn't find "drop user ..." in my O'Reilly mysql book, hence the question.
Maybe it documents an old version? It wouldn't be the first time an O'Reilly book was out of date...
Is removing the entry from the mysql.user table guaranteed to remove the user, there seem to be 'User' columns in quite a few of the other mysql database tables.
I think it removes the user - that is, they can't connect any more. For completeness, you should remove any lines mentioning them in mysql.db and other tables, else you may get unexpected results if you add a user with the same name.
On Wed, 17 Nov 2004 21:19:23 +0000, Chris Green chris@areti.co.uk wrote:
How do I delete a mysql user?
... and how do I stop a mysql user requiring a password?
-- Chris Green (chris@areti.co.uk)
Hi Chris, Have a look here, I think you may find a good manual provides answers to your mySQL questions perhaps quicker than alug can.
http://dev.mysql.com/doc/mysql/en/Removing_users.html
Good luck, Jen
On Thu, Nov 18, 2004 at 08:16:17AM +0000, Jenny Hopkins wrote:
On Wed, 17 Nov 2004 21:19:23 +0000, Chris Green chris@areti.co.uk wrote:
How do I delete a mysql user?
... and how do I stop a mysql user requiring a password?
-- Chris Green (chris@areti.co.uk)
Hi Chris, Have a look here, I think you may find a good manual provides answers to your mySQL questions perhaps quicker than alug can.
Thanks, I'd forgotten that mysql documentation is rather better than Oracle documentation.
The thing is most of the user side of SQL/mysql I have no problems with as I use Oracle SQL every day at work. Thus writing even quite complex SQL queries is not a problem. However I tend to get a bit stuck with the admin side because I don't do that at work and anyway that's where the syntax and commands tend to be less standard.
I have the O'Reilly mysql pocket reference which provides most of what I need when I get stuck but it just wasn't quite complete enough when it got to deleting users.
-
Chris Green -
Jenny Hopkins -
MJ Ray