Page 1 of 1

mysql database error

PostPosted: 24. November 2010 14:06
by WrinaSellers
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.';

Re: mysql database error

PostPosted: 24. November 2010 14:18
by Altrea
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:

Re: mysql database error

PostPosted: 24. November 2010 17:08
by JonB
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)