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'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.
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'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.
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'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?
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?
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
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.
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?
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.
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'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
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?
