• linux环境下安装mysql数据库遇到的问题


    总结一句话:
    安装完mysql数据库记得授权远程登录。
     
    坑的现象:
    ERROR 1045 (28000): Access denied for user 'guoxp'@'localhost' (using password: YES)
     
    解决方案如下:
    执行前查看状态:
    MariaDB [mysql]>  select Host,User,Password from user ;
    +-----------------------+-------+-------------------------------------------+
    | Host                  | User  | Password                                  |
    +-----------------------+-------+-------------------------------------------+
    | localhost             | root  |                                           |
    | localhost.localdomain | root  |                                           |
    | 127.0.0.1             | root  |                                           |
    | ::1                   | root  |                                           |
    | localhost             |       |                                           |
    | localhost.localdomain |       |                                           |
    +-----------------------+-------+-------------------------------------------+
    6 rows in set (0.00 sec)
     
     
    授权:
    MariaDB [mysql]> grant select,update,insert,delete on *.* to guoxp@远程登录的ip地址 identified by "远程登录的密码";
    Query OK, 0 rows affected (0.00 sec)
     
    执行后查看状态:
    MariaDB [mysql]>  select Host,User,Password from user ;
    +-----------------------+-------+-------------------------------------------+
    | Host                  | User  | Password                                  |
    +-----------------------+-------+-------------------------------------------+
    | localhost             | root  |                                           |
    | localhost.localdomain | root  |                                           |
    | 127.0.0.1             | root  |                                           |
    | ::1                   | root  |                                           |
    | localhost             |       |                                           |
    | localhost.localdomain |       |                                           |
    | 远程登录的ip地址        | guoxp | *FA074CDA355DAA0D0E53ABE2885985ECEB743D7A |
    +-----------------------+-------+-------------------------------------------+
    7 rows in set (0.01 sec)
  • 相关阅读:
    Android之ToolBar的使用
    Android之 RecyclerView,CardView 详解和相对应的上拉刷新下拉加载
    Andorid 之日历控件,可左右滑动,包含公历,农历,节假日等
    Docker技术入门与实战 第二版-学习笔记-4-Dockerfile外其他生成镜像的方法
    Docker技术入门与实战 第二版-学习笔记-3-Dockerfile 指令详解
    Docker技术入门与实战 第二版-学习笔记-2-镜像构建
    Docker技术入门与实战 第二版-学习笔记-1-镜像
    docker官方文档学习-1-Docker for mac安装配置
    vagrant up下载box慢的解决办法
    主机ping不通virtualbox虚拟机的解决办法
  • 原文地址:https://www.cnblogs.com/jack1208-rose0203/p/5887338.html
Copyright © 2020-2023  润新知