湛江网站优化,网站机房建设流程,建设一个网站费用,微信平台的微网站怎么做的前言MySQL 是最流行的关系型数据库管理系统#xff0c;可以在本地搭建一个mysql的环境#xff0c;便于学习。windows7/windows10mysql-8.0.11-winx64下载安装包也可以在此页面【https://dev.mysql.com/downloads/file/?id476233】#xff0c;进入页面后可以不登录。后点击底…前言MySQL 是最流行的关系型数据库管理系统可以在本地搭建一个mysql的环境便于学习。windows7/windows10mysql-8.0.11-winx64下载安装包也可以在此页面【https://dev.mysql.com/downloads/file/?id476233】进入页面后可以不登录。后点击底部“No thanks, just start my download.”即可开始下载。下载完成后解压到电脑本地目录如D:\soft\mysql8011初始化配置解压mysql-8.0.11-winx64.zip文件后在D:\soft\mysql8011\mysql-8.0.11-winx64目录新建一个my.ini配置文件内容如下顺便新建一个Data文件夹用于mysql数据库的数据的存放datadirD:\soft\mysql8011\mysql-8.0.11-winx64\Data[mysqld]# 设置3306端口port3306# 设置mysql的安装目录basedirD:\\soft\\mysql8011\\mysql-8.0.11-winx64# 设置mysql数据库的数据的存放目录datadirD:\\soft\\mysql8011\\mysql-8.0.11-winx64\\Data# 允许最大连接数max_connections200# 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统max_connect_errors10# 服务端使用的字符集默认为UTF8character-set-serverutf8# 创建新表时将使用的默认存储引擎default-storage-engineINNODB# 默认使用“mysql_native_password”插件认证default_authentication_pluginmysql_native_password[mysql]# 设置mysql客户端默认字符集default-character-setutf8[client]# 设置mysql客户端连接服务端时默认使用的端口port3306default-character-setutf8接下里初始化数据以管理员权限打开cmd,cd到bin目录D:\soft\mysql8011\mysql-8.0.11-winx64\bin,执行指令mysqld --initialize --consoleD:\soft\mysql8011\mysql-8.0.11-winx64\binmysqld --initialize --console2018-11-19T07:51:21.287486Z 0 [System] [MY-013169] [Server] D:\soft\mysql8013\mysql-8.0.11-winx64\bin\mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 46642018-11-19T07:51:39.104505Z 5 [Note] [MY-010454] [Server] A temporary password is generated for rootlocalhost: *kEkIrsF3Av2018-11-19T07:51:49.720112Z 0 [System] [MY-013170] [Server] D:\soft\mysql8013\mysql-8.0.11-winx64\bin\mysqld.exe (mysqld 8.0.11) initializing of server has completed从这一句里面找到root用户初始密码 [Note] [MY-010454] [Server] A temporary password is generated for rootlocalhost: *kEkIrsF3Av 初始密码就是*kEkIrsF3Av,记住它别关闭了后面登录会用到要是你手贱关快了或者没记住删掉初始化的 datadir 目录再执行一遍初始化命令又会重新生成的启动服务接着上面步骤在bin目录下执行命令:mysqld --install [服务名]mysqld --install mysqlD:\soft\mysql8011\mysql-8.0.11-winx64\binmysqld --install mysqlService successfully installed.安装完成之后就可以通过命令net start mysql启动MySQL的服务了。通过命令net stop mysql停止服务D:\soft\mysql8011\mysql-8.0.11-winx64\binnet start mysqlmysql 服务正在启动 ...mysql 服务已经启动成功。修改密码在MySQL安装目录的 bin 目录下执行命令mysql -u root -p会提示输入密码记住了上面第步安装时的密码 *kEkIrsF3Av填入即可登录成功,进入MySQL交互模式D:\soft\mysql8011\mysql-8.0.11-winx64\binmysql -u root -pEnter password: ************Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 8Server version: 8.0.11Copyright (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中执行命令ALTER USER rootlocalhost IDENTIFIED WITH mysql_native_password BY 新密码;mysqlALTER USER rootlocalhost IDENTIFIED WITH mysql_native_password BY yoyo;Query OK, 0 rows affected (0.38 sec)修改密码注意命令尾的一定要有。
