无法从我的网站访问MySQL数据库，但可以通过浏览器访问？

Question

I'm trying to hook up my website to my MySQL database on my new webhost, and I'm running into a few issues I can't resolve.

If I navigate to mywebsite.com/phpmyadmin/, I'm presented with an HTTP authorization, and upon successful entry of that, my PHPMyAdmin login page, where I can log-in as my user and see my databases. Yet, if I try to connect via PHP through my website, I receive the error:

SQLSTATE[HY000] [2005] Unknown MySQL server host 'mywebsite.com/phpmyadmin' (11)

My connection info is:

$this->dbh = new PDO('mysql:host=mywebsite.com/phpmyadmin;dbname=mydb;charset=utf8','me','myPassword');

I'm running LAMP on Ubuntu 14. Is there any particular reason this is failing?

Answer 1

PHPMyAdmin is a database client application, not a database server.

You need to provide connection information to your database server (which will probably be localhost)