ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL我已经在谷歌上搜索了这个问题,大多数文章都告诉我使用update user set authentication_string=password("!顺便说一句,我也尝试过这个代码set password for root@localhost = password('!QAZxsw2')
我最近在我的电脑上安装了MySQL,正在尝试将RStudio连接到MySQL。我遵循了书中的说明和的说明。to database: Error: Plugin caching_sha2_password could not be loaded: The specified module could notbe foundmysql -u username -pCREATE DATABASE myDatabase;
然后在RStudi