linux下MySQL数据库的安装和Solr环境搭建配置
简介:
基于Lucene的java搜索引擎服务器程序
功能:数据导入、增量更新、数据检索(全文检索、高亮显示、精确搜索)
全文检索:
分析用户输入,并对用户输入进行拆分,组合等转化操作,根据转化后的数据对数据源数据进行检索,并将检索结果返回给用户
分词器介绍:将用户输入根据语义拆分成多个词语(常用:word分词器、IKAnalyzer分词器等)
solr下载地址(版本4.9.1):
为什么需要搜索引擎:因为传统的SQL语句实现方式效率低下
一、通过打开虚拟机连接SecureCRT,进行linux下MySQL数据库的安装
1、linux下MySQL数据库的安装
1.检测系统自带Mysql,并卸载
[root@localhost ~]# rpm -qa | grep mysql
mysql-libs-5.1.66-2.el6_3.x86_64
2.删除mysql
[root@localhost ~]# rpm -e mysql-libs-5.1.66-2.el6_3.x86_64 --nodeps
[root@localhost ~]# rpm -qa | grep mysql
3.通过网络安装MySQL (yum)
[root@localhost ~]# yum -y install mysql-devel mysql-server
Loaded plugins: fastestmirror, refresh-packagekit, security
Existing lock /var/run/yum.pid: another copy is running as pid 2591.
Another app is currently holding the yum lock; waiting for it to exit...
The other application is: PackageKit
Memory : 24 M RSS (331 MB VSZ)
Started: Tue Aug 11 02:44:59 2020 - 00:34 ago
State : Sleeping, pid: 2591
.......
4.安装后查看是否安装成功
[root@localhost ~]# rpm -qa | grep mysql
mysql-devel-5.1.73-8.el6_8.x86_64
mysql-libs-5.1.73-8.el6_8.x86_64
mysql-server-5.1.73-8.el6_8.x86_64
mysql-5.1.73-8.el6_8.x86_64
5.安装后启动服务命令
[root@localhost ~]# service mysqld start
6.查看mysql是否已启动
[root@localhost ~]# ps -ef | grep mysql
root 2800 1 0 02:53 pts/0 00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql 2902 2800 6 02:53 pts/0 00:00:02 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
root 2948 2535 0 02:53 pts/0 00:00:00 grep mysql
7.开机自启动
[root@localhost ~]# chkconfig mysqld on
8.设置用户和密码
[root@localhost ~]# /usr/bin/mysqladmin -uroot password '123456'
9.进入
[root@localhost ~]# mysql -uroot -p123456
10.查看mysql用户
mysql> select host,user,password from mysql.user;
+-----------------------+------+-------------------------------------------+