mysql.user does not reflect privileges granted correctly?
Greetings, I did: mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret'; But mysql select * from user where user='ltmuser'\G; shows: *** 1. row *** Host: localhost User: ltmuser Password: 132f058a4532ff99 Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: N Grant_priv: N References_priv: N Index_priv: N Alter_priv: N Show_db_priv: N Super_priv: N Create_tmp_table_priv: N Lock_tables_priv: N Execute_priv: N Repl_slave_priv: N Repl_client_priv: N ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 I thought the *_priv fields should all have 'Y' rather than 'N'. I also tried 'flush privileges' but it did not help. What I need to do is load data from a file into a table. mysql load data infile '/home/user/LTM/generate_report.pl.ltm_enroll_tmp' into table ltm_enrollment fields terminated by '\t'; ERROR 1045: Access denied for user: 'ltmuser'@'localhost' (Using password: YES) What privileges are needed for doing 'load data infile'? I can insert rows one by one into table ltm_enrollment as user 'ltmuser'@'localhost' without any problems. Would anybody tell me what's wrong? Thanks, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.user does not reflect privileges granted correctly?
Bing Du wrote: I did: mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret'; But mysql select * from user where user='ltmuser'\G; shows: :: that 'ltm' != 'ltmuser' :-) Or is the example a typo? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.user does not reflect privileges granted correctly?
Bing Du [EMAIL PROTECTED] wrote: Greetings, I did: mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret'; But mysql select * from user where user='ltmuser'\G; shows: *** 1. row *** Host: localhost User: ltmuser Password: 132f058a4532ff99 Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: N Grant_priv: N References_priv: N Index_priv: N Alter_priv: N Show_db_priv: N Super_priv: N Create_tmp_table_priv: N Lock_tables_priv: N Execute_priv: N Repl_slave_priv: N Repl_client_priv: N ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 I thought the *_priv fields should all have 'Y' rather than 'N'. Table 'user' contains global level privileges, but you set permissions on the database level. Check 'db' table. I also tried 'flush privileges' but it did not help. What I need to do is load data from a file into a table. mysql load data infile '/home/user/LTM/generate_report.pl.ltm_enroll_tmp' into table ltm_enrollment fields terminated by '\t'; ERROR 1045: Access denied for user: 'ltmuser'@'localhost' (Using password: YES) What privileges are needed for doing 'load data infile'? You must have FILE privilege. I can insert rows one by one into table ltm_enrollment as user 'ltmuser'@'localhost' without any problems. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.user does not reflect privileges granted correctly?
I've verified there is no user called 'ltm' in the mysql.user table. So, yeah, apparently that's a typo in my post. Sorry. So, to re-state my problem: I did: mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret'; But mysql.user shows 'N' in all the *_priv columns for user 'ltmuser'. Bing Bing Du wrote: I did: mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret'; But mysql select * from user where user='ltmuser'\G; shows: :: that 'ltm' != 'ltmuser' :-) Or is the example a typo? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.user does not reflect privileges granted correctly?
Thanks for the heads-up! Bing Du [EMAIL PROTECTED] wrote: Greetings, I did: mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret'; But mysql select * from user where user='ltmuser'\G; shows: *** 1. row *** Host: localhost User: ltmuser Password: 132f058a4532ff99 Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: N Grant_priv: N References_priv: N Index_priv: N Alter_priv: N Show_db_priv: N Super_priv: N Create_tmp_table_priv: N Lock_tables_priv: N Execute_priv: N Repl_slave_priv: N Repl_client_priv: N ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 I thought the *_priv fields should all have 'Y' rather than 'N'. Table 'user' contains global level privileges, but you set permissions on the database level. Check 'db' table. Ah, ok. 'db' table looks correct. I also tried 'flush privileges' but it did not help. What I need to do is load data from a file into a table. mysql load data infile '/home/user/LTM/generate_report.pl.ltm_enroll_tmp' into table ltm_enrollment fields terminated by '\t'; ERROR 1045: Access denied for user: 'ltmuser'@'localhost' (Using password: YES) What privileges are needed for doing 'load data infile'? You must have FILE privilege. I did not realize FILE privilege was not covered by 'grant all'. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql.user does not reflect privileges granted correctly?
Your grant statement give ltm all privileges on LTM and not on user. By default, ltm is granted usage on user. To see the privileges the user ltm has, try any of these two: select * from db where user='ltmuser'\G; show privileges for [EMAIL PROTECTED] Select from db should show ltm having all privileges on LTM and not user. HTH Babs -Ursprüngliche Nachricht- Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 25. März 2004 18:27 An: [EMAIL PROTECTED] Betreff: Re: mysql.user does not reflect privileges granted correctly? Bing Du [EMAIL PROTECTED] wrote: Greetings, I did: mysql grant all on LTM.* to [EMAIL PROTECTED] identified by 'secret'; But mysql select * from user where user='ltmuser'\G; shows: *** 1. row *** Host: localhost User: ltmuser Password: 132f058a4532ff99 Select_priv: N Insert_priv: N Update_priv: N Delete_priv: N Create_priv: N Drop_priv: N Reload_priv: N Shutdown_priv: N Process_priv: N File_priv: N Grant_priv: N References_priv: N Index_priv: N Alter_priv: N Show_db_priv: N Super_priv: N Create_tmp_table_priv: N Lock_tables_priv: N Execute_priv: N Repl_slave_priv: N Repl_client_priv: N ssl_type: ssl_cipher: x509_issuer: x509_subject: max_questions: 0 max_updates: 0 max_connections: 0 I thought the *_priv fields should all have 'Y' rather than 'N'. Table 'user' contains global level privileges, but you set permissions on the database level. Check 'db' table. I also tried 'flush privileges' but it did not help. What I need to do is load data from a file into a table. mysql load data infile '/home/user/LTM/generate_report.pl.ltm_enroll_tmp' into table ltm_enrollment fields terminated by '\t'; ERROR 1045: Access denied for user: 'ltmuser'@'localhost' (Using password: YES) What privileges are needed for doing 'load data infile'? You must have FILE privilege. I can insert rows one by one into table ltm_enrollment as user 'ltmuser'@'localhost' without any problems. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.user does not reflect privileges granted correctly?
Bing Du [EMAIL PROTECTED] wrote: Thanks for the heads-up! Bing Du [EMAIL PROTECTED] wrote: What I need to do is load data from a file into a table. mysql load data infile '/home/user/LTM/generate_report.pl.ltm_enroll_tmp' into table ltm_enrollment fields terminated by '\t'; ERROR 1045: Access denied for user: 'ltmuser'@'localhost' (Using password: YES) What privileges are needed for doing 'load data infile'? You must have FILE privilege. I did not realize FILE privilege was not covered by 'grant all'. Because FILE is a global level privilege: GRANT FILE ON *.* TO 'ltmuser'@'localhost' IDENTIFIED BY 'secret'; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]