Saturday, December 31, 2011

Re: Cake is NOT able to connect to the database.

My last guess is pdo mysql is not enabled.

2012/1/1 Renato de Freitas Freire <renatoff@gmail.com>:
> 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 <ronghuazhao@gmail.com>
>>
>> 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分, 清水�己 <hiromi2...@gmail.com> wrote:
>> > Did you have done GRANT it?
>> >
>> > 2012/1/1 Ronghua <ronghuaz...@gmail.com>:
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > > I also tried my root login configuration, but it doesn't work as well.
>> >
>> > > On 1月1日, 上午1时51分, "Timothy O'Reilly" <timothy.john.orei...@gmail.com>
>> > > 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 <ronghuaz...@gmail.com>
>> > >> 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
>> > >> > cake-php+unsubscribe@googlegroups.com 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
>> > > cake-php+unsubscribe@googlegroups.com 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
>> cake-php+unsubscribe@googlegroups.com 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
> cake-php+unsubscribe@googlegroups.com 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
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

No comments: