MYSQL8.0【ZIP包】安装

1：安装MySQL服务

mysqld --initialize --console

mysqld --install  [服务名] 若本机安装多个MySQL版本需要用服务名进行区分

net start mysql  [启动MySQL的服务]

net stop mysql  [停止服务]

sc delete MySQL/mysqld -remove  [卸载 MySQL 服务]

2: 修改root密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

CREATE USER 'xiaoming'@'192.168.1.159' IDENTIFIED BY '123456'; 【创建用户并授权其可以连接本机MYSQL数据库】

GRANT ALL ON *.* TO 'yuwenkai'@'192.168.1.159' WITH GRANT OPTION;

3:设置数据库表中非主键字段自增

alter table tbl_test add test_column INTEGER(10) not Null ;

alter table tbl_test ADD KEY test(test_column);　//　test为任意的key名称

ALTER TABLE tbl_test MODIFY test_column BIGINT(20) auto_increment