rprajapa
Forum Replies Created
-
Forum: Installing WordPress
In reply to: Error Establishing Database connection.You need to login as “root” and then only you can do chown as the files are owned by root.
Forum: Installing WordPress
In reply to: Error Establishing Database connection.Try
ls -al /usr/local/mysql/
check if you see 3’rd and 4’th columns are “mysql”. In your case they most likely are “root”.
First of all you need to create a group “mysql” and also create a userid called “mysql” and mysql user should belong to mysql user.
chown -R mysql:mysql /usr/local/mysql/data
Hopefully this works for you on a Mac. I have never worked on Mac before but since you mention Mac OS X these unix commands should work.
Forum: Installing WordPress
In reply to: Error Establishing Database connection.PROBLEM SOLVED.
These are the steps I took.
1) Rebooted my sun box. This was not necessary but I wanted to start the mysql daemon manually and did not really want to kill the daemon.
I had problems restarting the daemon. Apparently I did not have premissions to write to /usr/local/mysql/data directory. This dir was owned by root and mysql couldnt not write to it.
So finally after changing the ownership to mysql I was able to manually start the daemon.
2) Next i got this error when I try to run the following test php script
<?php
$link = mysql_connect(‘localhost’, ‘mysql_user’, ‘mysql_password’);
if (!$link) {
die(‘Could not connect: ‘ . mysql_error());
}
echo ‘Connected successfully’;
mysql_close($link);
?>I get the following error
” Client does not support authentication protocol requested
by server; consider upgrading MySQL client”
This is my first installation and not upgrade. The version is Mysql 4.1.10
I still went ahead and reset the passwordmysql> SET PASSWORD FOR
-> ‘some_user’@’some_host’ = OLD_PASSWORD(‘newpwd’);and now it works.
so https://192.168.0.200/blog/wp-admin/install.php WORKS!!
Thanks
Forum: Installing WordPress
In reply to: Error Establishing Database connection.Hi macmanx,
I checked and re-read the above suggested url’s and everything looks good.
I even changed the php code (wp-includes/wp-db.php) where it actually connects to the database and have it print the DB parameters that it accepts from the wp-config file. now it prints the following message
>>>>>> below indicates the <user><password><db><host> and its all correct.
———Cut here—–Browser—-Output———
Error establishing a database connectionThis 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 blade.
->>>>>>>>>>>>> wordpress, popomysql, wordpress, blade
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.
———–Cut here——
Now only thing it seems for me to do is debug wp-db.php. I would love to see any system error messages the code generates .