要在MySQL中實現SSH免密碼登錄,可以按照以下步驟操作:
[mysqld]
bind-address = 0.0.0.0
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
ssh-keygen -t rsa
ssh username@mysql-server-ip-address
mysql -u username -p
如果一切配置正確,您應該能夠直接登錄到MySQL服務器而無需輸入密碼。