mysql-8.0.25_centos7_tar启动
时间:2021-07-01 10:21:17
帮助过:28人阅读
.
25-el7-x86_64]# ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/mysql-
8.0.
25-el7-x86_64 --datadir=/usr/local/mysql/mysql-
8.0.
25-el7-x86_64/data --pid-
file=/usr/local/mysql/mysql-
8.0.
25-el7-x86_64/data/mysql.pid --
explicit_defaults_for_timestamp
2021-
06-06T06:
27:
44.224106Z
0 [System] [MY-
013169] [Server] /usr/local/mysql/mysql-
8.0.
25-el7-x86_64/bin/mysqld (mysqld
8.0.
25) initializing of server
in progress as process
80717
2021-
06-06T06:
27:
44.238078Z
1 [System] [MY-
013576] [InnoDB] InnoDB initialization has started.
2021-
06-06T06:
27:
45.442357Z
1 [System] [MY-
013577] [InnoDB] InnoDB initialization has ended.
2021-
06-06T06:
27:
48.173559Z
6 [Note] [MY-
010454] [Server] A temporary password is generated
for root@localhost: jma*_HL2yyzo
4.启动mysql服务 /usr/local/mysqlmysql-8.0.25-el7-x86_64/bin/mysqld &(最后的&为后台启动,可不写)
5.进入mysql /usr/local/mysqlmysql-8.0.25-el7-x86_64/bin/mysql -uroot -pjma*_HL2yyzo(密码为上面产生的随机密码)
7.修改密码并设置远程可连:
mysql> ALTER USER‘root‘@‘localhost‘ IDENTIFIED BY ‘123456‘;
Query OK, 0 rows affected (0.00 sec)
mysql> CREATE USER ‘root‘@‘%‘ IDENTIFIED BY ‘123456‘;
Query OK, 0 rows affected (0.02 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql-8.0.25_centos7_tar启动
标签:dir rate 数据库 com sys cal create ali download