phpmyadmin help for newbie

[louisesanders]

Please help with phpmyadmin

 

I have been desperately trying to install PHPmyadmin for the last week but have failed miserably every time! I just want to install it on my local computer so that I can create databases etc etc locally.

 

I have installed PHP successfully (which I have checked in my browser using a test page with the following php code: <?php phpinfo(); ?> )

 

I have installed mysql successfully and have set a password. This seems to be working fine as well.

 

I am working on Windows Vista 32-bit operating system, with IIS7 installed and have installed mysql 5, php 5.2.5 and am trying to install phpMyAdmin2.11.2.1.

 

I have found some useful tutorials but then all of a sudden they don’t tell you exactly how to do something or refer to versions before 2.8 which had the config.inc.php file in the downloaded package. I even bought the book “Mastering phpMyAdmin 2.8” so that I could learn PHPmyadmin – the installation instructions in this book are not clear at all!

 

Please please could someone help me:

 

1. I have downloaded the .zip file and extracted all info to C:\inetpub\wwwroot\phpmyadmin.

 

2. I have enabled these extensions in the php.ini file:

;extension=php_gd2.dll

;extension=php_mbstring.dll

;extension=php_mcrypt.dll

;extension=php_mysql.dll

 

3. I then made a copy of config.sample.inc to config.inc.php

 

4. I added these settings - my code now looks like this:

 

<?php

/* vim: set expandtab sw=4 ts=4 sts=4: */

/**

* phpMyAdmin sample configuration, you can use it as base for

* manual configuration. For easier setup you can use scripts/setup.php

*

* All directives are explained in Documentation.html and on phpMyAdmin

* wiki <http://wiki.cihar.com>.

*

* @version $Id: config.sample.inc.php 10142 2007-03-20 10:32:13Z cybot_tm $

*/

 

/*

* This is needed for cookie based authentication to encrypt password in

* cookie

*/

$cfg['blowfish_secret'] = 'SanDeRs55687'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

 

/*

* Servers configuration

*/

$i = 0;

 

/*

* First server

*/

$i++;

/* Authentication type */

$cfg['Servers'][$i]['auth_type'] = 'cookie';

 

/* Server parameters */

$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = false;

 

/* Select mysqli if your server has it */

$cfg['Servers'][$i]['extension'] = 'mysql';

 

/* User for advanced features */

$cfg['Servers'][$i]['controluser'] = 'pma';

$cfg['Servers'][$i]['controlpass'] = 'pmapass';

 

/* Advanced phpMyAdmin features */

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';

$cfg['Servers'][$i]['relation'] = 'pma_relation';

$cfg['Servers'][$i]['table_info'] = 'pma_table_info';

$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';

$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';

$cfg['Servers'][$i]['column_info'] = 'pma_column_info';

$cfg['Servers'][$i]['history'] = 'pma_history';

$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

 

/*

* End of servers configuration

*/

 

/*

* Directories for saving/loading files from server

*/

$cfg['UploadDir'] = '';

$cfg['SaveDir'] = '';

 

$cfg['docSQLDir'] = 'docsql';

$cfg['ShowPhpInfo'] = true;

$cfg['ShowChgPassword'] = true;

$cfg['AllowArbitraryServer'] = false;

$cfg['LoginCookieRecall'] = 'something';

$cfg['LoginCookieValidity'] = 1800;

$cfg['AllowAnywhereRecoding'] = true;

$cfg['DefaultCharset'] = 'iso-8859-1';

$cfg['RecodingEngine'] = 'iconv';

$cfg['IconvExtraParams'] = '//TRANSLIT';

$cfg['GD2Available'] = 'yes';

 

?>

 

 

 

5. I then went to my browser and typed in http://localhost/phpmyadmin/index.php

6. It comes up with this error message:

 

phpMyAdmin - Error

Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.

 

 

7. I do not know where to find these log files and would not know how to read them either!

8. Although my test file for PHP shows that it is installed and working, do you think I need to re-install it and if so what are the instructions for installing PHP on IIS7? (Because this is where I could have gone wrong…

9. Pleeeeeease help this is driving me crazy…. Any step by step solutions would be greatly appreciated!

 

Many Thanks

Louise

 

[moleculo]

Doesn't phpmyadmin come with your host package?

 

I normally access phpmyadmin like this:

 

go to http://www.mywebsite.com/cpanel

enter username and password

click on the option "mysql databases"

scroll down to the bottom and click "phpmyadmin"

 

It might be different with your hosting company, but that's how I do it, and I never had to install anything.

 

[wildteen88]

Doesn't phpmyadmin come with your host package?

 

I normally access phpmyadmin like this:

 

go to http://www.mywebsite.com/cpanel

enter username and password

click on the option "mysql databases"

scroll down to the bottom and click "phpmyadmin"

 

It might be different with your hosting company, but that's how I do it, and I never had to install anything.

 

That is because louisesanders is installing PMA locally! She is not using a webhost.

 

@louisesanders for installing PMA create a file called config.inc.php in the root of the PMA folder and add the following code to that file:

<?php

/* Servers configuration */
$i = 0;

/* Server localhost (http) [1] */
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['auth_type'] = 'http';

?>

 

Also edit your php.ini file and make sure you have enabled the display_errors directive and that the error_reporting directive is set to E_ALL. Another thing to do is make PHP log errors to a custom log file. To do this enable the log_errors directive and then find the following line:

; Log errors to specified file.

Below that line you should find ;error_log = filename Remove the semi-colon ( at the start of that line and change filename to "C:/php_errors.log";

 

Save the php.ini and create a file called php_errors.log in your C: drive, Now restart IIS. Your new php configuration should now be loaded, you can always check this by running phpinfo();

 

Now try running PMA again. You should get a login box displayed. Enter your MySQL username/password (if you havn't setup a username/password for MySQL yet then use root as the username and leave the password field plank). You should now be logged into PMA. If any errors arise they should be displayed, if not check your php_errors.log file.

[roopurt18]

I'm going to approach this from a different direction.  Unless there are constraints on you that you have to use IIS, is there any reason why you're not just using a one-in-all package like XAMPP?  I can appreciate if you have to stick with IIS for technical reasons, or if you just like going through the process, but if your current goal is to just learn phpMyAdmin it seems silly to give yourself extra road blocks. 

 

Just thought I'd throw that out there.