MySQL error connecting to database

[foodie]

 

Error which I get:

 

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'mysql11.000webhost.com' (111)' in /home/a5416708/public_html/blog/includes/config.php:11 Stack trace: #0 /home/a5416708/public_html/blog/includes/config.php(11): PDO->__construct('mysql:host=mysq...', 'a5416708_blog', '123asd') #1 /home/a5416708/public_html/blog/index.php(1): require('/home/a5416708/...') #2 {main} thrown in /home/a5416708/public_html/blog/includes/config.php on line 11

 

Code I have witch exports database:

define('DBHOST','mysql11.000webhost.com');
define('DBUSER','a5416708_blog');
define('DBPASS','123asd');
define('DBNAME','a5416708_blog');

$db = new PDO("mysql:host=".DBHOST.";port=8889;dbname=".DBNAME, DBUSER, DBPASS);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

My question is this - How do I fix this error?

[doni49]

http://stackoverflow.com/a/23532364/1042053

[foodie]

Thanks for help about port.

Have fixed that.

 

Once I go to my page I get this

 

 

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a5416708_blog.blog_posts' doesn't exist

 

 

When I try to access Administrator Panel I get this error -

 

 

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'a5416708_blog.blog_members' doesn't exist

 

Next question is how do i fix this?

 

P.S I'm really noob in php/sql.

[benanamen]

It means exactly what it says. There is no table with that name. Replace that with a table name that exists or create a new table. Try blog_members

Edited January 2, 2016 by benanamen

[foodie]

Yeah, i figured that table dosent exist. It means I didnt explain myself fully. 

Question remains - how to create thoses tables witch my blog script needs

[foodie]

Nevermind, solved!