trying to install WordPress here (following the 5-minute-recipe), I’m afraid I’ve not come nearly as far as the other newbies :-). The error message it gives me upon calling wp-install.php is:
DB Error, could not list tables MySQL Error: Can’t connect to local MySQL server through socket ‘/var/run/mysql/mysql.sock’ (2)
That’s probably due to my lacking knowledge in MySQL administration, but searching the MySQL docs just gave me a headache. It at least does have a root password set (`mysql -uroot -pmypassword’ on the console works, and that’s also the data I used for b2config.php).
The system I’m trying this on is OpenBSD 3.4, MySQL 3.23.57 and PHP 4.3.3.
I’d be grateful for any hints that you might have!
Have you entered that data into your settings file (this is explained in the instructions)?
> It at least does have a root password set (`mysql -uroot -pmypassword’
> on the console works, and that’s also the data I used for b2config.php).
So the answer is yes, I have.
Which version are you using? The ucrrent version doesn’t use b2config.php (other than once during an upgrade process.) Toy may want to try with the most recent version 0.72 which is still in beta but quite stable.
Well, the file I downloaded was `wordpress-071-gold.tar.gz’. But I’ll try 0.72 if you say that’ll work.
I’m trying it with 0.72 now, but still the same problem — it’s not able to connect to the mySQL database. And yes, the database name in wp-config.php _is_ set correctly, as are username, password and hostname. Using `mysql -u <username> -p’ is working just fine, too.
What could this be related to?
Does a “ls -al /var/run/mysql/mysql.sock” show something? Are you sure that the socket is there? The other option (besides using sockets) could be to use TCP for communication. If your system has been configured like this, you had to adjust something in WordPress to reflect these settings, I guess.
# ls -l /var/run/mysql/mysql.sock
srwxrwxrwx 1 _mysql _mysql 0 Oct 10 00:52 /var/run/mysql/mysql.sock
So yes, it’s there. I tried using my server’s IP instead of “localhost”, but it doesn’t look like it could be fooled that easily. So how do you get WordPress to connect to mySQL by means of TCP?
Maybe you should create a little test file and make sure you can connect to the database?Anonymous
/var/www is chrooted……. its not possible to see beyond…..
try ln -s /var/run/mysql/mysql.sock /var/www/var/run/mysql/mysql.sock
- The topic ‘DB Error’ is closed to new replies.