6 Nov
2004
6 Nov
'04
12:07 p.m.
Chris Green wrote:
I'm having trouble getting started with mysql.
[SNIP]
Try this for instance (watch wrapping):
mysql -u root -p mysql Enter password: GRANT SELECT,INSERT,UPDATE,DELETE ON <db-name>.* TO <db-user>@localhost IDENTIFIED BY "user-pass"; ^d
Check access works: mysql -u <db-user> -p <db-name> ^d
To create a mysql database:
mysqladmin -u root -p create <db-name> Enter password:
To inject SQL data:
mysql -u root -p <db-name> < <db-name>.sql Enter password:
Hope that helps!
Cheers, Laurie.
--
--------------------------------------------------------------------
Laurie Brown
laurie@brownowl.com
--------------------------------------------------------------------