mysql 5.7 下载地址: https://dev.mysql.com/downloads/mysql/5.7.html#downloads
MySql5.7版本为例,安装方式文件分为两种:
- 一种是msi格式的,该格式直接点击安装,按照提示来就行,通常会将MySql安装在C:\Program Files\MySQL\MySQL Server 5.7目录中;
- 一种是zip格式的。zip格式是自己解压,解压缩之后其实MySQL就可以使用了,但是要进行配置。
我之前安装是的5.1版本,由于太老旧。不得不升级到当前的版本5.7.26(2019-05-26)。
把下载后的mysql 5.7解压 释放到本地目录 E:\phpcms\mysql 后,进行下列操作.
(注:以下所有操作都是在 Mysql 目录 E:\phpcms\mysql 下操作的, Mysql 语句结束用; 分号结尾,退出用 exit;)
1.配置环境变量
新增系统环境变量:
键名:MYSQL_HOME
键值:E:\Phpcms\mysql
在Path中添加:%MYSQL_HOME%\bin,注意Path中不同值之间的“;”符号不能省略
2. 添加并配置my.ini文件, 路径 E:\phpcms\mysql\my.ini
可以先新建一个my.txt文件,然后通过重命名修改文件后缀为.ini,以前的版本解压后或许会存在my-default.ini文件,但是5.7.26版本没有,因此要自己手动创建该文件,文件的内容如下:
路径: E:\ phpcms \ mysql \ my.ini
[mysql]
default-character-set=utf8
[mysqld]
port = 3306
basedir=E:/PHPCMS/MYSQL/
datadir=E:/PHPCMS/MYSQL/Data/
max_connections=200
explicit_defaults_for_timestamp=true
default-storage-engine=MYISAM
#Aa or aa: 0 1 2
lower_case_table_names=1
3. cd到mysq\bin目录下先初始化
以下在命令提示符下完成。(需要 管理员权限打开的)
E:
cd phpcms\mysql\bin
E:\PHPCMS\MYSQL\bin>mysqld --install
Service successfully installed.
E:\PHPCMS\MYSQL\bin>mysqld --initialize-insecure --user=root
2019-05-27T09:41:29.368567Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2019-05-27T09:41:29.369458Z 0 [ERROR] Aborting
E:\PHPCMS\MYSQL\bin>mysqld --initialize-insecure --user=root
E:\PHPCMS\MYSQL\bin>net start mysql
The MySQL service is starting.
The MySQL service was started successfully.
//mysqladmin -u 用户名 -p password 密码串
E:\PHPCMS\MYSQL\bin>mysqladmin -u root -p password 新密码串
Enter password: 旧密码串
//需要输入旧密码时,由于旧密码为空,所以直接回车即可。
//进入操作
E:\PHPCMS\MYSQL\bin>mysql -u root -p
Enter password: ***********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
//登入成功
mysql>
//退出
mysql>bye
以下,MySQL5.7解压版配置安装完毕。
4. 导入数据库:
先创建 数据库名 aerchi_db, 然后从外部导入数据表到该库。
//-p后紧接着密码,此处用*代替
E:\PHPCMS\MYSQL\bin>mysql -u root -p******
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.7.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
//show databases 查看数据库
mysql>show databases;
...
mysql> create database aerchi_db;
Query OK, 1 row affected (0.01 sec)
mysql> use aerchi_db;
Database changed
mysql> source D:\WebDev\renren-fast\renren-fast\db\mysql.sql
Query OK, 0 rows affected (0.33 sec)
Query OK, 0 rows affected (0.37 sec)
Query OK, 0 rows affected (0.33 sec)
....
Query OK, 0 rows affected (0.25 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.20 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.20 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> exit
Bye
5. 导出数据库。
把刚创建并导入的数据库 aerchi_db导出为 E:\phpcms\aerchi_db_back.sql
E:
cd PHPCMS\MYSQL\bin
//show databases 查看数据库
E:\PHPCMS\MYSQL\bin>mysqldump -u root -p aerchi_db > E:\phpcms\aerchi_db_back.sql
Enter password: ***********
查看如果如下图:
以下是某些抛错解决方法,不断更新中。
在运行 mysqld --initialize 时抛如下错
2019-05-27T09:22:02.625463Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-05-27T09:22:02.632632Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2019-05-27T09:22:02.633299Z 0 [ERROR] Aborting
=>
解决方法:
配置文件my.ini里增加
[mysqld]
explicit_defaults_for_timestamp=true
E:\PHPCMS\MYSQL\bin>net start mysql
The service name is invalid.
More help is available by typing NET HELPMSG 2185.
解决方法:
其它常用操作
1、windows下重新启动mysql的方法:
在安装mysql时系统会添加服务,可以通过管理工具里面的 <服务> 一项来停止和启动mysql。这样修改的my.ini就会生效了。
2、也可以用命令行模式,在运行里输入:
停止:net stop mysql
(其中mysql为你安装的mysql服务名称)
启动:net start mysql
3、如果你没安装系统服务,也可在命令行模式定位到mysql下的bin目录里,输入:
(关闭)mysqladmin shutdown
(启动)mysqladmin start
乐意黎
2019-05-27 23:39