Knowledgebase
cpanel with mysql 4.0,and mysql can not work
| Posted by ttgt, 05-30-2011, 07:50 AM | | Hi,
i need to use mysql 4.0 on my server,
after downgrade mysql from 5.0 to 4.0,
i restore my cpanel account to the server,
all mysql page get error,
for instance,workpress
Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at localhost. This could mean your host's database server is down.
Are you sure you have the correct username and password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?
If you're unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.
is it any issue make it ?
thanx
|
| Posted by ttgt, 05-30-2011, 07:51 AM | | i follow the way to downgrade to mysql 4.0
pico /var/cpanel/cpanel.config,change mysql-version=4.1 into mysql-version=4.
cp -fr /var/lib/mysql /var/lib/mysql.old
rm -fr /var/lib/mysql
rm -f /usr/sbin/mysqld
/scripts/mysqlup -force
mv "/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so" /root/
wget "http://search.cpan.org/CPAN/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.001.tar.gz"
tar -zxvf DBD-mysql-4.001.tar.gz
cd DBD-mysql-4.001
perl Makefile.PL
make
make install
/scripts/easyapache
thanx
|
| Posted by ttgt, 05-30-2011, 07:57 AM | | Hi,
i check the mysql database list from cpanel => mysql,
all the database shows with 0MB...
thanx
|
| Posted by ttgt, 05-30-2011, 08:35 AM | | i find all the mysql can not work,it seems all the restore do not restore each mysql-user's password at all.thanx
|
| Posted by m4rc3, 05-31-2011, 09:35 PM | | If this is happening on a production server and you need it fixed ASAP you should hire a server management company as going back and forward on the forums can be time consuming for you and your clients.
|
| Posted by technosource, 06-03-2011, 11:08 AM | | Any reason in specific you don't want to use MySQL 5? It may be less effort to update the scripts to use it, rather than trying to use MySQL 4.
|
|
 Add to Favourites
 Print this Article
|
Also Read
Melitaweb (Views: 619)
