Setting up phpmyadmin...

You are not logged in. [Log In] ubbDev » Forums » Community Development » HTML, CSS, Programming and MySQL
» MySQL and Server Configuration » Setting up phpmyadmin...

Topic Options

#276795 - 07/14/04 04:11 PM Setting up phpmyadmin...
Allusivekudos Junior Member Registered: 05/26/02 Posts: 378 Loc: Na Add to del.icio.us Digg it	I'm switching hosts soon and need to setup phpmyadmin now.<br /><br />I've read over the doc files on it, and I can set phpmyadmin up to manage either of the databases seperately, but can't figure out how to be able to set up the config file so I can manage both together. Anyone know what to do?<br /><br />thanks,<br />peter
Top

#276796 - 07/15/04 04:01 PM Re: Setting up phpmyadmin... [Re: adrienne48]
dimopoulos Kahuna Registered: 08/18/02 Posts: 1271 Loc: Vienna, Austria	The config file is set up in chunks of information that form an array. You just set up the first host in the first "host" element, the second in the second one etc. If you run out of array chunks then copy and paste as many as needed. _________________________ Nikos
Top

#276797 - 07/15/04 10:26 PM

Re: Setting up phpmyadmin... [Re: Hal_dup2]

Allusivekudos Offline

Junior Member

Registered: 05/26/02
Posts: 378
Loc: Na

Okay, that kind of makes sense.

Code:

<br />$cfg['Servers'][$i]['user']          = 'Database1';      // MySQL user<br />$cfg['Servers'][$i]['password']      = 'password1';          // MySQL password (only needed<br />                                                    // with 'config' auth_type)<br />$cfg['Servers'][$i]['only_db']       = 'Database1';          // If set to a db-name, only<br />                                                    // this db is displayed in left frame<br />                                                    // It may also be an array of db-names, where sorting order is relevant.<br />

Is this the code I need to do something with? I guess I'm unclear about how to set up the array. Thanks for your help!

Top

#276798 - 07/16/04 12:19 AM Re: Setting up phpmyadmin... [Re: adrienne48]
Allusivekudos Junior Member Registered: 05/26/02 Posts: 378 Loc: Na	Ah, nevermind. I had a dense moment. I get the array thing now.<br /><br /><br />I have another question though. What's the best way to maintain security over this? Seems dangerous and scary.<br /><br /><br />-p
Top

#276799 - 07/16/04 07:51 AM Re: Setting up phpmyadmin... [Re: adrienne48]
dimopoulos Kahuna Registered: 08/18/02 Posts: 1271 Loc: Vienna, Austria	I personally have installed it on one of my sites over an https protocol and using the http authentication since the transmission of data (login data this is) is secure. I wouldn't suggest any other option really. _________________________ Nikos
Top