Error trying to connect to the database

Duu · April 24, 2012, 12:21pm

I have database named mydata:

I get the following error after clicking on Model Generator

---- CDbConnection failed to open the DB connection: SQLSTATE[42000] [1049] Unknown database ’ mydata’ —

Can somebody help

This is how i configured my main.php

	// uncomment the following to use a MySQL database


	


	     'db'=&gt;array(


		'connectionString' =&gt; 'mysql:host=localhost;dbname= mydata',


		'emulatePrepare' =&gt; true,


		'username' =&gt; 'username',


		'password' =&gt; 'password',


		'charset' =&gt; 'utf8',


		'tablePrefix' =&gt; 'tbl_',


	),

phpnode · April 24, 2012, 12:24pm

you have a space in your connection string…

Duu · April 24, 2012, 12:37pm

Ooh thanks man, it works. Thanks very much.

milan8100 · January 8, 2019, 6:22am

SQLSTATE[HY000] [1049] Unknown database ‘yii2advanced’

i have got this error please give me solitions