执行mysql报错
mac下运行mysql报错
ERROR 1045 (28000): Access denied for user ‘zhang‘@‘localhost‘ (using password: NO)
解决很简单，执行命令sudo mysql即可
或者执行命令，mysql -u root
再解决不了，我就不知道了啊，你可以按照下边的方便，卸载了重装。
关闭运行的mysqld
比较暴力的方式：
查看mysql是否启动：ps -ef |grep mysql
输入：kill -9 (./mysqld前面第二个数字，这里是627) 然后回车
输入：ps -ef |grep mysql 就可以继续查看进程在不在：
删除mysql
删除前请确认是不是已经关闭运行的mysql，看上面
<code>brew remove mysql brew cleanup sudo rm /usr/<span class="hljs-built_in">local/mysql sudo rm <span class="hljs-attribute">-rf /usr/<span class="hljs-built_in">local/<span class="hljs-built_in">var/mysql sudo rm <span class="hljs-attribute">-rf /usr/<span class="hljs-built_in">local/mysql<span class="hljs-subst">* sudo rm ~/Library/LaunchAgents/homebrew<span class="hljs-built_in">.mxcl<span class="hljs-built_in">.mysql<span class="hljs-built_in">.plist sudo rm <span class="hljs-attribute">-rf /Library/StartupItems/MySQLCOM sudo rm <span class="hljs-attribute">-rf /Library/PreferencePanes/My<span class="hljs-subst">* launchctl unload <span class="hljs-attribute">-w~/Library/LaunchAgents/homebrew<span class="hljs-built_in">.mxcl<span class="hljs-built_in">.mysql<span class="hljs-built_in">.plist edit /etc/hostconfig <span class="hljs-literal">and remove the line MYSQLCOM<span class="hljs-subst">=-YES<span class="hljs-subst">- rm <span class="hljs-attribute">-rf ~/Library/PreferencePanes/My<span class="hljs-subst">* sudo rm <span class="hljs-attribute">-rf /Library/Receipts/mysql<span class="hljs-subst">* sudo rm <span class="hljs-attribute">-rf /Library/Receipts/MySQL<span class="hljs-subst">* sudo rm <span class="hljs-attribute">-rf /<span class="hljs-keyword">private/<span class="hljs-built_in">var/db/receipts<span class="hljs-comment">/*mysql*</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
安装
1.执行
<code>brew <span class="hljs-keyword">install mysql</span></code>
- 1
2.安装完 mysql 后，他会提示你 init database，并提供下面这两句让你执行，很可能你没执行这两句
<code><span class="hljs-comment">unset <span class="hljs-comment">TMPDIR <span class="hljs-comment">mysql_install_db <span class="hljs-literal">-<span class="hljs-literal">-<span class="hljs-comment">verbose <span class="hljs-literal">-<span class="hljs-literal">-<span class="hljs-comment">user=`whoami` <span class="hljs-literal">-<span class="hljs-literal">-<span class="hljs-comment">basedir="$(brew <span class="hljs-literal">-<span class="hljs-literal">-<span class="hljs-comment">prefix <span class="hljs-comment">mysql)" <span class="hljs-literal">-<span class="hljs-literal">-<span class="hljs-comment">datadir=/usr/local/var/mysql <span class="hljs-literal">-<span class="hljs-literal">-<span class="hljs-comment">tmpdir=/tmp</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></code>
- 1
- 2
3.然后就可以指向 mysql.server start 来启动了，为了安全，你还可以执行安全设置向导，根据提示一步一步配置
<code>mysql_secure_installation</code>
- 1
4.最后启动
<code>mysql.server <span class="hljs-operator"><span class="hljs-keyword">start</span></span></code>
- 1
参考地址
https://blog.csdn.net/xiaozh620/article/details/77530893
https://segmentfault.com/q/1010000000094608
mac下mysql安装、卸载、基本操作
标签：csdn cmak error who ret tty rem get tmp
本文系统来源：https://www.cnblogs.com/sexintercourse/p/11669024.html
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！