mysql基础命令汇总

最新推荐文章于 2024-07-31 18:10:28 发布

hehexiaoxia

最新推荐文章于 2024-07-31 18:10:28 发布

阅读量587

点赞数

分类专栏： Mysql 文章标签： mysql

本文链接：https://blog.csdn.net/hehexiaoxia/article/details/78255434

版权

5 篇文章 0 订阅

订阅专栏

启动：mysql -u root -p
创建用户：create user test;
创建密码：update mysql.user set authentication_string=password('testcyTX') where user='test’;
授权(管理员权限):grant all privileges on *.* to 'test'@'localhost' identified by 'test' with grant option;
查看用户权限：show grants for ‘test’;
创建数据库：create database dbname;
修改数据库编码：alter database dbname character set utf8mb4 collate utf8mb4_general_ci;
显示编码：show variables where variable_name like 'character\_set\_%' or variable_name like 'collation%’;
修改表编码：alter table tablename convert to character set utf8mb4 collate utf8mb4_general_ci;
显示表结构：describe tablename;
显示数据库：show databases;
显示数据库中表：use dbname; show tables;