Not Just Paranoid

Another site by Pete Maynard

MySQL manage users

To view all users.

SELECT user FROM mysql.user;

To add a MySQL user which is able to connect only from the local machine, and have access only to a database called soup.

# mysql -u root -p
INSERT INTO mysql.user (Host,User,Password) VALUES('localhost','username',PASSWORD('password'));
GRANT USAGE ON *.* to username@localhost IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON soup.* TO username@localhost;

If you don’t run the first “FLUSH PRIVILEGES;” statemtnt you might get the following error:

ERROR 1133 (42000): Can't find any matching row in the user table

To delete users

DELETE FROM mysql.user WHERE User='username';

A really got site to look up MySQL commands is:

18 Dec 2011 | Tags ( adding user MySQL )

Website Last Updated on 15 Sep 2023 (CC BY-SA 4.0)

This site uses JQuery and nanogallery2 hosted by
for the Flickr photo feed and GoatCounter for user insights.