CentOS 5 :: Upgrade Existing MySQL 5.0.77 Version On CentOS 5 Red Hat To MySQL 5.1.x
Aug 31, 2010
I want to upgrade existing MySQL 5.0.77 version on CentOS 5 Red Hat Linux to MySQL 5.1.x. Is anybody have list of patches or upgrades to upgrade to MySQL 5.1.x?
I have CentOS 5.4 installed with lighty and MySQL installed via yum. not a problem. The issue become when I'm having problem with the current mysql that I installed via yum which I believe its currently at version 5.1.42-2. So I'd like to upgrade it to the latest available version of mysql. Except I can't figure out whether to download the generic glibc32 version or just get the RHEL5 version or find the mysql enterprise version somewhere. So, not knowing what I'm doing, I downloaded the RHEL5 version since it's closer to CentOS 5.4. Except for whatever reason the mysqli is not installed or configured properly and I'm not sure how to fix it.
Any suggestion? Everything was working nicely when I used yum to install, except the problem with the version of mysql that's offered in the repository. So I'd like to request a suggestion on how to either somehow upgrade mysql using yum and there's a different repository that I didn't know, or perhaps download a proper latest and greatest mysql, install and have it configured so that mysqli work properly.
i would like to upgrade my centos 5.3 with the oldest update from repository. (about 224 update)I would like to update all the system but keep freezed php and mysql.
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems -- > mysql conflicts with mysql-server-community error: mysql conflicts with mysql-server-community
I have recently installed centos 5.6an app i have needs to run php 5.3 so i upgraded by adding a repo and using yum install php53*a php -v gives me this.PHP 5.3.3 (cli) (built: Mar 30 2011 13:51:41) Copyright (c) 1997-2010 The PHP GroupZend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologiesi also need mysql 5.1 so i picked a repo that had the 5.1 version of mysql in it and um install mysql*which gives me this.[root@localhost var]# mysql -Vmysql Ver 14.14 Distrib 5.1.52, for redhat-linux-gnu (i686) using readline 5.1and then tri to run my app and it failsthe only difference i see between the server that is current working and the new one is in the phpinfo file.in the mysql section of the working one it says Client API version. 5.1.xin the new server install it says the following which is still point to the client api or 5.0
mysql MySQL Supportenabled Active Persistent Links 0
I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld] datadir=/var/lib/mysql socket = /var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package).
Summary: Does a discrepancy between MySQL client library 5.0.x and MySQL server of 5.1.50 cause "inconsistent behavior", as reported by phpMyAdmin? The longer version: Windows Sysadmin taking the plunge into Linux. I tried to spare you all the rookie questions and did a fair bit of reading. I'm rather happy I was able to get CentOS 5.5 installed and running, configured iptables, got the kernel updated, Apache, MySQL and PHP installed. Then upgraded PHP to 5.2 after I figured out how repos and priorities work.
I got phpMyAdmin installed and running, then decided to upgrade from 2.11 to 3.3.7 but it keeps complaining that my MySQL client libraries are something like 5.0.63, while my server is 5.1.50, and this may cause "inconsistent behavior" or something of the like. So, feeling industrious, I decided to find an updated client.
MySQL-client-community-5.1.50-1.rhel5.i386.rpm
But it wouldn't let me install it as it conflicted with the default mysql-server installation. I also couldn't remove just the old client, to update to a newer one. So I blew away everything mysql on my server and installed the above client
MySQL-server-community-5.1.50-1.rhel5.i386.rpm
and that server file. I'm assuming I'm missing dependencies now as phpMyAdmin claims it can't load the mysql extension. Attempting to 'yum' php-mysql tried to install 'mysql' as a dependency, which immediately conflicted with the files I'd installed. At this point I'm wondering if I'm closing in on successfully installing a version that phpMyAdmin doesn't complain about, or if I should even care that it is complaining and just go back to all the repo versions of everything.
# rpm -e MySQL-shared-community-5.1.50-1.rhel5.i386.rpm error: package MySQL-shared-community-5.1.50-1.rhel5.i386.rpm is not installed
and I can not seem to find a php-mysql that works with MySQL 5.1
I followed the below thread and added the CentOS-Testing.repo and did a yum update php and it updated 30 packages, but when I try to install php-mysql I get :
[URL]
yum install php-mysql Setting up Install Process Parsing package install arguments Resolving Dependencies
[Code].....
Where can I find a php-mysql that works with MySQL 5.1? I checked the mysql website and can not seem to find any matches.
The Payment Card Institute (PCI) is requiring our site to upgrade to the latest versions of Apache, Mysql, OpenSSL, and PHP to fix known bugs that can compromise securityI can build all these from source, but when I do "make install" they don't mimic at all what is installed (directory format, files, etc) when I do apt-get install (of whatever old versions are in the dist).How can I find out how the packages are build via configure/make so that I can replicate the files, directory structure, etc, just with the current versions.
This is my first post, I hope I'm the the right place. I installed mysql mysql-server php-mysql perl-DBD-mysql libdbi-dbd-mysql via "yum install -y" on a server running CentOS 5.3 X86_64 The install completes successful with no errors, but once I start mysqld via "chkconfig --level 35 mysqld on" ; "service mysqld start" There are no errors in /var/log/mysqld.log netstat shows mysqld listening on 3306 and localhost is in /etc/hosts
I have two Centos 5 servers one running Asterisk with PHP installed and another sever running as a MySql Database server, at the moment when I try run simple script to see if I can connect to the remote server I get the following error.Quote:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I'm totally new to MySQL / PHPAdmin and have been dropped in at the deep end regarding getting MySQL and phpMyAdmin upgraded... When I look at the RPM's I see:
But when I go to the GUI I see: Welcome to phpMyAdmin 2.5.7-pl1 MySQL 4.0.16-standard-log running on localhost as root@localhost So to start with I'm not totally sure what version I'm running! I need to get these upgrades done due to PCI requirements so they are saying to upgrade to at least 4.0.25 I'm currently running RedHat9 so ideally need to know the easiest way to upgrade to a later 4.0 or 4.1 version.
I am trying to determine which version of Ubuntu we have installed on our Webfusion VPS in order to see how to update to specific php and mysql versions needed for installing some software.
I don't see anything that matches up to any of the Ubuntu releases. Is there any other way to determine what we have?
We have Plesk 9.5.2 on the machine.
Certain software we need to install requires PHP 5.2.10+ and Mysql 5.2+ but we currently have PHP 5.2.4-2ubuntu5.12 with Suhosin-Patch 0.9.6.2 and Ver 14.12 Distrib 5.0.51a
how to get the required versions of php and mysql (without breaking Plesk)? I tried editing /etc/apt/sources.list to add a new repository and using apt-get upgrade php but I probably did not add the correct repository.
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code: the-matrix:~ # mysql start ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or Code: the-matrix:~ # rcmysql start Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
I've installed MySQL using yum on CentOS 5. I'd like to upgrade mysql-5.0.77-4.el5_4.2 to MySQL Community Server 5.1.47. What is the best way to upgrade?
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[ [root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp [root@localhost ~]# /etc/init.d/mysqld start Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
Does anyone know where we can get the rpms (x86_64) for MySQL v4.0.26 or 27?
We are in the process of upgrading a very old server to CentOS 5 and need to retain this version. We still have a lot of clients that utilize this version.
I'm trying to install php / mysql on a remote Centos server.I've completed the installation stages but when I try ' php -v ' it comes up with these errors:
Code: PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/mcrypt.so' - libltdl.so.3: cannot open shared object file: No such file or directory in Unknown on line 0
I'm running MySQL 5.0 on a production server and I require to upgrade mysql to version 5.5 to get a new collation support. What is the best procedure to follow? I cannot find MySQL 5.5 on the standard repositories. A yum install would be the safest, correct?
This is a fresh install of CentOS 5.3 x86_64 with the following packages installed (using yum) as I have always done and has always worked in the past: httpd mysqld php php-mysql php-gd
However any pages requiring mysql fail and the following shows up in the httpd/error_log:
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/dbase.so' - /usr/lib/php/modules/dbase.so: cannot open shared object file: No such file or directory in Unknown on line 0
I've met several issues recently while building the MySQL server from CentOS 5 SRPM. The root problem are the expired SSL certificates used for built-in tests making all the tests fail. The problem is widely described on the net and I am in doubt now what to do: should I submit a patch or what?
I have been trying to install the above on my CentOS 5.5 server but am having missing libs issues. Our friend yum is not helping either. Here're some of the libs missing:
Missing Dependency: liblua-5.1.so()(64bit) is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64) Missing Dependency: libssl.so.10()(64bit) is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64) Missing Dependency: python(abi) = 2.6 is needed by package mysql-workbench-gpl-5.2.31-2el6.x86_64 (/mysql-workbench-gpl-5.2.31a-2el6.x86_64)