The stduser account is documented in Documentation.html, with the proper =
privileges it needs.
You don't need another account in the config file.
Ujwol Manandhar a =E9crit :
>=20
> 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 databa=
se
> is selected. Is there any way do that in phpmyadmin, the user directly =
go
> to it's database.
> Thanks in advance.
> Regds,
> Ujwol
>=20
> On Thu, 10 Jan 2002, Jan Gruber wrote:
>=20
> > 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 my=
sql.user
> > > table and give access to only database that is specified in mysql.d=
b 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 table=
s_priv
> > (even for single tables) table. This gives you a good, fine grained c=
ontrol
> > over the access rights for your users.
> >
> > So if your advanced auth works, you are half way there. Add another u=
ser 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
> >
>=20
> _______________________________________________
> Phpmyadmin-users mailing list
> Phpmyadmin-users@lists.sourceforge.net />
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users
--=20
Marc Delisle =20
Service de l'informatique
Coll=E8ge de Sherbrooke, Qu=E9bec
|