CentOS_6.6用rpm方式安装MySql

CentOS_6.6用rpm方式安装MySql
卸载旧版本MySql
检查MySQL及相关RPM包，是否安装，如果有安装，则移除
[root@MyServer010 ftp]# rpm -qa|grep mysql
mysql-libs-5.1.73-3.el6_5.x86_64
[root@MyServer010 ftp]# yum -y remove mysql-libs*
移除MySql也可以用下面的命令
rpm -e --nodeps mysql-libs-5.1.73-3.el6_5.x86_64
下载的MySql文件
[root@MyServer010 ftp]# ll
-rw-r--r-- 1 root root 18596528 10月21 14:31 MySQL-client-5.6.27-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 3392620 10月21 14:31 MySQL-devel-5.6.27-1.el6.x86_64.rpm
-rw-r--r-- 1 root root 55950588 10月21 14:32 MySQL-server-5.6.27-1.el6.x86_64.rpm
安装MySql
[root@MyServer010 ftp]# rpm -ivh MySQL-server-5.6.27-1.el6.x86_64.rpm
注意：
安装server时，会有下面的提示，会告知root第一次登录所需的随机密码文件位置。

A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
You will find that password in '/root/.mysql_secret'.
You must change that password on your first connect,
no other statement but 'SET PASSWORD' will be accepted.
See the manual for the semantics of the 'password expired' flag.
Also, the account for the anonymous user has been removed.
In addition, you can run:
/usr/bin/mysql_secure_installation
下面接着安装
[root@MyServer010 ftp]# rpm -ivh MySQL-devel-5.6.27-1.el6.x86_64.rpm
[root@MyServer010 ftp]# rpm -ivh MySQL-client-5.6.27-1.el6.x86_64.rpm
初始化数据库及设置密码
[root@MyServer010 ftp]# /usr/bin/mysql_install_db
[root@MyServer010 ftp]# service mysql start
Starting MySQL.. SUCCESS!
[root@MyServer010 ftp]# cat /root/.mysql_secret
# The random password set for the root user at Wed Oct 21 14:56:09 2015 (local time): _zh41DmKP_Zzw7vn
密码为红字，下面登录MySql
[root@MyServer010 ftp]# mysql -uroot -p_zh41DmKP_Zzw7vn
修改密码：
mysql> set password = password('admin');
Query OK, 0 rows affected (0.00 sec)
mysql> exit;
[root@MyServer010 ftp]# mysql -uroot -padmin
以新密码登录成功，则表示新密码设置完成。

允许远程登陆
mysql> use mysql;
mysql> select host, user, password from user;
+-------------+------+-------------------------------------------+
| host | user | password |
+-------------+------+-------------------------------------------+
| localhost | root | *4ACFE3202A5FF5CF467898FC58AAB1D615029441 |
| myserver010 | root | *72963C165975618B2D2D329E3550572F964D524A |
| 127.0.0.1 | root | *72963C165975618B2D2D329E3550572F964D524A |
| ::1 | root | *72963C165975618B2D2D329E3550572F964D524A |
+-------------+------+-------------------------------------------+
4 rows in set (0.00 sec)
mysql> update user set password=password('admin') where user='root';
mysql> update user set host='%' where user='root' and host='localhost';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> exit;
设置开机自启动
[root@MyServer010 ftp]# chkconfig mysql on
[root@MyServer010 ftp]# chkconfig --list | grep mysql
mysql 0:关闭1:关闭2:启用3:启用4:启用5:启用6:关闭
MySQL的默认安装位置
1 /var/lib/mysql/ #数据库目录
2 /usr/share/mysql #配置文件目录
3 /usr/bin #相关命令目录
4 /etc/init.d/mysql #启动脚本
修改字符集和数据存储路径，首先复制MySql的配置文件
配置/etc/f文件,修改数据存放路径、mysql.sock路径以及默认编码utf-8.
[root@MyServer010 share]# cp /usr/share/mysql/f /etc/f
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
#basedir = /var/lib/mysql
datadir = /opt/mysql_data
port = 3306
# server_id = .....
# socket = .....
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
查看字符集
show variables like '%collation%';
show variables like '%char%';。