Welcome Guest, Not a member yet? Register   Sign In
mysql connection refused
#3

(06-26-2018, 03:36 PM)jameshking Wrote: I am a beginner with CI and I am working my way through the tutorials on your site as well as some others I found through googling.  Everything works fine until I encounter a part of the tutorial that requires interface to mysql.  I have tried many suggestions found through googling, but so far nothing works.  I have a simple controller that echos Hello world and then tries to $this->load->database();  This fails with connection refused error.  This is my current database connection configuration:
$db['default'] = array(
'dsn' => '',
'hostname' => 'localhost:/db01/var/lib/mysql/mysql.sock',
'username' => 'jking',
'password' => 'mypassword',
'database' => 'citut',
'dbdriver' => 'mysqli',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => FALSE,
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array()
);

As you can see, the location of the database has been moved on this particular server.

Any help would be appreciated.  Thanks
I have all access to my server and mysql.  I am able to login to mysql locally on the server with my credentials.  I am also able to login to mysql remotely  with a couple of products like sequelpro using the same credentials.  I have not tried replacing localhost with 127.0.0.1, but i will try that.
Reply


Messages In This Thread
mysql connection refused - by jameshking - 06-26-2018, 03:36 PM
RE: mysql connection refused - by jlarroulet - 06-26-2018, 05:58 PM
RE: mysql connection refused - by jameshking - 06-26-2018, 06:46 PM
RE: mysql connection refused - by InsiteFX - 06-27-2018, 03:09 AM
RE: mysql connection refused - by jameshking - 06-27-2018, 03:07 PM
RE: mysql connection refused - by alamowais - 07-24-2018, 09:50 AM



Theme © iAndrew 2016 - Forum software by © MyBB