linux mysql 5.7.13 安装_Linux环境下mysql5.7.13安装教程

注意事项：需要先安装cmake、bison、boost库

http://blog.csdn.net/xyang81/article/details/51792144

2、安装cmake 和 bison首先可以查看下是否安装了

cmake

1

2

3

4

5

6

7

8

9

# rpm -qa |grep cmake

# tar zxvf cmake-3.6.0.tar.gz

# cd cmake-3.6.0

# ./bootstrap

# make && make install

# tar zxvf bison-3.0.4.tar.gz

# cd bison-3.0.4

# ./configure

# make && make install

3、安装Mysql

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

[root@localhost src]# tar -zxvf

mysql-5.7.13.tar.gz

[root@localhost src]# cd mysql-5.7.13

[root@localhost mysql-5.7.13]# cmake

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql

-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock

-DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

-DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1

-DWITH_BLACKHOLE_STORAGE_ENGINE=1

-DMYSQL_DATADIR=/usr/local/mysql/data -DMYSQL_TCP_PORT=3306

-DENABLE_DOWNLOADS=1

...

CMake Error at

cmake/boost.cmake:81 (MESSAGE):

You can download

it with -DDOWNLOAD_BOOST=1

-DWITH_BOOST=

This CMake script will

look for boost in

. If it is not

there,

it will download

and unpack it (in that

directory) for you.

If you are inside a

firewall, you may need to use an http

proxy:

Call Stack (most recent call

first):

cmake/boost.cmake:238

(COULD_NOT_FIND_BOOST)

CMakeLists.txt:451

(INCLUDE)

-- Configuring incomplete, errors occurred!

注：重新运行配置，需要删除CMakeCache.txt文件 解决：

(1)在预编译时添加相应的选项：cmake -DDOWNLOAD_BOOST=1

-DWITH_BOOST=/usr/local/boost (2)或者下载一个boost包，放到/usr/local/boost目录下，然后在cmake后面加选项-DWITH_BOOST=/usr/local/boost

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

[root@localhost mysql-5.7.13]# cmake

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql

-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DDEFAULT_CHARSET=gbk

-DDEFAULT_COLLATION=gbk_chinese_ci -DWITH_INNOBASE_STORAGE_ENGINE=1

-DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1

-DMYSQL_DATADIR=/data/mysqldb -DMYSQL_TCP_PORT=3306

-DENABLE_DOWNLOADS=1 -DDOWNLOAD_BOOST=1

-DWITH_BOOST=/usr/local/boost

....

CMake Error at

cmake/readline.cmake:64

(MESSAGE):

Curses library not found.

Please install appropriate

package,

remove CMakeCache.txt and

rerun cmake.On Debian/Ubuntu, package

name is libncurses5-dev, on Redhat and derivates it is

ncurses-devel.

Call Stack (most recent

call first):

cmake/readline.cmake:107

(FIND_CURSES)

cmake/readline.cmake:181

(MYSQL_USE_BUNDLED_EDITLINE)

CMakeLists.txt:479

(MYSQL_CHECK_EDITLINE)

-- Configuring

incomplete, errors occurred!

See also

"/usr/local/src/mysql-5.7.13/CMakeFiles/CMakeOutput.log".

See also

"/usr/local/src/mysql-5.7.13/CMakeFiles/CMakeError.log".

解决： (1)安装ncurses-devel yum -y install ncurses-devel(2)删除CMakeCache.txt rm CMakeCache.txt

(3)重新cmake

[root@localhost mysql-5.7.13]# cmake

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql

-DMYSQL_UNIX_ADDR=mysql.mysql -DDEFAULT_CHARSET=gbk

-DDEFAULT_COLLATION=gbk_chinese_ci -DWITH_INNOBASE_STORAGE_ENGINE=1

-DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1

-DMYSQL_DATADIR=/data/mysqldb -DMYSQL_TCP_PORT=3306

-DENABLE_DOWNLOADS=1 -DDOWNLOAD_BOOST=1

-DWITH_BOOST=/usr/local/boost

[root@localhost mysql-5.7.13]# make[root@localhost

mysql-5.7.13]# make install

默认密码位置

/root/.mysql_secret

启动命令

mysqld_safe --defaults-file=data/conf/mysql.cnf >/dev/null

2>&1 &

登录命令

mysql --default-character-set=utf8

--socket=/usr/local/mysql/data/mysql.sock -uroot -p"123456"

修改密码

update mysql.user set authentication_string=PASSWORD('123456')

where user='root' and host='localhost';

权限修改

GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH

GRANT OPTION;

创建新的实例

mysqld --initialize-insecure --user=mysql --datadir=/mysql/data --basedir=/usr/local/mysql --socket=/tmp/mysql.sock //在MySQL 5.7.6版本以前是 bin/mysql_install_db --user

mysql5.7密码问题

my.cnf 加入skip-grant-tables

setglobalvalidate_password_policy=0;

setglobalvalidate_password_length=4;

SET PASSWORD =

PASSWORD('123456');

GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1'

IDENTIFIED BY '123456' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY

'123456' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'c65mini.localdomain'

IDENTIFIED BY '123456' WITH GRANT OPTION;

flush privileges;