Welcome Guest, Not a member yet? Register   Sign In
Can't access to the databases in mysql
#1

[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.
#2

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




Theme © iAndrew 2016 - Forum software by © MyBB