Database Error PHP Codeigniter on my online server HELP

Xeroxeen

Member
May 20, 2013
1,935
73
0
~Logical Address~
machan mama php codeigniter walin website ekak haduwa.localhost eke elata wada karanawa.eth online server ekata daala website eka access karanakota mehema error ekak enawa.mage database configuration file eketh kisi awulak naha.

menna me error eka enne

Code:
A Database Error Occurred

Unable to connect to your database server using the provided settings.

Filename: core/Loader.php

Line Number: 346

me thamai configuration file eke details

Code:
$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = 'mysql.1freehosting.com';
$db['default']['username'] = 'MYUSERNAME';
$db['default']['password'] = 'MYPASSWORD;
$db['default']['database'] = 'MYDBNAME';
$db['default']['dbdriver'] = 'mysqli';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

plz help machan.mama net eketh baluwa hama thanama.hari answer ekak hambune naha:no:
 

SaNDun

Well-known member
  • May 4, 2006
    12,683
    819
    113
    In La Srinka
    host ekath localhost karala baluwa machan.eth naha :no:

    permission kiwwe database ekeda?eka kohomada karanne machan?
    database permission nam amuthuwen hadanna wena ekak naha. db eka create karanakota dena username & password ekata thamai permission set wenne. db eke port eka harida kiyala check karanna.
     

    Xeroxeen

    Member
    May 20, 2013
    1,935
    73
    0
    ~Logical Address~
    database permission nam amuthuwen hadanna wena ekak naha. db eka create karanakota dena username & password ekata thamai permission set wenne. db eke port eka harida kiyala check karanna.

    machan mama database eka localhost ekene haduwe.eeta passe eka export karala server ekata import kala.eka awulak nahane.kohomada machan db eke port eka harida kiyala check karanne?uba kiyanne online server ekeda?
     

    san1020

    Well-known member
  • Jun 8, 2011
    3,496
    506
    113
    ලැප ඉදිරියේ
    Try
    1. print_r($params) and print_r($active_record);
    2. if the $params are still correct then simplify $active_record
    3. echo mysql_error();
    4. $db[‘default’][‘db_debug’] = true/false
    5. $db[‘default’][‘stricton’] = true/false;
     

    Xeroxeen

    Member
    May 20, 2013
    1,935
    73
    0
    ~Logical Address~
    Try
    1. print_r($params) and print_r($active_record);
    2. if the $params are still correct then simplify $active_record
    3. echo mysql_error();
    4. $db[‘default’][‘db_debug’] = true/false
    5. $db[‘default’][‘stricton’] = true/false;

    machan me code eka koheda daann one?controller ekeda?

    machan codeigniter forum eketh mama meka damma.hena welawak yanawa ban monawata hari reply karanna.epa wenawa:sorry:
     
    Last edited:

    mldarshana

    Well-known member
  • Apr 2, 2007
    34,059
    1,404
    113
    ආශ්චර්ය අභියස :nerd:
    host ekath localhost karala baluwa machan.eth naha :no:

    permission kiwwe database ekeda?eka kohomada karanne machan?

    database user ta full privileges denna ona ... read/ write access

    00000266.png
     

    Xeroxeen

    Member
    May 20, 2013
    1,935
    73
    0
    ~Logical Address~
    database user ta full privileges denna ona ... read/ write access

    00000266.png

    machan oka denna one phpmyadmin eke privileges eken neda?mage server eke phpmyadmin privileges eka pennanne naha.eka nisa mama sql query ekak dunna mehema,

    "GRANT ALL PRIVILEGES ON *.* TO 'MYUSERNAME'@'%' WITH GRANT OPTION; "

    ethakota mehema awa,

    "#1470 - String 'MYUSERNAME' is too long for user name (should be no longer than 16)"