connect to database about homestead HOT 8 CLOSED

Can you try ;

'username' => 'root',
'password' => 'secret'

from homestead.

Yes, that works fine, did not find that in the docs. Thank you!

from homestead.

Alternatively you can add homestead@localhost
Just login mysql with root/secret

mysql -u root -p

CREATE USER 'homestead'@'localhost' IDENTIFIED BY 'secret';

GRANT ALL PRIVILEGES ON * . * TO 'homestead'@'localhost';

FLUSH PRIVILEGES;

from homestead.

We're fixing this :)

from homestead.

I'm still having trouble. Just installed and setup Homestead but can't get my app to connect to mySQL using either root or homestead usernames. Both work fine when I am SSH'd into the box.

from homestead.

What configs etc are you trying?—
Sent from Mailbox

On Fri, May 16, 2014 at 8:41 PM, Shealan Forshaw [email protected]
wrote:

I'm still having trouble. Just installed and setup Homestead but can't get my app to connect to mySQL using either root or homestead usernames. Both work fine when I am SSH'd into the box.

Reply to this email directly or view it on GitHub:
#5 (comment)

from homestead.

SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (111)

Using config:

    'mysql' => array(
        'driver'    => 'mysql',
        'host'      => '127.0.0.1',
        'database'  => 'beatnode',
        'username'  => 'homestead',
        'password'  => 'secret',
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
    ),

Obviously trying to connect to my db here but can't connect to homestead db either. Both work fine when SSH'd or connecting via mapped port in SequelPro.

from homestead.

Aha. Just tried changing 127.0.0.1 to localhost and it works. Is that a bug or did I read the docs wrong?

from homestead.