1.Linux编辑器字符集编码问题
一、中文支持
1. 安装中文语言包:
yum groupinstall chinese-support
2. 修改字符编码配置,没有这个文件就创建它:
vim /etc/sysconfig/i18n
修改后内容如下:
LANG=”zh_CN.GB18030″
SUPPORTED=”zh_CN.UTF-8:zh_CN:zh:en_US.UTF-8:en_US:en”
SYSFONT=”latarcyrheb-sun16″
i18n文件是用来设置系统语言,比如:zh_CN.UTF-8、zh_CN.GB18030、zh_TW.Big5、en_US.UTF-8等。
i18n中三个环境变量:
LANG变量,设置系统语言。
SUPPORTED变量决定系统支持的语言,即系统能够显示的语言。
SYSFONT变量表示系统字体。
3. 最后重启服务器:
reboot
使用locale命令查看系统语言设置:
locale
LANG=zh_CN.GB18030
LC_CTYPE=”zh_CN.GB18030″
LC_NUMERIC=”zh_CN.GB18030″
LC_TIME=”zh_CN.GB18030″
LC_COLLATE=”zh_CN.GB18030″
LC_MONETARY=”zh_CN.GB18030″
LC_MESSAGES=”zh_CN.GB18030″
LC_PAPER=”zh_CN.GB18030″
LC_NAME=”zh_CN.GB18030″
LC_ADDRESS=”zh_CN.GB18030″
LC_TELEPHONE=”zh_CN.GB18030″
LC_MEASUREMENT=”zh_CN.GB18030″
LC_IDENTIFICATION=”zh_CN.GB18030″
LC_ALL=
默认语言为en_US.UTF-8或POSIX,设置后为zh_CN.GB18030。
二、vim显示中文
安装中文包后还要编辑vim的配置文件vimrc:
vim /etc/vimrc
在最后加入以下内容:
set fileencoding=utf-8
set fileencodings=utf-8,gb18030,gbk,big5
2.数据库字符集编码问题
找到数据库安装路径,修改数据库配置文件my.cnf,其内容如下:
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[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 = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....
[client]
default-character-set = utf8
[mysqld]
default-storage-engine = INNODB
character-set-server = utf8
collation-server = utf8_general_ci
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
- 数据库命令行操作(与乱码无关)
/etc/init.d/mysqld start
mysqladmin -u root (-p旧密码) password 新密码
mysql -uroot -p密码
1、显示数据库列表。
show databases;
刚开始时才两个数据库:mysql和test。mysql库很重要它里面有MYSQL的系统信息,我们改密码和新增用户,实际上就是用这个库进行操作。
2、显示库中的数据表:
use mysql; //打开库,学过FOXBASE的一定不会陌生吧
show tables;
3、显示数据表的结构:
describe 表名;
4、建库:
create database 库名;
5、建表:
use 库名;
create table 表名 (字段设定列表);
6、删库和删表:
drop database 库名;
drop table 表名;
7、将表中记录清空:
delete from 表名;
8、显示表中的记录:
select * from 表名;
- 注意事项
云服务器管理控制台有防火墙和安全组,注意设置端口,否则无法访问。