3 replies to this topic

[Ewe Loon]

Ok, Im Able to create and drop databases,
but does anyone know the commands to assign users, and set the permissions for them

[gregwarner]

The syntax for creating users in MySQL is:

CREATE USER 'username'@'host' IDENTIFIED BY 'password';

Replace the lowercase words above with your info. For example, if I were creating myself, I would use:

CREATE USER 'greg'@'localhost' IDENTIFIED BY 'someweakpassword';

The syntax for granting permissions is such:

GRANT priv [,priv, ...] ON dbname.tablename TO 'username'@'host' IDENTIFIED BY 'password';

So, again, if I were granting SELECT, INSERT, and UPDATE permissions to myself on all tables stored in the 'myinventory' database, it would look like this:

GRANT SELECT, INSERT, UPDATE ON myinventory.* TO 'greg'@'localhost' IDENTIFIED BY 'someweakpassword';

Hope that helps. Check the MySQL documentation on their website for the full, unabridged syntax of these statements.

[Ewe Loon]

thank you

[gregwarner]

My pleasure.