本文共 2354 字,大约阅读时间需要 7 分钟。
yum install -y gcc gcc-c++ cmake ncurses ncurses-devel bison openssl openssl-devel
wget https://cdn.mysql.com/archives/mysql-5.7/mysql-boost-5.7.28.tar.gz
mkdir -p /mysql/data
useradd -s /sbin/nologin mysqlid mysql出现如下信息,说明创建成功。uid=1000(mysql) gid=1000(mysql) groups=1000(mysql)
chown -R mysql:mysql /mysql
mkdir -p /usr/local/mysql
tar -zxvf mysql-boost-5.7.28.tar.gz
cd mysql-5.7.28cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/usr/local/mysql -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_DATADIR=/mysql/data -DMYSQL_TCP_PORT=3307 -DWITH_BOOST=boost/boost_1_59_0/ -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1
出现如下页面,表示成功。
make 出现如下页面表示成功
make install 出现如下页面表示成功
vim /usr/local/mysql/my.cnf文件配置内容:[mysqld]basedir=/usr/local/mysqldatadir=/mysql/datasocket=/tmp/mysql.sockport=3307[mysqld_safe]log-error=/var/log/mysql57/mysql57.logpid-file=/var/run/msyql57/mysql57.pid
mkdir /var/log/mysql57touch /var/log/mysql57/mysql57.logchown -R mysql:mysql /var/log/mysql57
/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/mysql/data
初始化完成后,会出现如下页面,最后面会出现数据库密码,后面会用到,记得保存一下。
/usr/local/mysql/support-files/mysql/server startlsof -i:3307 出现如下页面表示数据库启动成功
登陆数据库/usr/local/mysql/bin/mysql -uroot -p输入前面初始化出现的密码。登陆后,如下所示:
修改密码:mysql> alter user 'root'@'localhost' identified by '你的密码';Query OK, 0 rows affected (0.01 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)#远程登陆mysql> create user 'root'@'%' identified by '远程登陆密码';Query OK, 0 rows affected (0.00 sec)mysql> grant all privileges on *.* to 'root'@'%' identified by '远程登陆密码' with grant option;Query OK, 0 rows affected, 1 warning (0.00 sec)然后用navicat连接测试就可以了。
vim /etc/profile在末行添加export PATH=$PATH:/usr/local/mysql/bin/wq保存退出后source /etc/profile使环境变量生效。重新登陆数据库,只需要输入mysql -uroot -p就可以了。启动数据库(启动不了,看日志,一般是权限问题)mysqld &启动方式:mysqld --user=root 在my.cnf中添加user=mysql授权方式:chown -R mysql:mysql /mysqlchown -R mysql:mysql /var/run/mysqlchown -R mysql:mysql /tmp普通用户登陆
转载地址:http://gwabi.baihongyu.com/