General :: What Version Of MySQL Have On Box?
Jul 23, 2010how can i find out what version of MySQL i have on my box?i know if i run phpinfo() it says 5.0.77 but how can i find out what it is inside centos 5?
View 4 Replies
ADVERTISEMENT
General :: MySQL / PhpMyAdmin Upgrade To A Later 4.0 Or 4.1 Version?
Feb 1, 2010I'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:
php-mysql-4.2.2-17.2
php-4.2.2-17.2
php-imap-4.2.2-17.2
php-ldap-4.2.2-17.2
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.
Ubuntu :: MySQL Library Version X.x.x Differs From Server Version X.x.x
Jun 4, 2010Installed Zend Server CE on 10.04 - install mostly fine. But phpmyadmin shows this error; "Your PHP MySQL library version 5.0.83 differs from your MySQL server version 5.1.41" I have followed the Zend online docs and used a DEB install. Why would these versions be different?how do I fix it so that the two are in sync?
View 3 Replies View RelatedServer :: Migrating MySql DB From Version 4.0 To Version 5.1
Nov 29, 2010I want to upgrade mediawiki software from version 1.6 to version 1.16 . The newer version is supposed to be installed on another server. I am trying to migrate the old mediawiki mysql database with no success.
I run the following commands -
Code:
Code:
to restore db on new server -
Code:
I get the following error message -
Code:
General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)
Jun 2, 2010i 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.
CentOS 5 :: Upgrade Existing MySQL 5.0.77 Version On CentOS 5 Red Hat To MySQL 5.1.x
Aug 31, 2010I 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?
View 6 Replies View RelatedFedora :: Server Version Where Apache Php Mysql Are There?
Mar 15, 2010I found the desktop version but I am wondering is there a server version where apache php mysql are all there?
View 1 Replies View RelatedUbuntu :: Install PHP And MySQL On DESKTOP Version?
Sep 25, 2010I'm an absolute biginer with UBUNTU witch I just install to start trainning PHP/Mysql. I've instaled UBUNTU Desktop. Is it enough or should I install UBUNTU Server? That is, can I install PHP and MySQL on this DESKTOP version?
View 2 Replies View RelatedUbuntu Servers :: Is MySQL Community Version?
May 23, 2011Is the MySQL version installed during the installation of say Ubuntu Server 10.04, the MySQL Community Version?
View 2 Replies View RelatedRed Hat / Fedora :: Change Mysql/php Version With Script ?
Aug 24, 2010Has anyone tried downloading all the different releases of the mysql source code and creating a .sh script to switch between them? Will it work well? I would imagine there would be issues with library linkage and compatibility? The issue I'm having is a client was running mysql 5.0.x and I was on 5.1.x - my tests pass on my server but not on his. Both my development machine and my continuous integration server where the tests run all use the latest. Do I have to purchase a server for every combination of software configuration I want my application to support? Or can it be emulated with virtual machines or something?
Same for PHP. I want to essentially have this happen:
Basically looping thru all combination, would I have to set up a virtual machine? Or would that even work?
CentOS 5 :: Updating MySQL To The Latest Version?
Feb 4, 2010I 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.
CentOS 5 Server :: YUM : Freeze PHP And Mysql Version?
Jun 16, 2011i 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.
View 2 Replies View RelatedUbuntu :: Determine Version And Upgrade Php/mysql With Plesk
Sep 24, 2010I 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.
uname -a gives this:
Linux [hostname] 2.6.18-028stab070.2 #1 SMP Tue Jul 6 14:34:09 MSD 2010 x86_64 GNU/Linux
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.
Slackware :: Upgrading Apache - PHP And MySql From A Default Version
Apr 1, 2010I want to upgrade Apache, PHP, and MySql from a default version I'm having in my installed Slackware. What is the proper step to do this? Will it cause some problem if I upgrade them?
View 13 Replies View RelatedCentOS 5 Server :: Wrong Mysql Client Api Version In Php53?
Aug 4, 2011I 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
[code]....
Fedora :: Get A Link To Download MySql Query Browser(windows Version)?
Jan 16, 2011Does anyone know where I can get a link to download MySql query browser(windows version)?
I want to query my database on my fedora box in windows to make life easier... I can not seem to find a link to download the query browser though
CentOS 5 :: Website To Download / Install MySQL 5.1 Version RPM Installation For 64-bit Distribution?
Jul 26, 2010I am looking for official recommended web site to download and install MySQL 5.1 version RPM installation for 64-bit CentOS 5 distribution?
View 3 Replies View RelatedCentOS 5 :: PhpMyAdmin Complains Of MySQL Client Library And Server Version Mismatch
Sep 18, 2010Summary: 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
General :: Create A New Mysql User And A Mysql Database At The Shell Prompt?
Aug 7, 2010How do I create a new mysql user and a mysql database at the shell prompt?
View 1 Replies View RelatedGeneral :: Mysql Not Starting After Changing Mysql Admin Password In Fedora?
Feb 19, 2010Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.
View 1 Replies View RelatedGeneral :: Access Remote Mysql Db With Mysql-administrator Command?
May 13, 2011I have install mysql on my fedora12. My different mysql server is located in us. I want to check health status and hits per seconds everything. Is it possible with mysql-administrator command.
now a these days i am connect through ssh and excuting below command
#mytop mysql -u root -p <passwd>
In my mysql db i have added the userip & passwd (allowed the privileages for that ip)
If i use mysql-administrator i am getting below error
MySQL Error Nr. 2003
Can't connect to MySQL server on '66.98.152.64' (111)
General :: Interact With The Mysql To Reset The Root Mysql Pass?
Jun 14, 2011I have tried many different ways to interact with the mysql to reset the root mysql pass. This is what I got to right now
Code:
#!/bin/sh
newpass=$1
service mysqld stop
mysqld_safe --skip-grant-tables --skip-networking &
echo "use mysql;" >> /tmp/mysql_pass_reset.txt
echo "update user set password=PASSWORD("$newpass") where User="root";" >> /tmp/mysql_pass_reset.txt
[Code]...
OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock
Jun 7, 2011I 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
[Code]...
General :: Which LXDE Version Has The Newest Version Of Firefox And Open Office
Sep 17, 2010Which LXDE version of Linux has the newest version of Firefox and Open Office included?
I am looking for an iso file, and I am trying to run this off of a live CD for now. So I want a light version of Linux, probably LXDE, or if not, then probably XFCE. But I need a new version of Firefox and OpenOffice included.
Because, I tried burning the customizable NimbleX @ custom.nimblex.net . Pretty good, except it uses Firefox 2, and Open Office 2.3, which are outdated.
And I tried Mint XFCE, which might have been pretty good too, but it had some issue of blanking and requiring relogin after I opened hotmail frequently (user id: mint, password: blank).
The web browser and the word processing program are the most important and essential applications to me.
So are there any Linux versions in LXDE on LiveCD that include newer versions of Firefox (or at least another good browser) and Open Office (oo seems better than abi)? (Again, if no LXDE, perhaps XFCE?)
I just want to download a good version in an iso file, and burn it to a CD and get to work. Like I said the web browser and the word processing program are all important.
So really, what iso/LiveCD versions are the fastest for running on an older system, and yet have the newest browser and word processor included?
General :: ERROR: Source Object Libxml2.so Has EABI Version 0 But Target Turbine Has EABI Version 4
Apr 2, 2010When I compile my application, I received following error: ERROR: Source object libxml2.so has EABI version 0, but target turbine has EABI version 4. So I need a libxml2 file with ARM EABI version 4. Can I find one from the internet? or does anyone know how to create one?
View 1 Replies View RelatedUbuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?
Jun 17, 2010I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
Software :: Connecting To Mysql Database - Can't Connect To Local MySQL Server Through Socket
Aug 25, 2010I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
OpenSUSE :: MySQL Error 2002 (HY000): Can't Connect To Local MySQL?
Dec 6, 2010I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).
Error I receive is:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Ubuntu Servers :: Mysql ERROR 1045 \ Trying To Allow Remote Access To Mysql?
Jan 14, 2011i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
Slackware :: Postfix - Cyrus SASL Authentication - Pam-mysql - Mysql Database
May 10, 2011Pam-mysql can not connect to the database and below are my configurations.
saslfinger -s Output:
root@mailbackup:/# saslfinger -s
saslfinger - postfix Cyrus sasl configuration Tue May 10 10:12:10 EAT 2011
version: 1.0.2
mode: server-side SMTP AUTH
-- basics --
Postfix: 2.7.2
System: Slackware 13.1.0
-- smtpd is linked to --libsasl2.so.2 => /usr/local/lib/libsasl2.so.2 (0x00007f74ebfb7000)
-- active SMTP AUTH and TLS parameters for smtpd --
-- listing of /usr/lib64/sasl2 --
-- listing of /usr/local/lib/sasl2 --
-- content of /usr/lib64/sasl2/smtpd.conf --
-- content of /usr/local/lib/sasl2/smtpd.conf --
-- active services in /etc/postfix/master.cf --
-- mechanisms on localhost --