MySQL add user

tommytomato · 02-19-2004, 09:52 AM

Hi my OS is fedora core 1 with mysql 3.23.58

I've done the admin pass etc via the linux command line.

what i'm try to do is add a new user with its own database.

If been trying this , but it seem to change the admin pass.

Quote:

grant select, insert, update, delete, create, drop
on database_name.*
to new_user identified by 'pass-word';

any one help me out please.

TT

trickykid · 02-19-2004, 10:24 AM

Try something like this:

Code:

mysql> use <your-database-you-created>

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP
ON *.* TO 'username'@'your.host.domain' IDENTIFIED BY 'password';

mysql> FLUSH PRIVILEGES;