Hi,
I had done that thing earlier too and even now I tried that, but the
result is same. It does display the database for specific user but
phpmyadmin says,MySql says: no database selected.
And in the standard user field, do I have to keep root user or mysql
user who has all the permission, if the advanced auth is true? If I don't
specify any user there, it says couldn't connect to the server, which I
believe is quite obvious.
I believe my problem is " no database selected". While connecting to
mysql from command prompt, unless I type use this database; , no database
is selected. Is there any way do that in phpmyadmin, the user directly go
to it's database.
Thanks in advance.
Regds,
Ujwol
On Thu, 10 Jan 2002, Jan Gruber wrote:
> Hi !
>
> On Thursday 10 January 2002 06:49 am, you wrote:
> > Hi,
> > I'm using PhP-Myadmin 3.23.40 and advanced authentication. While
> > advanced authentication is working fine,I find it hard to use this in multi
> > user environment. How do I setup php-myadmin to authenticate via mysql.user
> > table and give access to only database that is specified in mysql.db table?
>
> Simply give the database users no privileges in the user/host tables and set
> all the priv's either in the db (for a certain database) or the tables_priv
> (even for single tables) table. This gives you a good, fine grained control
> over the access rights for your users.
>
> So if your advanced auth works, you are half way there. Add another user to
> the user/db/host/ table as described. Create the database(s) needed and
> start testing the whole thing.
>
> HTH
> Jan
>
> --
> cat /dev/world | perl -e "while (<>) {(/(^.*? \?) 42 \!/) && (print $1)}"
> errors->(c)
> _
>
> _______________________________________________
> Phpmyadmin-users mailing list
> Phpmyadmin-users@lists.sourceforge.net />
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users
>
|
