How to create users in MySQL4

Question

I tried using the "create user" command in a MySQL4 database (something similar to what is available in the MySQL5 docs), but it failed. Can someone provide me the right syntax?

Have you looked at the old documentation? dev.mysql.com/doc/refman/4.1/en/user-account-management.html — Marcus
– Marcus, Commented Oct 14, 2011 at 6:53
What is the full create user command that you have tried so far? — Tom Mac
– Tom Mac, Commented Oct 14, 2011 at 7:09
@Tom - It didn't work with a create user, but worked with the grant statement. — Jason
– Jason, Commented Oct 14, 2011 at 8:29

Jeremy Smyth · Accepted Answer · 2011-10-14 08:24:42Z

3

Users are created the first time you GRANT them a privilege.

From http://dev.mysql.com/doc/refman/4.1/en/grant.html :

The GRANT statement creates MySQL user accounts and grants rights to accounts.

So, let's say you have a database "mydb", with a table "mytable". If you want to create a user "jason", with the password "pwd123!" who has SELECT privileges on this table, you can do this:

grant select on mydb.mytable to 'jason'@'hostname' identified by 'pwd123!';

The usual caveats about hostname apply.

If you want to give jason full permissions on mydb:

grant all on mydb.* to 'jason'@'hostname' identified by 'pwd123!';

Important note: every time you use identified by, you're changing the password for that user/hostname, so you you will typically only use this syntax when creating a user!

answered Oct 14, 2011 at 8:24

Jeremy Smyth

23.6k2 gold badges57 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create users in MySQL4

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related