1、下载MYSQL从官网下载MySQL安装包,下载链接:https://www.mysql.com/downloads/安装MYSQL解压MySQL安装包tar-zxvfmysql-5.7.22-linux-glibc2.12-x86_64。tar.gzmvmysql-5.7.22-linux-glibc2.12-x86_64/usr/local/mysql添加系统用户和用户组groupaddmysqluseradd-r-gmysqlmysql创建MySQL数据目录mkdir/usr/local/mysql/data修改MySQL目录权限chown-Rmysql:mysql/usr/local/mysql初始化数据库cd/usr/local/mysql./bin/mysqld--initialize--user=mysql--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data修改mysql目录权限chown-Rroot:root./chown-Rmysql:mysqldata添加启动服务cpsupport-files/mysql.server/etc/init.d/mysql修改MySQL配置文件vim/etc/my.cnf[mysqld]basedir=/usr/local/mysqldatadir=/usr/local/mysql/datasocket=/tmp/mysql.sockuser=mysqlport=3306character-set-server=utf8symbolic-links=0[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid!includedir/etc/my.cnf.d3.配置MySQL账号密码和远程连接修改my.cnf配置[mysqld]datadir=/usr/local/mysql/databasedir=/usr/local/mysqlsocket=/tmp/mysql.sockuser=mysqlport=3306character-set-server=utf8#跳过密码验证skip-grant-tablessymbolic-links=0[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid!includedir/etc/my.cnf.drestartMySQLserviceservicemysqlrestartsetuserloginpasswordmysql>ALTERUSER'root'@'localhost'IDENTIFIEDBY'123456';mysql>FLUSH特权;设置MySQL远程访问mysql>GRANTALLPRIVILEGESON*.*TO'root'@'%'IDENTIFIEDBY'123456'WITHGRANTOPTION;mysql>FLUSH特权;
