#21437: unable to setup phpMyAdmin ------------------------------+--------------------------------------------- Reporter: steve404@… | Owner: alakazam@… Type: defect | Status: assigned Priority: Normal | Milestone: Component: wiki | Version: 1.8.0 Keywords: | Port: phpmyadmin ------------------------------+--------------------------------------------- Changes (by alakazam@…): * status: new => assigned -- Ticket URL: <http://trac.macports.org/ticket/21437#comment:2> MacPorts <http://www.macports.org/> Ports system for Mac OS

#21437: The MAMP howto doesn't match the sample phpMyAdmin config file ------------------------------+--------------------------------------------- Reporter: steve404@… | Owner: alakazam@… Type: defect | Status: assigned Priority: Normal | Milestone: Component: wiki | Version: 1.8.0 Keywords: | Port: phpmyadmin ------------------------------+--------------------------------------------- Comment(by ryandesign@…): I've worked on the ports that comprise the MAMP stack, but the MAMP guide in the wiki was created by someone else. I read through it recently and made a lot of adjustments for clarity and changes that had occurred in the MAMP ports, but that's about it. I haven't used phpMyAdmin in years so I don't know how it's changed lately. One thought I had was that the MAMP guide tells the user to create the file httpd-phpmyadmin.conf with a certain contents. I would suggest that it should instead be the phpMyAdmin port's responsibility to do that. -- Ticket URL: <http://trac.macports.org/ticket/21437#comment:4> MacPorts <http://www.macports.org/> Ports system for Mac OS

#21437: The MAMP howto doesn't match the sample phpMyAdmin config file -------------------------+-------------------------------- Reporter: steve404@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Component: wiki | Version: 1.8.0 Resolution: | Keywords: Port: phpmyadmin | -------------------------+-------------------------------- Changes (by ryandesign@…): * owner: => macports-tickets@… Old description:

Hello,

I'm following instructions at the below link to setup Apache, MySQL and PHP. https://trac.macports.org/wiki/howto/MAMP

At the end of the page it describes how to setup phpMyAdmin:

{{{ Finally, you need to set up the phpMyAdmin configuration to access mySQL. First, set up the config file:

cd /opt/local/www/phpmyadmin/ cp config.sample.inc.php config.inc.php This will create a file config.inc.php in the phpMyAdmin folder. Edit that file, and locate the lines:

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed // with 'config' auth_type) Where ' ' is an empty password; fill it with your MySQL root password. You can either change the 'auth_type' from 'config' to 'cookie' or 'httpd', or alternatively provide the password you selected for the root user in the 'password' option. }}}

I'm able to create file config.inc.php, however when I search for the section to define the password, I don't have that section of code.

How do I set the password? Do I just add those 3 or 4 lines of code?

-Steve

New description: Hello, I'm following instructions at the below link to setup Apache, MySQL and PHP. wiki:howto/MAMP At the end of the page it describes how to setup phpMyAdmin: {{{ Finally, you need to set up the phpMyAdmin configuration to access mySQL. First, set up the config file: cd /opt/local/www/phpmyadmin/ cp config.sample.inc.php config.inc.php This will create a file config.inc.php in the phpMyAdmin folder. Edit that file, and locate the lines: $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? $cfg['Servers'][$i]['user'] = 'root'; // MySQL user $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed // with 'config' auth_type) Where ' ' is an empty password; fill it with your MySQL root password. You can either change the 'auth_type' from 'config' to 'cookie' or 'httpd', or alternatively provide the password you selected for the root user in the 'password' option. }}} I'm able to create file config.inc.php, however when I search for the section to define the password, I don't have that section of code. How do I set the password? Do I just add those 3 or 4 lines of code? -Steve -- -- Ticket URL: <https://trac.macports.org/ticket/21437#comment:6> MacPorts <http://www.macports.org/> Ports system for Mac OS