Error 1045 phpMyAdmin on Window XP localhost

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
SweetWisdomAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0
 
jazzIIIloveCommented:
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
 
jazzIIIloveCommented:
those are my username and passwords...root, root:)
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
jazzIIIloveCommented:
<<set the mysql lines as localshost, user_name, password
i mean find those lines and add localhost, username and password
0
 
jazzIIIloveCommented:
<<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
 
SweetWisdomAuthor Commented:
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
 
jazzIIIloveCommented:
np...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.