user account troubles>>>

[Mikkel]

I have Mysql 5.0.22, php4.4.1. Apache 1.3.36. but having difficulties in creating a databse user account.

in mysql as root I tried using
mysql gallery2 -u root -p -e "GRANT ALL ON database1.* TO 4h77lgs@localhost IDENTIFIED BY '12345'"

I am not sure if I need to include the ' ' around the password. Pressing enter returns me a -> prompt. If I then type \q and try to login into mysql using mysql -u 4h771gs -p I revieve access denied.
Next I tried
CREATE USER 4h77lgs IDENTIFIED BY PASSWORD '12345'
SET PASSWORD FOR 4h77lgs = PASSWORD('12345')
GRANT ALL ON database1.* TO 4h77lgs@localhost IDENTIFIED BY '12345'

Can some please explain exactly what I need to type to create a database user and grant it rights to a databaes? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[sierra]

It looks as if commands entered at the mysql> prompt need to be terminated by a delimiter, which defaults to a semicolon:

mysql> CREATE USER 4h77lgs@localhost IDENTIFIED BY PASSWORD '12345';
mysql> GRANT ALL ON database1.* TO 4h77lgs@localhost IDENTIFIED BY '12345';
mysql> SET PASSWORD FOR 4h77lgs = PASSWORD('12345'); -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --