manjaro安装MySQL8

1 篇文章 0 订阅
1 篇文章 0 订阅
[k@k-pc ~]$ sudo pacman -S mysql
[sudo] k 的密码:
正在解析依赖关系...
正在查找软件包冲突...

软件包 (5) jemalloc-1:5.2.1-1  libmysqlclient-8.0.17-2
           mysql-clients-8.0.17-2  protobuf-3.7.0-1  mysql-8.0.17-2

下载大小:    54.94 MiB
全部安装大小:  244.06 MiB
[k@k-pc ~]$ sudo mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql
[sudo] k 的密码:
2019-10-13T10:05:24.640169Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
这个sql_mdoe的设置有关,my.ini
2019-10-13T10:05:24.640218Z 0 [System] [MY-013169] [Server] /usr/bin/mysqld (mysqld 8.0.17) initializing of server in progress as process 2485
2019-10-13T10:05:27.947546Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Yz;f4tY/t%N,
2019-10-13T10:05:29.900996Z 0 [System] [MY-013170] [Server] /usr/bin/mysqld (mysqld 8.0.17) initializing of server has completed
[Server] A temporary password is generated for root@localhost: Yz;f4tY/t%N,
                                               用戶名          密碼
[k@k-pc ~]$ sudo systemctl restart mysqld
開啓服務
[k@k-pc ~]$ mysql -u root -p
[k@k-pc ~]$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.17

Copyright (c) 2000, 2019, 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、付费专栏及课程。

余额充值