Yii: How to connect remotely to a database?

Question

I am trying to connect to a db remotely using the Yii framework

Is there any specific setting because i can't connect to the db.

'db' => array(
    'class' => 'PortalDbConnection',
    'connectionString' => 'mysql:host=192.168.0.2;dbname=mydb',
    'username' => 'root',
    'password' => '',
    'tablePrefix' => '',
    'emulatePrepare' => true,
    'enableParamLogging' => true,
    'enableProfiling' => true,
    'charset' => 'utf8',
),

Error

2013/10/16 09:14:22 [error] [exception.CDbException] SQLSTATE[HY000]
[2003] Can't connect to MySQL server on 'mysql5.ms.domain.net' (13)
2013/10/16 09:14:22 [info] [application] User: Guest (ID: )

nothing is wrong with this code,, issue is here `192.168.0.2`,, allow the access for * systems or atleast this system where the Yii/PHP code resides, — zzlalani, Oct 16 '13 at 06:36
take a look at this.. http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html — zzlalani, Oct 16 '13 at 06:41
still, not able to connect; will keep this article updated when i fix it — Ionut Flavius Pogacian, Oct 16 '13 at 07:03

score 3 · Accepted Answer · edited May 23 '17 at 12:10

3

This code is valid for me:

'db'=>array( 
        'connectionString' => 'mysql:host=192.168.1.96;dbname=dbname',
        'emulatePrepare' => true,
        'username' => 'root',
        'password' => '',
        'charset' => 'utf8',
        'enableProfiling'=>true,
        'enableParamLogging' => true,
    ),

Do you have configurated on the DB server the %root access, from remote?

Edited:

For configure remote access:

There's two steps in that process:

a) Grant privileges. As root user execute:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';

b) bind to all addresses:

The easiest way is to comment out the line in your my.cnf file:

#bind-address = 127.0.0.1

and restart mysql

service mysql restart

@hovanessyan solution: MySQL root access from all hosts

edited May 23 '17 at 12:10

Community

1
1

answered Oct 16 '13 at 06:30

Daniel Vaquero

1,315
1
8
13

what do you mean with %root access? – Ionut Flavius Pogacian Oct 16 '13 at 06:31
root@% means root can access from any host. I think by default root can only access from localhost. Of course that then means that any hacker can attempt to access your server with root access from any client that can get to it. Better not to use root, and to restrict the user that you are using to the server that your Yii application runs on. – jmarkmurphy Oct 16 '13 at 15:28

score 2 · Answer 2 · answered Oct 16 '13 at 08:35

It's a problem of server accessebily, not user access. Check number of port of mysql server (must be 3306, if not - use mysql:host=192.168.0.2;port=<your port>;dbname=mydb) and try to ping 192.168.0.2 (or maybe can run this nmap -p 3306 -sT 192.168.0.2, it from here) from the where yii placed

Yii: How to connect remotely to a database?

2 Answers2