


A detailed introduction on how to configure the startup surface installation version of mysql under Windows
一,下载Zip版本的免安装版本的Mysql,并解压之安装目录下面
二,在Windows的Path中添加Mysql的Bin目录,使得可访问mysql等命令。
*遇到奇怪问题,在win10的path加入了mysql运行记录。但是执行mysql依然未找到。此时mysql的bin目录为path中的最后一项。后来在path中再增加一项(例如,path为 ....;%MYSQL_BIN%;D:\test;)则可以在命令中可以找到mysql
三,创建Mysql的启动选项文件my.ini。
Mysql会从C:、 Windir,安装目录等多个目录搜索My.ini配置文件。mysql5.7.1.17没有启动用的配置文件,同时没有设置Data文件夹。可以在安装目录或者希望存放数据的地方创建data目录
创建My.ini文件,并且设置配置如下
[client] #客户端使用UTF8 default-character-set=utf8 [mysqld] #服务启动的目录 #注意Windows下面,目录路径分隔符要用/,如要要用反斜杠,则要\\ basedir=D:/Server/mysql-5.7.18-winx64 datadir=D:/Server/mysql-5.7.18-winx64/data port = 3306 #服务器默认使用UTF8 character-set-server=utf8 #不使用授权表可以登陆MYSQL,初次启动适用 skip-grant-tables
四,调用初始化命令,初始化。该命令需要用管理员权限运行。
win10在开始菜单的视窗图标 右键 -> 命令提示符(管理员) 可以打开
mysqld --initialize \mysqld --initialize-insecure #这个命令,代表初始化后,root用户为空密码 ** 同时可以制定初始化时候使用的配置文件 mysqld --defaults-file=C:\my.ini --initialize
执行该命令后,MYSQL将进行data数据存放目录的初始化,以及数据库原始表的一些初始化工作,包括root用户的创建。
在data(数据目录)目录下面的XXXXXX.err文件里面,可以查看生成的root的随机密码
五,启动mysql服务
mysqld --console
五,登陆并修改密码
如果忘记密码了,可以从MySql的error log里面找到初始化的随机密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Abcd8888';
The above is the detailed content of A detailed introduction on how to configure the startup surface installation version of mysql under Windows. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

The way to update ByBit exchanges varies by platform and device: Mobile: Check for updates and install in the app store. Desktop Client: Check for updates in the Help menu and install automatically. Web page: You need to manually access the official website for updates. Failure to update the exchange can lead to security vulnerabilities, functional limitations, compatibility issues and reduced transaction execution efficiency.

Detailed explanation and installation guide for PiNetwork nodes This article will introduce the PiNetwork ecosystem in detail - Pi nodes, a key role in the PiNetwork ecosystem, and provide complete steps for installation and configuration. After the launch of the PiNetwork blockchain test network, Pi nodes have become an important part of many pioneers actively participating in the testing, preparing for the upcoming main network release. If you don’t know PiNetwork yet, please refer to what is Picoin? What is the price for listing? Pi usage, mining and security analysis. What is PiNetwork? The PiNetwork project started in 2019 and owns its exclusive cryptocurrency Pi Coin. The project aims to create a one that everyone can participate

Need to download the Gate.io app to start your cryptocurrency journey? This guide details the latest version download steps for iOS, Android, and Windows devices. Simply visit the official website, find the download link and select the appropriate option based on your device. For iOS, it will go directly to the App Store, while Android and Windows users will download the APK or installer for manual installation. Once installed, you can launch the app and set up your account to step into the world of cryptocurrency.

Choosing the right Bitcoin market viewing software is crucial, it can help investors grasp market conditions in real time and make smarter investment decisions. This article will guide you how to make a choice, covering personal needs assessment (trading frequency, analysis depth, information needs and budget), software type selection (exchange interface, professional software, market website/APP), core functional considerations (data reliability, chart tools, custom settings, community communication and platform compatibility), and direction recommendations (maturity financial platform, cryptocurrency aggregation platform, community recommendation software). Finally, it is recommended that you try a few more software and compare it to choose the tool that best suits your needs. Please remember that software is only an auxiliary tool, and you must be cautious when investing at your own risk.

This article introduces two methods to download the Binance client: official website [adid]9f61408e3afb633e50cdf1b20de6f466[/adid] download and application store download. The official website download method includes visiting Binance official website, finding the download button, selecting the corresponding operating system version (such as Windows or Mac) to download the installation package, and then running the installer to complete the installation.

The OKX trading platform can be downloaded through mobile devices (Android and iOS) and computers (Windows and macOS). 1. Android users can download it from the official website or Google Play, and they need to pay attention to security settings. 2. iOS users can download it through the App Store or follow the official announcement to obtain other methods. 3. Computer users can download the client of the corresponding system from the official website. Always make sure to use official channels when downloading, and register, log in and security settings after installation.

Article introduction Binance download portal varies by device and operating system. You need to first clarify the device type, then visit the official website Binance.com (note to check the domain name), look for the "Download" button in a prominent position on the official website, and select download according to different operating systems. The computer version download and install the installation program is prompted to install; Android needs to confirm security from the official website; iOS search and download it in the App Store. After downloading, you need to create or log in to an account, and pay attention to keeping the account information and keys.

Solve the problem of third-party interface returning 403 in Node.js environment. When we use Node.js to call third-party interfaces, we sometimes encounter an error of 403 from the interface returning 403...
