mysql database error

Problems with the Windows version of XAMPP, questions, comments, and anything related.

mysql database error

Postby WrinaSellers » 24. November 2010 14:06

Hello to all, any help would be appreciated,

I have loaded the new XAMPP, and receiving the following error::
Database Error: Unable to connect to the database:Could not connect to MySQL
I have the most current Microsoft dll:: ntwdblib.dll


I am concerned at the localhost TCP connect, could this be causing the problem?

Server: localhost via TCP/IP
Server version: 5.1.41
Protocol version: 10
User: root@localhost
MySQL charset: UTF-8 Unicode (utf8)

I am using Joomla, and have updated the configuration.php file See setting below:

Do I need to change or delete something??
class JConfig {
var $offline = '0';
var $editor = 'jce';
var $list_limit = '20';
var $helpurl = 'http://help.joomla.org';
var $debug = '0';
var $debug_lang = '0';
var $sef = '0';
var $sef_rewrite = '0';
var $sef_suffix = '0';
var $feed_limit = '10';
var $feed_email = 'author';
var $secret = '************';
var $gzip = '0';
var $error_reporting = '-1';
var $xmlrpc_server = '0';
var $log_path = '/localhost/advancnlocal/logs';
var $tmp_path = '/localhost/advancnlocal/tmp';
var $live_site = '';
var $force_ssl = '0';
var $offset = '-6';
var $caching = '0';
var $cachetime = '15';
var $cache_handler = 'file';
var $memcache_settings = array();
var $ftp_enable = '0';
var $ftp_host = '127.0.0.1';
var $ftp_port = '21';
var $ftp_user = '';
var $ftp_pass = '';
var $ftp_root = '';
var $dbtype = 'mysql';
var $host = 'localhost';
var $user = 'root';
var $db = 'advancnmaster';
var $dbprefix = 'master1_';
var $mailer = 'smtp';
var $mailfrom = 'advancncare@advancn.org';
var $fromname = 'AdvanCN.org';
var $sendmail = '/usr/sbin/sendmail';
var $smtpauth = '0';
var $smtpsecure = 'none';
var $smtpport = '25';
var $smtpuser = 'admin';
var $smtppass = '**********';
var $smtphost = 'localhost';
var $MetaAuthor = '1';
var $MetaTitle = '1';
var $lifetime = '2880';
var $session_handler = 'database';
var $password = '********';
var $sitename = 'sitename.org';
var $MetaDesc = 'Joomla! - the dynamic portal engine and content management system';
var $MetaKeys = 'joomla, Joomla';
var $offline_message = 'This site is down for maintenance. Please check back again soon.';
WrinaSellers
 
Posts: 4
Joined: 29. March 2010 20:22

Re: mysql database error

Postby Altrea » 24. November 2010 14:18

why do you open another post with exactly the same problem?
That will not speed up the help you requested for.

If the reason is just, that your other post is in the german section: Forum-Moderators can move threads :shock:
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: mysql database error

Postby JonB » 24. November 2010 17:08

The 'default connection' for a XAMPP installation is not TCP/IP, its the MySQL socket.

I'm not questioning what or why you did or didn't do things. However. normally, the reason for a TCP/IP connector is that you wish to remotely access the database (in addition to using localhost), say with a database tool like Navicat or MySQL workbench loaded on a remote workstation. If that is the case - you should set the IP to 0.0.0.0 I believe. (and make a couple of other changes)

See this post -

viewtopic.php?f=16&t=42567&p=167604&hilit=Mysql+socket#p167604

Good Luck
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 82 guests