linux安装mysql
下载mysql https://dev.mysql.com/downloads/mysql/5.6.html#downloads
先检查是否有mysql用户组和mysql用户,没有就添加有就忽略: groups mysql
添加用户组和用户 groupadd mysql && useradd -r -g mysql mysql
进入mysql目录修改权限 cd mysql
chown -R mysql:mysql ./
ls /etc/my.cnf
rm my.cnf
rm /etc/my.cnf
安装依赖库 yum -y install autoconf && yum install libaio* -y && yum -y install numactl
执行安装脚本 ./scripts/mysql_install_db --user=mysql
cp support-files/my-default.cnf /etc/my.cnf
cp support-files/mysql.server /etc/rc.d/init.d/mysql
ln -s /usr/local/mysql/bin/mysql /usr/local/bin/mysql
mysql -u root -p
use mysql
update user set password =password('123456') where user = 'root';
flush privileges;
连接远程数据库
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;