Restore Privileges and Access to Master User in RDS to use correctly and access database

0

I was connected to mysql using command line with AWS credentials. I was trying to add some privileges to be able to run a sql script file into the database. I followed some information and run the following query GRANT USAGE ON *.* TO masterusername@'ip' IDENTIFIED BY 'my_secret'; GRANT ALL ON database.* TO masterusername@'ip'; And suddenly I was not able to connect to the database, it's telling me I have no access to such database; My application is running fine but when I try to connect to the db via mysql command line I'm not able to connect. This is a glance to the grants I have but I think I might tried to reset them, but not sure how. SELECT USER(), CURRENT_USER(); information, prior and after the change Before:

+-------------------+------------------+
| USER()            | CURRENT_USER()   |
+-------------------+------------------+
| masterusername@ip | masterusername@% |
+-------------------+------------------+

After:

+----------------------+----------------------+
| USER()               | CURRENT_USER()       |
+----------------------+----------------------+
| masterusername@ip    | masterusername@ip    |
+----------------------+----------------------+

I want to change it back but seems I have no longer privileges cause of the @ip part of the connection I need to restore it to what it was

Enrique
已提問 4 個月前檢視次數 304 次
2 個答案
0

You can restore the password with this api

 aws rds modify-db-instance --master-user-password
AWS
管理員
philaws
已回答 4 個月前
profile picture
專家
已審閱 4 個月前
  • Do you know if this will restore the config for the user? I can access with the password to the mysql command line but it does not allow me to connect to the db I want.

  • There are 2 users matching the master username; only resetting the the one not tied to a specific host @philaws

0

This does not reset the grants for the root user...

已回答 3 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南