Kohana - Database_Exception [ 2 ]: mysql_connect() 2

Question

I am trying to setup my database config as demonstrated here: http://kowsercse.com/2011/09/04/kohana-tutorial-beginners/

I have cut and pasted the database.php with my mysql credentials. I then get an error which I fixed by renaming the file to Database.php. the next issue is that my credentials don't change no matter what I put in. The error shows:

Database_Exception [ 2 ]: mysql_connect() [function.mysql-connect]: Access denied for user 'ivanh'@'localhost' (using password: NO)

MODPATH/database/classes/Kohana/Database/MySQL.php [ 67 ]

62      catch (Exception $e)
63      {
64          // No connection exists
65          $this->_connection = NULL;
66 
67          throw new Database_Exception(':error',
68              array(':error' => $e->getMessage()),
69              $e->getCode());
70      }
71 
72      // \xFF is a better delimiter, but the PHP driver uses underscore

So no matter what I insert, username, host and password values do not change. My code in Database.php is then copied from: http://kohanaframework.org/3.3/guide/database/config firstly with my own database values then after as is. With no luck.

Other info: I'm creating this on a shared unix host. Kohana 3.1.4: Database_Exception [ 2 ]: mysql_connect(): Access denied seems like a similar issue without a resolution.

Any help would be great, thanks.

Did you try the suggestions from the linked question: checking if MySQL works without Kohana & dumping your config? — kero

Sourav Sourav · Accepted Answer · 2013-12-27T06:05:44

Try These Steps:

Step 1:

Go to bootstrap.php
path- kohana\application\bootstrap.php
Un-comment the below line for database access 'database' => MODPATH.'database', // Database access

Step 2: Go to Your config folder, create the database.php file if not created, with below codes by giving your MySql credential

Path: kohana\application\config\database.php

Notes: First create a database in your Mysql If the problem is not solved check your MySql settings too..there may be a error

    <?php defined('SYSPATH') OR die('No direct access allowed.');

return array
(
    'default' =>
 array
    (
        'type'       => 'MySQL',
        'connection' => array(
            /**
             * The following options are available for MySQL:
             *
             * string   hostname     server hostname, or socket
             * string   database     database name
             * string   username     database username
             * string   password     database password
             * boolean  persistent   use persistent connections?
             * array    variables    system variables as "key => value" pairs
             *
             * Ports and sockets may be appended to the hostname.
             */
            'hostname'   => 'localhost',
            'database'   => 'CHANGE YOUR DATABASE NAME HERE',
            'username'   => 'CHANGE YOUR USER NAME HERE',
            'password'   => 'CHANGE YOUR PASSWORD HERE',
            'persistent' => FALSE,
        ),
        'table_prefix' => '',
        'charset'      => 'utf8',

    ),
    'remote' => array(
        'type'       => 'MySQL',
        'connection' => array(
            /**
             * The following options are available for PDO:
             *
             * string   dsn         Data Source Name
             * string   username    database username
             * string   password    database password
             * boolean  persistent  use persistent connections?
             */
            'dsn'        => 'mysql:host=localhost;dbname=CHANGE YOUR DATABASE NAME HERE',
            'username'   => 'CHANGE YOUR USER NAME HERE',
            'password'   => 'CHANGE YOUR PASSWORD HERE',
            'persistent' => FALSE,
        ),
        /**
         * The following extra options are available for PDO:
         *
         * string   identifier  set the escaping identifier
         */
        'table_prefix' => '',
        'charset'      => 'utf8',
        'caching'      => FALSE,
    ),
);

Kohana - Database_Exception [ 2 ]: mysql_connect() 2

Database_Exception [ 2 ]: mysql_connect() [function.mysql-connect]: Access denied for user 'ivanh'@'localhost' (using password: NO)

MODPATH/database/classes/Kohana/Database/MySQL.php [ 67 ]

2 Answers