dbeaver连接mysql提示以下错误

null,  message from server: "Host '172.23.0.1' is not allowed to connect to this MySQL server"

        

          
        
        
        

          

          AI 代码解读
        
      
      

解决步骤：

第一步：

use mysql;

        

          
        
        
        

          

          AI 代码解读
        
      
      

第二步：

update user set host = '%' where user = 'root';

        

          
        
        
        

          

          AI 代码解读
        
      
      

第三步:

alter user 'root'@'%' identified with mysql_native_password by '123456';

        

          
        
        
        

          

          AI 代码解读
        
      
      

第四步:

flush privileges;

        

          
        
        
        

          

          AI 代码解读