MySQLWorkbench with Homestead

Installation

If you have a Windows and Mac machine download the MySQLWorkbench installer from here.


If you are on linux do the following:

  • Download the MYSQL APT repo.
  • Install the downloaded release package with the following command:
    sudo dpkg -i downloaded_file_path.deb
  • Update package information from the MySQL APT repository with the following command:
    sudo apt-get update
  • Install MySQL by the following command
    sudo apt-get install mysql-server
  • To install the MySQL Workbench:
    sudo apt-get install mysql-workbench-community


Connecting

Open Mysql workbench and click on new connection:

Set up the new connection:

  • Connection Name: Homestead
  • Hostname: 192.168.10.10
  • Username: homestead
  • Password: secret
  • Click on "Store in Keychain" and type it there.

Test the connection:

If you can't connect, make sure your vagrant box is up (vagrant up).

A new connection should be showing in the MySQLWorkbench home screen:

Double click on it to connect to your homestead database.


To import or export database SQL dump files click on server->import/export. Make sure to click on "self-contained file", not the default "folder" (our SQL is a single file with all the SQL commands).

Comments (0)

Search Here