mysql 8.0 创建原先数据库、用户并授权，以及相关查看并删除操作

1054 (42S22): Unknown column 'password' in 'field list'

mysql> select user,host,authentication_string from mysql.user; +------------------+-----------+------------------------------------------------------------------------+| user | host | authentication_string |+------------------+-----------+------------------------------------------------------------------------+| userwordpress | % | $A$005$v+Z!_:N3>#j || | | |37hnnPVHEsfeJmFXX/cI9nN144VKUFUdwVggvblw3XUa08 || debian-sys-maint | localhost | $A$005$T)!+a-*> || mysql.infoschema | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED || mysql.session | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED || mysql.sys | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED || root | localhost | $A$005$Ietoh=j ~0 |+------------------+-----------+------------------------------------------------------------------------+6 rows in setTime: 0.008s

3、核对普通用户实质上

有两种手段核对。

第一种手段：show grants for 'userwordpress';

mysql> show grants for 'userwordpress'; +--------------------------------------------------------------+| Grants for userwordpress@% |+--------------------------------------------------------------+| GRANT USAGE ON *.* TO 在在userwordpress在在@在在%在在 || GRANT ALL PRIVILEGES ON 在在wordpress在在.* TO 在在userwordpress在在@在在%在在 |+--------------------------------------------------------------+2 rows in setTime: 0.007s

第二种手段： select * from mysql.user where user='userwordpress'G;

g 等同于’;’

G使每个文件名打印到单独的行，也有 ’;' 的作用

只能知悉哪个检索的哪张备注的实质上，如托userwordpress在mysql检索的user备注的实质上，结果显示都是N（no），难以实质上，如果托root普通用户就都是Y（yes）选择了。

mysql> select * from mysql.user where user='userwordpress' G; ***************************[ 1. row ]***************************Host | %User | userwordpressSelect_priv | NInsert_priv | NUpdate_priv | NDelete_priv | NCreate_priv | NDrop_priv | NReload_priv | NShutdown_priv | NProcess_priv | NFile_priv | NGrant_priv | NReferences_priv | NIndex_priv | NAlter_priv | NShow_db_priv | NSuper_priv | NCreate_tmp_table_priv | NLock_tables_priv | NExecute_priv | NRepl_slave_priv | NRepl_client_priv | NCreate_view_priv | NShow_view_priv | NCreate_routine_priv | NAlter_routine_priv | NCreate_user_priv | NEvent_priv | NTrigger_priv | NCreate_tablespace_priv | Nssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | 0max_updates | 0max_connections | 0max_user_connections | 0plugin | caching_sha2_passwordauthentication_string | $A$005$v+Z!_:N3>1]T#jL1]?|37h1]CnnPVHEsfeJmFXX/cI9nN144VKUFUdwVggvblw3XUa08password_expired | Npassword_last_changed | 2021-11-26 01:59:27password_lifetime | account_locked | NCreate_role_priv | NDrop_role_priv | NPassword_reuse_history | Password_reuse_time | Password_require_current | User_attributes | 三：截图普通用户，检索

用drop而非delete，简单的区隔就是，drop是截图【备注】，truncate与delete则是截图备注里面【记录】。

截图普通用户

drop user 'userwordpress';#或者drop user 'userwordpress'@'%';

同理，截图检索

drop database wordpress;

用drop截图时，就会有确认电子邮件，为了防止误删。（删库跑路，请小心谨慎可用）

mysql> drop database wordpress; You're about to run a destructive command.Do you want to proceed? (y/n): yYour call!Query OK, 0 rows affectedTime: 0.005s。

山西男科医院专家预约挂号
肚子胀气消化不良怎么办
郑州白癜风检查多少钱
湖北男科医院哪家好
郑州男科挂号
急性支气管炎咳嗽治疗用药
白带有异味
咳嗽有痰吃什么药
维生素d
肠瘘