/****** 执行步骤 
上传文件
将MySQL linux压缩包上传/usr/local/文件夹下
解压MySQL  linux压缩包至本文件夹下
cd /usr/local
tar -zxvf mysql-5.6.17-linux-glibc2.12-x86_64.tar.gz

重命名解压后文件夹为mysql
mv /usr/local/mysql-5.6.17-linux-glibc2.12-x86_64 /usr/local/mysql

新建数据 文件夹
cd /
mkdir data
cd data
mkdir mysql
cd mysql
mkdir data log run

新建mysql用户组和mysql用户
groupadd mysql
useradd -r -g mysql mysql

将mysql文件夹授权于mysql用户
chown -R mysql:mysql /data/mysql/

mysql初始化
/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data

生成系统数据库 （openEuler arm）
/usr/local/mysql/bin/mysqld_safe --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/data/ --pid-file=/data/mysql/run/mysql.pid

打开my.cnf文件
vim /usr/local/mysql/my.cnf

编辑下列配置项
[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysql/data
log-error=/data/mysql/log/mysql.log
socket=/data/mysql/run/mysql.sock
pid-file=/data/mysql/run/mysql.pid
character_set_server=utf8
symbolic-links=0
explicit_defaults_for_timestamp=true
lower_case_table_names =1
group_concat_max_len=-1

修改mysql文件夹授予root用户
chown -R root:root /usr/local/mysql/

修改data文件夹授予mysql用户
chown -R mysql:mysql /data/mysql/

启动mysql服务
/usr/local/mysql/support-files/mysql.server start

Mysql开机自启
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
添加执行权限
chmod +x /etc/init.d/mysqld
#Centos命令
chkconfig --add mysqld 或者 chkconfig mysqld on

#Ubuntu命令
update-rc.d mysqld defaults Adding system startup for /etc/init.d/mysqld
update-rc.d mysqld remove

配置防火墙
vim /etc/sysconfig/iptables

-A INPUT -m state --state NEW -m  tcp -p tcp --dport 3306 -j ACCEPT

重启防火墙
service iptables restart
或者systemctl restart iptables.service

修改root账户密码
/usr/local/mysql/bin/mysqladmin -u root password
Zhongguang1986

root用户登录mysql
/usr/local/mysql/bin/mysql -h 127.0.0.1 -u root -p 
Zhongguang1986

新建zg账户
create user zg identified by '123456';
删除空账户
delete from mysql.user where user ='';
zg账户远程登录权限
grant all privileges on *.* to zg@'%' identified by '123456';
grant all privileges on *.* to zg@'localhost' identified by '123456';
grant all privileges on *.* to zg@'127.0.0.1' identified by '123456';
flush privileges; 

Ubuntu 故障解决方案
Error：error while loading shared libraries: libncurses.so.5
apt-get install libncurses5

Error while loading shared libraries: libaio.so.1
apt-get install libaio-dev

Error：Can't connect to local MySQL server through socket '/tmp/mysql.sock'
ln -s /data/mysql/run/mysql.sock /tmp/mysql.sock