Re: Mysql permissions

2005-02-08 Thread SGreen
"Nupur Jain" <[EMAIL PROTECTED]> wrote on 02/08/2005 01:26:06 PM: > I have problems with access permissions on a Solaris 9 installtion > of MySql-max 4.1. My user table shows this > > select * from user; > | Host| User | Password > | Select_priv | Insert_priv | Update_priv | Delete

RE: mysql permissions

2002-11-08 Thread Shon Stephens
thank you victoria! -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko@;ensita.net] Sent: Friday, November 08, 2002 12:07 PM To: [EMAIL PROTECTED] Subject: re: mysql permissions Shon, Friday, November 08, 2002, 4:46:19 PM, you wrote: SS> i need to create a u

re: mysql permissions

2002-11-08 Thread Victoria Reznichenko
Shon, Friday, November 08, 2002, 4:46:19 PM, you wrote: SS> i need to create a user (besides root) that can show databases, Use Show_db_priv after 4.0.2, before 4.0.2 user can see all databases if mysqld is running without --skip-show-database option. SS> show tables SS> from every database, Us

RE: mysql permissions

2002-11-08 Thread Dan Rossi
grant all ? -Original Message- From: Shon Stephens [mailto:sstephens@;corp.goamerica.net] Sent: Saturday, November 09, 2002 1:46 AM To: '[EMAIL PROTECTED]' Subject: mysql permissions i need to create a user (besides root) that can show databases, show tables from every database, lock all