GRANT ALL ON *.* TO demoemployee@'1.5.6.4' IDENTIFIED BY 'my_password'
錯誤： 您的 SQL 語法有錯誤；檢查與您的 MySQL 服務器版本相對應的手冊，以獲取在第 1 行的“IDENTIFIED BY 'my_password'”附近使用的正確語法
我沒有看到上面的語法有任何問題，但它仍然不起作用，并'在我的查詢末尾添加了額外的內容。
我已經在我的 MySQL 服務器 8.xx 和這樣的在線工具上嘗試過這個：https ://en.rakko.tools/tools/36/
我還嘗試了其他一些查詢，但無法解決。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'my_password'
我應該如何解決這個問題？
uj5u.com熱心網友回復：
將MySQL 5.7 中的檔案與GRANT8.0 中的檔案進行比較，可以發現不再支持身份驗證特性。5.7 版本還明確警告它們已經在 5.7 中被棄用，并且在未來的版本中可能會被洗掉：
筆記
GRANTMySQL 5.7 中不推薦使用 of來定義帳戶身份驗證特征。相反，使用CREATE USER或建立或更改身份驗證特征ALTER USER。預計GRANT在未來的 MySQL 版本中將洗掉此 功能。
所以只需洗掉IDENTIFIED BY 'my_password'.
uj5u.com熱心網友回復：
回復@Code Cooker 評論：Doesn't really work，如果您有權創建另一個用戶，它就可以作業：
mysql> create user 'demoemployee'@'1.5.6.4' IDENTIFIED BY 'TestPass';
Query OK, 0 rows affected (0.07 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'demoemployee'@'1.5.6.4' ;
Query OK, 0 rows affected (0.09 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.03 sec)
mysql> show grants for 'demoemployee'@'1.5.6.4';
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Grants for demoemployee@1.5.6.4 |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `demoemployee`@`1.5.6.4` |
| GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,XA_RECOVER_ADMIN ON *.* TO `demoemployee`@`1.5.6.4` |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2 rows in set (0.00 sec)
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/394809.html