mysqlimport access denied errors
Hi, I'm working on SOlaris 8 with MySQL v3.23.54. I'm trying to give a user 'user1' access to one of my databases 'db1', and specifically one table 'table1'. As root I've run: msql grant all on db1 to user1@localhost -and it appears to work fine. However when as the solaris user 'user1', I run the following from the shell prompt: $:/usr/local/mysql/bin/mysqlimport db1 table1.txt I get: /usr/local/mysql/bin/mysqlimport: Error: Access denied for user: 'user1@localhost' (Using password: NO), when using table: table1 -- I want this user 'user1' to be able to run the mysqlimport command without prompting for a password. Can you help? thanks. _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlimport access denied errors
At 13:04 + 12/20/02, Imran Khan wrote: Hi, I'm working on SOlaris 8 with MySQL v3.23.54. I'm trying to give a user 'user1' access to one of my databases 'db1', and specifically one table 'table1'. As root I've run: msql grant all on db1 to user1@localhost -and it appears to work fine. Try this instead: grant all on db1.* to user1@localhost However when as the solaris user 'user1', I run the following from the shell prompt: $:/usr/local/mysql/bin/mysqlimport db1 table1.txt I get: /usr/local/mysql/bin/mysqlimport: Error: Access denied for user: 'user1@localhost' (Using password: NO), when using table: table1 -- I want this user 'user1' to be able to run the mysqlimport command without prompting for a password. Can you help? thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php