-- 查看数据目录位置
show global variables like "%datadir%"
-- 创建用户
CREATE USER 'weirdo'@'%' IDENTIFIED BY '123456';
-- 设置权限 (库.表)
GRANT ALL ON *.* TO 'weirdo'@'%';
-- 设置密码
SET PASSWORD = '123456';
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
-- 创建库
create database db_test;
-- 创建表
create table userInfo(
id int unsigned auto_increment,
userName varchar(50) not null comment'用户名',
userPwd varchar(32) not null comment'密码',
primary key(id)
)engine=innodb charset=utf8 comment'用户表';
MySQL 常用命令及操作(随手笔记)
最新推荐文章于 2024-10-06 20:42:07 发布