GRANT syntax problem

[Anon]

Hi folks
I'm trying to create a user with all privileges.

Here is what I'm trying....

GRANT ALL TO nick@localhost IDENTIFIED BY "password";

..or

GRANT ALL ON ALL TO nick@localhost IDENTIFIED BY "password";

I have read the Manual but I\m not feeeling very clever and just can't get any joy.

Any help appreciated

Nick

[smarlowe]

Not sure which alias etc... your dbms uses, but on mine it's public:

grant all on some_table to public;

[Anon]

I'm using MySQL and trying to create a user that has all priv's on all db's like the root user.

Or at the least all priv's on a db.

Thanks

Nick

[smarlowe]

On postgresql you can use public to say anyone can do anything. I thought that was where you were heading.

Acutally, it just looks like you're using too much name.

I'm not sure how to add people to mysql, but likely the name would just be something like smarlowe, not [e-mail].

As for making a single user like 'root' on a particular database, usually all you have to do in most dbms systems is assigned ownership of the db to that user.

[Anon]

Thanks Scott, I'll work on it!

Nick

[[deleted]]

The manual isn't that complex is it? :-)

GRANT ALL ON database.table TO user@host IDENTIFIED BY 'password';

[Anon]

Thanks Vincent,

I've got it now. Do I have to do this for each database(GRANT ALL) or can I do somthing so the user has that access across everything?

Reason being I need to mess with MySQL and my Databases without being root.

Hope that make some sense!

Cheers

Nick

[[deleted]]

something like this will give a user access to each table of every database:

GRANT ALL ON . TO user@host IDENTIFIED BY 'password'

Did you check out the MySQL manual yet?

[Anon]

Certainly did though I admit to some tardiness in the last Q.

Thanks for the pointers

Nick