If you insert records directly into the tables in mysql, then they only
have the rights you specifically specify. GRANT is smart enough to
handle a lot of the dirty-work for you. In particular, I like the:
GRANT SELECT on *.* to readonly@'%' identified by 'readonly';
This will create the user
Hey everybody --
I'm trying to get a handle on permissions in MySQL. I've read the manual several
times, and I still lack the 'big picture'.
It seems to me there are three levels of security:
1. Database permissions
2. Table permissions
3. column permissions.
What I don't understand is how al
.
Ass.: RaydaCosta
-Mensagem original-
De: Paras pradhan [mailto:[EMAIL PROTECTED]]
Enviada em: Sexta-feira, 16 de Agosto de 2002 09:08
Para: [EMAIL PROTECTED]
Assunto: Mysql database permissions questions
hi all
when i connect to my mysql database server using
mysql -h a.b.c.d
hi all
when i connect to my mysql database server using
mysql -h a.b.c.d -u xyz -pmypass
It logs on and it's fine and in mysql shell when i do "use mysql" then it is
allowing me to acess the mysql default "mysql" database. i dunn't want this.
when i type "use mysql" then it sud say acc
umn level.
The output of SHOW GRANTS means that 'usernew' has no global
privileges (USAGE) and has SELECT privilege on the database 'Liste_MP3'.
C> Thanks!
C> -Original Message-
C> From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
C> Sent: 1 août, 2002
on 8/1/02 11:32 AM, Victoria Reznichenko at [EMAIL PROTECTED]
wrote:
> C> Is there a way to create a user by giving access to only one database,
> C> without giving him the permission to "mysqlshow --user=[thisuser]
> C> --password=[thispassword]" and retrieve all database names? He should see
>
27; |
| GRANT SELECT ON Liste_MP3.* TO 'usernew'@'localhost'
|
+---
+
2 rows in set (0.00 sec)
It's a new user I never entered before, and still, it generates this usage
on *.*...
Thanks!
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED
Caron,
Thursday, August 01, 2002, 5:34:16 PM, you wrote:
C> mysql> show grants for nouveau@localhost;
C> +---
C> +
C> | Grants for nouveau@localhost|
C> +---
mysql> show grants for nouveau@localhost;
+---
+
| Grants for nouveau@localhost|
+---
+
| GRANT USAGE ON *.* TO 'nouveau'@
