【常规操作】MySQL相关

操作mysql导入数据库至远程服务器

1. 远程连接授权

mysql> GRANT ALL PRIVILEGES ON *.* TO [email protected]'%' IDENTIFIED BY 'root'
mysql> flush privileges;

3. cmd窗口连接远程MySQL

mysql -h -49.233.137.247 -u -root -p【密码】
show databases;
mysql> use 【database】;
mysql> source 【文件目录】

---

CentOS7安装MySQL过程–抄自尚硅谷

1. 检查是否安装过MySQL，如果有，先删除

[[email protected] zhk] rpm -qa |grep mysql*
[[email protected] zhk] rpm -e --nodeps mysql【后续部分】

2. 安装MySQL

[[email protected] zhk] rpm -ivh 【MySQL-server-5.5.54-1.linux2.6.x86_64.rpm】
[[email protected] zhk] rpm -ivh 【MySQL-client-5.5.54-1.linux2.6.x86_64.rpm】
[[email protected] zhk] rpm -qa | grep -i mysql

3. 查看MySQL版本

[[email protected] zhk] mysql --version

4. 查看MySQL的状态

[[email protected] zhk] service mysql status

5. 启动MySQL服务

[[email protected] zhk] service mysql start 

6. 登录MySQL

[[email protected] zhk] mysql -uroot -p
-----------------默认没有没有密码

7. 将密码修改成‘123456’

[[email protected] zhk] /usr/bin/mysqladmin -u root  password '123456'

8. 设置mysql权限为5

[[email protected] zhk] chkconfig --level 5 mysql on

修改字符编码

1. 常规方法

mysql> show variables like 'char%';
mysql> set character_set_client = 'utf8'
mysql> set character_set_connection = 'utf8'
mysql> set character_set_database = 'utf8'
mysql> set character_set_result = 'utf8'
mysql> set character_set_server = 'utf8'
mysql> set character_set_system = 'utf8'

2. 修改配置文件

– 找到mysql的配置文件，修改配置文件

[[email protected] zhk] cd /usr/share/mysql
[[email protected] zhk] cp my-huge.cng /etc/my.cnf
[[email protected] zhk] vim /etc/my.cnf

– 修改相应位置

– 重启MySQL服务器

[[email protected] zhk] service mysql restart

– 已生成的库表字符集更改（原有数据是utf8编码）

mysql> alter database 【数据库名】 character set 'utf8';
mysql> alter table 【数据表名】 convert to  character set 'utf8';