安装坏境:系统 centos7
centos7不支持mysql,内部集成了mariadb, 而安装mysql的话会和mariadb文件冲突,所以需要先卸载mariadb, 以下为卸载mariadb,安装mysql的步骤
列出所有被安装的rpm package rpm -qa | grep mariadb
#卸载 rpm -e mariadb-libs-5.5.37-1.el7_0.x86_64
1,下载 下载地址:官网下载 下载版本: 我这里选择的5.6.33,通用版,linux下64位 直接通过linux命令行下载:wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz 2,解压 这里一定要通过命令行解压,找到你的安装包路径,到路径下,命令ls -l 显示绿色的就有权限解压 tar -zxvf mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz 复制解压后的mysql的mysql目录 cp -r mysql-5.6.33-linux-glibc2.5-x86_64 /usr/local/mysql 3,添加用户组和用户 添加用户组 groupadd mysql 添加用户mysql 到用户组mysql useradd -g mysql mysql 4,安装 cd /usr/local/mysql/ mkdir ./data/mysql chown -R mysql:mysql ./ ./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data/mysql cp support-files/mysql.server /etc/init.d/mysqld 分配权限 chmod 755 /etc/init.d/mysqld cp support-files/my-default.cnf /etc/my.cnf ,5,出现如下异常: FATAL ERROR: please install the following Perl modules before executing /usr/bin/mysql_install_db: Data::Dumper 解决: yum install -y perl-Module-Install.noarch -bash: ./scripts/mysql_install_db: /usr/bin/perl: bad interpreter: 没有那个文件或目录 解决:yum -y install perl perl-devel Installing MySQL system tables…/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory 解决:yum -y install libaio-devel 6,修改启动脚本 vi /etc/init.d/mysqld 7,修改项: basedir=/usr/local/mysql/ datadir=/usr/local/mysql/data/mysql 8,启动服务 service mysqld start 9,测试连接 ./mysql/bin/mysql -uroot 10,加入环境变量,编辑 /etc/profile,这样可以在任何地方用mysql命令了 export PATH=$PATH:/usr/local/mysql//bin 11,让配置文件生效 source /etc/profile
启动mysql service mysqld start 关闭mysql service mysqld stop 查看运行状态 service mysqld status
更改mysql的密码 SET PASSWORD FOR ‘root’@‘localhost’ = PASSWORD(‘newpass’);