Mysql 安装
1) 准备
[root@yun02 ~]# groupadd mysql
[root@yun02 ~]# useradd mysql -g mysql -M -s /sbin/nologin
2)downlaod mysql for linux from www.mysql.com
版本选择:5.5 其次是5.1或5.6,选择连续较长时间没有更新的版本,跟dba确认ga版本。
wget https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz
mysql: 安装方式,
1,yum 场景:公司内部系统,并发不大。
yum install mysql-server
大公司自己会制作rpm,然后放到yum仓库,然后yum install 这样比较好。
http://dreamway.blog.51cto.com/blog/1281816/1110874
2,常规编译安装mysql 5.1
3,5.5+ 要用 cmake 编译 数量少的话,cmake,数量多的话,自己制作二进制放到yum仓库。
4,二进制安装。yum install
1) yum开始:
yum install mysql # 是直接安装clien
yum install mysql-server # 安装client and server 5.17
service mysqld start
初始化root 本地登录密码
/usr/bin/mysqladmin -u root password '111111'
不允许root远程登录,
进入删除匿名用户,和 无密码用户。
然后 flush privilege; # 需要在修改用户权限的时候,进行刷新用户权限。
然后进入数据库 添加hive 用户,并且授权用户
grant all privileges on *.* to 'hive'@'%' identified by 'hive';
flush privilege; # 需要在修改用户权限的时候,进行刷新用户权限。
chkconfig mysqld on
chkconfig mysqld --lis
# 修改字符集
vim /etc/mysql/my.cnf
show variables like '%character%';
mysql> show variables like '%character%';+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
可以看出我们的character_set_database和character_set_server两处还未设置成utf8(或者GBK)。
下面我们只需要在mysql的配置文件修改即可。退出mysql之后在命令行输入以下代码编辑配置文件:
sudo vim /etc/mysql/my.cnf
下面只需要在两处修改即可!但要注意mysql5.5以下版本和5.5以上版本有一处不同,一定要注意自己的版本!
- [client]
- port=3306
- socket=/var/lib/mysql/mysql.sock
- default-character-set=utf8
- [mysql]
- no-auto-rehash
- default-character-set=utf8
- [mysqld]
- port=3306
- default-character-set=utf8
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
service mysqd stop
cp -rp /var/lib/mysql /data/mysql
ln -s /data/mysql /var/lib/mysql
- [mysqld]
- datadir=/var/lib/mysql
- socket=/var/lib/mysql/mysql.sock
- user=mysql
- # Disabling symbolic-links is recommended to prevent assorted security risks
- symbolic-links=0
- port=3306
- #default-character-set=utf8
- character-set-server=utf8
- max_allowed_packet = 256M
- innodb_buffer_pool_size=8G
- max_connections=10000
- innodb_file_per_table=1
- default-storage-engine=INNODB
- lower_case_table_names=1
- [client]
- port=3306
- socket=/var/lib/mysql/mysql.sock
- default-character-set=utf8
- [mysql]
- no-auto-rehash
- default-character-set=utf8
- [mysqld_safe]
- log-error=/var/log/mysqld.log
- pid-file=/var/run/mysqld/mysqld.pid
修改数据目录:
#卸载
yum remove mysql # 卸载client 会连同 server一起卸载, 但是卸载数据不会别删除。
[root@yun02 ~]# rpm -qa|grep -i mysql
mysql-libs-5.1.73-8.el6_8.x86_64
perl-DBD-MySQL-4.013-3.el6.x86_64
[root@yun02 ~]#
[root@yun02 ~]# rpm -ve mysql-libs-5.1.73-8.el6_8.x86_64
error: Failed dependencies:
libmysqlclient.so.16()(64bit) is needed by (installed) postfix-2:2.6.6-6.el6_5.x86_64
libmysqlclient.so.16()(64bit) is needed by (installed) perl-DBD-MySQL-4.013-3.el6.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) postfix-2:2.6.6-6.el6_5.x86_64
libmysqlclient.so.16(libmysqlclient_16)(64bit) is needed by (installed) perl-DBD-MySQL-4.013-3.el6.x86_64
mysql-libs is needed by (installed) postfix-2:2.6.6-6.el6_5.x86_64
[root@yun02 ~]# rpm -ve mysql-libs-5.1.73-8.el6_8.x86_64 --nodeps
3、查找之前老版本mysql的目录、并且删除老版本mysql的文件和库
1
|
find
/ -name mysql
|
查找结果如下:
1
2
3
4
5
|
find
/ -name mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/lib64/mysql
|
删除对应的mysql目录
1
2
3
|
rm
-rf
/var/lib/mysql
rm
-rf
/var/lib/mysql
rm
-rf
/usr/lib64/mysql
|
具体的步骤如图:查找目录并删除
注意:卸载后/etc/my.cnf不会删除,需要进行手工删除
1
|
rm
-rf
/etc/my
.cnf
|
4、再次查找机器是否安装mysql
1
|
rpm -qa|
grep
-i mysql
|
二进制编译安装:
参考如下: