linux 安装mysql

linux下安装mysql

安装mysql：/usr/local/mysql
1.查看是否安装
rpm -qa | grep mysql
2.进入/usr/local/目录
cd /usr/local/
3.下载mysql
 wget https://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.45-linux-glibc2.12-x86_64.tar.gz
4.解压
tar -zxvf mysql-5.6.45-linux-glibc2.12-x86_64.tar.gz 
5.删除压缩包
rm -rf mysql-5.6.45-linux-glibc2.12-x86_64.tar.gz
6.重命名
mv mysql-5.6.45-linux-glibc2.12-x86_64/ mysql
7.开始mysql用户组和mysql用户，添加完使用groups mysql查看是否添加成功
groupadd mysql
useradd -r -g mysql mysql
8.查看分组是否成功
groups mysql
9. 修改mysql目录拥有者为刚建立的mysql用户
cd /usr/local/mysql/
chown -R mysql:mysql ./
10.mysql初始化
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
11.修改mysql目录拥有者为root用户，修改data目录拥有者为mysql
chown -R root:root ./ && chown -R mysql:mysql data

12启动mysql
./support-files/mysql.server start

13.发现并没有/var/log/mariadb/mariadb.log这个路径,那我们就创建, 并给mysql用户授权即可
mkdir /var/log/mariadb
touch /var/log/mariadb/mariadb.log
chown -R mysql:mysql? /var/log/mariadb/

14.创建“var/lib/mysql”目录，并且授予最大权限
mkdir /var/lib/mysql
chmod 777 /var/lib/mysql

15.vim /etc/my.cnf
请在[mysqld]下设置这一行：datadir = /usr/local/mysql/data

16.创建软连接
cd /var/lib/mysql/
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

17.修改密码和登录
./bin/mysqladmin -u root password 'root' 
./bin/mysql -h127.0.0.1 -uroot -proot

18.开启远程登录
grant all privileges on *.* to root@'%' identified by 'root';
刷新权限:flush privileges;

19.设置开机自启动
[root@wangpeng /]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@wangpeng /]# chmod +x /etc/init.d/mysqld
[root@wangpeng /]# chkconfig --add mysqld

20.用navicat连接了，如果不成功，登录aliyun服务器 配置安全组 手动添加3306端口