MySQL数据库常用命令汇总
-- 查看mysql的当前登陆用户
select user();
-- 列出数据库
show databases;
-- 使用数据库
use mysql;
describe mysql.user;
select host, user from user;
select host,user,password from mysql.user;
-- 创建一个数据库
CREATE DATABASE hive;
-- 列出表
show tables;
-- 显示MySQL所有用户:
select host,user,password from user;
-- 添加 MySQL 用户(user name:user1,password:sql):
grant all on . to ranger@'%' identified by 'zdh1234' with grant option;
-- 删除 MySQL 用户:
delete from user where user='user1';
select host,user,password from user where user = '';
delete from user where user = '';
flush privileges;
select * from user;
-- 删除mysql.user表中出现user为空的记录
delete from user where user is NULL;
update user set user='root' where host='localhost';
-- 修改密码,需要重启mysql
update user set password=password("zdh1234") where user="root" and host='localhost';
grant all on . to root@'localhost' identified by 'zdh1234' with grant option;
flush privilege;
insert into table(Host
,User
,Password
,Select_priv
,Insert_priv
,Update_priv
,Delete_priv
,Create_priv
,Drop_priv
,Reload_priv
,Shutdown_priv
,Process_priv
,File_priv
,Grant_priv
,References_priv
,Index_priv
,Alter_priv
,Show_db_priv
,Super_priv
,Create_tmp_table_priv
,Lock_tables_priv
,Execute_priv
,Repl_slave_priv
,Repl_client_priv
,Create_view_priv
,Show_view_priv
,Create_routine_priv
,Alter_routine_priv
,Create_user_priv
,Event_priv
,Trigger_priv
,Create_tablespace_priv
,ssl_type
,ssl_cipher
,x509_issuer
,x509_subject
,max_questions
,max_updates
,max_connections
,max_user_connections
,plugin
,authentication_string
) values ('%','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','',null,null,null,0,0,0,0,'',null);
SET GLOBAL log_bin_trust_function_creators = 1;
SELECT @@global.log_bin_trust_function_creators;
-- 查看服务器变量have_ssl,是否支持SSL
SHOW VARIABLES LIKE '%ssl%';
-- 如果为yes,表示服务端已经开启SSL
-- 查看服务ssl等状态
SHOW STATUS LIKE 'Ssl_cipher';
SHOW STATUS LIKE '%ssl%';
最新文章
- zookeeper事务
- 向linux内核中添加外部中断驱动模块
- cut - 小巧的文本截取工具
- EDIUS设置3D转场的教程
- DLUTOJ 1209 字典序和r-子集
- Delphi 中的哈希表(二)—— TStringHash
- win8 获取管理员权限
- URL锚点HTML定位技术机制
- C#中的DateTime:本周第一天,本月第一天,今年第一天,本周第一天的时间
- 关于Hibernate的总结
- 重写OnPaint事件对窗体重绘 实例1
- Linux学习之scp命令
- nginx使用自认证的https证书
- C# new和override的区别
- Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual tha
- CentOS 7 rpm -i 时 警告warning: /var/tmp/rpm-tmp.z7O820: Header V4 RSA/SHA512 Signature, key ID a14fe591: NOKEY 解决方法
- 【笔记】Python基础七:正则表达式re模块
- Spring Boot (二)集成Jsp与生产环境部署
- Git学习笔记06-版本回退
- java 约束配置文件和本地约束