[eluser]Unknown[/eluser]
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:
Code:
$dbs = $this->dbutil->list_databases();
foreach ($dbs as $db)
{
echo $db;
echo ('<br />');
}
I get the following result:
information_schema
mysql
performance_schema
test
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.