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 --