您好,欢迎访问一九零五行业门户网

mysql源码包如何安装

mysql源码包安装的方法:首先上传或下载源码包,并安装依赖;然后解压安装包,并生成;接着编译和安装、做软连接、创建用户、拷贝配置文件和启动脚本、初始化数据库等等;最后启动数据库和配置环境变量,并确认启动即可。
更多相关免费学习推荐:mysql教程(视频)
mysql源码包安装的方法:
源码包安装
1)上传或下载源码包
[root@db02 ~]# rz mysql-5.6.46.tar.gz
2)安装依赖
由于安装环境的不同,在生成的过程中可能也会报其它的错误,按照错误的提示安装相应的依耐包即可。
[root@db02 ~]# yum install -y ncurses-devel libaio-devel gcc gcc-c++ glibc cmake autoconf openssl openssl-devel
3)解压安装包
[root@db02 ~]# tar xf mysql-5.6.46.tar.gz
4)生成
[root@db02 ~]# cd mysql-5.6.46/[root@db02 mysql-5.6.46]# cmake . -dcmake_install_prefix=/usr/local/mysql-5.6.46 \-dmysql_datadir=/usr/local/mysql-5.6.46/data \-dmysql_unix_addr=/usr/local/mysql-5.6.46/tmp/mysql.sock \-ddefault_charset=utf8 \-ddefault_collation=utf8_general_ci \-dwith_extra_charsets=all \-dwith_innobase_storage_engine=1 \-dwith_federated_storage_engine=1 \-dwith_blackhole_storage_engine=1 \-dwithout_example_storage_engine=1 \-dwith_zlib=bundled \-dwith_ssl=system \-denabled_local_infile=1 \-dwith_embedded_server=1 \-denable_downloads=1 \-dwith_debug=0
5)编译和安装
[root@db02 mysql-5.6.46]# make && make install
6)做软连接
[root@db02 ~]# ln -s /usr/local/mysql-5.6.46 /usr/local/mysql
7)创建用户
[root@db02 ~]# useradd mysql -s /sbin/nologin -m
8)拷贝配置文件和启动脚本
[root@db02 ~]# cd /usr/local/mysql/support-files/[root@db02 support-files]# cp my-default.cnf /etc/my.cnfcp: overwrite '/etc/my.cnf'? y[root@db02 support-files]# cp mysql.server /etc/init.d/mysqld
9)初始化数据库
[root@db02 support-files]# cd /usr/local/mysql/scripts/[root@db02 scripts]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
8)配置system管理mysql
[root@db02 scripts]# vim /usr/lib/systemd/system/mysqld.service[unit]description=mysql serverdocumentation=man:mysqld(8)documentation=https://dev.mysql.com/doc/refman/en/using-systemd.htmlafter=network.targetafter=syslog.target[install]wantedby=multi-user.target[service]user=mysqlgroup=mysqlexecstart=/usr/local/bin/mysqld --defaults-file=/etc/my.cnflimitnofile = 5000[root@db02 scripts]# systemctl daemon-reload[root@db02 scripts]# systemctl start mysqld
9)启动失败报错
[root@db02 scripts]# /etc/init.d/mysqld startstarting mysql.logging to '/usr/local/mysql-5.6.46/data/db02.err'.200709 15:42:14 mysqld_safe directory '/usr/local/mysql-5.6.46/tmp' for unix socket file don't exists. error! the server quit without updating pid file (/usr/local/mysql-5.6.46/data/db02.pid). #原因:1.cmake过程指定了socket文件位置,实际位置不存在2.目录权限不足 #解决:[root@db02 scripts]# mkdir /usr/local/mysql-5.6.46/tmp/[root@db02 scripts]# chown -r mysql.mysql /usr/local/mysql[root@db02 scripts]# chown -r mysql.mysql /usr/local/mysql-5.6.46/
10)启动数据库
[root@db02 scripts]# systemctl start mysqld
11)配置环境变量
[root@db03 scripts]# vim /etc/profile.d/mysql.shexport path=/usr/local/mysql/bin:$path[root@db03 mysql]# source /etc/profile
12)确认启动
[root@m01 scripts]# ps -ef | grep mysqlmysql 12886 1 2 03:10 ? 00:00:00 /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnfroot 12921 10636 0 03:11 pts/1 00:00:00 grep --color=auto mysql[root@m01 scripts]# netstat -lntp tcp6 0 0 :::3306 :::* listen 12886/mysqld
以上就是mysql源码包如何安装的详细内容。
其它类似信息

推荐信息