Very interesting. That did indeed work! Not I have to use a uid/pwd!
What precipitated all this was my wanting to install postnuke. I've had
similar problems before and ended up having to remove sql and re-install.
So now I'm getting the infamous "undefined function mysql_connect" when
trying to get postnuke installed. I haven't touched the php.ini and I've
created the database but can't get past that. I've searched the forums
but haven't found anything yet that I've been able to use.
I saw an apt-get but that's for Debian and I'm running RH8.
I really have to document all these little fixes!
pete
Liberty Young wrote:
> On Fri, 2003-02-07 at 12:31, mazdaracer wrote:
>
>>There's all of it. The gist is that only 2 users are listed.
>>
>
> That's what i was afraid of. Add instead a default user with NO
> privlages
>
> INSERT INTO user (Host, User, Password) VALUES("", "Nobody", "");
> INSERT INTO user (Host, User, Password) VALUES("localhost", "%", "");
>
> Then you can add more users with various access privs from different
> hosts, and access to specific DBs
>
> Definitely go rent/read the Mysql and Msql book from Oreilly.
> They have a chapter that talks about how MySQL queries the mysql db when
> determing log-ins.
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change you mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
(text/plain)