more MySQL issues

[Liberty Young]

What happens if you write a quick test script to access your mySQL
server?


On Fri, 2003-02-07 at 14:53, mazdaracer wrote:
> 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
> > 
> 
> 
> ---------------------------------------------------
> 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