mysql安装和配置环境windows+linux

windows

1. 下载windows版安装包,这里有个5.7的地址，其他版本的话需要你自己下载
   windows版5.7网盘地址
   提取码：wind

2. 下载后解压,目录如下
   

3. 配置环境变量
   添加一个环境变量，
   变量名：MYSQL_HOME
   变量值：D:\java\mysql-5.7.9-winx64\

4. 生成data文件
   cmd进入mysql所在目录
   mysqld --initialize-insecure --user=mysql

5. 安装MySQL
   执行命令
   mysqld -install

6. 启动mysql
   net start MySQL
   

7. 登录MySQL
   mysql -u root -p
   一开始没设置密码就直接回车即可

8. 设置密码

   update mysql.user set authentication_string=("123456"),host = '%' where user="root"; 
   

linux

1. 使用命令下载mysql，也可以直接rz上传上去

   cd /usr/local
   wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz 
   

2. 安装

   cd /usr/local
   tar -zxvf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
   mv mysql-5.7.25-linux-glibc2.12-x86_64 /usr/local/mysql
   

3. 新建data目录

   mkdir /usr/local/mysql/data
   

4. 新建mysql用户组及mysql用户

   groupadd mysql 
   useradd mysql -g mysql 
   

5. 将/usr/local/mysql的所有者及所属组改为mysql

   chown -R mysql.mysql /usr/local/mysql
   

6. 配置

   /usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data
   

7. 编辑/etc/my.cnf

   	[mysqld]
   
   datadir=/usr/local/mysql/data
   
   basedir=/usr/local/mysql
   
   socket=/tmp/mysql.sock
   
   user=mysql
   
   port=3306
   
   character-set-server=utf8
   
   // 取消密码验证
   
   skip-grant-tables
   
   // Disabling symbolic-links is recommended to prevent assorted security risks
   
   symbolic-links=0
   
   // skip-grant-tables
   
   [mysqld_safe]
   
   log-error=/var/log/mysqld.log
   
   pid-file=/var/run/mysqld/mysqld.pid
   

8. 开启服务

   cp /usr/local/mysql/support-files/mysql.server 
   /etc/init.d/mysql chkconfig mysql on 
   service mysql start 
   

9. 设置密码

   /usr/local/mysql/bin/mysql -u root -p
   use mysql;
   update user set authentication_string=password(‘你的密码’) where user=‘root’; 
   flush privileges;
   exit;
   

10. 将/etc/my.cnf中的skip-grant-tables删除

11. 允许远程连接

    /usr/local/mysql/bin/mysql -u root -p 
    	use mysql;
    	update user set host=’%’ where user = ‘root’;
    	flush privileges;
    	eixt;