安装CMAKE下载CMAKEhttps://cmake.org/download/解压文件tar-zxvfcmake-3.6.0-rc3.tar.gz安装GCCyuminstallgcc-c++切换到cmake目录cdcmake-3.6.0-rc3执行配置文件./configureinstallmake&&makeinstallinstallmariadb下载mariadbhttps://downloads.mariadb.org/mariadb/解压文件tar-zxvfmariadb-10.1.14.tar.gz切换到mariadb目录cdmariadb-10.1.14创建mysql用户组和用户组addmysqluseradd-rM-gmysql-s/sbin/nologinmysql创建安装目录和数据目录mkdir/usr/mariadbmkdir/usr/mariadb/datachown-Rmysql:mysql/usr/local/mariadb安装ncurses-develyum安装ncurses-devel编译cmake-DCMAKE_INSTALL_PREFIX=/usr/mariadb-DMYSQL_DATADIR=/usr/mariadb/data-DMYSQL_USER=mysql-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ciinstallmake&&makeinstall删除旧配置文件复制新文件rm-f/etc/my.cnfcp/usr/mariadb/support-files/my-large.cnf/etc/my.cnf初始化数据库/usr/mariadb/scripts/mysql_install_db--user=mysql--basedir=/usr/mariadb--datadir=/usr/mariadb/data添加环境变量运行命令打开系统文件vi/etc/profile最后添加MYSQL_HOME=/usr/mariadbPATH=$MYSQL_HOME/bin:$PATHexportPATHmariadbboot自启动cp/usr/mariadb/support-files/mysql.server/etc/init.d/mysqldchkconfig--addmysqldstartdatabaseservicemysqldstartsetdatabasepasswordmysqladmin-uroot-ppassword"新密码“登录到数据库设置root远程访问GRANTALLPRIVILEGESON*.*TO'root'@'%'IDENTIFIEDBY'password'WITHGRANTOPTION;flushprivileges;
