12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间:2024-12-25 09:56:52
作者:文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
1.安装Mysql数据库①下载Mysql数据包wgethttp://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz②在/usr/local/src下解压缩文件包tarzxvfmy
以下为本文的正文内容,内容仅供参考!本站为公益性网站,复制本文以及下载DOC文档全部免费。
1.安装Mysql数据库
①下载Mysql数据包
wgethttp://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
②在/usr/local/src下解压缩文件包
tarzxvfmysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
③将解压后的文件包改名为mysql
mvmysql-5.6.35-linux-glibc2.5-x86_64/usr/local/mysql
④创建名为mysql的用户以及/data/文件夹用于存放mysql数据库的数据
useraddmysqlmkdir/data/
⑤运行脚本安装数据库
[root@test_01mysql]#./scripts/mysql_install_db--user=mysql--datadir=/data/mysqlFATALERROR:pleaseinstallthefollowingPerlmodulesbeforeexecuting./scripts/mysql_install_db:Data::Dumper
此处出现错误,提示需要先安装Dumper,安装perl-Data-Dumper后解决问题
[root@test_01mysql]#yuminstall-yperl-Data-Dumper
⑥拷贝mysql模板配置文件至/etc/my.cnf。并修改socket和datadir的值为如下内容
datadir=/data/mysqlsocket=/tmp/mysql.sock
⑦配置启动文件
将mysql.server文件拷贝至/etc/init.d/mysqld,配置basedir和datadir
[root@test_01mysql]#cpsupport-files/mysql.server/etc/init.d/mysqldbasedir=/usr/local/mysqldatadir=/data/mysql
将mysqld加入启动服务中
[root@test_01mysql]#chkconfig--addmysqld[root@test_01mysql]#chkconfig--list注意:该输出结果只显示SysV服务,并不包含原生systemd服务。SysV配置数据可能被原生systemd配置覆盖。如果您想列出systemd服务,请执行'systemctllist-unit-files'。欲查看对特定target启用的服务请执行'systemctllist-dependencies[target]'。mysqld0:关1:关2:开3:开4:开5:开6:关netconsole0:关1:关2:关3:关4:关5:关6:关network0:关1:关2:开3:开4:开5:开6:关基于xinetd的服务:chargen-dgram:关chargen-stream:关daytime-dgram:关daytime-stream:关discard-dgram:关discard-stream:关echo-dgram:关echo-stream:关tcpmux-server:关time-dgram:关time-stream:关
⑧启动服务
[root@test_01mysql]#servicemysqldstartStartingMySQL.Loggingto'/data/mysql/test_01.err'......SUCCESS![root@test_01mysql]#netstat-lntpActiveInternetconnections(onlyservers)ProtoRecv-QSend-QLocalAddressForeignAddressStatePID/Programnametcp000.0.0.0:220.0.0.0:*LISTEN1411/sshdtcp00127.0.0.1:250.0.0.0:*LISTEN2075/mastertcp00192.168.231.128:8730.0.0.0:*LISTEN5995/rsynctcp600:::3306:::*LISTEN9562/mysqldtcp600:::22:::*LISTEN1411/sshdtcp600::1:25:::*LISTEN2075/master
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19