Upgrading The Php Client API Version To MySQL
Jun 14, 2007
I can't for the life of me figure out how to upgrade the Client API version authencation method in php for MySQL.
The server had MySQL 3.23.58 before and doing a phpinfo() reflects that. The problem is even after I install a newer version of MySQL 4.1.22 (using RPMs), it still doesn't see it.
I've ran privilege table fix but I am unable to use any mysql accounts unless I use the old password method.
I can have MySQL be up and running using the old password method but I prefer that it works with the newer authentication method since things could go wrong if I do the other way.
Is there a way I can resolve this? or do I just have to stick with the old password hashing method?
View 3 Replies
ADVERTISEMENT
Jun 1, 2007
loading a phpinfo() shows that the mysql variable "Client API version" on my server doesn't match the version of mysql installed ( 4.0.20 when mysql version is 4.1.21).
Can this cause trouble and php or mysql errors on scripts i'm running?
View 0 Replies
View Related
Jun 27, 2009
I have recently upgraded mysql server from 5.0.75 to 5.1.31 on my Ubuntu server 9.04 32 bit. After that when I am running phpmyadmin it is printing a warning :
Your PHP MySQL library version 5.0.75 differs from your MySQL server version 5.1.31.
View 2 Replies
View Related
Apr 5, 2007
I am in the process of upgrading PHP. I have successfully compiled with with no errors. However, before I run the make install command, I would like to backup all the files associated with my current version of PHP. I am going from 4.3.11 to 4.4.6. I was wondering if anyone knew what the directories and files to back up? I am using Fedora Core.
View 3 Replies
View Related
May 4, 2008
After the vBulletin's latest version i had to upgrade my mysql server from 4 to 5
searched a little bit found out that it can be done through tweak settings ,, select 5 and click save then do the server software update link .
i did that
after that i checked one of the websites that uses vB
found this database error:
<!--
Database error in vBulletin :
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/xxx/public_html/vb/includes/class_core.php on line 274
MySQL Error :
Error Number :
Date : Sunday, May 4th 2008 @ 01:05:15 PM
Script : [url]
Referrer :
IP Address : 212.102.30.3
Username :
Classname : vB_
i went to the shell and wrote (mysql) i received this error:
[root@server tmp]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
googled alot searching for a solution but i found millions of problems with different specifications so i didn't want to mess it up more!
most of them talked about the file (/var/lib/mysql/mysql.sock) and the configurations in the file (my.cnf)
i've been through my.cnf and couldn't find anything about /var/lib/mysql/mysql.sock
my server is centOs 5 32 bit intel xeon
my php version is 5.2.5
i've reset the root password to mysql to blank again through WHM
i really hope that you can provide me with a solution ASAP as my clients are starting to warm up to beat me
if anyone of you needs to know anything else about my server just shoot and i'll be here to answer
By the way
the file mysql.sock doesn't seem to be there on the server.
View 7 Replies
View Related
Apr 22, 2007
I've been trying to move this one website to a VPS for a few days now. Everything was easy enough until it comes to restoring the wordpress blog. The problem is that the VPS that I'm transferring to has mysql 3.23. Since wordpress requires 4.0+ mysql I've been trying to upgrade but I keep running into problems.
The OS is centos 3.8 and I've been using RPMs to install mysql. First I uninstalled the old mysql using "rpm -qa | grep mysql" and then moving the packs. Then I find mysql 4.1.22 centos. I installed them using rpm -ivh blahblah.
After that I restart mysql and apache. When I start apache I get this error "Cannot load /etc/httpd/modules/mod_auth_mysql.so into server: libmysqlclient.so.10: cannot open shared object file: No such file or directory"
Well I commented that part from httpd.conf and was able to restart apache no problem.
The problem is after I restart apache, php is unable to connect to mysql. In other words, wordpress isn't working (got the "Your PHP installation appears to be missing the MySQL which is required for WordPress" error). Now I don't think its that line since I'm not requiring any authencation. It seems to be what comes with the old mysql 3.23
My problem is how do I get pass this error? I've even tried compiling php from source with --mysql switch and it still doesn't connect.
I've noticed that if I just installed the new mysql, wordpress actually works but obviously when apache restarts, it wouldn't work.
Could it be that apache is somehow requiring the authencation? but since I've disabled that line, I don't know why it needs that.
View 4 Replies
View Related
Apr 10, 2007
I'm currently running mysql 4.1 and want to upgrade to 5.0, has anyone had any issues in upgrading, this is a production box so I want to make sure that it goes smoothly.
View 10 Replies
View Related
Feb 3, 2008
I'm trying to upgrade to MySQL 5 from MySQL 4.1, did the change on WHM Tweak Settings and then run /scripts/mysqlup but i get this error:
the installer version: cPPkgs::MySQL 5.0.45 installer for Linux
Fetching http://httpupdate.cpanel.net/mysqlinstall/5.0.45-0/centos/5/MySQL-server-5.0.45-0.glibc23.i386.rpm (0)....@69.72.164.152......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
Preparing... ########################################### [100%]
error: install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glibc23
running:
rpm -ivh MySQL-server-5.0.45-0.glibc23.i386.rpm
give error:
error: Failed dependencies:
perl(DBI) is needed by MySQL-server-5.0.45-0.glibc23.i386
i did run /scripts/perlinstaller --force Bundle::DBD::mysql too, but it doesn't fix it
View 14 Replies
View Related
May 7, 2008
I would like to start offering MySQL 5 on all my shared hosting accounts, seeing how it's an increasingly requested feature. However, by my understanding most applications still require MySQL 4 to operate (am particularly concerned with those bundled with Fantastico). I would like my current clients to be able to continue working with these older apps using MySQL 4 while allowing new clients to make use of the latest features available with MySQL 5.
I would like to get people's opinions as to what the best approach would be here. Should I upgrade directly to MySQL 5, offer both versions 4 and 5 simultaneously, or just stick to version 4 until version 5 is better supported? If I choose to install both versions in parallel, is this an easily supported option with CPanel/WHM? Will the configuration change break anything for clients already using applications with MySQL 4?
View 3 Replies
View Related
Jun 19, 2008
to upgrade the PHP and MySql versions our shared hosting ocmpany is offering. We are now at PHP 4.3 and MySQL 4.014 I need to bring it up to PHP and MySQL 5.xx versions.
Has anyone done this and if so what gotchas should I look for? what is the suggestes upgrade path not to affect clients using the older versions?
View 7 Replies
View Related
Jul 14, 2008
I have a Win2003 dedicated server (with The Planet) that i use to host a large IPB forum site.
I got it about 3yrs ago and as I was a complete newbie to server management I got Plesk CP installed so that it would take care of all the SQL, PHP and mail installation and setup in one easy go.
I've since found Plesk for Windows to be a complete waste of space.. but it's still on there and has never been upgraded. I don't actually use it as a CP.
Similarly PHP and mySQL have never been upgraded.
Now I've got to the stage where, to upgrade the IPB forum software, I need to upgrade PHP and mySQL.. but looking at the installation, they seem to be embedded in the Plesk installation. They're inside the SWSoft/Plesk/ folders and none of the ini or config files appear to be in the places you'd expect them to be.
My question -
Would these upgrades be simple?? A case of just running an update package?? Or is the fact that PHP/mySQL are embedded in Plesk mean that it'll all mess up?
I'm worried that a failed upgrade will knacker the forum, which is why I've delayed for so long.
View 2 Replies
View Related
Aug 28, 2014
I need to upgrade mysql from 5.1.73 to 5.7 but I have applications like lms, cms, and websites that runs with that version with no problems, my question is: Some of you had problems upgrading mysql, because i kwon plesk runs over mysql y i don't want to mess up with plesk.
View 1 Replies
View Related
Nov 4, 2007
A very unusual issue;
MySQL updated from 3 to 4.1. PHPinfo reports 3.1 is still in effect.
Any ideas?
Stumped me a little, every other MySQL upgrade has gone 100% perfect.
Im blaming PHPINFO for now
View 8 Replies
View Related
Oct 25, 2007
I need MySQL 5.x for my IPB forum and took one host, but I cannot understand what version of MySQL i have, as:
cPanel says:
MySQL version: 5.0.45-community
but phpMyAdmin says:
Server version: 5.0.45-community
MySQL client version: 4.1.22
What version of MySQL do I really have?
What is difference with Server and client? and why version of client is not 5?
View 8 Replies
View Related
Feb 5, 2007
for a hosting plan now. I will mainly use it for developing. What version of PHP and MySql is reasonable to settle for? I understand that the later the better, but I see that most hosting companies are stuck in PHP 4.1 and MySql 4.4. Is that good enough?
View 7 Replies
View Related
Aug 4, 2009
Which version of MySQL is the most used version in webhosts? The latest version of MySQL is version 5.1.
I am wondering because PHP5 which came out back in 2005 has still not been adopted in many web hosts.
Is mysql 4 the most used or mysql 5.x ? Which is the most common mysql version?
View 9 Replies
View Related
Jun 14, 2008
What will be best combo of those 3 which is main core for running almost any web server.Presently i have latest mysql,apache and php installed,but some people says how that is not good beacuse newest version arenot tested yet well enough.
View 6 Replies
View Related
Jan 26, 2007
Which version of Mysql is proven to be the most fastest and stable
View 3 Replies
View Related
Mar 25, 2008
I have recently upgraded MySQL to 5.25
However, when I run phpinfo, I see the following:
mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.1.21
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient
mysqli
MysqlI Support enabled
Client API library version 4.1.21
Client API header version 4.1.20
MYSQLI_SOCKET /var/lib/mysql/mysql.sock
View 4 Replies
View Related
Sep 22, 2014
I'm still using Plesk 11.5.30 and MySql 5.5.39. That was discribed here how to update. But i need to have a MySql 5.6.5 (minimum) for some software (This version is over 2 years old). I'm using CentOs 6.5. and PHP 5.4.33
how to do this, whitout breaking plesk 11.5.30??
View 4 Replies
View Related
Jun 6, 2015
Is it possible to update the MySQL version on the db nodes from 5.1 to 5.5 or is it supported?
View 3 Replies
View Related
Sep 10, 2007
I'm trying to do a FULLTEXT search (1 field) on a ~3 gig table with ~650,000 rows. A lot of queries work fine and give results in seconds, but for queries on words that (I believe) occur very commonly in the database (e.g., this is a Italian database, the word 'italia' probably occurs a lot) take a while and then give the following errror:
#2008 - MySQL client ran out of memory
But the server has 8 gigs of RAM (and plenty of free hard disk space). Server is Linux with MySQL 4.0.27.
Here's my /etc/my.cnf file:
[mysqld]
set-variable = max_connections=1000
safe-show-database
log_slow_queries
long_query_time=5
max_allowed_packet=16M
ft_min_word_len=3
what I can do to make this work?
View 7 Replies
View Related
Jun 17, 2008
"Client does not support authentication protocol requested by server; consider upgrading MySQL client"
I upgraded from MySQL 4 to 5 and everything was fine for about a week. On Monday, I get the error above. From what I've read, this is the oldpassword/new password hash error that I can fix in about 2 minutes on my server. However, this is on a Parcom server, and Parcom has been sloooowww to react.
Can anyone think of another reason why this would be coming up? It's running fine on 3 other PCs that I run as a backup. I've dropped the database twice and rebuilt it twice, still with the same error. Ditto for the user/pass.
View 2 Replies
View Related
Oct 2, 2007
how to do this in myphpadmin
also got cpanel if it helps.
View 5 Replies
View Related
