Mysql 1045 Error Resolution

Source: Internet
Author: User
Keywords MySQL

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

Recently downloaded the PHP installation package:

Install the Php+mysql installation Configuration tutorial (full utility) under IIS, the package applies to the server environment under Windows 2000/xp/2003 iis+php+mysql+zend OPTIMIZER+GD library +phpmyadmin.

I followed the installation steps until I modified the config.default.php file as follows:

$cfg [' Servers '] [$i] [' auth_type '] = ' cookie '; authentication method (config, HTTP or cookie based)?

$cfg [' Servers '] [$i] [' user '] = ' root '; MySQL User

$cfg [' Servers '] [$i] [' password '] = '; MySQL Password (only needed

But enter Http://localhost//phpMyAdmin open the page, follow the corresponding user and password to enter, but always appear the following prompts:

#1045-access denied for user ' root ' @ ' localhost ' (using Password:no)

(Cookies must be started to log in.)

I thought the cookies didn't start, so then I followed the instructions on the Internet to start cookies:

Internet Explorer 6.x

Select Tools from the main menu | Internet Options ... ".

Select the Privacy tab.

Click Advanced ....

Select Overwrite automatic cookie processing.

To enable: Select Accept for first-party cookies and third party cookies and select Always allow session cookies.

To disable: Select Deny for first-party cookies and third party cookies without selecting always allow session cookies.

To get a hint: Select Prompt for first-party cookies and third party cookies, and do not select Always allow session cookies.

Click OK

But after setting up, the above prompts still appear, so I always suspect that cookies do not really start, continue to set cookies, and take a long time, but it still does not work. I even suspected the entire installation was in trouble and wanted to reinstall it once.

But I did not; I opened the config.default.php file and found

$cfg [' Servers '] [$i] [' user '] = ' root '; MySQL User

$cfg [' Servers '] [$i] [' password '] = '; MySQL Password (only needed

Comments after these two statements: the original user and password are MySQL database.

But the password I have set when installing MySQL (password: admin).

The above two statements I did not modify, directly closed the file config.default.php.

I held a try attitude, re-enter the username root and password admin, the result login success!

It seems that cookies have been started, but the login interface still shows: Cookies must be started to log in. This is a big misleading, always thinking that cookies are not started.

I hope this article will help people with similar problems.

Original PS (www.shenmu66.com.cn) reprint please keep

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.