Mailing List
Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
ODBC - ODBC with the MySQL Connector/ODBC driver
Perl - Perl support for MySQL with DBI and DBD::mysql
MySQL++ - Programming with the C++ API to MySQL
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
Search:  
Power your search with and, or, +, -, or "some phrase" operators.
RES: GRANT PRIVILEGES doesn 't perform the way I expect it to....?
   ?

RES: GRANT PRIVILEGES doesn 't perform the way I expect it to....?
   ?

2004-06-07       - By Renato Cramer

 Back
Hi Scott,

Really in user table not modify nothing, but in db table the privileges
appear ok.
Your user get message of access denied?

Regards,
Renato Cramer.

-- --Mensagem original-- --
De: Scott Fletcher [mailto:SFletcher@(protected)]
Enviada em: segunda-feira, 7 de junho de 2004 17:29
Para: mysql@(protected); scott@(protected)
Assunto: GRANT PRIVILEGES doesn 't perform the way I expect it to....??


I 'm having a little trouble with granting the correct privilege to the
user with one database instead of all databases. When I do this with
all databases, it work great..

--snip--
//Issued SQL Command...
GRANT ALL ON *.* TO 'Username '@ 'localhost.domain.com '
<mailto: 'Username '@ 'localhost.domain.com ' > IDENTIFIED BY 'Password '



//Correct Data in user table in mysql database..

+-- ---- ---+-- ------+-- ---- ---- -----+-- ---- -----+-- ---- -----+--
-- ---- ---+-- ---- -----+-- ---- -----+-- ---- ---+-- ---- -----+-- ---
-- ------+-- ---- ------+-- ---- ---+-- ---- ----+-- ---- ---- ----+----
-- -----+-- ---- ----+-- ---- ------+-- ---- ----+-- ---- ---- ---- ----
-+-- ---- ---- -----+-- ---- ------+-- ---- ---- ----+-- ---- ---- -----
+-- ---- --+-- ---- ----+-- ---- -----+-- ---- ------+-- ---- ---- --+--
-- ---- ---+-- ---- ---- ----+
| Host | User | Password | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv
| Index_priv | Alter_priv | Show_db_priv | Super_priv |
Create_tmp_table_priv | Lock_tables_priv | Execute_priv |
Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer
| x509_subject | max_questions | max_updates | max_connections |
+-- ---- ---+-- ------+-- ---- ---- -----+-- ---- -----+-- ---- -----+--
-- ---- ---+-- ---- -----+-- ---- -----+-- ---- ---+-- ---- -----+-- ---
-- ------+-- ---- ------+-- ---- ---+-- ---- ----+-- ---- ---- ----+----
-- -----+-- ---- ----+-- ---- ------+-- ---- ----+-- ---- ---- ---- ----
-+-- ---- ---- -----+-- ---- ------+-- ---- ---- ----+-- ---- ---- -----
+-- ---- --+-- ---- ----+-- ---- -----+-- ---- ------+-- ---- ---- --+--
-- ---- ---+-- ---- ---- ----+
| localhost | Username | 14617e5f1090a4a9 | Y | Y |
Y | Y | Y | Y | Y | Y
| Y | Y | N | Y | Y |
Y | Y | Y | Y | Y
| Y | Y | Y | |
| | | 0 | 0 |
0 |
+-- ---- ---+-- ------+-- ---- ---- -----+-- ---- -----+-- ---- -----+--
-- ---- ---+-- ---- -----+-- ---- -----+-- ---- ---+-- ---- -----+-- ---
-- ------+-- ---- ------+-- ---- ---+-- ---- ----+-- ---- ---- ----+----
-- -----+-- ---- ----+-- ---- ------+-- ---- ----+-- ---- ---- ---- ----
-+-- ---- ---- -----+-- ---- ------+-- ---- ---- ----+-- ---- ---- -----
+-- ---- --+-- ---- ----+-- ---- -----+-- ---- ------+-- ---- ---- --+--
-- ---- ---+-- ---- ---- ----+

--snip--



I don 't want to this user to have access to most databases, just only
one database. When I do this, it doesn 't grant the priviledges the same
way...



--snip--

//Issued SQL Request

GRANT ALL ON DATABASE_NAME.* TO 'Username '@ 'localhost.domain.com '
<mailto: 'Username '@ 'localhost.domain.com ' > IDENTIFIED BY 'Password '



//Incorrect Data in user table in mysql database..

| localhost | Username | 14617e5f1090a4a9 | N | N |
N | N | N | N | N | N
| N | N | N | N | N |
N | N | N | N | N
| N | N | N | |
| | | 0 | 0 |
0 |

--snip--


What do I need to do to make those 'Select ', 'Update ', 'Delete ',
'Alter ', etc.. to be "Y " by issuing that SQL Request from above???
What did I do wrong??

Thanks,
Scott





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql @(protected)