GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'ym*#,welopka' WITH GRANT OPTION;

时间: 2023-09-13 10:10:21 浏览: 181

MySQL命令行下18个常用命令

在日常的网站维护和管理中，会用到非常多的SQL语句，熟练使用对网站管理有很多好处，尤其是站群管理的时候。下面列一些常用的命令做备记。 1、显示数据库 show databases 显示表 show tables; 2、创建用户创建root用户密码为123 use mysql; grant all on *.* to root@'%' identified by '123' with grant option; commit; 3、修改密码 grant all on *.* to xing@'localhost' identified by '123456' wit MySQL是世界上最受欢迎的关系型数据库管理系统之一，用于存储和管理各种类型的数据。在命令行界面下，MySQL提供了丰富的命令，使得数据库的管理和维护变得简单而高效。以下是对标题和描述中提到的18个常用MySQL命令的详细解释： 1. **显示数据库**：使用`show databases;`命令可以列出当前MySQL服务器上的所有数据库。 2. **创建用户**：创建新用户并设置密码，例如创建名为root的用户，密码为123，权限为全局，允许任何主机连接： ``` use mysql; grant all on *.* to root@'%' identified by '123' with grant option; commit; ``` 3. **修改密码**：改变用户密码，如将用户名为xing，主机为localhost的用户密码改为123456： ``` grant all on *.* to xing@'localhost' identified by '123456' with grant option; update user set password = password('newpwd') where user = 'xing' and host='localhost'; flush privileges; ``` 4. **创建数据库**：使用`create database`命令创建数据库，例如创建名为testdb的数据库： ``` create database testdb; ``` 5. **预防性创建数据库**：使用`if not exists`关键字防止已存在的数据库被再次创建： ``` create database if not exists testdb; ``` 6. **创建表**：在选择的数据库中创建表，例如在testdb数据库中创建名为table1的表，包含username和password两列： ``` use testdb; create table table1( username varchar(12), password varchar(20) ); ``` 7. **预防性创建表**：预防性创建表aaa，避免已存在时出现错误： ``` create table if not exists aaa( ss varchar(20) ); ``` 8. **查看表结构**：使用`describe`命令查看表的结构： ``` describe table1; ``` 9. **插入数据**：插入数据到table1表中： ``` insert into table1(username, password) values('leizhimin','lavasoft'), ('hellokitty','hahhahah'); commit; ``` 10. **查询数据**：查询table1中的所有数据： ``` select * from table1; ``` 11. **更改数据**：更新表中数据，例如将username为hellokitty的password更改为'hehe'： ``` update table1 set password='hehe' where username='hellokitty'; commit; ``` 12. **删除数据**：删除username为hellokitty的数据： ``` delete from table1 where username='hellokitty'; commit; ``` 13. **添加列**：向table1表中添加sex和age两列： ``` alter table table1 add column( sex varchar(2) comment '性别', age date not null comment '年龄' ); commit; ``` 14. **修改表结构**：从查询结果创建新表，这里假设要创建名为tmp的表： ``` create table tmp as select * from table1; ``` 15. **删除表**：删除存在的table1和tmp表： ``` drop table if exists table1; drop table if exists tmp; ``` 16. **备份数据库**：备份testdb数据库到本地文件： ``` mysqldump -h 192.168.3.143 -u root -p pwd -x --default-character-set=gbk > C:\testdb.sql ``` 17. **删除数据库**：删除testdb数据库： ``` drop database testdb; ``` 18. **恢复数据库**：恢复testdb数据库： ``` 首先创建testdb数据库 create database testdb; 然后执行恢复命令 mysql -u root -pleizhimin testdb < C:\testdb.sql ``` 掌握这些基本的MySQL命令行操作，将使你在数据库管理中更加得心应手，无论是日常维护还是应对复杂任务，都能游刃有余。在实际工作中，你还可以根据需要学习更多的高级命令和功能，如索引、视图、触发器、存储过程等，进一步提升数据库管理效率。

