I'm trying to use MediaWiki and WP to connect to two MySQL databases.
The databases are working properly and so are the forms but
when I try to establish a connection to the database with MediaWiki or WP,
I just get a DB connection error: Permission denied
.
Some facts:
I'm able to...
- Connect to RDS by MySQL Workbrench to add/remove a users/table/Schema
- Connect to RDS by ec2 Command-line (
mysql -u MYUSER -p -h ENDPOINT
)
I'm NOT able to...
- Check my server logs in MySQL Workbrench or Command-line
Could not acquire management access for administration. Exception: Unsupported administration target type: ('windows', 'linux', 'wmi')
- Remove rdsadmin or Revert the asingeded roles and privileges
Error changing account rdsadmin@localhost: Access denied on rdsadmin@localhost
- Grant DBA/MaintenenaceAdmin/ProcessAdmin or ReplicationAdmin to WPuser
Error changing account WPuser@%: Access denied for user 'WPuser'@'%' (using password: YES)
What i have done so far:
I added the Elastic/Private and even Public IP address for the EC2 instance to the VPC security group. as follows: xx.xx.xxx.xxx/32 and xxx.xx.xx.xxx/32. I'm Not useing EC2-Classic Platform, so there is no RDS security group as i'm seeing.
GRANT ALL ON
%.* TO WPuser@
%`; and GRANT index, create, select, insert, update, delete, drop, alter, lock tables on WIKIdb.* to 'WIKIuser'@'ENDPOINT';
Again, my questions are:
What i missed and why would be the solution to establish those applications to databases?
Also do you have anything in mind, how can i solve the "I'm NOT able to..." section to "I'm able to..." ?
I'd be grateful for any help on these