mariadb访问权限设置

最新推荐文章于 2024-07-25 00:10:35 发布

原创

最新推荐文章于 2024-07-25 00:10:35 发布 · 2.3k 阅读

3 ·

CC 4.0 BY-SA版权

本文详细介绍了MariaDB的访问权限设置，包括如何创建用户、授权远程和本地登录、普通用户的权限显示以及如何撤销和指定数据库显示权限。通过实例展示了如何修改user表授权以及删除用户，确保数据库的安全和可控。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.访问权限

我们想让root用户ip为172.25.254.3这台主机访问。直接访问会报错，需要给权限。那么如何更改权限呢？

[root@foundation3 network-scripts]# mysql -uroot -predhat -h172.25.254.3
ERROR 1045 (28000): Access denied for user 'root'@'foundation3.ilt.example.com' (using password: YES)

进入mariadb数据库，然后我们查看mysql里user的内容
里面有个比较乱的表格，如下。

MariaDB [(none)]> select * from mysql.user;

+--------------+-------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+
| Host         | User  | Password                                  | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string |
+--------------+-------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+------------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+--------+-----------------------+
| localhost    | root  | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 | Y           | Y           | Y           | Y           | Y