search
HomeBackend DevelopmentPHP Tutorialthinkphp 连接mysql 问题

'DB_TYPE'               => 'mysql',     // 数据库类型	'DB_HOST'               => 'localhost', // 服务器地址	'DB_NAME'               => 'test',          // 数据库名	'DB_USER'               => 'root',      // 用户名	'DB_PWD'                => '123456',          // 密码	'DB_PORT'               => 3306,        // 端口	'DB_PREFIX'             => 'think_',    // 数据库表前缀	'DB_SUFFIX'             => '',          // 数据库表后缀    'DB_FIELDTYPE_CHECK'    => false,       // 是否进行字段类型检查    'DB_FIELDS_CACHE'       => true,        // 启用字段缓存    'DB_CHARSET'            => 'utf8',      // 数据库编码默认采用utf8    'DB_DEPLOY_TYPE'        => 0, // 数据库部署方式:0 集中式(单一服务器),1 分布式(主从服务器)    'DB_RW_SEPARATE'        => false,       // 数据库读写是否分离 主从式有效

密码没错啊
怎么提示
系统发生错误 
您可以选择 [ 重试 ] [ 返回 ] 或者 [ 回到首页 ]
[ 错误信息 ]

Access denied for user 'root'@'localhost' (using password: NO)


回复讨论(解决方案)

提示说密码错误,你说密码错误,可大家谁知道到底是你的密码错没错呢?

看这里
http://topic.csdn.net/u/20111208/23/dacbb0fb-9cfc-4a5a-8377-3ad0d89d0a95.html?71662

用户名,密码是否错误?

用户名,密码是否错误?

if(mysql_connect("localhost","root","123456")){
echo "成功";
}能显示成功啊

提示说密码错误,你说密码错误,可大家谁知道到底是你的密码错没错呢? if(mysql_connect("localhost","root","123456")){
echo "成功";
}能显示成功啊

但是 Access denied for user 'root'@'localhost' ( using password: NO)
是说连接时是没有给出口令的

但是 Access denied for user 'root'@'localhost' (using password: NO)
是说连接时是没有给出口令的 何解

含简单,你测试一下就知道了
已知
mysql_connect("localhost","root","123456")
可以连接成功
那么
mysql_connect("localhost","root","12345"); //注意我有意去掉了口令最后的 6
会报错 Access denied for user 'root'@'localhost' (using password: YES)

mysql_connect("localhost","root"); //不给口令
会报错 Access denied for user 'root'@'localhost' (using password: NO)

问题解决了。
配置文件写错了。

解决了,但是不知道为什么  ,主配置文件 config.php  里面有
$config    =    require './config.inc.php';    //config.inc.php 里面就是 公用的 数据库配置信息
我删掉 config.inc.php 把里面的信息直接写在 主配置文件里面  居然就行了....... 

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
PHP Dependency Injection Container: A Quick StartPHP Dependency Injection Container: A Quick StartMay 13, 2025 am 12:11 AM

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Dependency Injection vs. Service Locator in PHPDependency Injection vs. Service Locator in PHPMay 13, 2025 am 12:10 AM

Select DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.

PHP performance optimization strategies.PHP performance optimization strategies.May 13, 2025 am 12:06 AM

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHP Email Validation: Ensuring Emails Are Sent CorrectlyPHP Email Validation: Ensuring Emails Are Sent CorrectlyMay 13, 2025 am 12:06 AM

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl

How to make PHP applications fasterHow to make PHP applications fasterMay 12, 2025 am 12:12 AM

TomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc

PHP Performance Optimization Checklist: Improve Speed NowPHP Performance Optimization Checklist: Improve Speed NowMay 12, 2025 am 12:07 AM

ToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin

PHP Dependency Injection: Improve Code TestabilityPHP Dependency Injection: Improve Code TestabilityMay 12, 2025 am 12:03 AM

Dependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.

PHP Performance Optimization: Database Query OptimizationPHP Performance Optimization: Database Query OptimizationMay 12, 2025 am 12:02 AM

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),