#1045 Cannot log in to the MySQL server

  • Resolved Mike

    (@mikefreel)


    11 years, 5 months ago

    I installed InstantWP 4.3 – Windows 7 in the following location – D:\INSTANTWP\InstantWP_4.3

    Everything was working fine with default passwords. I then opened up MySQL Admin and changed the password. Now unable to connect to database and launch website. How do I reset user & password back to default.
    ie user = root with no password

Viewing 3 replies - 1 through 3 (of 3 total)

  • You need to either change the password in the config.php file to match what you changed it to in MySQL admin, or change the password in MySQL admin back to what it is in the config.php file.

    Thread Starter Mike

    (@mikefreel)

    I think I really messed up here. Additionally when I changed the password in MySQL Admin – I clicked the Hash Generator 4.1. and clicked ok. Straight away it took me to the login page – I entered the new password which is [ @secret! ] and received the #1045 error. – so I had a look at the config.inc.php – just confused me more. See below…my sql skills = zero. Is their no option from command line to reset?

    <?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 setup/
 *
 * All directives are explained in Documentation.html and on phpMyAdmin
 * wiki <https://wiki.phpmyadmin.net>.
 *
 * @version $Id$
 * @package phpMyAdmin
 */

/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = '4325443kjbh65746283746%/&!Bjhgj'; /* 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';$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* rajk - for blobstreaming */
$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;
$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';
$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;
$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';

/* 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]['tracking'] = 'pma_tracking';
// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
/* Contrib / Swekey authentication */
// $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';

/*
 * End of servers configuration
 */

/*
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>
    Thread Starter Mike

    (@mikefreel)

    resolved…tnx

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘#1045 Cannot log in to the MySQL server’ is closed to new replies.