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?
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.
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?
I am running Apache on a Windows server and it is up and running.I downloaded and installed:
Apache 2.4.9 Win32 [Apache VC11 Binary] httpd-2.4.9-win32-VC11.zip
And included ModSecurity from download: modules-2.4-win32-VC11.zip..
The version of ModSecurity is mod_security-2.7.7 . It is up and running, but I get a warning:
ModSecurity: Loaded PCRE do not match with compiled!
Here's the difference in the PCRE from the logs:
PCRE compiled version="8.33 "; loaded version="8.34 2013-12-15".
The compiled version does not match the loaded version. Is this something I should be concerned about and try to find compiled versions that match?
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
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?
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 RelatedWhich 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?
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 RelatedWhich version of Mysql is proven to be the most fastest and stable
View 3 Replies View RelatedI 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
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??
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 RelatedI'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?
"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.
how to do this in myphpadmin
also got cpanel if it helps.
I'm using Parallels Plesk 12.0 and a mysql-Server.
I'm logged in with a customer's account into his phpmyadmin. Whenever a client connects to his website (which uses the database of his account) I get logged out and receive a "session expired" error. When I log in again I get "there's already a user with your username logged in".
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
which version of vmware are stabler/better ?
install on centOS server
for creating VPS windows/linux
vmware 1.5
vmware 2 ?
How can I tell which version of virtuozzo my host is running?
I have the VZPP, is there any way to check?
I noticed when installing latest version of APF 0.9.6.3 over the previous version 0.9.6.2 it will import all the variable and ports settings from conf.apf and allow_hosts.rules files of the previous version. so there will be no need to edit or configure any thing any more when upgrading APF exept setting DEVEL_MODE to 0 and restart APF.
View 0 Replies View RelatedI have an old laptop, it's got a 1000mhz processor and 128mb ram..
I want to install linux on it, but a) haven't got that much exp with Linux and b) don't know much about the OS in general..
I just am getting fed up of Windows!!
My knowledge stretches to using X-Windows about 8 years ago..
I have looked at Ubuntu, as the desktop looks cool and a friend said it's quite easy to get ya head around, but the site says you need atleast 256mb ram..
There Is Some Way That Hacker use a .htaccess file to change the php Version On The Server To use the Exploit
Look I Run A php Shell From My Server
[url]
You Can See From The picture that my php version is 5.2.6
then I Have upload the .htaccess To My server
the Version has been changed
look to other picture
[url]
You Can see The .htaccess file
And This Way Only Work If I have More Than one php Version on my server
How Can I Secure My server From This Way
i m using DirectAdmin server with Redhat CentOS 5.0.
May i know which version of ioncube should i use.
i found there is so many different type of ioncube at [url]
I have a Centos VPS with Cpanel. I have begun receiving some email notifications, apparantly from my cpanel... The latest one says that the version of perl I am running is too old.
Subj: [checkperlmodules] perl version too old (v5.8.8 required, v5.8.7 is installed.)
Are there any problems or dire consequences from upgrading or side effects? What version should I upgrade to?