On Fri, 12 Jul 2002, Richard Hayes wrote: > I have created a mysql database "account" with Webmin and a user bw with > all the permissions. Also, I have a schema "account.sql" > > Using the command > > bash#> mysql -u <account> bw_accounting <file.sql > > I get the error 1044 Access denied for bw@localhost
mysql -u user -p database <file The -p tells MySQL to ask for a password from you. I usually alias mysql to mysql -p since I'm not about to start storing passwords in files all over the joint, and I usually use multiple different DB users. -- ----------------------------------------------------------------------- #include <disclaimer.h> Matthew Palmer, Geek In Residence http://ieee.uow.edu.au/~mjp16 -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
