Send an Email
1800 810 6547
All Entries Tagged With: "Mysql"
Mysql Version Mismatch in cPanel and Backend(Shell)
Issue: cPanel says that the version of MySQL is 4.1.20. However, when I check the version within Shell it tells me I’m running MySQL-5.0. Why is cPanel not reporting the correct version? Fix: Steps: * just remove the file at /home/username/.cpanel/datastore/_usr_sbin_mysqld_–version * Then log back into your cPanel. It will then display the correct version.
admin | Mar 28, 2009 | Comments 0
How to find the MySQL slow queries?
MySQL can log the queries which are taking longer than X seconds . This feauture is disabled by default. If you want to enable this option, proceed with the following steps:- 1) Login to the server via ssh. 2) Open the file /etc/my.cnf and put the following entries:- [root@localhost ~]#vi /etc/my.cnf Locate the [mysqld] section [...]
admin | Mar 21, 2009 | Comments 0
