哪个网站做试卷吧有答案,小红书关键词检测,大连网站设计,母婴网站源码 带采集1.从官网下载mysql-5.7.21-windowx64.zip mysql下载页面2.解压到合适的位置(E:mysql) 这名字是我改过的3.配置环境变量#xff0c;将E:mysqlbin 添加到PATH中4.在mysql目录下(E:mysql) 创建 my.ini文件#xff0c;内容如下#xff1a;[mysql]# 设置mysql客户端默认字符集def…1.从官网下载mysql-5.7.21-windowx64.zip mysql下载页面2.解压到合适的位置(E:mysql) 这名字是我改过的3.配置环境变量将E:mysqlbin 添加到PATH中4.在mysql目录下(E:mysql) 创建 my.ini文件内容如下[mysql]# 设置mysql客户端默认字符集default-character-setutf8[mysqld]#设置3306端口port 3306# 设置mysql的安装目录basedirE:mysql# 设置mysql数据库的数据的存放目录datadirE:mysqldata# 允许最大连接数max_connections200# 服务端使用的字符集默认为8比特编码的latin1字符集character-set-serverutf8# 创建新表时将使用的默认存储引擎default-storage-engineINNODB#为注释5.管理员身份运行cmd切换目录 cd E:mysqlbin生成mysql服务(就是安装my.ini文件)E:mysqlbin mysqld -install;Service successfully installed.生成data目录 E:mysqlbin mysqld --initialize-insecure --usermysql ;这里生成失败的话看下面E:mysqlbincd ../E:mysql mysqld --initialize-insecure --usermysql ;启动mysql服务E:mysqlbin net start mysql;MySQL 服务正在启动 .MySQL 服务已经启动成功。6.登录数据库,修改密码(默认为空)E:mysqlbin mysql -u root -p;Enter password: //这里直接回车Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 2Server version: 5.7.21 MySQL Community Server (GPL)Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type help; or h for help. Type c to clear the current input statement.mysql修改密码mysql show databases;--------------------| Database |--------------------| information_schema || mysql || performance_schema || sys |--------------------4 rows in set (0.00 sec)mysql use mysql;Database changedmysql set password for rootlocalhostpassword(新密码);mysql flush privileges;退出测试是否成功mysql quit;E:mysqlbin mysql -u root -p;Enter password:注释在mysql中一条语句结束加号开始mysql服务net start mysql;停止mysql服务net stop mysql;生成服务mysqld -install;删除服务mysqld -remove;登录数据库mysql -u root -p;退出mysql quit;总结
