前提:
用一个拥有sudo权限的用户安装
1.创建工作目录
在根目录下创建一个work目录,并赋予读写执行功能
cd /
sudo mkdir work
sudo chmod 777 -R work
2.安装依赖包
sudo yum -y install make gcc-c++ cmake bison-devel ncurses-devel
3.上传安装包并解压
mysql-5.6.14.tar.gz
tar -zxvf mysql-5.6.14.tar.gz
进到刚解压后的文件夹里面
cd mysql-5.6.14/
4.开始安装
4.1执行下面命令
sudo cmake -DCMAKE_INSTALL_PREFIX=/work/mysql -DMYSQL_DATADIR=/work/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
4.2编译并安装
sudo make && sudo make install
4.3创建mysql用户
sudo adduser mysql
sudo passwd mysql
4.4将编译好的mysql文件夹授权给mysql用户及mysql用户组
sudo chown -R mysql:mysql /work/mysql
4.5以mysql身份登录
su - mysql
4.6进到/work/mysql路径下
cd /work/mysql
4.7初始化数据
scripts/mysql_install_db --basedir=/work/mysql --datadir=/work/my
sql/data --user=mysql
Can't locate Data/Dumper.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/pe
rl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at scripts/mysql_install_db line 42.BEGIN failed--compilation aborted at scripts/mysql_install_db line 42.
如果报以上错误,则执行以下语句(切换回ryan用户即有sudo权限用户)
sudo yum install 'perl(Data::Dumper)'
切换回mysql用户,再次执行初始化脚本命令
将/etc/my.cnf文件删除,或者改名称
sudo mv /etc/my.cnf /etc/my.cnf.bak
4.8设置开机启动
cd /work/mysql
sudo cp support-files/mysql.server /etc/init.d/mysql
sudo chkconfig mysql on
4.9启动mysql服务
sudo service mysql start
5验证
5.1客户端连接进去
cd /work/mysql/bin
./mysql -uroot
5.2修改root密码
SET PASSWORD = PASSWORD('root2020');
5.3开放远程访问
use mysql;
select user,host,password from user;
将有密码那一行改为%即可
update user set host='localhost' where user='root' and host = '%';
update user set host='%' where user='root' and host = '127.0.0.1';
flush privileges;
5.4远程连接验证
打开navicat发现已经可以正常连接了。如果是用云服务器,一定要确保3306端口能够正常访问。腾讯云、阿里云等在安全组放行即可。