Phpinfo Shows Wrong MySQL Version

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


ADVERTISEMENT

CPanel Shows Wrong Versions Of Apache And MySQL

Mar 5, 2008

I've a small reseller account with cPanel with 5 sites. After transfering to other host (full cPanel backup of old sites, restoring on new host) cPanel of 2 sites still displays the version number of the old host, the other 3 sites are correct.

CP1: correct - CP2: wrong

View 4 Replies View Related

Your PHP MySQL Library Version 5.0.75 Differs From Your MySQL Server Version

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

Plesk 12.x / Linux :: Installing Joomla - Wrong Version Of PHP / Can't Allow SSH

Aug 18, 2014

I'm new to Plesk - I've inherited a web site for a local social club so have just been handed login and password. I believe I have version 11.0.9 and as I can see mention of an Apache webserver I'm guessing its linux.

So - I want to redesign and use Joomla so I can share the content updating with others.

I can't install Joomla as I have PHP 5.1 and need 5.3. I have no 'server' or any sort of option I can find (and I've looked everywhere!) to find a command line or somewhere I can run things.

When I try to allow SSH access the option says Forbidden and there is no option to change it.

View 1 Replies View Related

Mysql And Php: What If "Client API Version" Doesn't Match Mysql Version

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

MySQL Monitor Shows MySQL As Offline When It's Not

Jan 15, 2007

I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.

Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.

The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).

The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.

Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?

View 11 Replies View Related

APF :: If I Do An Nmap, Mysql Shows Up As Open Still

Nov 14, 2008

I just upgraded to the latest version of APF. I am running CentOS with the 2.6 kernel.

I added my ports to allow, started it up, and it does not seem to be blocking anything.

I get no errors on startup though. If i do an nmap, mysql shows up as open still. I can even telnet to it.

root@me [~]# /usr/local/sbin/apf -r
apf(6367): {glob} flushing

View 6 Replies View Related

Current CPU Usage Shows Mysql 177 - Is This %

Oct 12, 2007

my server is jammed and takes minutes to load simple pages, can you please take a look ath the following image, its show under "CPU %" for mysql 177, does that mean mysql is using 177% of resources of cpu?

View 3 Replies View Related

What's Wrong With MY Mysql

Feb 22, 2007

I have a mysql-only server and the server is constantly > 30 in server load. I'm ousted as to what is wrong with mysql and what can be done to optimize it. Using mysql report to generate the following:

Quote:

MySQL 4.1.22-standard uptime 0 0:22:30 Thu Feb 22 07:14:45 2007

__ Key _________________________________________________________________
Buffer used 30.93M of 256.00M %Used: 12.08
Current 60.41M %Usage: 23.60
Write ratio 0.891
Read ratio 0.001

__ Questions ___________________________________________________________
Total 416.13k 308.2/s
DMS 136.54k 101.1/s %Total: 32.81
Com_ 120.17k 89.0/s 28.88
COM_QUIT 117.10k 86.7/s 28.14
QC Hits 44.35k 32.9/s 10.66
-Unknown 2.04k 1.5/s 0.49
Slow 19 0.0/s 0.00 %DMS: 0.01
DMS 136.54k 101.1/s 32.81
SELECT 82.50k 61.1/s 19.82 60.42
UPDATE 27.28k 20.2/s 6.56 19.98
REPLACE 10.85k 8.0/s 2.61 7.95
INSERT 7.98k 5.9/s 1.92 5.84
DELETE 7.93k 5.9/s 1.91 5.81
Com_ 120.17k 89.0/s 28.88
change_db 119.37k 88.4/s 28.69
admin_comma 791 0.6/s 0.19
show_variab 3 0.0/s 0.00

__ SELECT and Sort _____________________________________________________
Scan 6.38k 4.7/s %SELECT: 7.73
Range 6.35k 4.7/s 7.70
Full join 0 0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 3.99k 3.0/s
Sort range 9.92k 7.4/s
Sort mrg pass 1.27k 0.9/s

__ Query Cache _________________________________________________________
Memory usage 5.85M of 32.00M %Used: 18.28
Block Fragmnt 22.41%
Hits 44.35k 32.9/s
Inserts 75.31k 55.8/s
Insrtrune 75.31k:1 55.8/s
Hit:Insert 0.59:1

__ Table Locks _________________________________________________________
Waited 54.03k 40.0/s %Total: 31.44
Immediate 117.80k 87.3/s

__ Tables ______________________________________________________________
Open 763 of 1500 %Cache: 50.87
Opened 769 0.6/s

__ Connections _________________________________________________________
Max used 651 of 650 %Max: 100.15
Total 119.74k 88.7/s

__ Created Temp ________________________________________________________
Disk table 24 0.0/s
Table 3.75k 2.8/s
File 2.55k 1.9/s

__ Threads _____________________________________________________________
Running 106 of 132
Cached 36 of 128 %Hit: 96.43
Created 4.28k 3.2/s
Slow 4 0.0/s

