centos升级到最新的mysql
来源:互联网 发布:电子相册自动播放软件 编辑:程序博客网 时间:2024/05/20 21:21
去网站下载mysql的yum源,地址如下:
http://repo.mysql.com/
在linux上先查看系统的版本号,根据版本号对应下载
more /etc/redhat-release
rpm -Uvh http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm
yum -y upgrade mysql
mysql_upgrade
修改database,table,column字符集
# For each database:
ALTER DATABASE vipmonk CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
# For each table:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# For each column:
ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# (Don’t blindly copy-paste this! The exact statement depends on the column type, maximum length, and other properties. The above line is just an example for a `VARCHAR` column.)
修改my.ini(linux下为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,检查字符集:
mysql> 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)
修改所有表和字段的字符集
ALTER TABLE tbl_name CONVERT TO CHARACTER SET character_name [COLLATE ...] 如:
ALTER TABLE logtest CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
//批量修改所有表和字段的字符集
SELECT
CONCAT('alter table ',table_name,' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;')
FROM
INFORMATION_SCHEMA.tables
WHERE
TABLE_SCHEMA='database_name'
- centos升级到最新的mysql
- centos升级到最新的mysql
- centos yum升级到最新的mysql 5.6
- centos 升级内核到最新版本
- Centos升级curl到最新版本
- centos升级mysql到5.5
- MySQL 瑞士军刀SQLyog升级到最新版本
- centos 升级mysql 5.1 到 mysql 5.5
- 将CentOS系统默认的python一键自动升级到最新的2.7.13版本
- 将CentOS系统默认的python手动升级最新到2.7.13版本
- Centos最新方法升级php版本到5.2.11
- Centos最新方法升级php版本到5.2.11
- CentOS下平滑无缝升级Nginx到最新版本
- CentOs如何将SVN、GIT升级到最新版本
- centos mysql从5.1升级到5.6
- centOS 6.5下升级mysql,从5.1升级到5.7
- centos yum升级到mysql 5.6 指定版本 平滑升级
- CentOS下将MySQL 5.1升级到MySQL 5.5
- DNN模块开发之利器篇:七种武器
- DDR
- 《linux 内核完全剖析》 笔记 CODE_SPACE 宏定义分析
- Port Number 1253/tcp | What is Port 1253/tcp?
- QT Window Geometry
- centos升级到最新的mysql
- JavaScript单线程的疑问与解答
- 为的是躲避老婆的“声讨”
- HTTP消息头中的“Cache-control”介绍
- win7 vpn 619
- APP前后台文件与图片传输
- Spring IOC机制
- KEIL MDK调试小技巧
- LNK2026 XXX模块对于 SAFESEH 映像是不安全的