你提供的命令是将所有数据库的所有表赋予了'root'用户在任何主机上的全部权限，并设置了密码为'ym*#,welopka'。同时，使用了`WITH GRANT OPTION`选项，这将允许'root'用户授予其他用户访问权限。请注意，授予所有权限给'root'用户可能存在安全风险。建议在生产环境中使用更加严格的权限控制，并仅授予所需的最小权限。如果你确实需要这样的权限配置，请确保密码强度足够强，并妥善保管好密码。另外，确保只有可信任的主机可以连接到你的MySQL服务器，以增加安全性。

阅读全文

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'ym*#,welopka' WITH GRANT OPTION;

相关推荐

给Mysql添加远程访问权限的方法

mysql 赋给用户权限 grant all privileges on.docx

grant all privileges on *.* to root@"%" identified by ".";

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

grant all privileges on *.* to "root"@"%" identified by "xxxx"

mysql 5.7GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'Admin123@qwe' WITH GRANT OPTION;

MySQL80 的GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456';

grant all privileges on *.* to "root"@"%" identified by "xxxx"中包含触发器权限吗

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' identity BY 'password' WITH GRANT OPTION;检查错误

Grant all privileges on pmsDB.*to root@%’ identified by ‘pms8782’的作用

Grant all privileges on pmsDB.*to root@%’ identified by ‘pms8782’;作用

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';显示找不到用户表中的匹配行

Grant all privileges on pmsDB.*to root@%’ identified by ‘pms8782’;干嘛的

GRANT ALL PRIVILEGES ON *.* TO 'rooy'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;报错

GRANT ALL PRIVILEGES ON *.* TO 'exporter'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;语法错误

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Aa@123456' WITH GRANT OPTION > 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'Aa@123456' WITH GRANT OPTION' at line 1

mysql> GRANT ALL PRIVILEGES ON *.* TO exporter@'%' identified by '123456' WITH GRANT OPTION; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by '123456' WITH GRANT OPTION' at line 1

最新推荐

MiniGui业务开发基础培训-htk

BottleJS快速入门：演示JavaScript依赖注入优势

管理建模和仿真的文件

【版本控制】：R语言项目中Git与GitHub的高效应用

RT-DETR如何实现在实时目标检测中既保持精度又降低计算成本？请提供其技术实现的详细说明。

vConsole插件使用教程：输出与复制日志文件

"互动学习：行动中的多样性与论文攻读经历"

【自然语言处理】：R语言文本挖掘与情感分析入门指南

智能衣柜的设计中是如何应用嵌入式系统与物联网技术实现个性化定制的？

Node.js v12.7.0版本发布 - 适合高性能Web服务器与网络应用

GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'ym*#,welopka' WITH GRANT OPTION;

grant all privileges on . to root@"%" identified by ".";

GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION

GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

grant all privileges on . to "root"@"%" identified by "xxxx"

mysql 5.7GRANT ALL PRIVILEGES ON . TO 'root'@'%'IDENTIFIED BY 'Admin123@qwe' WITH GRANT OPTION;

MySQL80 的GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456';

grant all privileges on . to "root"@"%" identified by "xxxx"中包含触发器权限吗

GRANT ALL PRIVILEGES ON . TO 'root'@'%' identity BY 'password' WITH GRANT OPTION;检查错误

GRANT ALL PRIVILEGES ON . TO 'root'@'%';显示找不到用户表中的匹配行

GRANT ALL PRIVILEGES ON . TO 'rooy'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;报错

GRANT ALL PRIVILEGES ON . TO 'exporter'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;语法错误

GRANT ALL PRIVILEGES ON . TO 'root'@'%'; ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)

GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY 'Aa@123456' WITH GRANT OPTION > 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'Aa@123456' WITH GRANT OPTION' at line 1

mysql> GRANT ALL PRIVILEGES ON . TO exporter@'%' identified by '123456' WITH GRANT OPTION; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by '123456' WITH GRANT OPTION' at line 1