[CentOS] CentOS 4 with MySQL 4.1

[Chris Hammond]

I should have mentioned that JFFNMS on another server CAN talk to the DB 
so it is running properly.

Thanks
Chris

Chris Hammond wrote:

> Thanks, makes perfect sense but due to my lack of DB knowledge, I 
> would have never thought of it. :(  I downloaded
> the binary package, removed all traces of mysql packages and brought 
> up the binary version of 4.0 in /usr/local/mysql
> using the script in support-files.  I then yum installed php-mysql 
> which brought in all the dependencies.  I can connect
> with the "mysql" client in /usr/bin which is the 4.1 versions.  
> However, JFFNMS still says that php-mysql is not loaded
> and cannot talk to the DB.   How would you go about testing the 
> php-mysql piece?
>
> Thanks!!!
> Chris
>
> Troy Engel wrote:
>
>> Chris Hammond wrote:
>>
>>> Greetings all!
>>>
>>> I have built a new server with MySQL and have noticed that before 
>>> even doing anything
>>> to it I found that the MySQL logins were much slower than the 4.0 
>>> server I used prior to it.
>>
>>
>>
>> Just as a note, I have not noticed this problem at all -- my logins 
>> are just as fast/fine/snappy as always. Not sure what's wrong with 
>> your stuff..
>>
>>> I am at a loss of what to do.  I would prefere to go with MySQL 4.1 
>>> just because that is what
>>> comes with CentOS 4, short of that I need php-mysql to work with 
>>> 4.0.  Databases and
>>> custome building of RPM's is beyond my capabilities.
>>
>>
>>
>> You can use the builtin 4.1 *client* binaries (which are what php and 
>> it's ilk are linked to), while using the 4.0 server binaries. All you 
>> need to do is uninstall "mysql-server" RPM, install your downloaded 
>> 4.0 binary package to /usr/local/mysql/ (eg), and run the server from 
>> there using it's custom initscript.
>>
>> Make sure the /etc/my.cnf is all configured nicely before 
>> bootstrapping the downloaded 4.0 install, and everything should just 
>> click (within reason). Most importantly, make sure the socket path 
>> and database path is set.
>>
>> -te
>>
>
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos