MySQL安装
启动 net start MySQL
退出MySQL exit
关闭net stop MySQL
登录MySQL mysql -u root -p
(mysql -u root -p123456)
密码 123456
修改密码(update mysql.user set authentication_string=password(‘123456’)where user=‘root’ and Host= ‘localhost’;)
用户名root
update mysql.user set authentication_string=password(“123456”) where user="root"and Host= ‘localhost’;
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
1、配置mysql 环境变量
2、新建mysql配置文件ini
[mysqld]
basedir=D:\MySQL\mysql-5.7.35\
datadir=D:\MySQL\mysql-5.7.35\data\
port=3306
#skip-grant-tables
3、启动管理员模式下的CMD,运行所有的命令
进入D:\MySQL\mysql-5.7.35\bin
4、安装mysql
mysqld -install
5、初始化数据
执行命令:mysqld --initialize-insecure --user=mysql
6、启动服务
net start MySQL
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-cxqBpNi2-1635675307959)(C:\Users\夏斌\Desktop\1435523-20180909151501496-475633604.png)]
7、登录MySQL
mysql -u root -p
8、修改密码
pdatemysql.usersetauthentication_string=password('123456')where user='root' and Host= 'localhost';
9、退出MySQL
exit
10、进入MySQL
mysql -u root -p123456