Level 35
I don't know Heidi that well but you need to connect to your homestead box first that is located on ip: 192.168.10.12 (first line of your config).
Mar 3, 2020
11
Level 1
Connecting Laravel to HeidiSQL
I've installed a laravel project and I installed homestead into that project. I'm now trying to connect my laravel project to HeidiSQL.
I thought I was doing fine but I get this error
SQL Error (1049): Unknown database 'laravel-database'
Here is my details on HeidiSQL
Network type: MariaDB or MySQL (TCP/IP)
Library: libmariadb.dll
Hostname/IP: 127.0.0.1
User: homestead
Password: secret
Port: 33060
Database: laravel-database
and this is in my Homestead.yaml file
ip: 192.168.10.12
memory: 2048
cpus: 2
provider: virtualbox
authorize: ~/.ssh/id_rsa.pub
keys:
- ~/.ssh/id_rsa
folders:
-
map: 'E:\Websites\laravel-app'
to: /home/vagrant/code
sites:
-
map: laravel-app.test
to: /home/vagrant/code/public
databases:
- laravel-database
features:
-
mariadb: false
-
ohmyzsh: false
-
webdriver: false
name: laravel-app
hostname: laravel-app
Level 75
I don't understand the question isn't HeidiSQL just a front end.
It's not a database.
You can connect MySQL to HeidiSQL.
But laravel has nothing to do with that.
Level 1
That is what I tried.
did this in details on HeidiSQL
Hostname/IP: 192.168.10.12
but I still got that error
Level 75
See my above reply you would connect the same way you connect laravel to mySQL.
It's just a connection string.
Level 102
I think @bastet is just trying to connect to the database from the Heidisql program.
Mine is set up at work. I'll check my settings tomorrow
Level 102
Did you set the port on Heidi to 33060? Ip is 127.0.0.1
Edit: oh just saw it in your first post. Nevermind
Level 102
Can you connect to it using laravel? Did you try to just connect to the default database name homestead
Level 75
Put Heidi on Vagrant.
Level 1
Level 75
Level 1
When I restarted my machine I saw my database show up in HeidiSQL. Not sure why though.
Please or to participate in this conversation.