【Mysql】Linux安装
准备数据目录:
mkdir /data/mysql
下载Mysql:
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
tar -xzvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.17-linux-glibc2.5-x86_64 /usr/local/mysql
cd /usr/local/mysql
增加mysq的用户、组:
addgroup mysql
useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql
chown -R mysql .
chgrp -R mysql .
chown -R mysql /data/mysql
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
报错:bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
解决方法:
yum install -y libaio //运行此命令
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
bin/mysql_ssl_rsa_setup --datadir=/data/mysql
cd /usr/local/mysql/support-files
cp my-default.cnf /etc/my.cnf
cp mysql.server /etc/init.d/mysql
vim /etc/init.d/mysql:修改basedir、basedata
修改my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/data/mysql
启动mysql
/etc/init.d/mysql start
报错:Starting MySQL./usr/local/mysql/bin/mysqld_safe: line 586: /var/lib/mysql/mysqld_safe.pid: No such file or directory
按提示把相应的目录、权限都加上。
南京小黄猫教育
是专业的计算机编程培训,包含面向少儿的Scratch,面向青少年的Python,面向就业的Java、C/C++及Web前端技术。微信:wuwy233
地址:南京市江宁区月华路12-6弘阳上院