MYSQL数据库Mysql 5.7.17安装后登录mysql的教程

MYSQL应用
[Note] A temporary password is generated for root@localhost: Wtng#?e&S5,-

MYSQL应用
$ /usr/local/mysql/bin/mysql -uroot -p'Wtng#?e&S5,-'

MYSQL应用
mysql> set password = password('mypassword');

MYSQL应用
$ vi /etc/my.cnf
  [mysqld]配置区域添加：
  skip-grant-tables
$ service mysqld restart

MYSQL应用
$ /usr/local/mysql/bin/mysql -uroot 
mysql> update user set authentication_string=password('mypassword') where user='root';
mysql> quit

MYSQL应用
$ yum install Cy wget gcc gcc-c++ bison ncurses ncurses-devel 

MYSQL应用
$ cd /usr/local/src/
$ wget https://cmake.org/files/v3.7/cmake-3.7.1.tar.gz
$ tar zxvf cmake-3.7.1.tar.gz
$ cd cmake-3.7.1
$ ./bootstrap && gmake && gmake install

MYSQL应用
$ wget https://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
$ tar zxf boost_1_59_0.tar.gz
$ mv boost_1_59_0 /usr/local/

MYSQL应用
$ cd /usr/local/src/
$ wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.17.tar.gz
$ tar zxvf mysql-5.7.17.tar.gz

MYSQL应用
$ groupadd mysql
$ useradd -r -g mysql -s /sbin/nologin mysql

MYSQL应用
$ cd /usr/local/src/mysql-5.7.17
$ mkdir build
$ cd build
$ cmake .. \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DSYSCONFDIR=/etc \
-DMYSQL_DATADIR=/data/mysql \
-DMYSQL_USER=mysql \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_BOOST=/usr/local/boost_1_59_0
$ make && make install

MYSQL应用
$ cd /usr/local/mysql
$ chown -R mysql:mysql .
$ mkdir -p /data/mysql
$ chown -R mysql.mysql /data/mysql
$ ./bin/mysqld --initialize \
--user=mysql \
--basedir=/usr/local/mysql \
--datadir=/data/mysql
$ ./bin/mysql_ssl_rsa_setup --datadir=/data/mysql

MYSQL应用
$ cp support-files/my-default.cnf /etc/my.cnf
$ vim !$

MYSQL应用
basedir = /usr/local/mysql
datadir = /data/mysql
port = 3306
socket = /tmp/mysql.sock

MYSQL应用
$ cp support-files/mysql.server /etc/init.d/mysqld
$ vim !$

MYSQL应用
 basedir = /usr/local/mysql
  datadir = /data/mysql

MYSQL应用
/etc/init.d/mysqld start

MYSQL应用
$ chkconfig --add mysqld
$ chkconfig mysqld on
$ service mysqld start