re: mysqladmin access denied error
On Friday 20 December 2002 15:31, Imran Khan wrote: I'm using solaris 8 with mysql v 3.23.54. I want to enable a solaris user - 'user1', to use the mysqlimport command without using a password. I've run, as root, the following sql command: mysqlgrant all on db1.* to user1@localhost -this appears to work fine. However as user1 in the solaris shell, when I run: $:/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 So how can I allow a user to run mysqlimport to my db1 database, and without a password? To use mysqlimport you must have FILE privilege. It's not a database privilege, it's a global privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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 . - 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: mysqladmin access denied error
On Friday 20 December 2002 15:31, Imran Khan wrote: I'm using solaris 8 with mysql v 3.23.54. I want to enable a solaris user - 'user1', to use the mysqlimport command without using a password. I've run, as root, the following sql command: mysqlgrant all on db1.* to user1@localhost -this appears to work fine. However as user1 in the solaris shell, when I run: $:/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 So how can I allow a user to run mysqlimport to my db1 database, and without a password? To use mysqlimport you must have FILE privilege. It's not a database privilege, it's a global privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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 . - 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: mysqladmin access denied error
On Friday 20 December 2002 15:31, Imran Khan wrote: I'm using solaris 8 with mysql v 3.23.54. I want to enable a solaris user - 'user1', to use the mysqlimport command without using a password. I've run, as root, the following sql command: mysqlgrant all on db1.* to user1@localhost -this appears to work fine. However as user1 in the solaris shell, when I run: $:/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 So how can I allow a user to run mysqlimport to my db1 database, and without a password? To use mysqlimport you must have FILE privilege. It's not a database privilege, it's a global privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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 . - 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: mysqladmin access denied error
On Friday 20 December 2002 15:31, Imran Khan wrote: I'm using solaris 8 with mysql v 3.23.54. I want to enable a solaris user - 'user1', to use the mysqlimport command without using a password. I've run, as root, the following sql command: mysqlgrant all on db1.* to user1@localhost -this appears to work fine. However as user1 in the solaris shell, when I run: $:/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 So how can I allow a user to run mysqlimport to my db1 database, and without a password? To use mysqlimport you must have FILE privilege. It's not a database privilege, it's a global privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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 . - 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: mysqladmin access denied error
On Friday 20 December 2002 15:31, Imran Khan wrote: I'm using solaris 8 with mysql v 3.23.54. I want to enable a solaris user - 'user1', to use the mysqlimport command without using a password. I've run, as root, the following sql command: mysqlgrant all on db1.* to user1@localhost -this appears to work fine. However as user1 in the solaris shell, when I run: $:/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 So how can I allow a user to run mysqlimport to my db1 database, and without a password? To use mysqlimport you must have FILE privilege. It's not a database privilege, it's a global privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
