SweetWisdom
asked on
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.
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'] = '';
?>
Shortcut-to-phpMyAdminError1045.jpg
those are my username and passwords...root, root:)
<<set the mysql lines as localshost, user_name, password
i mean find those lines and add localhost, username and password
i mean find those lines and add localhost, username and password
<<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...
No need...Sorry, if the above is not present, phpMyAdmin will give a different error; cannot load mysql extenstion...Our case is authentication based...
ASKER
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
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
np...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well try for the followings:
/* Authentication type and info */
$cfg['Servers'][$i]['auth_
$cfg['Servers'][$i]['user'
$cfg['Servers'][$i]['passw
$cfg['Servers'][$i]['exten
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...