mysql安装笔记

参考博客，在此表示感谢：

https://blog.csdn.net/u010999809/article/details/82223681
https://www.cnblogs.com/mituxiaogaoyang/p/11780741.html
https://www.cnblogs.com/snzigod/p/8241649.html
http://repo.mysql.com/yum/mysql-5.6-community/el/6/x86_64/
https://www.cnblogs.com/007sx/p/7083143.html

检查清理本地mysql包
yum list installed | grep mysql # 检查是否已经安装过mysql及相关包
yum -y remove mysql-libs # 卸载之前安装过的mysql

下载地址：
http://repo.mysql.com/yum/
http://repo.mysql.com/yum/mysql-5.6-community/el/6/x86_64/

安装
wget -c http://repo.mysql.com/yum/mysql-community/el/6/x86_64/mysql-community-release-el6-5.noarch.rpm # 下载msql的yum源对应的rpm
rpm -Uvh mysql-community-release-el6-5.noarch.rpm # 安装rpm
yum install mysql-community-server #安装mysql

service mysqld start
service mysqld restart

（2）输入mysql，直接进入mysql

使用以下sql来修改root密码

mysql> use mysql;
mysql> update user set password=password("你的新密码") where user="root";

例如： 
update user set password=password("root") where user="root";

mysql> flush privileges;
mysql> quit

（3）设置远程访问权限：
方法一：
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

方法二：
update user set host='%' where user='root';

到这里root账户已经重置成新的密码了

修改字符集为utf-8
包括服务端（character-set-server）的和客户端（client）的
[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8

常用命令：

select user, host from user;
flush privileges
show grants for root@'%';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

数据库导入：
https://www.cnblogs.com/withfeel/p/10796633.html

create database GlobalWebP2P;
use GlobalWebP2P;
use GlobalWebP2P;
set names utf8;
source /opt/mysql-yum/GlobalWebP2P.sql;