Mysql 安装常见错误记录

环境：win7,mysql5.7

一：启动mysql服务，报错
本地计算机上的mysql服务启动停止后，某些服务在未由其他服务或程序使用时将 自动停止

解决步骤：
1: 删除原服务，这里mysql是服务名，貌似要重启系统
mysqld --remove mysql

2：mysql根目录创建data空目录或清空data目录

3: 初始化
mysqld --initialize-insecure --user=mysql

4：注册mysql服务，成功后在系统服务中应该有mysql服务
mysqld --install mysql --defaults-file=C:/soft/db/mysql-5.7.10-winx64/my.ini

5：启动服务,默认会创建一个root用户，密码为空
net mysql start

6: 登陆
mysql -u root -p

实践：

C:\soft\db\mysql-5.7.10-winx64\bin>mysqld --install mysql --defaults-file=C:/soft/db/mysql-5.7.10-wi
nx64/my.ini
Service successfully installed.

C:\soft\db\mysql-5.7.10-winx64\bin>net start mysql
mysql 服务正在启动 ..
mysql 服务已经启动成功。


C:\soft\db\mysql-5.7.10-winx64\bin>mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.10 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, 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> show database
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'database' at line 1
mysql> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

二：mysqld: Can’t create directory ‘C: \soft\db\mysql-5.7.10-winx64\data’ (Errcode: 2 - No such file or d
irectory)
解决方案：将目录修改成反斜杠