update privilege of database and table

[Anon]

Dear all,

The userlogin and password for the database and its tables in mysql server are originally "root" and none respectively. How do we change the userlogin "simon" and password "simon" directly?

Sincerely yours,
Simon

[Anon]

As root, using the mysql command line:

grant select,insert,update,delete
on databasename.*
to simon@localhost
identified by "simon";