ターミナルでのmysqlの起動方法

Question

ターミナルの使い方は全くの初心者です。

自分の場合mysql.server start⇨mysql -uroot
としても プロゲートに書いてあったbrew services stat mysql
としても起動できるのですが、

.どっちで起動するべきなのでしょうか？
.この二つの違いはなんなのでしょうか？

よろしくお願いいたします。

Answer 1

自分の場合mysql.server start

この場合、ただ単にmysqlサーバーをアプリとして起動するだけになります。

MacOSにはlaunchctlというサービス・デーモン管理の仕組みがあって、

brew services stat mysql

で起動すると、launchctlツールでサービスを管理できるようになります。

~ $ launchctl list | grep brew
3011    0   homebrew.mxcl.mongodb-community@4.0
473     0   homebrew.mxcl.postgresql
3492    0   homebrew.mxcl.mysql
2863    0   homebrew.mxcl.httpd

launchctlにはサービスを管理、制御するいろいろなオプションがあります。

~ $ launchctl
Usage: launchctl <subcommand> ... | help [subcommand]
Many subcommands take a target specifier that refers to a domain or service
within that domain. The available specifier forms are:

Subcommands:
	bootstrap       Bootstraps a domain or a service into a domain.
	bootout         Tears down a domain or removes a service from a domain.
	enable          Enables an existing service.
	disable         Disables an existing service.
	kickstart       Forces an existing service to start.
	attach          Attach the system's debugger to a service.
	debug           Configures the next invocation of a service for debugging.
	kill            Sends a signal to the service instance.
	blame           Prints the reason a service is running.
	print           Prints a description of a domain or service.
	print-cache     Prints information about the service cache.
	print-disabled  Prints which services are disabled.
	procinfo        Prints port information about a process.
	hostinfo        Prints port information about the host.
	resolveport     Resolves a port name from a process to an endpoint in launchd.
	limit           Reads or modifies launchd's resource limits.
	runstats        Prints performance statistics for a service.
	config          Modifies persistent configuration parameters for launchd domains.
	dumpstate       Dumps launchd state to stdout.
	dumpjpcategory  Dumps the jetsam properties category for all services.
	reboot          Initiates a system reboot of the specified type.
	bootshell       Brings the system up from single-user mode with a console shell.
	load            Bootstraps a service or directory of services.
	unload          Unloads a service or directory of services.
	remove          Unloads the specified service name.
	list            Lists information about services.
	start           Starts the specified service.
	stop            Stops the specified service if it is running.
	getenv          Gets the value of an environment variable from within launchd.
	bsexec          Execute a program in another process' bootstrap context.
	asuser          Execute a program in the bootstrap context of a given user.
	submit          Submit a basic job from the command line.
	managerpid      Prints the PID of the launchd controlling the session.
	manageruid      Prints the UID of the current launchd session.
	managername     Prints the name of the current launchd session.
	error           Prints a description of an error.
	variant         Prints the launchd variant.
	version         Prints the launchd version.
	help            Prints the usage for a given subcommand.

結論を言うとどちらで起動してもいいですが、homebrewの作法に従った方が無難です。