在mac os上安装mysql5.7.11

mysql> update user set authentication_string=password('root') where user='root' and host='localhost';
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 1

在mac os上安装mysql5.7.11

安装好以后,登录mysql

bash-3.2$ mysql -u root -p

出现如下错误信息:

error: 'Access denied for user 'root'@'localhost' (using password: NO)'
这是因为root密码问题,修改root密码,如下:

bash-3.2$ mysqladmin -u root password root
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

出现上面错误;
切换到mac os管理员账号;


bash-3.2$ su root
Password:

执行如下mysql指令,取消对mysql账号的安全验证;

sh-3.2# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
[1] 9569
sh-3.2# 2016-03-14T13:40:49.6NZ mysqld_safe Logging to '/usr/local/mysql/data/liguohuideMacBook-Pro.local.err'.
2016-03-14T13:40:49.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
sh-3.2# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 5.7.11 MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.



执行修改root用户密码指令:


mysql> update user set authentication_string=password('root') where user='root' and host='localhost';
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 1


刷新权限:


mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

退出mysql数据库;

mysql> quit
Bye




关闭所有mysqld的进程;
bash-3.2$ killall -TERM mysqld


启动mysql安全模式;
bash-3.2$ mysqld_safe &


重启mysql数据库,用账户root登录mysql
bash-3.2$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 195
Server version: 5.7.11


Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql>


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值