RPM方式安装MySQL5.6
a. 检查 MySQL 及相关 RPM 包,是否安装,如果有安装,则移除( rpm –e 名称)
2
mysql-libs-5.1.66-2.el6_3.x86_64
b. 下载Linux对应的RPM包,如:CentOS6.4_64对应的RPM包,如下:
3
-rw-r--r--. 1 root root 18442536 Dec 11 20:19 MySQL-client-5.6.15-1.el6.x86_64.rpm
4
-rw-r--r--. 1 root root 3340660 Dec 11 20:06 MySQL-devel-5.6.15-1.el6.x86_64.rpm
5
-rw-r--r--. 1 root root 54360600 Dec 11 20:03 MySQL-server-5.6.15-1.el6.x86_64.rpm
c. 安装MySQL
注:安装中出现下问题
[root@localhost centos]# rpm -ivh MySQL-server-5.6..rpm warning: MySQL-server-5.6.38-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY error: Failed dependencies: libc.so.6(GLIBC_2.14)(64bit) is needed by MySQL-server-5.6. libc.so.6(GLIBC_2.15)(64bit) is needed by MySQL-server-5.6. libc.so.6(GLIBC_2.16)(64bit) is needed by MySQL-server-5.6. libc.so.6(GLIBC_2.17)(64bit) is needed by MySQL-server-5.6. libstdc++.so.6(GLIBCXX_3.4.15)(64bit) is needed by MySQL-server-5.6.
在安装包后面加两个参数,如
[root@sh158-xen data]#
rpm -ivh MySQL-server-5.6..rpm --nodeps --force
d. 初始化 MySQL 及设置密码
6
mysql> SET PASSWORD = PASSWORD(
'123456'
);
e. 允许远程登陆
02
mysql>
select
host,user,password from user;
03
+-----------------------+------+-------------------------------------------+
04
| host | user | password |
05
+-----------------------+------+-------------------------------------------+
06
| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
07
| localhost.localdomain | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |
08
| 127.0.0.1 | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |
09
| ::1 | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |
10
+-----------------------+------+-------------------------------------------+
12
mysql> update user
set
password=password(
'123456'
) where user=
'root'
;
13
mysql> update user
set
host=
'%'
where user=
'root'
and host=
'localhost'
;
14
mysql> flush privileges;
f. 设置开机自启动
3
mysql 0:off 1:off 2:on 3:on 4:on 5:on 6:off
g. MySQL的默认安装位置
修改字符集和数据存储路径
配置 /etc/my.cnf 文件,修改数据存放路径、mysql.sock 路径以及默认编码utf-8.
[client] password = 123456 port = 3306 default-character-set =utf8 [mysqld] port = 3306 character_set_server =utf8 character_set_client =utf8 collation-server =utf8_general_ci #(注意linux下mysql安装完后是默认:表名区分大小写,列名不区分大小写; 0:区分大小写,1:不区分大小写) lower_case_table_names =1 #(设置最大连接数,默认为 151,MySQL服务器允许的最大连接数16384; ) max_connections =1000 [mysql] default-character-set = utf8
查看字符集
show variables like '%collation%';
show variables like '%char%';