DreamCoder for Oracle DBA 2.1 - User Guide and FAQ

Frequently Asked Questions - DreamCoder for Oracle DBA

1. When I try to connect a database, I get the following message: "Access denied for user: myuser@myhost.com (Using password: YES)",What it can be happening?
   The error indicates that the "root" or other user has not been granted network access. You can try executing the following using the mysql command prompt.
   
   grant all privileges on *.* to 'root'@'%' identified by 'password' with grant option;
   
   or GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'myuser'@'myhost';
   
   
2. When I try to connect a database, I get the following message: "ORA-12222: TNS:no such protocol adapter",What it can be happening?
   The protocol adapter requested (by way of the "(PROTOCOL=..)" keyword-value pair in a TNS address) is unknown. If the supplied address is typographically correct then the protocol adapter is not installed.
   
   
3. How to connect my remote MySQL Database server via the Internet?
   MySQL Turbo Manager should be able to get connected to your remote MySQL Database server, but you need the privileges for this.
   
   
4. I try to connect to remote MySQL and receive the message "Host not allowed to connect to server" , What it can be happening?
   This message is generated because you don't have a permission to connect to remote MySQL Database server from your host. Try to execute a GRANT statement to user.