linux下安装mysql

1.下载安装包
wget http://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz

2.解压安装包
安装依赖
yum -y install perl perl-devel autoconf

tar zxvf http://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz

3.进入文件夹
cd mysql-5.6.26-linux-glibc2.5-x86_64

4.创建用户组和用户
groupadd mysql
useradd -r -g mysql mysql

5.修改权限
chown -R mysql:mysql ./

6.安装数据库
./script/mysql_install_db —user=mysql

7.修改当前目录拥有者
chown -R root:root ./
chowd -R mysql:mysql data

8.添加mysql为系统服务
cp support-files/mysql.server /etc/init.d/mysql

9.修改mysql服务路径配置
vi /etc/init.d/mysql
修改 basedir=mysql安装包路径、datadir=mysql数据存放目录(默认为mysql安装包路径/data)

10.复制配置mysql配置文件
先查看support-files目录下是否有mysql-medium.cnf文件，有的话直接复制就好了cp support-files/mysql-medium.cnf my.cnf
如果没有就自己配置下

11.添加mysql系统变量
vi /etc/profile
export MYSQL=/usr/local/mysql
export PATH=$PATH:$MYSQL/bin
source /etc/profile
echo $PATH

12.启动mysql
service mysql start

12.1修改密码
./bin/mysqladmin -u root password ‘密码’

13.命令行连接MYSQL
mysql -u root -p //新安装默认没有密码，输入后直接回车即可

你想root使用mypassword从任何主机连接到mysql服务器的话:

GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘Abcd123456789’ WITH GRANT OPTION;

Flush PRIVILEGES;

14.修改mysql引擎和修改mysql字符集:

vi /etc/my.cnf

在原文件中添加以下内容：
[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect=’SET NAMES utf8mb4’

重启mysql：service mysqld restart

再次查看字符集设设置：
SHOW VARIABLES WHERE Variable_name LIKE ‘character_set_%’ OR Variable_name LIKE ‘collation%’;

+————————–+——————–+
| Variable_name | Value |
+————————–+——————–+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| collation_connection | utf8mb4_unicode_ci |
| collation_database | utf8mb4_unicode_ci |
| collation_server | utf8mb4_unicode_ci |
+————————–+——————–+
10 rows in set (0.00 sec)

设置成功。