English 中文(简体)
MacOSX: 自动启动boot
原标题:MacOSX: autostart mysql on boot

我刚刚通过土勤人员在终点站安装了我的板。

现在,当我试图与我的sql连接时,它就失败了,但在我跑了<条码>之后,它就发挥了作用。

因此,我现在需要做的是我的麦克风。

I ve searched Valley for mysqld autoload atstartup 等等,但无法找到正确的答案。

希望的人可以把我引向正确的方向。 感谢!

最佳回答

<代码>brew info mysql,向您发出指示,在开始装上MySQL,但在此,你需要做:

mkdir -p ~/Library/LaunchAgents
cp `brew --prefix mysql`/*mysql*.plist ~/Library/LaunchAgents/
launchctl load -w ~/Library/LaunchAgents/*mysql*.plist
问题回答

现职:brew info mysql

To have launchd start mysql now and restart at login: brew services start mysql

Or, if you don t want/need a background service you can just run: mysql.server start

因此,运行<条码>brew服务开始采用我的sql,将确保它作为服务运行,并重新启动每个标识。

如果你以<代码>sudo管理该指令:

sudo brew services start mysql

该服务将使得服务运行on post,而不是在录制之后,这对服务器更为有用。

Mipadi s answer failed for me with MySQL 5.6.13 installed with Homebrew on the date of this post. But I checked brew info mysql as he suggested and it gave me a working solution:

> ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents
mkdir -p ~/Library/LaunchAgents
cp /usr/local/opt/mysql/homebrew.mxcl.mysql.plist ~/Library/LaunchAgents/
launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

你们不需要再制定一份名单。 最新版(1.3.4)截至2017年10月,只能运行:

<代码>brew servicesstart <service_name>

它将在你重新启用计算机时自动启动。 页: 1 你

To have launchd start mysql now and restart at login: brew services start mysql Or, if you don t want/need a background service you can just run: mysql.server start

3. Alejandro的后继行动

检查哪些服务是用户(log)和根(boot):

$ brew services list
Name       Status  User   Plist
chronograf started jacob  /Users/jacob/Library/LaunchAgents/homebrew.mxcl.chronograf.plist
grafana    started jacob  /Users/jacob/Library/LaunchAgents/homebrew.mxcl.grafana.plist
influxdb   started root   /Library/LaunchDaemons/homebrew.mxcl.influxdb.plist
kapacitor  stopped        
mariadb    started jacob  /Users/jacob/Library/LaunchAgents/homebrew.mxcl.mariadb.plist
memcached  started jacob  /Users/jacob/Library/LaunchAgents/homebrew.mxcl.memcached.plist
telegraf   started jacob  /Users/jacob/Library/LaunchAgents/homebrew.mxcl.telegraf.plist

I have brew install of MYSQL.

type

brew info mysql

遵循以下指示:

1. 启动原木:

ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents




相关问题
SQL SubQuery getting particular column

I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

php return a specific row from query

Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...

Character Encodings in PHP and MySQL

Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...

Pagination Strategies for Complex (slow) Datasets

What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...

Averaging a total in mySQL

My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...

热门标签