install mysql-优快云博客

本文提供了一步一步指导，教你如何下载MySQL并进行安装配置。包括设置环境变量、安装MySQL服务、初始化数据库、配置MySQL参数及设置root账户密码等关键步骤。

download mysql

download mysql from ```http://dev.mysql.com/downloads/mysql/```

configure environment

add ```D:\mysql\bin``` to path

download the Microsoft Visual C++ 2013 Redistributable Package

https://www.microsoft.com/en-gb/download/details.aspx?id=40784select vcredist_x64.exe

register mysql service

cd D:\mysql\bin
mysqld -install

configure mysql configuration file

edit my.ini in D:\mysql

[mysqld]

basedir=D:\mysql
datadir=D:\mysql\data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

initialize mysql

cd D:\mysql\bin
mysqld --initialize

start mysql server to check mysql service

net start mysql

configure mysql root account

start no password mode of mysql server

net stop mysql
mysqld --skip-grant-tables

start another cmd

mysql -u root
flush privileges;
grant all privileges on *.* to 'root'@'localhost' identified by 'mypassword' with grant option;
flush privileges;
exit;

kill mysqld.exe

taskkill /f /im mysqld.exe

start mysql again

net start mysql

use mysql

mysql -P 3306 -h localhost -u root -p

转载于:https://www.cnblogs.com/otfsenter/p/7825596.html