<?php
// uncomment the following to define a path alias
// Yii::setPathOfAlias('local','path/to/local-folder');
// This is the main Web application configuration. Any writable
// CWebApplication properties can be configured here.
echo 'jee';
return array(
'basePath'=>dirname(__FILE__).DIRECTORY_SEPARATOR.'..',
'name'=>'My Web Application',
// preloading 'log' component
'preload'=>array('log'),
// autoloading model and component classes
'import'=>array(
'application.models.*',
'application.components.*',
),
'modules'=>array(
// uncomment the following to enable the Gii tool
/*
'gii'=>array(
'class'=>'system.gii.GiiModule',
'password'=>'Enter Your Password Here',
),
*/
),
// application components
'components'=>array(
'user'=>array(
// enable cookie-based authentication
'allowAutoLogin'=>true,
),
// uncomment the following to enable URLs in path-format
/*
'urlManager'=>array(
'urlFormat'=>'path',
'rules'=>array(
'<controller:\w+>/<id:\d+>'=>'<controller>/view',
'<controller:\w+>/<action:\w+>/<id:\d+>'=>'<controller>/<action>',
'<controller:\w+>/<action:\w+>'=>'<controller>/<action>',
),
),
*/
/*
'db'=>array(
'connectionString' => 'sqlite:'.dirname(__FILE__).'/../data/testdrive.db',
),
*/
// uncomment the following to use a MySQL database
'db'=>array(
'connectionString' => 'mysql:host=localhost;dbname=portfolio',
'emulatePrepare' => true,
'username' => 'root',
'password' => '',
'charset' => 'utf8',
),
'errorHandler'=>array(
// use 'site/error' action to display errors
'errorAction'=>'site/error',
),
'log'=>array(
'class'=>'CLogRouter',
'routes'=>array(
array(
'class'=>'CFileLogRoute',
'levels'=>'error, warning',
),
// uncomment the following to show log messages on web pages
/*
array(
'class'=>'CWebLogRoute',
),
*/
),
),
),
// application-level parameters that can be accessed
// using Yii::app()->params['paramName']
'params'=>array(
// this is used in contact page
'adminEmail'=>'webmaster@example.com',
),
);
Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user '.root'.
the root password is not set in MySQL that’s just a security issue and why you get a warning in pgpmysql, but it’s not the reason why your code is not connecting to mysql
Have you tryed to create a model? Have you got any error?
Okey, now i have made new user in mysql which is poiting to localhost with all privileges to database "portfolio". Also global priviledges are set to be "all priviledges".
Still nothing special happens. I wonder do the yii make new database just calling index.php in browser or is there some URL what I should call to initialize new MySQL database?
Becouse I think it is still using SQLite becouse you can log in and log out normally, which should not be possible action without database.
Seems to me that you need to study Yii a bit more… have you read the definitive guide to Yii ?
Yii does not initialize the database or create any table… you have to do it with some other tools like phpMyAdmin…
You can log in because the default code generated by Gii does not use a database for logging in… it has fixed username/password as "admin/admin" or "demo/demo"
But again… check the guide… there are explained all this "starter" steps…
I echoed those variables in error log and they seemed to be pointing my created database(with necessary user table) but maybe I’m going to find next solutation with my self, or at least I hope so…