RE: Grant problem
There are precedence rules and these are discussed in the manual. http://dev.mysql.com/doc/mysql/en/Connection_access.html Since you are granting at the database level you will see the changes in the db table and not the user table. -Original Message- From: Cam To: Mysql List Sent: 7/30/04 12:06 PM Subject: Grant problem I'm running the scarab problem reporting system and and trying to grant some privileges to a user and don't understand why it isn't working. I have the following user that I can see in the USER table mysql select user,host,password,Insert_priv from user where user='scarab' and host='localhost.localdomain'; ++---+--+-+ | user | host | password | Insert_priv | ++---+--+-+ | scarab | localhost.localdomain | 6324f94c732accc0 | N | ++---+--+-+ 1 row in set (0.00 sec) Notice how this user has no insert priv and has a password. If I now give the command mysql grant all privileges on scarab.* to 'scarab'@'localhost.localdomain' identified by 'secret'; Query OK, 0 rows affected (0.00 sec) Here comes my first question Why are there no rows affected? Anyway I query the user table and see that the password has been changed but the privileges have not. mysql select user,host,password,Insert_priv from user where user='scarab' and host='localhost.localdomain'; ++---+--+-+ | user | host | password | Insert_priv | ++---+--+-+ | scarab | localhost.localdomain | 428567f408994404 | N | ++---+--+-+ 1 row in set (0.00 sec) I've tried several combinations and even 'flush privileges' although the manual says that I don't have to. The complete listing of the table goes something like mysql select user,host,password,Insert_priv from user; ++---+--+-+ | user | host | password | Insert_priv | ++---+--+-+ | root | localhost | | Y | | root | kskLinux | | Y | || localhost | | N | || kskLinux | | N | | scarab | localhost | 6324f94c732accc0 | N | | scarab | | | N | | scarab | 127.0.0.1 | | N | | scarab | localhost.localdomain | 428567f408994404 | N | | scarab | % | 6324f94c732accc0 | N | ++---+--+-+ 9 rows in set (0.03 sec) So now, even though '[EMAIL PROTECTED]' has a password when I login and don't give a password I get in see below. [EMAIL PROTECTED] root]# mysql -u scarab -h localhost.localdomain -p scarab Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 to server version: 4.0.20-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. If I try to give a password it fails. Is there a precidence rule in effect here? I'm so confused. :( what am I doing wrong? Cheers Cam -- 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: grant problem!!!
[EMAIL PROTECTED] wrote: hi, I am having problems with mysql. 1. I downloaded mysql on to my system. 2.installed it 3. ran the server using the command prompt C:\mysql\bin\mysqld --console it gave me the results that i could start using the service. 4. i started mysql on another command prompt. what i am trying to do is i have to enter a huge genome sequence into a field. In order to do tht i have to change the global and session variables in mysql. i can change the session variables but i am not able to change the global variables. I gave the command: set global max_allowed_packet=4; it said: Access denied. You need the SUPER privilege for this operation. Then i created a database genome_db . then at the command promp i typed grant all privileges on genome_db.* to root@localhost identified by ' '; User 'root'@'localhost' by default has all privileges. i got the result as: Access denied for user: @'localhost' to database 'genome_db' dont know what to do:( confused You are connected as anonymous user. Use -u option of mysql client to specify username and connect to the MySQL server as a root: mysql -uroot -- 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]
SV: GRANT problem
GRANT insert,delete,update,select on phonewatch.* to [EMAIL PROTECTED] identified by 'password' works. GRANT insert,delete,update,select on phonewatch.* to datatal identified by 'password' do not. Can someone please test this and verify if it's a bug? -Ursprungligt meddelande- Från: Nathaniel Mallet [mailto:[EMAIL PROTECTED] Skickat: den 24 oktober 2003 03:04 Till: Rory McKinley; Datatal AB - Gauffin, Jonas Kopia: [EMAIL PROTECTED] Ämne: RE: GRANT problem I was having the same problems trying to get a user added to a new DB, so here's are the commands I used: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@localhost IDENTIFIED BY 'password'; FLUSH PRIVILEGES; where user and password are whatever you need it to be. I've never had much luck with % as host, so specify localhost for you user, and you should be all set. Nat -Original Message- From: Rory McKinley [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 6:21 AM To: Datatal AB - Gauffin, Jonas Cc: [EMAIL PROTECTED] Subject: Re: GRANT problem Ok. I'm stumped. If I'm reading the manual correctly, you were right about not hving to specify the host..the only difference between your version and the manual is that they use single quotes around the user name but I can't see how that makes any difference. I normally just specfiy hosts because using wildcards for hosts makes me nervous - hey, even paranoid people have enemies :) If anyone knows the answer to this I would be interested in knowing what it is too Sorry I can't be of more help Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 12:05 PM Subject: SV: GRANT problem it works if I specify the host. Why doesn't % work as host? -Ursprungligt meddelande- Från: Rory McKinley [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 11:56 Till: Datatal AB - Gauffin, Jonas Ämne: Re: GRANT problem thinking. In one of your follow up posts I see that you have the command as this : C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD Try C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -p And enter password at the prompt Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:45 AM Subject: SV: GRANT problem Not sure if this will help - in your GRANT statement do you not need to specify a host for the user e.g. GRANT.. to datatal @ your_host_name.?. GRANT uses % as host if none is specified. % = all hosts. any other ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] forums.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: GRANT problem
GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; yes. no diffrence. Specifying '%' or no host doesn't work for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SV: GRANT problem
What do you mean by ' doesn't work ' ? Have you tried connecting from another machine? Datatal AB - Gauffin, Jonas wrote: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; yes. no diffrence. Specifying '%' or no host doesn't work for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: SV: GRANT problem
I get access denied (from mysql.exe and myodbc) when specifying no host or % as host in the grant statement. -Ursprungligt meddelande- Från: gerald_clark [mailto:[EMAIL PROTECTED] Skickat: den 24 oktober 2003 15:11 Till: Datatal AB - Gauffin, Jonas Kopia: [EMAIL PROTECTED] Ämne: Re: SV: GRANT problem What do you mean by ' doesn't work ' ? Have you tried connecting from another machine? Datatal AB - Gauffin, Jonas wrote: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; yes. no diffrence. Specifying '%' or no host doesn't work for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SV: SV: GRANT problem
Use 'localhost' as the host unless you are specifying the grant to be for users on another machine. '%' stands for all machines except 'localhost'. Datatal AB - Gauffin, Jonas wrote: I get access denied (from mysql.exe and myodbc) when specifying no host or % as host in the grant statement. -Ursprungligt meddelande- Från: gerald_clark [mailto:[EMAIL PROTECTED] Skickat: den 24 oktober 2003 15:11 Till: Datatal AB - Gauffin, Jonas Kopia: [EMAIL PROTECTED] Ämne: Re: SV: GRANT problem What do you mean by ' doesn't work ' ? Have you tried connecting from another machine? Datatal AB - Gauffin, Jonas wrote: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; yes. no diffrence. Specifying '%' or no host doesn't work for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: SV: SV: GRANT problem
Use 'localhost' as the host unless you are specifying the grant to be for users on another machine. '%' stands for all machines except 'localhost'. I know. And the is exactly what I want. Datatal AB - Gauffin, Jonas wrote: I get access denied (from mysql.exe and myodbc) when specifying no host or % as host in the grant statement. -Ursprungligt meddelande- Från: gerald_clark [mailto:[EMAIL PROTECTED] Skickat: den 24 oktober 2003 15:11 Till: Datatal AB - Gauffin, Jonas Kopia: [EMAIL PROTECTED] Ämne: Re: SV: GRANT problem What do you mean by ' doesn't work ' ? Have you tried connecting from another machine? Datatal AB - Gauffin, Jonas wrote: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; yes. no diffrence. Specifying '%' or no host doesn't work for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: GRANT problem
Additional info: the user is added to mysql.user with no privileges. the user is added to mysql.db with insert,update,delete,select privileges on phonewatch db. When I try to connect to the db, C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD, I get ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) please help -Ursprungligt meddelande- Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 09:15 Till: [EMAIL PROTECTED] Ämne: GRANT problem Hello I've created an account by using: GRANT insert,update,select,delete on phonewatch.* to datatal identified by 'MYPASSWORD' I cant connect(mysql.exe or myodbc) to the db with the new account, and I did not receive any errormessages when creating the account. Have I forgot something? Med vänlig hälsning/Best Regards Datatal Utveckling AB Jonas Gauffin Tel direct: +46 (0) 498 25 30 16 Tel Support: +46 (0) 498 25 30 30 Fax: +46 (0) 498 25 30 99 http://www.datatal.se I try every day, but sometimes I fail -- 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]
SV: GRANT problem
yep. but that does only apply when using INSERT INTO, right? GRANT should do that by itself? anyway, it didn't help. didn't help to restart mysqld either. mysql select * from db where user='datatal'; +--++-+-+-+-+-+-+---++-+++---+--+ | Host | Db | User| Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | +--++-+-+-+-+-+-+---++-+++---+--+ | %| phonewatch | datatal | Y | Y | Y | Y | N | N | N | N | N | N | N | N| +--++-+-+-+-+-+-+---++-+++---+--+ mysql select * from db where user='datatal'; +--++-+-+-+-+-+-+---++-+++---+--+ | Host | Db | User| Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | +--++-+-+-+-+-+-+---++-+++---+--+ | %| phonewatch | datatal | Y | Y | Y | Y | N | N | N | N | N | N | N | N| +--++-+-+-+-+-+-+---++-+++---+--+ -Ursprungligt meddelande- Från: Franz, Fa. PostDirekt MA [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 11:03 Till: Datatal AB - Gauffin, Jonas Ämne: AW: GRANT problem Hi Jonas, did you send a 'FLUSH PRIVILEGES' after the GRANT-Statement ? If not, MySQL-Srver doesn't read the privileges-Table again. mfg Klaus -Ursprungligt meddelande- Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 10:44 Till: [EMAIL PROTECTED] Ämne: SV: GRANT problem Additional info: the user is added to mysql.user with no privileges. the user is added to mysql.db with insert,update,delete,select privileges on phonewatch db. When I try to connect to the db, C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD, I get ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) please help -Ursprungligt meddelande- Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 09:15 Till: [EMAIL PROTECTED] Ämne: GRANT problem Hello I've created an account by using: GRANT insert,update,select,delete on phonewatch.* to datatal identified by 'MYPASSWORD' I cant connect(mysql.exe or myodbc) to the db with the new account, and I did not receive any errormessages when creating the account. Have I forgot something? Med vänlig hälsning/Best Regards Datatal Utveckling AB Jonas Gauffin Tel direct: +46 (0) 498 25 30 16 Tel Support: +46 (0) 498 25 30 30 Fax: +46 (0) 498 25 30 99 http://www.datatal.se I try every day, but sometimes I fail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- 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: GRANT problem
Hi Jonas Not sure if this will help - in your GRANT statement do you not need to specify a host for the user e.g. GRANT.. to datatal @ your_host_name.?. Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 9:14 AM Subject: GRANT problem Hello I've created an account by using: GRANT insert,update,select,delete on phonewatch.* to datatal identified by 'MYPASSWORD' I cant connect(mysql.exe or myodbc) to the db with the new account, and I did not receive any errormessages when creating the account. Have I forgot something? Med vänlig hälsning/Best Regards Datatal Utveckling AB Jonas Gauffin Tel direct: +46 (0) 498 25 30 16 Tel Support: +46 (0) 498 25 30 30 Fax: +46 (0) 498 25 30 99 http://www.datatal.se I try every day, but sometimes I fail -- 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]
SV: GRANT problem
Not sure if this will help - in your GRANT statement do you not need to specify a host for the user e.g. GRANT.. to datatal @ your_host_name.?. GRANT uses % as host if none is specified. % = all hosts. any other ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SV: GRANT problem
it works if I specify the host. Why doesn't % work as host? -Ursprungligt meddelande- Från: Rory McKinley [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 11:56 Till: Datatal AB - Gauffin, Jonas Ämne: Re: GRANT problem thinking. In one of your follow up posts I see that you have the command as this : C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD Try C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -p And enter password at the prompt Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:45 AM Subject: SV: GRANT problem Not sure if this will help - in your GRANT statement do you not need to specify a host for the user e.g. GRANT.. to datatal @ your_host_name.?. GRANT uses % as host if none is specified. % = all hosts. any other ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: GRANT problem
Ok. I'm stumped. If I'm reading the manual correctly, you were right about not hving to specify the host..the only difference between your version and the manual is that they use single quotes around the user name but I can't see how that makes any difference. I normally just specfiy hosts because using wildcards for hosts makes me nervous - hey, even paranoid people have enemies :) If anyone knows the answer to this I would be interested in knowing what it is too Sorry I can't be of more help Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 12:05 PM Subject: SV: GRANT problem it works if I specify the host. Why doesn't % work as host? -Ursprungligt meddelande- Från: Rory McKinley [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 11:56 Till: Datatal AB - Gauffin, Jonas Ämne: Re: GRANT problem thinking. In one of your follow up posts I see that you have the command as this : C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD Try C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -p And enter password at the prompt Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:45 AM Subject: SV: GRANT problem Not sure if this will help - in your GRANT statement do you not need to specify a host for the user e.g. GRANT.. to datatal @ your_host_name.?. GRANT uses % as host if none is specified. % = all hosts. any other ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: GRANT problem
I was having the same problems trying to get a user added to a new DB, so here's are the commands I used: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@localhost IDENTIFIED BY 'password'; FLUSH PRIVILEGES; where user and password are whatever you need it to be. I've never had much luck with % as host, so specify localhost for you user, and you should be all set. Nat -Original Message- From: Rory McKinley [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 6:21 AM To: Datatal AB - Gauffin, Jonas Cc: [EMAIL PROTECTED] Subject: Re: GRANT problem Ok. I'm stumped. If I'm reading the manual correctly, you were right about not hving to specify the host..the only difference between your version and the manual is that they use single quotes around the user name but I can't see how that makes any difference. I normally just specfiy hosts because using wildcards for hosts makes me nervous - hey, even paranoid people have enemies :) If anyone knows the answer to this I would be interested in knowing what it is too Sorry I can't be of more help Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 12:05 PM Subject: SV: GRANT problem it works if I specify the host. Why doesn't % work as host? -Ursprungligt meddelande- Från: Rory McKinley [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 11:56 Till: Datatal AB - Gauffin, Jonas Ämne: Re: GRANT problem thinking. In one of your follow up posts I see that you have the command as this : C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD Try C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -p And enter password at the prompt Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:45 AM Subject: SV: GRANT problem Not sure if this will help - in your GRANT statement do you not need to specify a host for the user e.g. GRANT.. to datatal @ your_host_name.?. GRANT uses % as host if none is specified. % = all hosts. any other ideas? -- 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: GRANT problem
Have you tried: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; On Thu, 2003-10-23 at 21:03, Nathaniel Mallet wrote: I was having the same problems trying to get a user added to a new DB, so here's are the commands I used: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO user@localhost IDENTIFIED BY 'password'; FLUSH PRIVILEGES; where user and password are whatever you need it to be. I've never had much luck with % as host, so specify localhost for you user, and you should be all set. Nat -Original Message- From: Rory McKinley [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 6:21 AM To: Datatal AB - Gauffin, Jonas Cc: [EMAIL PROTECTED] Subject: Re: GRANT problem Ok. I'm stumped. If I'm reading the manual correctly, you were right about not hving to specify the host..the only difference between your version and the manual is that they use single quotes around the user name but I can't see how that makes any difference. I normally just specfiy hosts because using wildcards for hosts makes me nervous - hey, even paranoid people have enemies :) If anyone knows the answer to this I would be interested in knowing what it is too Sorry I can't be of more help Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 12:05 PM Subject: SV: GRANT problem it works if I specify the host. Why doesn't % work as host? -Ursprungligt meddelande- Frn: Rory McKinley [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 11:56 Till: Datatal AB - Gauffin, Jonas mne: Re: GRANT problem thinking. In one of your follow up posts I see that you have the command as this : C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD Try C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -p And enter password at the prompt Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:45 AM Subject: SV: GRANT problem Not sure if this will help - in your GRANT statement do you not need to specify a host for the user e.g. GRANT.. to datatal @ your_host_name.?. GRANT uses % as host if none is specified. % = all hosts. any other ideas? -- 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 on Darwin (Mac OS X 10.2) grant problem
2. Grants aren't working. Almost for each db we have the grant I did is something like : grant all on db.* to 'user'@'%.domain.com' identified by 'password'; So, I end up with a user with no global privilege in the user table, and a entry in the db table with all privs. User table : '%.domain.com', user, pass, N for the rest, exept Lock_tables_priv is Y. Db table : '%.domain.com', db, user, Y for the rest. When users connect from the web server (another machine), they can connect to the mysql server, but they can't do anything. We get : select command denied to user: '[EMAIL PROTECTED]' for table 'table' Have one of these users connect and issue this statement: SELECT CURRENT_USER(); If the username part of the result value is empty (nothing before the '@' character), you probably have a problem of these users actually being authenticated using an anonymous-user account. Dump those accounts by connecting to the server as root and issuing these statements: mysql DELETE FROM mysql.user WHERE User = ''; mysql FLUSH PRIVILEGES; Then have the user try again. I get something like : [EMAIL PROTECTED], which fits the user in the user and db table. I suppose it's right... Also, I want to point out that those exacts same privs where working right on my intel box... Any new hints on this ? Nicolas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL on Darwin (Mac OS X 10.2) grant problem
Hi ! Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just crached, I had to recover on another hardware, a Mac OS X 10.2, wih mysql-max 4.0.15. The restore went well, but I have some problems : 1. All tables/database are now lower case. This not a major issue, as the dbs are still running ok. I'll handle it later when the intel server is back up again. 2. Grants aren't working. Almost for each db we have the grant I did is something like : grant all on db.* to 'user'@'%.domain.com' identified by 'password'; So, I end up with a user with no global privilege in the user table, and a entry in the db table with all privs. User table : '%.domain.com', user, pass, N for the rest, exept Lock_tables_priv is Y. Db table : '%.domain.com', db, user, Y for the rest. When users connect from the web server (another machine), they can connect to the mysql server, but they can't do anything. We get : select command denied to user: '[EMAIL PROTECTED]' for table 'table' If we connect as root, the select is working properly. It's not the host either, I tried with % as hosts, and it didn't work. Any hints ? Nicolas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Darwin (Mac OS X 10.2) grant problem
At 11:30 -0400 10/14/03, Nicolas Ross wrote: Hi ! Our normal server is on RedHat 7.3 / mysql-max 4.0.14. The server just crached, I had to recover on another hardware, a Mac OS X 10.2, wih mysql-max 4.0.15. The restore went well, but I have some problems : 1. All tables/database are now lower case. That's because HFS+ filesystems on Mac OS X are not case sensitive. The server runs with lower_case_table_names on by default on Mac OS X as a result. This not a major issue, as the dbs are still running ok. I'll handle it later when the intel server is back up again. 2. Grants aren't working. Almost for each db we have the grant I did is something like : grant all on db.* to 'user'@'%.domain.com' identified by 'password'; So, I end up with a user with no global privilege in the user table, and a entry in the db table with all privs. User table : '%.domain.com', user, pass, N for the rest, exept Lock_tables_priv is Y. Db table : '%.domain.com', db, user, Y for the rest. When users connect from the web server (another machine), they can connect to the mysql server, but they can't do anything. We get : select command denied to user: '[EMAIL PROTECTED]' for table 'table' Have one of these users connect and issue this statement: SELECT CURRENT_USER(); If the username part of the result value is empty (nothing before the '@' character), you probably have a problem of these users actually being authenticated using an anonymous-user account. Dump those accounts by connecting to the server as root and issuing these statements: mysql DELETE FROM mysql.user WHERE User = ''; mysql FLUSH PRIVILEGES; Then have the user try again. If we connect as root, the select is working properly. It's not the host either, I tried with % as hosts, and it didn't work. Any hints ? Nicolas -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on Darwin (Mac OS X 10.2) grant problem
2. Grants aren't working. Almost for each db we have the grant I did is something like : grant all on db.* to 'user'@'%.domain.com' identified by 'password'; So, I end up with a user with no global privilege in the user table, and a entry in the db table with all privs. User table : '%.domain.com', user, pass, N for the rest, exept Lock_tables_priv is Y. Db table : '%.domain.com', db, user, Y for the rest. When users connect from the web server (another machine), they can connect to the mysql server, but they can't do anything. We get : select command denied to user: '[EMAIL PROTECTED]' for table 'table' Have one of these users connect and issue this statement: SELECT CURRENT_USER(); If the username part of the result value is empty (nothing before the '@' character), you probably have a problem of these users actually being authenticated using an anonymous-user account. Dump those accounts by connecting to the server as root and issuing these statements: mysql DELETE FROM mysql.user WHERE User = ''; mysql FLUSH PRIVILEGES; Then have the user try again. I get something like : [EMAIL PROTECTED], which fits the user in the user and db table. I suppose it's right... Also, I want to point out that those exacts same privs where working right on my intel box... Thanks Nicolas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a grant problem.
Matthew, Tuesday, March 05, 2002, 12:05:46 AM, you wrote: MD a while ago I had problems with users on mysql. MD I am trying to login as root from the local host using password and I get MD access denied using password=YES Usually it means that you are using wrong password for your user. Take a look at: http://www.mysql.com/doc/A/c/Access_denied.htm You can find info about causes of 'Access denied' errors. MD the host column of my user table is set to % and I have done a flush MD privileges MD and from other certain hosts I cannot login as root remote MD my user table looks like MD host=% and everything else is set to Y MD Why is this ??? MD Matt -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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
a grant problem.
Hi, a while ago I had problems with users on mysql. I am trying to login as root from the local host using password and I get access denied using password=YES the host column of my user table is set to % and I have done a flush privileges and from other certain hosts I cannot login as root remote my user table looks like host=% and everything else is set to Y Why is this ??? Many thanks, Matt - 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