Can anybody please explain the steps in adding a new user to mysql.
I'll never figure this out from the manual. In all respects I think
the mysql manual is pretty good except in the area of users and access
privileges.
I thought making perl connect to mysql through DBI was hard to set up,
but that is nothing compared to adding a new user to mysql. I set up
Apache, DBI, Perl, and DBD::mysql. I can send and retrieve values to
my database from web pages that call perl scripts, but I can't add a
new user to mysql. I can only access the database as root.
I've tried everything I could that was listed in the mysql official
manual to create user: test with pw: test** but I cannot do it. I
keep getting this error:
/root > mysql -h localhost -u test -ptest**
ERROR 1045: Access denied for user: 'test@localhost' (Using password:
YES)
thanks
--
Jeff Greer
B.S. computer science, University of MO - Rolla
"If travelling by plane is 'flying' then travelling by boat is
swimming.
If you want to experience the environment, get out of the vehicle."
SKYDIVE!
