someone else installed an instance of Magento for me on Ubuntu on AWS and now I am running into some permission issues and trying to debug (e.g. database tables are not being created). I think the permission issues are because on this server the DB is installed on RDS. I have the exact Magento installed on another AWS server with DB locally installed and that's working fine.
- How do I check which user is Magento running as?
- How can I manually login into MySql from command prompt? Just typing "MySql" gives the error "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)". I can see MySql credentials at app/etc/local.xml, but unable to figure out how to get the "mysql>" prompt
- Any pointer on what the issue (permission issues) be MySql@RDS?