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_priv |

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

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, User

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 user