我认为,随着已经安装了旧的神秘面纱,我可以结束这一职务。 我也存在同样的问题,上述解决办法都没有对我有效。 因此,我确定:

旧布rew s remove &cleanup directs, unloaded the startctlscript, 然后删除了/usr/ local/var上的我的舱位。 (如果适用的话,可向您提出)和启动名单

Updated the string for the plist. Note also your alternate security script directory will be based on which version of MySQL you are installing.

逐步:

brew remove mysql

brew cleanup

launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist

sudo rm -rf /usr/local/var/mysql

I then started from scratch:

1. installed mysql with brew install mysql

2. 指挥员建议:

   unset TMPDIR
   
   mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
   

3. 开始我sql与mysql.server 开始的指挥,以便能够登录在上。

4. 替代安全说明:

   /usr/local/Cellar/mysql/5.5.10/bin/mysql_secure_installation
   

5. 跟踪<代码> 射线 栏目。

   #start
   launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
   
   #stop
   launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
   

< Note: the -force bit on brew Cleanup will also Cleanup original kegs, consider it s a new-ish homebrew norm.

www.un.org/Depts/DGACM/index_spanish.htm 注释二: 评论员说,不需要第2步。 我不想对此进行测试,因此,YMMV!

这里有详细的指令,把所有MySQL从你的Ma分离出去,然后安装“Brew Way”,Sedorner写道:

Remove MySQL completely per The Tech Lab

• ps -ax | grep mysql
• stop and kill any MySQL processes
• sudo rm /usr/local/mysql
• sudo rm -rf /usr/local/var/mysql
• sudo rm -rf /usr/local/mysql*
• sudo rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
• sudo rm -rf /Library/StartupItems/MySQLCOM
• sudo rm -rf /Library/PreferencePanes/My*
• launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
• edit /etc/hostconfig and remove the line MYSQLCOM=-YES-
• rm -rf ~/Library/PreferencePanes/My*
• sudo rm -rf /Library/Receipts/mysql*
• sudo rm -rf /Library/Receipts/MySQL*
• sudo rm -rf /private/var/db/receipts/*mysql*
• sudo rm -rf /tmp/mysql*
• try to run mysql, it shouldn t work

Brew install MySQL per user Sedorner from this StackOverflow answer

• brew doctor and fix any errors

• <条码>删除了我的sql。

• <条码> 显示器件

• www.un.org/Depts/DGACM/index_spanish.htm TMPDIR

    mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp # whoami is executed inline
  

• http://www.un.org/Depts/DGACM/index_spanish.htm

• 指挥 Brew建议,将MySQL添加到-startctl 因此,在启动时自动发射

现在应当工作并按预期运行所有时间

Godspeed。

问题相同。 如同所制定的指示或初步表格一样,有些错误。 这就是我如何用我的机器 running。

如果我的焊服务器已经运行在你的Mac上,则首先停止使用:

。

开始使用我的焊服务器,由以下指挥,允许任何人在完全许可的情况下投射。

www.un.org/Depts/DGACM/index_spanish.htm

然后,mysql -u fundamental, 如今,这应当让你在没有密码的情况下成功登录。 以下指挥机构应当重新确定所有根本密码。

UPDATE mysql.user SET Password=PASSWORD( NewPassword ) WHERE User= root ; FLUSH PRIVILEGES;

现在,如果你杀掉我的手脚印——安全,又不采用斯基普-快乐选择,就重新开张,那么你就应该能够用<条码>米斯喀尔-乌根——p和你刚才确定的新密码。

If brew installed MySQL 5.7, the process is a bit different than for previous versions. In order to reset the root password, proceed as follows:

sudo rm -rf /usr/local/var/mysql
mysqld --initialize

临时密码将刊印在议会,只能用于更新基本密码:

mysql.server start
echo "ALTER USER  root @ localhost  IDENTIFIED BY  my-new-password ;" | mysql -uroot --password=TEMPORARY_PASSWORD

Homebrew

1. First, make sure you have homebrew installed
2. Run brew doctor and address anything homebrew wants you to fix
3. Run brew install mysql
4. Run brew services restart mysql
5. Run mysql.server start
6. Run mysql_secure_installation

奥凯,我有同样的问题并解决了这个问题。 出于某种原因,我的手工艺品——安全——内装书写文字在使用家用燃烧器安装神秘面具时在盒子外工作,因此我是人工操作的。 http://www.ohchr.org。

mysql -u root

这应当使你陷入我的.。 现在做以下工作(摘自我sql_secure_installation):

UPDATE mysql.user SET Password=PASSWORD( your_new_pass ) WHERE User= root ;
DELETE FROM mysql.user WHERE User= root  AND Host NOT IN ( localhost ,  127.0.0.1 ,  ::1 );
DELETE FROM mysql.user WHERE User=  ;
DELETE FROM mysql.db WHERE Db= test  OR Db= test\_% 
DROP DATABASE test;
FLUSH PRIVILEGES;

如今已经离开,回到我的桌子上:mysql -u fundamental -p。

我现在也存在同样的问题。 如果你<代码>brew info mysql,并遵循它所认为的根本密码,那么如果我正确记住的话,就应当有<代码>新密码<>。 我看到你看到的同样情况:。 第条帮助我最多。

它拒绝了我为我创建的任何<><>><>>>账户。 当我在操作<条码>后打字时,我没有再接过任何电线。 我以<代码>mysqld_safe开启了MySQLWorkbench,并添加了“代码>root

If mysql is already installed

完全停止我s。

1. mysql.server stop <-- may need editing based on your version
2. ps -ef | grep mysql <-- lists processes with mysql in their name
3. kill [PID] <-- kill the processes by PID

移除档案。 上述指示是好的。 页: 1

1. sudo find /. -name "*mysql*"
2. Using your judgement, rm -rf these files. Note that many programs have drivers for mysql which you do not want to remove. For example, don t delete stuff in a PHP install s directory. Do remove stuff in its own mysql directory.

Install

希望你们有回家。 否则下载。

我现在要说一 root,但我不认为你必须。 Edit2018:你可以 t起rew子,再生根。

1. sudo brew update
2. sudo brew install cmake <-- dependency for mysql, useful
3. sudo brew install openssl <-- dependency for mysql, useful
4. sudo brew info mysql <-- skim through this... it gives you some idea of what s coming next
5. sudo brew install mysql --with-embedded; say done <-- Installs mysql with the embedded server. Tells you when it finishes (my install took 10 minutes)

Afterwards

1. sudo chown -R mysql /usr/local/var/mysql/ <-- mysql wouldn t work for me until I ran this command
2. sudo mysql.server start <-- once again, the exact syntax may vary
3. Create users in mysql (http://dev.mysql.com/doc/refman/5.7/en/create-user.html). Remember to add a password for the root user.

<<>strong>TL;DR

MySQL服务器安装后可能无法运行。 履历 如果你不希望我的SQL作为背景服务。

<>完整>

我刚刚安装了MySQL(表)5.7.17,涉及一个新的MacBook Pro的运行,在操作<密码>时也出现错误。

Securing the MySQL server deployment.

Enter password for user root: 
Error: Can t connect to local MySQL server through socket  /tmp/mysql.sock  (2)

Say what?

根据Brew的安装信息,mysql_secure_installation 请让我......确保安装。 我看到MySQL服务器可能无法运行,这是正确的。 滚动式<条码>brew服务从我的sql开始,然后mysql_secure_installation<>/code>与一个药店一样工作。