linux下安装mysql

下载安装包
mkdir /data/software -pv
cd /data/software
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
安装准备
cd /usr/local
tar -xf /data/software/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.17-linux-glibc2.5-x86_64/ mysql
cd mysql
mkdir data
groupadd mysql
useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql
chown -R mysql.mysql /usr/local/mysql/
执行安装脚本
./bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
cp -a ./support-files/my-default.cnf /etc/my.cnf
cp -a ./support-files/mysql.server /etc/init.d/mysqld
安装mariadb
yum install -y mariadb-server
systemctl start mariadb.service
systemctl enable mariadb.service
mysql_sceure_installation
调整环境变量
vim /etc/my.cnf
systemctl start mysql.service
查看密码
cat /root/.mysql_secret
修改密码
mysql -u root -p
SET PASSWORD FOR ‘root’@localhost=PASSWORD(‘123456’);
修改远程访问权限
use mysql
update user set host = ‘%’ where user = ‘root’ limit 1;
flush privileges;

mysql配置文件
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
socket = /tmp/mysql.sock

注意:
1.在5.7中修改密码的字段由原来的password转为authentication_string
update user set authentication_string=password(‘123456’) where user=‘root’;
flush privileges;

2、mysql5.7在linux下默认区分数据库表名大小写，如果想忽略此功能
	在mysql配置文件中的[mysqld]下设置
		lower_case_table_names=1

3、关于sock文件链接的错误，
	在mysql配置文件中的[mysql]下设置
		socket = /tmp/mysql.sock

export JAVA_HOME=/usr/lib/jdk1.8.0_74
export PATH=$JAV{A}_{H}OME/bin:$PATH
export CLASSPATH=.:$JAV{A}_{H}OME/lib/dt.jar:$JAVA_HOME/lib/tools.jar