问题一：

    image.png

    解决办法：将localhost 更改为 127.0.0.1 即可

    问题二：

    image.png

    解决办法步骤：

    第一步：进入管理员用户 sudo -s
    第二步：重启数据库 service mysql restart
    第三步：进入数据库 mysql -u root -p
    第四步：更改密码（默认密码为空）分步骤输入下面代码

    1：use mysql；

    image.png


    #其中yhq256112是设置的新密码！
    2：ALTER USER ‘root’@’localhost’ IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY ‘yhq256112’;

    image.png

    3：flush privileges;

    image.png

    4：quit;

    image.png

    第五步：重新利用 navicat 登录数据库

    image.png


    问题1、问题2参考网站：https://blog.csdn.net/qq_25719943/article/details/107760503?ops_request_misc=%25257B%252522request%25255Fid%252522%25253A%252522161147949816780264046707%252522%25252C%252522scm%252522%25253A%25252220140713.130102334.pc%25255Fall.%252522%25257D&request_id=161147949816780264046707&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_v2~rank_v29-1-107760503.pc_search_result_hbase_insert&utm_term=linux%E5%88%A9%E7%94%A8navicat%E8%BF%9E%E6%8E%A5mysql8.0.22%E6%95%B0%E6%8D%AE%E5%BA%93%E6%98%BE%E7%A4%BA%20Access%20denied%20for%20user%20%27root%27@%27localhos

    问题3：

    建立数据库报1449号错误截图

    image.png

    解决方案代码如下（先进入mysql数据库）：

    drop user mysql.infoschema@”localhost”;
    // 这个部分mysql.infoschema@”localhost”就是连接数据库报错提示的用户与地址

    flush privileges;
    //刷新权限

    create user mysql.infoschema@”localhost” identified by ‘h102’;
    //mysql.infoschema@”localhost”这个也要改成你报错的用户与地址

    flush privileges;


    ————————————————————————————————————

    问题4：

    解决问题4后又报出 ERROR 1356 (HY000): View ‘information_schema. SCHEMATA’… 错误

    解决方案代码：

    use mysql

    update user set Select_priv = ‘Y’ where User = ‘mysql.infoschema’;
    //这里注意用户名，也是你报错的用户名

    flush privileges;

    1
    问题3、问题4解决方案参考博客：https://blog.csdn.net/weixin_43558190/article/details/108676123?ops_request_misc=%25257B%252522request%25255Fid%252522%25253A%252522161148985916780265486587%252522%25252C%252522scm%252522%25253A%25252220140713.130102334.pc%25255Fall.%252522%25257D&request_id=161148985916780265486587&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_v2~rank_v29-2-108676123.pc_search_result_hbase_insert&utm_term=navicat%E8%BF%9E%E6%8E%A5mysql%E6%8A%A5%E5%87%BA1449%20-%20The%20user%20specified%20as%20a%20definer%20(%27mysql.infoschema%27@%27localhost%27)%20does%20not%20exist%2520does%2520not%2520exist)