0.前言
mysql8安装:/qq_21383435/article/details/80577038
1.下载
地址:/downloads/
然后找到mysql
找到下载地址
选择以前的版本,然后选择系统和版本
点击下载
然后下载后双击安装,直到结束
2.修改root密码
2.1 转到管理员权限
lcc@lcc bin$ sudo su
进入mysql目录
cd /usr/local/mysql/bin/
2.2 跳过权限
root@lcc bin# ./mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
[1] 955
root@lcc bin# Logging to '/usr/local/mysql-5.7.28-macos10.14-x86_64/data/lcc.err'.
-11-09T02:23:40.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql-5.7.28-macos10.14-x86_64/data
2.3 登录mysql
root@lcc bin# ./mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 7
Server version: 5.7.28 MySQL Community Server (GPL)
Copyright (c) 2000, , 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>
2.4 修改密码
ysql> use mysql;
ysql> update user set password=password('123456') where user='root' and host='localhost';
ERROR 1054 (42S22): Unknown column 'password' in 'field list'
执行后报错 ERROR 1054(42S22) Unknown column ‘password’ in ‘field list’
错误的原因是 5.7版本下的mysql数据库下已经没有password这个字段了,password字段改成了authentication_string
mysql> update mysql.user set authentication_string=password('*******') where user='*******'; #修改密码成功
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> flush privileges; #立即生效
Query OK, 0 rows affected (0.00 sec)
mysql> quit
2.5 验证登录
# 退出root用户
root@lcc bin# exit
exit
lcc@lcc bin$ ./mysql -u root -p
Enter password:123456
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 183
Server version: 5.7.28
Copyright (c) 2000, , 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.
# 参考:/memory6364/article/details/82426052
mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> alter user 'root'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)
mysql>