My last guess is pdo mysql is not enabled. 2012/1/1 Renato de Freitas Freire <[email protected]>: > I had the same problem when start using cake 2.0.4 on my work, but I tried > it on my pc and it work fine. > > It might be something with your server configuration. > > I will doble check it on monday on my work. > Any news I tell you. > > But you can try it on other server, or try to upgrade your mysql, or > something like that. > > -- > Renato Freire > > > > > 2012/1/1 Ronghua <[email protected]> >> >> Yes, I grant all privileges to the user. Actually, if I write a php >> file to connect to mysql directly, I can query the result from table. >> >> <?php >> $host='localhost'; >> $user_name='testuser'; >> $password='123456'; //这里****是你设置的密码 >> >> $conn=mysql_connect($host,$user_name,$password); >> if (!$conn) >> { >> die('connect fail：'.mysql_error()); >> } >> echo 'connect success！<br/>'; >> mysql_select_db("cake_testing", $conn); >> $result = mysql_query("SELECT * FROM test"); >> while($row = mysql_fetch_array($result)) >> { >> echo $row['ref']." ".$row['content']; >> echo "<br />"; >> } >> if (mysql_close($conn)) >> { >> echo '<br/>...<br/>'; >> echo '到数据库的连接已经成功关闭'; >> } >> ?> >> >> On 1月1日, 上午10时39分, 清水��己 <[email protected]> wrote: >> > Did you have done GRANT it? >> > >> > 2012/1/1 Ronghua <[email protected]>: >> > >> > >> > >> > >> > >> > >> > >> > > I also tried my root login configuration, but it doesn't work as well. >> > >> > > On 1月1日, 上午1时51分, "Timothy O'Reilly" <[email protected]> >> > > wrote: >> > >> I'm sure you have tried it, but have you tried Login "Root" and >> > >> Password >> > >> "Root"? >> > >> Regards, >> > >> Tim >> > >> > >> On Sat, Dec 31, 2011 at 2:59 AM, Ronghua <[email protected]> >> > >> wrote: >> > >> > Hi, today is first day I'm using cake. I have setup CakePHP 2.0.4. >> > >> > In >> > >> > \app\Config\database.php, the configuration is as below >> > >> > <?php >> > >> > >> > class DATABASE_CONFIG { >> > >> > public $default = array( >> > >> > 'datasource' => 'Database/Mysql', >> > >> > 'persistent' => false, >> > >> > 'host' => 'localhost', >> > >> > 'login' => 'testuser', >> > >> > 'password' => '123456', >> > >> > 'database' => '', >> > >> > 'prefix' => '', >> > >> > 'encoding' => '' >> > >> > ); >> > >> > } >> > >> > >> > I can connect to mysql with MySQLQueryBrowser by testuser and pwd >> > >> > 123456, but I can't connect to database through Cake. Here is the >> > >> > description in the website. Can someone help me here? From the >> > >> > website >> > >> > reference, seems nothing else need to change. >> > >> > >> > Your version of PHP is 5.2.6 or higher. >> > >> > >> > Your tmp directory is writable. >> > >> > >> > The FileEngine is being used for caching. To change the config edit >> > >> > APP/Config/core.php >> > >> > >> > Your database configuration file is present. >> > >> > >> > Cake is NOT able to connect to the database. >> > >> > >> > -- >> > >> > Our newest site for the community: CakePHP Video Tutorials >> > >> >http://tv.cakephp.org >> > >> > Check out the new CakePHP Questions >> > >> > sitehttp://ask.cakephp.organdhelp >> > >> > others with their CakePHP related questions. >> > >> > >> > To unsubscribe from this group, send email to >> > >> > [email protected] For more options, visit this >> > >> > group >> > >> > athttp://groups.google.com/group/cake-php >> > >> > > -- >> > > Our newest site for the community: CakePHP Video >> > > Tutorialshttp://tv.cakephp.org >> > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help >> > > others with their CakePHP related questions. >> > >> > > To unsubscribe from this group, send email to >> > > [email protected] For more options, visit this >> > > group athttp://groups.google.com/group/cake-php >> >> -- >> Our newest site for the community: CakePHP Video Tutorials >> http://tv.cakephp.org >> Check out the new CakePHP Questions site http://ask.cakephp.org and help >> others with their CakePHP related questions. >> >> >> To unsubscribe from this group, send email to >> [email protected] For more options, visit this group >> at http://groups.google.com/group/cake-php > > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > [email protected] For more options, visit this group at > http://groups.google.com/group/cake-php
-- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
