Database Created in Terminal Not Found By PhpMyAdmin

Discussion in 'Web Design and Development' started by reillyjg, Oct 15, 2010.

  1. reillyjg macrumors newbie

    Joined:
    Oct 15, 2010
    #1
    Hello,
    I created a MySQL database in Terminal for a web app. I can connect to it with pages created in TextWrangler and all works well. Now I am trying to attach it to a website created in Dreamweaver CS4 and I am unable to see it when I try a Database Connection (MySQL) only the following databases are listed: MySQL and Information_Schema. I also cannot see it when I try PhpMyAdmin. Again, I only see the two databases previously listed.
    Any suggestions would be greatly appreciated.
    Thank you!
     
  2. SrWebDeveloper macrumors 68000

    SrWebDeveloper

    Joined:
    Dec 7, 2007
    Location:
    Alexandria, VA, USA
    #2
    Possibly related to user/group permissions issues (saved in the "MYSQL" database).

    In phpMyAdmin edit config.inc.php and make sure similar to this:

    Code:
    
    $cfg['Servers'][$i]['only_db'] 	= array('db1', 'db2', '*'); // array of database names
    
    $cfg['Servers'][$i]['user']          = 'root'; // or whatever user you assigned to the database(s)
    $cfg['Servers'][$i]['password']      = '???'; // user's password
    $cfg['Servers'][$i]['verbose']       = 'My Name'; // server display name
    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    /* Server parameters */
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    
    Follow the documentation.txt instructions.

    -jim
     

Share This Page