Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Error 1045 phpMyAdmin on Window XP localhost

Posted on 2008-10-05
8
1,280 Views
Last Modified: 2013-12-13
Hi,

I am trying to install phpMyAdmin on my Window XP system. Apache server and PHP works fine and MySQL works fine by itself.
This is what I have done
1) I downloaded a  phpMyAdmin-3.0.0-english and unzip it in my root directory (Where all my php scripts are saved).
2) I have searched online and followed couple of different methods but so far no luck.
2a) I have went into http://localhost/phpmyadmin/scripts/setup.php and followed using the script method "http://minitutorials.com/apache/phpmyadmin11.shtml"
3) I also tried to manually setup by creating a config.inc.php file but no luck.

Is there anything that I should know or missing. Please guide me as I am a total beginner in setting up MySQL and phpMyAdmin..

Thank you,
S.M.
/**
 * 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 11456 2008-08-05 17:28:28Z lem9 $
 */
 
/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = 'badeds234'; /* 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';
/* Contrib / Swekey authentication */
// $cfg['Servers'][$i]['auth_swekey_config'] = './swekey.conf';
 
/*
 * End of servers configuration
 */
 
/*
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
 
?>

Open in new window

Shortcut-to-phpMyAdminError1045.jpg
0
Comment
Question by:SweetWisdom
  • 5
8 Comments
 
LVL 12

Expert Comment

by:jazzIIIlove
ID: 22646029
I must admit It's not very easy to configure them, i may suggest xampp or wamp to be installed as they are bundled...

Well try for the followings:

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['extension'] = 'MySQL'

Which php.ini is used in apache (check phpinfo())
Check the error log of apache. What is written there? Also check the php.ini if extension=php_mysql.dll is present.

Moreover, from phpinfo() could you show us the path my php.ini file resides...and set the mysql lines as localshost, user_name, password...And restart the apache service

Hope this helps...
0
 
LVL 12

Expert Comment

by:jazzIIIlove
ID: 22646032
those are my username and passwords...root, root:)
0
 
LVL 12

Expert Comment

by:jazzIIIlove
ID: 22646037
<<set the mysql lines as localshost, user_name, password
i mean find those lines and add localhost, username and password
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 12

Expert Comment

by:jazzIIIlove
ID: 22646052
<<Also check the php.ini if extension=php_mysql.dll is present.

No need...Sorry, if the above is not present, phpMyAdmin will give a different error; cannot load mysql extenstion...Our case is authentication based...
0
 

Author Comment

by:SweetWisdom
ID: 22646123
Hi jazzllllove,

Thanks for all the solution.. I actually just figure it out. It was that i didn't remove the config.sample.inc from the phpmyadmin folder. Instead I had both config.inc.php and config.sample.inc file inside the folder.

Thanks again
0
 
LVL 12

Expert Comment

by:jazzIIIlove
ID: 22646142
np...
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22910582
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Ajax php search with multiple text fields generated by php 38 65
Wordpress Query 5 25
Wordpress Only run code if on a certain page 11 22
AJAX Wordpress Not Reading Variable 2 27
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to count occurrences of each item in an array.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question