Documentation for macOS
#Installing MySQL via Herd Pro
MySQL is the most popular relational database engine for web development, and setting up a database server with a few clicks makes it incredibly easy to follow tutorials or get up and running with a professional setup in minutes. Many popular hosting platforms like Laravel Forge support MySQL databases out of the box, making the switch from local to production a breeze.
If you are new to Laravel and want to move from SQLite to a database service, MySQL is the best choice for most applications.
#Configuration
Herd provides a sensible default configuration for your MySQL instance that works seamlessly for new setups, and you can change the port of the service to run it in parallel to existing installations on your machine.
Enabling the autostart option automatically starts a service instance when you start Herd.
DB_CONNECTION=mysqlDB_HOST=127.0.0.1DB_PORT=3307DB_DATABASE=laravel # set this to your project databaseDB_USERNAME=rootDB_PASSWORD=
#Database service migrations
Whether you set up a newer version of MySQL or migrate from existing instances on your machine, the most comfortable way is to use a database client like TablePlus to export and import the database tables.
#Connecting via CLI
Herd symlinks the mysql
to your PATH, so you can connect to the database via the command line.
As Laravel Herd allows you to start multiple MySQL servers, you should specify the port to connect to the correct instance.
For example, to connect to the MySQL server running on port 3306, you can use the following command:
mysql -u root -h 127.0.0.1 -P 3306 -p