1.0.1检查系统是否安装其他版本的mysql
yum list installed | grep mysql yum -y remove mysql-libs.x86_64 |
1.0.2获取mysql5.6包并解压(tar包百度云)
tar xvf mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz |
1.0.3复制到指定目录
mv mysql-5.6.35-linux-glibc2.5-x86_64 /usr/local/mysql |
1.0.4创建mysql用户和组
groupadd mysql useradd -r -g mysql mysql -d /usr/local/mysql passwd mysql |
1.0.5修改目录权限
chown -R mysql:mysql /usr/local/mysql |
1.0.6安装数据库
su mysql /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data exit |
1.0.7复制mysql配置文件
cd /usr/local/mysql/support-files cp my-default.cnf /etc/my.cnf |
1.0.8添加系统服务
cp mysql.server /etc/init.d/mysql chkconfig mysql on |
1.0.9添加环境变量
vim /etc/profile 在最下面添加
export MYSQL_HOME="/usr/local/mysql" export PATH="$PATH:$MYSQL_HOME/bin" 保存退出后,执行生效代码
. /etc/profile |
1.1.0启动mysql
service mysql start |
1.1.1设置root密码
mysqladmin -u root password '123456' |
1.1.2设置默认端口
vim /etc/my.cnf [mysqld] basedir=/usr/local/mysql datadir=/usr/local/mysql/data port=3306 server_id=1 socket=/tmp/mysql.sock |
1.1.3mysql远程链接授权
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 注意:'myuser'、'mypassword' 需要替换成实际的用户名和密码。 FLUSH PRIVILEGES; |