Mysql Operations
install mysql on centos
- wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
- sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
- sudo yum update
- sudo yum install mysql-server
- sudo systemctl start mysqld
- sudo mysql_secure_installation
##set mysql server character set
- change mysql config file -- /etc/my.cnf add the following lines:
character_set_server=utf8
init_connect='SET NAMES utf8'
- use show variables like %char% to check the mysql character set settings
- how to solve the Chinese issues
dump data
mysqldump -h10.10.39.231 -ugongs -p --lock-tables=false fds violation_parameters > violation_parameters.dump