配置mysql linux_Linux下安装与配置mysql 5.7

本文介绍如何在Linux下安装最新版 Mysql Community Server

使用Linux Generic x86 64bit版本

安装前置lib

shell> apt-get update source

# 更新apt源

shell> apt-cache search libaio

shell> apt-cache search libnuma

shell> apt-get install libaio

shell> apt-get install libnuma1

分配mysql user

shell> groupadd mysql

# 创建工作组

shell> useradd -r -g mysql -s /bin/false mysql

# 创建用户

解压与安装

shell> mkdir /usr/local/mysql

shell> cd /usr/local/mysql

shell> /usr/local/mysql tar zxvf mysql安装包路径.tar.gz

shell> /usr/local/mysql mkdir mysql-files

shell> /usr/local/mysql chown mysql:mysql mysql-files

shell> /usr/local/mysql chmod 750 mysql-files

shell> /usr/local/mysql/bin ./mysqld --initialize --user=mysql

# 安装成功后应该有以下提示

# [Note] A temporary password is generated for root@localhost: *********

# *号处即默认的root密码

shell> /usr/local/mysql/bin ./mysql_ssl_rsa_setup

shell> /usr/local/mysql/bin ./mysqld_safe --user=mysql &

修改默认密码

shell> /usr/local/mysql/bin ./mysql -u root -p

# 输入默认密码

mysql>

mysql> SET PASSWORD = PASSWORD('新密码');

mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

mysql> flush privileges;

# 至此，root密码已成功修改

添加PATH

shell> export PATH=$PATH:/usr/local/mysql/bin

# 随后在任何目录均可使用mysql

允许远程访问SQL数据库

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;

之后可以很方便地用图形化的数据库管理器进行操作，以navicat为例，使用ssh通道即可访问内部数据库