Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

reillyjg

macrumors newbie
Original poster
Oct 15, 2010
1
0
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!
 
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
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.