MongoDB环境安装
yay -S mongodb34-bin
这个时候运行mongo命令我出现以下报错
MongoDB shell version v3.4.16
connecting to: mongodb://127.0.0.1:27017
2019-12-06T11:47:58.912+0800 W NETWORK [thread1] Failed to connect to 127.0.0.1:27017, in(checking socket for error after poll), reason: Connection refused
2019-12-06T11:47:58.916+0800 E QUERY [thread1] Error: couldn't connect to server 127.0.0.1:27017, connection attempt failed :
connect@src/mongo/shell/mongo.js:240:13
@(connect):1:6
exception: connect failed
这里需要启动服务
systemctl start mongodb.service // 启动服务
system enable mongodb // 设置开机自启动
这样就可以了,还可以安装一个客户端
yay -S robo3t-bin // 安装可视化界面
安装mysql
sudo pacman -S mysql
mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql // 初始化mysql
执行初始化的过程中我出现以下报错
mysqld: error while loading shared libraries: libicuuc.so.65: cannot open shared object file: No such file or directory
百度过后,参考这个大佬的解答:https://www.guqing.xyz/archives/mysql-libicu
以下我git clone时没有这个包,使用wget是可以下载的,速度不敢想像,这是百度网盘下载链接
链接: https://pan.baidu.com/s/1la6H_cepkyaNpFZIMz7-yg 提取码: nbt7 复制这段内容后打开百度网盘手机App,操作更方便哦。
当然,如果CSDN有vip的话,可以在我上传的资源中找到,下载即可。
下载到包以后从tar解压开始依次执行以下命令。
git clone https://github.com/unicode-org/icu/releases/download/release-65-rc/icu4c-65rc-src.tgz
tar -zxvf icu4c-65rc-src.tgz
cd icu/source
./configure
make
sudo make install
sudo ln -s /usr/local/lib/libicuuc.so.65 /usr/lib/libicuuc.so.65
sudo ln -s /usr/local/lib/libicui18n.so.65 /usr/lib/libicui18n.so.65
sudo ln -s /usr/local/lib/libicudata.so.65 /usr/lib/libicudata.so.65
之后再执行初始化操作,我出现如下问题
mysqld: Can't create directory '/var/lib/mysql/' (OS errno 17 - File exists)
2019-12-06T05:48:28.484665Z 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.
2019-12-06T05:48:28.484812Z 0 [System] [MY-013169] [Server] /usr/bin/mysqld (mysqld 8.0.18) initializing of server in progress as process 16568
2019-12-06T05:48:28.489066Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2019-12-06T05:48:28.489198Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-12-06T05:48:28.489524Z 0 [System] [MY-010910] [Server] /usr/bin/mysqld: Shutdown complete (mysqld 8.0.18) Source distribution.
不能够创建,感觉是权限不够的问题,使用sudo权限
sudo mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql
mysql终于成功初始化
2019-12-06T05:50:09.662707Z 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.
2019-12-06T05:50:09.662834Z 0 [System] [MY-013169] [Server] /usr/bin/mysqld (mysqld 8.0.18) initializing of server in progress as process 16588
2019-12-06T05:50:12.062984Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 你的密码
初始化成功以后:
sudo systemctl enable mysqld.service # 允许开机启动
systemctl start mysqld.service # 启动mysqld服务
systemctl status mysqld.service # 查看mysqld服务的状态
# 修改密码
mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
终于安装成功了。。。
后记
目的是在学习以下爬虫,所以安装了这些数据库,其实,在docker容器里安装应该会更好一些,可以保持系统干净些。仅作为学习记录,说不定什么时候我又重装系统了呢。
参考文章
https://www.guqing.xyz/archives/mysql-libicu