<\/span><\/h2>\n\n\n\n\u53ea\u9700\u8981\u4fee\u6539\u6bcf\u4e2agcluster\u7684\u914d\u7f6e\u3002\u4e00\u822c\u5168\u65b0\u5b89\u88c5\u7684\u4f1a\u81ea\u52a8\u589e\u52a0\u8be5\u53c2\u6570\uff0c\u9ed8\u8ba4\u662f0<\/p>\n\n\n\n
vi \/opt\/gcluster\/config\/gbase_8a_gcluster.cnf\n\n\u5728\u5176\u4e2d\u4fee\u6539\u6216\u589e\u52a0\u53c2\u6570\n\nmax_connections = 10000\nmax_connect_errors=1000000\nmax_allowed_packet = 64M\nnet_write_timeout = 1000000\nnet_read_timeout = 1000000\nconnect_timeout = 1000000\ninteractive_timeout =1000000\nwait_timeout = 1000000\nopen_files_limit = 65535\n\ngbase_caching_sha2_password=1\n\ngbase_express_log = 1\n\ngcluster_connect_net_read_timeout = 1000000\ngcluster_connect_net_write_timeout = 1000000\ngcluster_connect_timeout = 1000000\ngcluster_wait_query_cancel_timeout = 200\n\n<\/code><\/pre>\n\n\n\n<\/span>\u6837\u4f8b<\/span><\/h2>\n\n\n\n\u5982\u4e0b\u521b\u5efa\u4e86\u4e00\u4e2aabc\u7528\u6237\uff0c\u4ecegbase.user\u7684\u5143\u6570\u636e\u8868\u91cc\u53ef\u4ee5\u770b\u5230\u5176\u5bc6\u7801\u957f\u5ea6\u548c\u8001\u7684sha1\u4e0d\u540c\uff0c\u4e3a65\u4f4d\uff0c\u8001\u7684\u662f41\u4f4d\u3002<\/p>\n\n\n\n
gbase> show variables like '%sha%';\n+-----------------------------+-------+\n| Variable_name | Value |\n+-----------------------------+-------+\n| _gbase_gns_share_connection | 1 |\n| gbase_caching_sha2_password | ON |\n+-----------------------------+-------+\n2 rows in set (Elapsed: 00:00:00.00)\n\ngbase> create user abc ;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n\ngbase> grant all on testdb.* to abc identified by 'abc';\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\n\ngbase> select * from gbase.user;\n+--------------------------------------------------------------+------------------+-------------------------------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+----------+--------------+---------------+----------------+---------------+-------------------------+-------------------+------+\n| 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 | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | max_cpus | max_memories | max_tmp_space | resource_group | task_priority | user_limit_storage_size | user_storage_size | UID |\n+--------------------------------------------------------------+------------------+-------------------------------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+----------+--------------+---------------+----------------+---------------+-------------------------+-------------------+------+\n| % | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | | 0 | 1 |\n| % | gbase | *9C0ADBD7F08FA9D49D82760B104110C55B943B8D | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | | 0 | 2 |\n| % | abc | *4F8B42C22DD3729B519BA6F68D2DA7CC5B2D606D05DAED5AD5128CC03E6C6358 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | | 0 | 2049 |\n+--------------------------------------------------------------+------------------+-------------------------------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+------------------+----------------+---------------------+--------------------+------------------+------------+--------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+----------------------+----------+--------------+---------------+----------------+---------------+-------------------------+-------------------+------+\n3 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n