Re: [ALUG] Very basic mysql problem

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