CodeIgniter Forums

Full Version: Can't access to the databases in mysql
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

Hi, all. I am using mysql-5.5.20-winx64 version. The problem is that I can not access the database I created using MySQL 5.5 Command Line Client. When I use the following code:
$dbs = $this->dbutil->list_databases();
foreach ($dbs as $db)
    echo $db;
    echo ('<br />');
I get the following result:

And when I use 'show databases' in mysql client, I get the following:
mysql> show databases;
| Database |
| information_schema |
| mysql |
| performance_schema |
| sakila |
| test |
| world |
6 rows in set (0.00 sec)

So the problem is that I can not access part of the databases that I created via MySQL command line client. Anyone know what the reason might be? Root user is used in both creating those databases and in the CI database config file.

** Moreover, if I use database forge class to create a database, then it is accessible to CI but not accessible to MySQL command line client.

Thanks a lot in advance.

El Forum

Found the problem. It is because the port used is 3307 but not 3306. Change that in the config file and everything runs fine.