I have both MySQL 4 and MySQL 5 support at my host and I have been using MySQL 4 based databases with WP for over a year and no problem so far. Now I wanted to create a new blog/cms at different folder with the same host and wanted to use MySQL 5 database since MySQL 4 support would be out soon. But it just doesn't connect nor does it obviously gets installed.
My host suggests that in Database Host field, I need to put: localhost:/tmp/mysql5.sock
which I did but still no luck...
Where am I going wrong?
If simple installation is not working, should it mean I give up my hope of migrating my old WP blogs to MySQL 5?