1. 

   dbsaul, Member

   I have installed dbr on my web host using dbr's own objects database.

   How do I connect with another database ?
2. 

   myDBR Team, Key Master

   Grant to myDBR's database user account a read access to the databases you wish to report from and use following notation in reports:

   select column
   
   from mydatabase.mytable
   
   

   --
   myDBR Team
3. 

   dbsaul, Member

   The database I want to read from is "TEST". So what you mean is that I log in to that database and grant the user I created in MYDBR read access. Is that correct ? How do I do this - thanks
4. 

   myDBR Team, Key Master

   Use MySQL grant command to do this:

   GRANT SELECT ON TEST.* TO username@'localhost' IDENTIFIED BY 'password';

   See more info at MySQL Manuals.

   --
   myDBR Team

Reply

You must log in to post.