__ Aborted _____________________________________________________________
Clients 5.28k 3.9/s
Connects 1.16k 0.9/s

__ Bytes _______________________________________________________________
Sent 2.03G 1.5M/s
Received 159.51M 118.2k/s

And my my.cnf

Quote:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections = 650
key_buffer = 256M
myisam_sort_buffer_size = 64M
skip-locking
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 1M
table_cache = 1500
thread_cache_size = 128
wait_timeout = 10
connect_timeout = 5
tmp_table_size = 128M
max_allowed_packet = 36M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
max_user_connections =600
[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

View 5 Replies View Related

MySQL Won't Accept Commands: Wrong Password

Jun 2, 2008

I am just trying out MySQL on the external Apache server. I must have written down the wrong password. My commands to enter mysql with a password results in denied access.

What file do I undo in order to create a new password? I don't know the exact steps I'm supposed to take. I don't think this is a MySQL issue, but a server issue, right?

I used to create databases and tables on my regular computer and left off the password altogether while I was practicing. Now I'm taking steps to do it on the actual server, and have run across this problem.

View 6 Replies View Related

MySQL Version

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

What Version Of MySQL Do I Really Have

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

Which Version Of PHP And MySQL

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

Which Version Of MySQL Is Most Adopted

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

Best Apache/php/mysql Version Combo

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

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 View Related

Mysql Version Best Stable And Fast

Jan 26, 2007

Which version of Mysql is proven to be the most fastest and stable

View 3 Replies View Related

Plesk 11.x / Linux :: Upgrade MySQL To At Least Version 5.6.5

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

Plesk Automation :: Update MySQL Version Database Node

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

Apache :: Compiled Version Does Not Match Loaded Version

Mar 26, 2014

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?

View 2 Replies View Related

How Disable Phpinfo()

Apr 17, 2009

when some one upload and load files with phpinfo()

he can see our server PHP Configuration.

how can us disable phpinfo()?

View 13 Replies View Related

How To Set SERVER_ADMIN On Phpinfo()?

Feb 9, 2007

How do I set this Environment variable "SERVER_ADMIN" that I am seeing on phpinfo()?

View 1 Replies View Related

Phpinfo.php.gif Executing Php

Mar 6, 2007

Having this problem on chroot'ed sites in Ensim.

This is what I have in my php.conf:

Code:
[root@ns1 conf.d]# cat /etc/httpd/conf.d/php.conf
#
# PHP is an HTML-embedded scripting language which attempts to make it
# easy for developers to write dynamically generated webpages.
#

LoadModule php5_module modules/libphp5.so

SetOutputFilter PHP
SetInputFilter PHP

AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
This prevents file.php.gif from executing in a non-chrooted site, but in my chrooted sites, file.php.gif will execute as a PHP file. Any idea why? Some other config I have to change?

View 10 Replies View Related

Enable Phpinfo()

Mar 27, 2007

i give following error so how can i enable phpinfo()

Code:
warning : phpinfo() has been disabled for security reasons

View 6 Replies View Related

Zend Won't Show Up In Phpinfo

Mar 31, 2008

cat /proc/version

Linux version 2.6.23.15-80.fc7 (gcc version 4.1.2 20070925 (Red Hat 4.1.2-27)) #1 SMP Sun Feb 10 17:29:10 EST 2008

I installed Zend Optimizer (this is NOT a cpanel box to clarify)

1. Downloaded ZendOptimizer-3.3.3-linux-glibc23-i386.tar.gz

2. cd's into that directory

3. ./install.sh

No errors

[root@host ~]# service httpd restart
Stopping httpd: [ OK ]
Starting httpd: [ OK ]

However, ZO does not show up in php info

php -v

PHP 5.2.4 (cli) (built: Sep 18 2007 08:50:58)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with eAccelerator v0.9.5.2, Copyright (c) 2004-2006 eAccelerator, by eAccelerator

php -m

[Zend Modules]
eAccelerator

File: /usr/local/Zend/etc/php.ini

[Zend]
zend_extension_manager.optimizer=/usr/local/Zend/lib/Optimizer-3.3.3
zend_extension_manager.optimizer_ts=/usr/local/Zend/lib/Optimizer_TS-3.3.3
zend_optimizer.version=3.3.3

zend_extension=/usr/local/Zend/lib/ZendExtensionManager.so
zend_extension_ts=/usr/local/Zend/lib/ZendExtensionManager_TS.so

Code:
[root@host lib]# ls -lh
total 32K
drwxr-xr-x 9 root root 4.0K 2008-03-28 20:27 Optimizer-3.3.3
drwxr-xr-x 7 root root 4.0K 2008-03-28 20:27 Optimizer_TS-3.3.3
-rwxr-xr-x 1 root root 11K 2008-03-31 16:21 ZendExtensionManager.so
-rwxr-xr-x 1 root root 11K 2008-03-31 16:21 ZendExtensionManager_TS.so

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved