How to add users in sql

[Anon]

I wan't to know how i add mysql users to the mysql database.....

thnx.

[Anon]

In Linux, from the command prompt, connect using the command mysql -host "your Host"
-u "your username(maybe root)" -p

once connected issue command "use mysql"
then preform a simple insert statement into the user table ie. "insert into user values
('value1', 'value2')";

after adding users you must always then reload the grant tables. Check out the documentation at www.mysql.net for more.

[Anon]

As mysql administrator, in the MySQL shell:

grant select,update,insert,delete
on DATABASENAME.*
to USERNAME@localhost
identified by 'PASSWORD';

Exchange DATABASENAME, USERNAME and PASSWORD with the relevant values.

Note that this works immediately; you do not have to re-load the MySQL grant tables if you do it this way. Actually, I generally recommend against Jay's suggestion. The GRANT syntax is easier and closer to what is normally the procedure on other database systems.