MySQL 指令

net start mysql           # 启动本机 MySQL 运行net stop mysql            # 终止本机 MySQL 运行Copy to clipboardErrorCopied

# 本地连接mysql -h localhost -u root -p 
# 远程连接mysql -h 10.0.0.51 -P 3306 -u root -p 123456
# 断开连接mysql> exitmysql> quitmysql> /pCopy to clipboardErrorCopied

-- 增加用户(CREATE)mysql> CREATE USER 'boy'@'localhost' IDENTIFIED BY '';                -- 创建用户 boy 允许从本地网络登录mysql> CREATE USER 'girl'@'10.0.0.%' IDENTIFIED BY '123456';          -- 创建用户 girl 允许从特定网络登录
-- 删除用户(DROP)mysql> DROP USER 'girl'@'10.0.0.%';
-- 修改用户(ALTER)mysql> ALTER USER 'boy'@'localhost' IDENTIFIED BY '123456';
-- 重命名用户(RENAME)mysql> RENAME USER 'boy'@'localhost' TO 'man'@'localhost';
-- 设置密码mysql> SET PASSWORD = PASSWORD('123456');                              -- 为当前用户设置密码mysql> SET PASSWORD FOR 'boy'@'localhost' = PASSWORD('123456');        -- 为指定用户设置密码
-- 查询全部用户信息(DESC/SELECT)mysql> DESC mysql.user;                                            mysql> SELECT user,host,authentication_string FROM mysql.user