radondb-mysql-kubernetes icon indicating copy to clipboard operation
radondb-mysql-kubernetes copied to clipboard

Access denied for user 'root'@'x.x.x.x'

Open Mongolian1 opened this issue 4 years ago • 7 comments

After deployment following the above tutorial. https://github.com/radondb/radondb-mysql-kubernetes/blob/main/docs/kubernetes/deploy_radondb-mysql_on_kubernetes.md#%E9%80%9A%E8%BF%87-git-%E9%83%A8%E7%BD%B2

I can't connect to leader remotely. How could I make it so I can connect to radondb remotely? Thanks a lot!

Mongolian1 avatar Sep 25 '21 14:09 Mongolian1

Hi! thanks for your contribution! great first issue!

github-actions[bot] avatar Sep 25 '21 14:09 github-actions[bot]

Hello, you can refer to here for account management related questions #182.

runkecheng avatar Sep 25 '21 14:09 runkecheng

By default, the root account does not support remote access.

runkecheng avatar Sep 25 '21 14:09 runkecheng

I didn't find command for allowing the root account to support remote access in this reference. https://github.com/radondb/xenon/blob/master/docs/xenoncli_commands.md#2-mysql-operation @runkecheng

Mongolian1 avatar Sep 25 '21 15:09 Mongolian1

I didn't find command for allowing the root account to support remote access in this reference. https://github.com/radondb/xenon/blob/master/docs/xenoncli_commands.md#2-mysql-operation @runkecheng

You can create a super user and enable remote access instead of opening remote access for the root account.

runkecheng avatar Sep 25 '21 15:09 runkecheng

I didn't find command for allowing the root account to support remote access in this reference. https://github.com/radondb/xenon/blob/master/docs/xenoncli_commands.md#2-mysql-operation @runkecheng

Each pod has a xenon container, you can enter the xenon container to execute xenoncli. You can refer here

runkecheng avatar Sep 25 '21 15:09 runkecheng

Got it!

Mongolian1 avatar Sep 26 '21 10:09 Mongolian1