I have windows 7 64 bit and have installed the following: Apache 2.2.17, Mysql 5.1.5.8, php 5.2.17 and phpmyadmin 3.4.3.2. these were installed each separately and I have encounter the following errors. I would appreciate your recommendations on these.
I get the following errors in phpmyadmin:
1. configuration 1. The phpMyAdmin configuration storage is not completely configured, some extended features have been disabled
I click where it says"click here" and the following screen shows:
$cfg['Servers'][$i]['pmadb'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['relation'] ... not OK [ Documentation ]
General relation features: Disabled
$cfg['Servers'][$i]['table_info'] ... not OK [ Documentation ]
Display Features: Disabled
$cfg['Servers'][$i]['table_coords'] ... not OK [ Documentation ]
$cfg['Servers'][$i]['pdf_pages'] ... not OK [ Documentation ]
Creation of PDFs: Disabled
$cfg['Servers'][$i]['column_info'] ... not OK [ Documentation ]
Displaying Column Comments: Disabled
Browser transformation: Disabled
$cfg['Servers'][$i]['bookmarktable'] ... not OK [ Documentation ]
Bookmarked SQL query: Disabled
$cfg['Servers'][$i]['history'] ... not OK [ Documentation ]
SQL history: Disabled
$cfg['Servers'][$i]['designer_coords'] ... not OK [ Documentation ]
Designer: Disabled
$cfg['Servers'][$i]['tracking'] ... not OK [ Documentation ]
Tracking: Disabled
$cfg['Servers'][$i]['userconfig'] ... not OK [ Documentation ]
User preferences: Disabled
2. The configuration file now needs a secret passphrase (blowfish_secret).
I added a blowfish secret but it does not recongnize it
config.inc.php file contains the following but I can no longer find it in the phpmyadmin setup directory. The only file is the config.php:
<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 3.4.3.2 setup script
* Date: Fri, 21 Oct 2011 16:10:55 -0400
*/
/* Servers configuration */
$i = 0;
/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['ssl'] = true;
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* End of servers configuration */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
$cfg['blowfish_secret'] = 'da17clec07d75003#';
$cfg['ForceSSL'] = true;
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
?>
config.php File was created by setup scripts option:
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* Front controller for config view / download and clear
*
* @package phpMyAdmin-setup
*/
/**
* Core libraries.
*/
require './lib/common.inc.php';
require_once './libraries/config/Form.class.php';
require_once './libraries/config/FormDisplay.class.php';
require_once './setup/lib/ConfigGenerator.class.php';
require './libraries/config/setup.forms.php';
$form_display = new FormDisplay();
$form_display->registerForm('_config.php', $forms['_config.php']);
$form_display->save('_config.php');
$config_file_path = ConfigFile::getInstance()->getFilePath();
if (isset($_POST['eol'])) {
$_SESSION['eol'] = ($_POST['eol'] == 'unix') ? 'unix' : 'win';
}
if (PMA_ifSetOr($_POST['submit_clear'], '')) {
//
// Clear current config and return to main page
//
ConfigFile::getInstance()->resetConfigData();
// drop post data
header('HTTP/1.1 303 See Other');
header('Location: index.php');
exit;
} elseif (PMA_ifSetOr($_POST['submit_download'], '')) {
//
// Output generated config file
//
header('Content-Type: text/plain');
header('Content-Disposition: attachment; filename="config.inc.php"');
echo ConfigGenerator::getConfigFile();
exit;
} elseif (PMA_ifSetOr($_POST['submit_save'], '')) {
//
// Save generated config file on the server
//
file_put_contents($config_file_path, ConfigGenerator::getConfigFile());
header('HTTP/1.1 303 See Other');
header('Location: index.php');
exit;
} elseif (PMA_ifSetOr($_POST['submit_load'], '')) {
//
// Load config file from the server
//
$cfg = array();
require_once $config_file_path;
ConfigFile::getInstance()->setConfigData($cfg);
header('HTTP/1.1 303 See Other');
header('Location: index.php');
exit;
} elseif (PMA_ifSetOr($_POST['submit_delete'], '')) {
//
// Delete config file on the server
//
@unlink($config_file_path);
header('HTTP/1.1 303 See Other');
header('Location: index.php');
exit;
} else {
//
// Show generated config file in a <textarea>
//
header('HTTP/1.1 303 See Other');
header('Location: index.php?page=config');
exit;
}
?>
3.Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.58. This may cause unparticular
behavior.
How do I update the MYSQL library of PHP. Do I have to uninstall PHP 5.2.17 and install 5.3 as well as mysql.
4.A newer version of phpMyAdmin is available and you should consider upgrading. The newest versio
on 2011-09-14.
Does it automatically update itself.
Please note I am not an expert. I am just beginning to learn about Apache, PHP and MYSQL. Please provid
detail explanation of what to do and how to do it.
5. Is there a User Manual for phpMyAdmin as I notice that in some books that I have bought there is v
explanation in how to use phpMyAdmin. Most use the command line.
6. I have download xamp-win-32-1.7.7-VC9 installer.exe I would like to know if this is the right version for my laptop which contains windows 7 64 bit. Do you know have a 64 bit version of xamp. What is VC9 stand for and is this the correct one for me. Also is mysql 5.5 contained in this xamp 1.7.7 is it a 32 bit or 64 bit.
I am considering of installing the portable version of xamp and would like to know if are any problems encounter with windows 7 64 bit.
I would appreciate your response to the above. Thank you