Hi, I’ve been trying to install TI on localhost and connect it to MySQL but somehow stuck with this error below.
Restarted server, apache, MySQL, and even fresh installed TI but nothing changed. I really don’t know what to do.
Could anyone know how to solve this error??
`
Migrating application and extensions…
In Connection.php line 669:
SQLSTATE[HY000] [2002] No such file or directory (SQL: select column_name as column_name from information_schema.columns where table_schema = tastyigniter_db and table_name = ti_migrations)
In PDOConnection.php line 47:
SQLSTATE[HY000] [2002] No such file or directory
In PDOConnection.php line 43:
SQLSTATE[HY000] [2002] No such file or directory
`
Already created database for TI. Here’s the config/database.php in the root directory.
'mysql' => [
'driver' => 'mysql',
'host' => 'localhost',
'port' => 3306,
'database' => 'tastyigniter_db',
'username' => 'root',
'password' => '{some password here}',
'unix_socket' => '',
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => 'ti_',
'strict' => FALSE,
'engine' => null,
],
When I look at the pdo cofiguration in php.ini, I see something like this
`
…skipping…
; http://php.net/pdo-odbc.connection-pooling
;pdo_odbc.connection_pooling=strict
;pdo_odbc.db2_instance_name
[Pdo_mysql]
; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
pdo_mysql.default_socket=
`
And when I run php -m | grep pdo, it says like
[root@1b44ef2433f1 /]# php -m | grep pdo
pdo_mysql
pdo_sqlite
Any idea will be appreciated!
