more MySQL issues

mazdaracer plug-discuss@lists.plug.phoenix.az.us
Fri, 07 Feb 2003 13:53:11 -0800


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
>