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?
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.
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?
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
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 RelatedI 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?
Which 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 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?
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?
I have recently ordered a dedicated server. The server has a Centos Firefox. With a Web Host Manager package.
We are running apache1 with php5.
I would like to upgrade to apache2 (httpd2) and recompile php.
I found myself some bit stuck, the WHM won't allow me to upgrade my apache version and only upgrade the current installed version.
Is there a build script somewhere out there that will do this for me?
I am having a problem with a specific program im using and the developers are telling me that there is an mmap bug with the gcc version of centos 5.1 possibly including the libstdc++ libraries.
I have everything updated so my only recourse right now is to try a different compiler.
Is it possible to install a different version of gcc along with the one that comes with the distro?
I remember way back I tried to change gcc versions and all hell broke lose, almost everything was dependent on distro gcc.
Someone familiar with server software upgrade, please help. I want upgrade from php 4 to php version 5.
My server not running with cpanel or anything. Just apache, php and mysql!
Is there a command to use with ssh to show whether or not I am up to date with my version of APF Firewall?
Did some searches for a FAQ but didn't come across much but how to add or remove ip's from blacklists.
I got two version of my.cnf, but neither of them works ideally.
On one hand, If i used the old one, the swap memory will be used out after 5-7 days running and system halt.
On the other hand, the second copy of my.cnf will cause too much pain on cpu, even traffic is low, cpu could up to 70 or 80 percentage and hanging there for 1 minutes.
I did a lots optimization in the past (including httpd.conf, my.cnf, sysctl.conf ), and found that the only problem left on my server would be my.cnf, I have to get it right this time!
So I would be really appreciate if you guys can help me out.
here is two copies of my.cnf:
first one
[mysqld]
max_connections = 400
key_buffer = 64M
myisam_sort_buffer_size = 32M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 3M
table_cache = 1024
thread_cache_size = 286
thread_concurrency=2
interactive_timeout = 60
wait_timeout = 60
connect_timeout = 30
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 128M
query_cache_type = 1
tmp_table_size = 48M
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 32M
sort_buffer = 32M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
second one
mysqld]
skip-locking
max_connections = 400
max_user_connections=300
interactive_timeout=60
key_buffer = 64M
myisam_sort_buffer_size = 64M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 3M
table_cache = 1024
record_buffer=2M
thread_cache_size = 286
thread_concurrency=2
interactive_timeout = 60
wait_timeout = 60
connect_timeout = 30
max_allowed_packet = 16M
max_connect_errors = 50
query_cache_limit = 4M
query_cache_size = 128M
query_cache_type = 1
tmp_table_size = 256M
max_heap_table_size = 128M
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer = 256M
read_buffer = 2M
write_buffer = 2M