mysql编译安装添加用户useradd-s/usr/sbin/nologin-rmysql下载源码包并解压wgethttps://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.21。tar.gztar-zxfmysql-boost-5.7.21.tar.gzcdmysql-5.7.21安装扩展依赖yumremovemariadb-libsyuminstallgcc-yyuminstallgcc-c++-yyuminstallcmake-yyuminstalllibaio-yyuminstallncurses-devel-y创建mysql安装目录和数据库存放目录mkdir-p/data/db/mysqlmkdir-p/data/log/mysql编译安装mysqlcmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\-DSYSCONFDIR=/usr/local/mysql/etc\-DMYSQL_DATADIR=/data/mysql\-DWITH_MYISAM_STORAGE_ENGINE=1\-DWITH_INNOBASE_STORAGE_ENGINE=1\-DWITH_PARTITION_STORAGE_ENGINE=1\-DWITH_SYSTEMD=1\-DWITH_SSL=系统\-DWITH_ZLIB=系统\-DWITH_EMBEDDED_SERVER_DLE=1\-1\-DEXTRA_CHARSETS=all\-DDEFAULT_CHARSET=utf8mb4\-DDEFAULT_COLLATION=utf8mb4_general_ci\-DDOWNLOAD_BOOST=1\-DWITH_BOOST=/usr/local/boostmake-j8&&makeinstall查看是否安装成功[root@rootmysql-5.7.12]#cd/usr/local/mysql/[root@rootmysql]#lsbindataincludemanmysql.sock.lockREADMEsupport-filesCOPYINGdocslibmysql.sockmysql-testshare创建一个新目录mkdir-p/data/db/mysql/mkdir-p/data/log/mysql/Add配置文件mkdir/usr/local/mysql/etctouch/usr/local/mysql/etc/my.cnfln-s/usr/local/mysql/etc/my.cnf/usr/local/etc修改权限chown-Rmysql:mysql/usr/local/mysql/*chown-Rmysql:mysql/data/db/mysql/data/log/mysql生成初始化密码cd/usr/local/mysqlbin/mysqld--initialize--user=mysql--basedir=/usr/local/mysql--datadir=/data/db/mysqlbin/mysql_ssl_rsa_setupvim/data/log/mysql/error.log查看初始化密码grep'临时密码'/data/log/mysql/error.log到启动mysql服务添加到系统服务cp/usr/local/mysql/usr/lib/systemd/system/mysqld.service/usr/lib/systemd/systemmkdir-p/var/run/mysqld/chownmysql:mysql/var/run/mysqldsystemctlstartmysqldservicemysqlstartstartmysqlservicemysqldstart查看mysql启动是否正常servicemysqldstatus或者ps-ef|grepmysqlsetmysqld服务启动systemctlenablemysqld.servicecheckmysqldboot自启动是否成功setsystemctllist-dependencies|grepmysqld修改mysql密码，以及远程连接权限ALTERUSER'root'@'localhost'IDENTIFIEDBY'Studytime%';usemysql;selecthost,userfromuser;updateusersethost='%'whereuser='root';将*.*上的所有权限授予由'Studytime%'标识的'root'@'%'WITHGRANTOPTION;FLUSHPRIVILEGES;
