mysql安装

win下卸载：
由于是压缩版安装，因此删除的时候不用去应用中心卸载，只需删除注册表的相关信息。
卸载服务：

mysqld --remove mysql

将解压的mysql目录删除就完成了。

win下安装：
mysql-5.7.17-winx64版本：
将下载的压缩包解压到安装目录：
1、

2、添加环境变量：

3、在cmd中初始化安装

mysqld --initialize-insecure --user=mysql

添加到系统服务：

mysqld --install

4、查看版本，启动服务：

mysql --version
net start mysql

mysql-5.6.13-winx64版本
此版本跟之前的安装有点区别。
1、不需要创建data
2、不需要修改my-default.ini
安装命令：
mysqld –console
第一次启动时，会在/data 目录下创建需要的所需文件

第二次执行 mysqld –console

将MySql设置成window服务

=================分割线==========================
linux下的安装。
卸载mysql:

 yum remove  mysql mysql-server mysql-libs mysql-server;
 find / -name mysql 将找到的相关东西delete掉   rm -rf ./var/lib/mysql；
 rpm -qa|grep mysql(查询出来的东东yum remove掉)
 卸载方法
 rpm -e --nodeps (包名)

1、在线yum安装：

1、查看有没有安装过：
          yum list installed mysql*
          rpm -qa | grep mysql*
2.查看有没有安装包：
          yum list mysql*
3.安装mysql客户端：
          yum install mysql
4.安装mysql 服务器端：
          yum install mysql-server
          yum install mysql-devel

启动mysql服务：

          service mysqld start或者/etc/init.d/mysqld start

数据库字符集设置

     mysql配置文件/etc/my.cnf中加入default-character-set=utf8

2、离线安装：
二进制编码安装：
下载二进制编码文件

复制到linux文件下

创建软件存放目录：
mkdir -p /home/software/mysql
创建mysql用户
groupadd mysql
useradd -g -r mysql mysql
解压下载的tar包，解压完后会有两个gz包，test的gz我们不用
tar -xvf mysql-5.7.17-linux-glibc2.5-x86_64.tar 
tar -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
将解压后的包移动到/usr/loacl下并将名称改为mysql
mv mysql-5.7.17-linux-glibc2.5-x86_64 /usr/local/mysql
cd /usr/local/mysql/
创建data与logs目录
mkdir /usr/local/data
mkdir /usr/local/logs
更改目录权限
chown -R mysql:mysql /usr/local/mysql
创建my.cnf文件
vi /etc/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.

[client]
port=3306
socket=/tmp/mysql.sock

[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 = .....


# 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 

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
pid-file=/usr/local/mysql/data/mysql.pid
log_error=/usr/local/mysql/logs/mysql-error.log

#default-character-set=utf8
character_set_server=utf8
port=3306
server_id=10
user=mysql

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

初始化mysql：

cd /usr/local/mysql/

bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
注意：执行完上面这步，在mysql的logs目录下应该会生成mysql-error.log，打开会看到生成的初始化密码
 A temporary password is generated for root@localhost: jfH_e0duDORh

注意：如果没有生成或者没有生成密码，一定是上面的步骤没有执行对，将mysql文件删掉，重新解压拷贝，按照上面的流程走

如果生成了初始化密码接着执行：

bin/mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data

配置启动文件：

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
映射一个链接到/usr/bin目录下
ln -s /usr/local/mysql/bin/mysql /usr/bin

启动服务：

service mysql start
mysql -u root -p

输入之前初始化的密码就OK。
修改初始化密码：
service mysql stop
/usr/local/mysql/bin/mysqld_safe –skip-grant-tables

重新打开一个SSH

mysql
use mysql
update user set authentication_string=password('123456') where user='root';
flush privileges;
exit

这样改完如果不行就登陆进去直接改：

alter user 'root'@'localhost' identified by 'root';
flush privileges;
exit

======================分割线======================

编译安装：
装备条件：
下载源

wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17.tar.gz

下载boost

wget http://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz

将boost解压

 tar -zxvf boost_1_59_0.tar.gz
 mv boost_1_59_0 /usr/local/boost

下载依赖

yum install cmake gcc-c++ ncurses-devel perl-Data-Dumper boost boost-doc boost-devel

添加用户

groupadd mysql          
useradd -g mysql mysql  

将源码包解压：

tar -zxvf mysql-5.7.17.tar.gz
cd mysql-5.7.17

5.7以后都是用cmake命令

cmake -DCMAKE_INSTALL_PREFIX=/home/mysql -DMYSQL_DATADIR=/home/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost

编译（编译需要很久，尽量将虚拟机的性能调到最大）：

make && make install

编译完后给目录设置权限：

chown -R mysql:mysql /home/mysql

初始化数据库（这一步执行完会生成初始密码，一定要记住）：

/home/mysql/bin/mysqld --initialize --user=mysql --basedir=/home/mysql --datadir=/home/mysql/data

初始2：

bin/mysql_ssl_rsa_setup --datadir=/home/mysql/data

配置启动文件：

cp /home/mysql/support-files/mysql.server /etc/init.d/mysql
映射一个链接到/usr/bin目录下
ln -s /home/mysql/bin/mysql /usr/bin

设置配置文件：

mv /etc/my.cnf /etc/my.cnf.bak
cp /home/mysql/support-files/my-default.cnf /etc/my.cnf

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.

[client]
port=3306
socket=/tmp/mysql.sock
default-character-set=utf8
[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 = .....

# 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 


basedir=/home/mysql
datadir=/home/mysql/data
socket=/tmp/mysql.sock
#pid-file=/home/mysql/data/mysql.pid
pid-file=/home/mysql/data/localhost.localdomain.pid
#log_error=/home/mysql/logs/mysql-error.log

character_set_server=utf8
port=3306
server_id=10
user=mysql

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

起动服务：

service mysql start

设置初始密码参考上面

=========================设置开机自动启动============

chmod +x /etc/init.d/mysql
chkconfig –add mysql
chkconfig mysql on 或者chkconfig –levels 235 mysql on

设置远程连接：
grant all privileges on . to ‘root’@’%’ identified by ‘123456’ with grant option;

flush privileges;