覆盖工匠迁移命令的默认 Laravel 数据库配置
问题描述
For my database (MySQL), I have two user accounts, one (mydbuser
) for general application access with select/inset/update/delete permissions on all tables, the other (mydbadmin
) with privilege to manage tables, etc
My Laravel app is configured to use the mydbuser
user, while mydbadmin
is currently used for manually setting up the tables, etc.
Now, I want to start using Artisan migrations
and seeding
to handle creating the database for new instances of the application, but with the standard application configuration, migrate
only has access to the lesser-privileged account, so can't actually create/drop the tables at all.
Is there a way of overriding the database user/password configured in database.php when I run
and other migrate commands? Some command line switch perhaps, that would allow me to specify the mydbadmin
user and password? Or even just to point to a different database configuration setting?
You may use:
but you need to have defined this seconddb
connection in your database.php
config file. Of course running this command you will only create migrations
table, nothing more, so if you want to make standard migration you need to use:
and for seeding:
Example database.php
file configuration:
And in case you need other information about paramters, you can always run --help
argument for example:
这篇关于覆盖工匠迁移命令的默认 Laravel 数据库配置的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!