2003 - Can't connect to MySQL server on 'localhost' (10061)

mraza · October 21, 2009

i have installed Apache 2.2.14 and PHP 5.2.11 and both are working great, then instaleld MySQL 5.1 and it also works ok i test in cmd.exe and changed the root pass etc. Now i download phpMyAdmin-3.2.2.1-english.zip and extacted in htdocs, i went through setup created a folder named config and just enterted 'localhost' in server and root and password and cut and paste the cofig.inc.php in phpmyadmin main directory and deleted the config folder. now whenever i try to login it show me this error:

#2003 - Can't connect to MySQL server on 'localhost' (10061)

Please any help what i am missing, i need to install all things all individually , and this one is last for now to move on. i am on win 7 32 system. Thanks for any support.

Regards

Daniel0 · October 22, 2009

Are you sure the MySQL server is running and listening to the correct port? Try running

netstat -an | find "3306" | find "LISTENING"

from the command line and see what it returns.

mraza · October 22, 2009

Thanks sir when i put that command it displays nothing just empty, i saw in services MySql is running

Daniel0 · October 22, 2009

Well, it's not listening to the correct port then.

Try running

netstat -bn

to figure out what port it is listening to. If mysqld.exe doesn't even show up when you do that, then something is very wrong.

mraza · October 22, 2009

Hello Sir i did a new installation of MySQL and typed the first command you wrote before now i get this :

TCP 0.0.0.0:3306 My-PC:0 LISTENING

I restarted apache and then went to phpmyadmin and this time it shows a blank page again after entering login detail. i m missing something in phpmyadmin configuration.

Daniel0 · October 22, 2009

Right, so now MySQL is listening to the correct port at least.

I'm not sure why phpmyadmin would show a blank page. Probably some sort of error occurred (that's a typical reason why you would get an unexpected blank page). Try making sure that error_reporting is set to E_ALL in php.ini and that display_errors is set to on. Remember to restart Apache after doing that. When you've done that, try to see if there is any error printed to the screen in phpmyadmin.

mraza · October 22, 2009

in my php.ini it was set to

error_reporting = E_ALL & ~E_NOTICE

and i changed it to

error_reporting = E_ALL

and display_errors is on and this time i get this error

"PHPMYADMIN ERROR

Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.

"

i put that back in php,ini, then i setup again phpmyadmin, here is my config.inc.php of phpmyadmin.

<?php
/*
* Generated configuration file
* Generated by: phpMyAdmin 3.2.2.1 setup script by Piotr Przybylski <piotrprz@gmail.com>
* Date: Thu, 22 Oct 2009 16:46:14 +0300
*/

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

/* End of servers configuration */

$cfg['blowfish_secret'] = '4ae0621fc15f81.13661664';
$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>

Daniel0 · October 22, 2009

So did you check the error log like it suggested?

mraza · October 22, 2009

i got this in my Apache error log when i goto localhost/phpMyAdmin/:

[Thu Oct 22 16:56:33 2009] [notice] Child 3328: Starting thread to listen on port 80.
[Thu Oct 22 16:56:35 2009] [notice] Parent: child process exited with status 255 -- Restarting.
[Thu Oct 22 16:56:35 2009] [notice] Apache/2.2.14 (Win32) PHP/5.2.11 configured -- resuming normal operations
[Thu Oct 22 16:56:35 2009] [notice] Server built: Sep 28 2009 22:41:08
[Thu Oct 22 16:56:35 2009] [notice] Parent: Created child process 1964
[Thu Oct 22 16:56:35 2009] [notice] Child 1964: Child process is running
[Thu Oct 22 16:56:35 2009] [notice] Child 1964: Acquired the start mutex.
[Thu Oct 22 16:56:35 2009] [notice] Child 1964: Starting 64 worker threads.
[Thu Oct 22 16:56:35 2009] [notice] Child 1964: Starting thread to listen on port 80.
[Thu Oct 22 17:02:57 2009] [notice] Parent: child process exited with status 255 -- Restarting.
[Thu Oct 22 17:02:57 2009] [notice] Apache/2.2.14 (Win32) PHP/5.2.11 configured -- resuming normal operations
[Thu Oct 22 17:02:57 2009] [notice] Server built: Sep 28 2009 22:41:08
[Thu Oct 22 17:02:57 2009] [notice] Parent: Created child process 1456
[Thu Oct 22 17:02:57 2009] [notice] Child 1456: Child process is running
[Thu Oct 22 17:02:57 2009] [notice] Child 1456: Acquired the start mutex.
[Thu Oct 22 17:02:57 2009] [notice] Child 1456: Starting 64 worker threads.
[Thu Oct 22 17:02:57 2009] [notice] Child 1456: Starting thread to listen on port 80.

Daniel0 · October 22, 2009

Hmm... try making sure that the session save path is readable by the webserver. Sessions are by default stored on the file system, so if PHP cannot write to that directory, sessions won't work.

mraza · October 22, 2009

i created a new folder and set new session path in php.ini, and its creating the session file;

session.save_path = "C:\temp"

PMA_token |s:32:"035de8ce5596fe61cc209ff78741748b";PMA_Config|O:10:"PMA_Config":10:{s:14:"default_source";s:30:"./libraries/config.default.php";s:8:"settings";a:168:{s:14:"PmaAbsoluteUri";s:28:"http://localhost/phpMyAdmin/";s:28:"PmaNoRelation_DisableWarning";b:0;s:21:"SuhosinDisableWarning";b:0;s:20:"McryptDisableWarning";b:0;s:22:"AllowThirdPartyFraming";b:0;s:15:"blowfish_secret";s:23:"4ae0621fc15f81.13661664";s:13:"ServerDefault";i:1;s:9:"MaxDbList";i:100;s:12:"MaxTableList";i:250;s:27:"MaxCharactersInDisplayedSQL";i:1000;s:6:"OBGzip";s:4:"auto";s:21:"PersistentConnections";b:0;s:8:"ForceSSL";b:0;s:13:"ExecTimeLimit";i:300;s:11:"MemoryLimit";i:0;s:16:"SkipLockedTables";b:0;s:7:"ShowSQL";b:1;s:21:"AllowUserDropDatabase";b:0;s:7:"Confirm";b:1;s:17:"LoginCookieRecall";b:1;s:19:"LoginCookieValidity";i:1440;s:16:"LoginCookieStore";i:0;s:20:"LoginCookieDeleteAll";b:1;s:11:"UseDbSearch";b:1;s:23:"IgnoreMultiSubmitErrors";b:0;s:18:"VerboseMultiSubmit";b:1;s:20:"AllowArbitraryServer";b:0;s:13:"Error_Handler";a:2:{s:7:"display";b:0;s:6:"gather";b:0;}s:14:"LeftFrameLight";b:1;s:15:"LeftFrameDBTree";b:1;s:20:"LeftFrameDBSeparator";s:1:"_";s:23:"LeftFrameTableSeparator";s:2:"__";s:19:"LeftFrameTableLevel";i:1;s:11:"ShowTooltip";b:1;s:18:"ShowTooltipAliasDB";b:0;s:18:"ShowTooltipAliasTB";b:0;s:15:"LeftDisplayLogo";b:1;s:12:"LeftLogoLink";s:8:"main.php";s:18:"LeftLogoLinkWindow";s:4:"main";s:18:"LeftDisplayServers";b:0;s:18:"DisplayServersList";b:0;s:20:"DisplayDatabasesList";s:4:"auto";s:19:"LeftDefaultTabTable";s:17:"tbl_structure.php";s:9:"ShowStats";b:1;s:11:"ShowPhpInfo";b:0;s:14:"ShowServerInfo";b:1;s:15:"ShowChgPassword";b:1;s:12:"ShowCreateDb";b:1;s:13:"SuggestDBName";b:1;s:19:"NavigationBarIconic";s:4:"both";s:7:"ShowAll";b:0;s:7:"MaxRows";i:30;s:5:"Order";s:3:"ASC";s:13:"ProtectBinary";s:4:"blob";s:18:"ShowFunctionFields";b:1;s:11:"CharEditing";s:5:"input";s:10:"InsertRows";i:2;s:23:"ForeignKeyDropdownOrder";a:2:{i:0;s:10:"content-id";i:1;s:10:"id-content";}s:18:"ForeignKeyMaxLimit";i:100;s:7:"ZipDump";b:1;s:8:"GZipDump";b:1;s:8:"BZipDump";b:1;s:13:"CompressOnFly";b:1;s:9:"LightTabs";b:0;s:16:"PropertiesIconic";b:1;s:20:"PropertiesNumColumns";i:1;s:16:"DefaultTabServer";s:8:"main.php";s:18:"DefaultTabDatabase";s:16:"db_structure.php";s:15:"DefaultTabTable";s:7:"sql.php";s:28:"DefaultTabTranslationMapping";a:9:{s:17:"tbl_structure.php";s:12:"strStructure";s:11:"tbl_sql.php";s:6:"strSQL";s:14:"tbl_select.php";s:9:"strSearch";s:14:"tbl_change.php";s:9:"strInsert";s:7:"sql.php";s:9:"strBrowse";s:16:"db_structure.php";s:12:"strStructure";s:10:"db_sql.php";s:6:"strSQL";s:13:"db_search.php";s:9:"strSearch";s:17:"db_operations.php";s:13:"strOperations";}s:6:"Export";a:81:{s:6:"format";s:3:"sql";s:11:"compression";s:4:"none";s:6:"asfile";b:0;s:7:"charset";s:0:"";s:8:"onserver";b:0;s:18:"onserver_overwrite";b:0;s:22:"remember_file_template";b:1;s:19:"file_template_table";s:9:"__TABLE__";s:22:"file_template_database";s:6:"__DB__";s:20:"file_template_server";s:10:"__SERVER__";s:11:"ods_columns";b:0;s:8:"ods_null";s:4:"NULL";s:13:"odt_structure";b:1;s:8:"odt_data";b:1;s:11:"odt_columns";b:1;s:12:"odt_relation";b:1;s:12:"odt_comments";b:1;s:8:"odt_mime";b:1;s:8:"odt_null";s:4:"NULL";s:17:"htmlexcel_columns";b:0;s:14:"htmlexcel_null";s:4:"NULL";s:18:"htmlword_structure";b:1;s:13:"htmlword_data";b:1;s:16:"htmlword_columns";b:0;s:13:"htmlword_null";s:4:"NULL";s:18:"texytext_structure";b:1;s:13:"texytext_data";b:1;s:16:"texytext_columns";b:0;s:13:"texytext_null";s:4:"NULL";s:11:"xls_columns";b:0;s:8:"xls_null";s:4:"NULL";s:11:"csv_columns";b:0;s:8:"csv_null";s:4:"NULL";s:13:"csv_separator";s:1:";";s:12:"csv_enclosed";s:1:""";s:11:"csv_escaped";s:1:"\";s:14:"csv_terminated";s:4:"AUTO";s:13:"excel_columns";b:0;s:10:"excel_null";s:4:"NULL";s:13:"excel_edition";s:3:"win";s:15:"latex_structure";b:1;s:10:"latex_data";b:1;s:13:"latex_columns";b:1;s:14:"latex_relation";b:1;s:14:"latex_comments";b:1;s:10:"latex_mime";b:1;s:10:"latex_null";s:13:"\textit{NULL}";s:13:"latex_caption";b:1;s:23:"latex_structure_caption";s:17:"strLatexStructure";s:33:"latex_structure_continued_caption";s:35:"strLatexStructure strLatexContinued";s:18:"latex_data_caption";s:15:"strLatexContent";s:28:"latex_data_continued_caption";s:33:"strLatexContent strLatexContinued";s:16:"latex_data_label";s:18:"tab:__TABLE__-data";s:21:"latex_structure_label";s:23:"tab:__TABLE__-structure";s:13:"sql_structure";b:1;s:8:"sql_data";b:1;s:17:"sql_compatibility";s:4:"NONE";s:20:"sql_include_comments";b:1;s:14:"sql_disable_fk";b:0;s:19:"sql_use_transaction";b:0;s:17:"sql_drop_database";b:0;s:14:"sql_drop_table";b:0;s:17:"sql_if_not_exists";b:1;s:22:"sql_procedure_function";b:0;s:18:"sql_auto_increment";b:1;s:14:"sql_backquotes";b:1;s:9:"sql_dates";b:0;s:12:"sql_relation";b:0;s:11:"sql_columns";b:1;s:11:"sql_delayed";b:0;s:10:"sql_ignore";b:0;s:16:"sql_hex_for_blob";b:1;s:8:"sql_type";s:6:"insert";s:12:"sql_extended";b:1;s:18:"sql_max_query_size";i:50000;s:12:"sql_comments";b:0;s:8:"sql_mime";b:0;s:18:"sql_header_comment";s:0:"";s:13:"pdf_structure";b:0;s:8:"pdf_data";b:1;s:16:"pdf_report_title";s:0:"";}s:6:"Import";a:19:{s:6:"format";s:3:"sql";s:7:"charset";s:0:"";s:15:"allow_interrupt";b:1;s:12:"skip_queries";s:1:"0";s:17:"sql_compatibility";s:4:"NONE";s:25:"sql_no_auto_value_on_zero";b:1;s:11:"csv_replace";b:0;s:14:"csv_terminated";s:1:";";s:12:"csv_enclosed";s:1:""";s:11:"csv_escaped";s:1:"\";s:12:"csv_new_line";s:4:"auto";s:11:"csv_columns";s:0:"";s:11:"ldi_replace";b:0;s:14:"ldi_terminated";s:1:";";s:12:"ldi_enclosed";s:1:""";s:11:"ldi_escaped";s:1:"\";s:12:"ldi_new_line";s:4:"auto";s:11:"ldi_columns";s:0:"";s:16:"ldi_local_option";s:4:"auto";}s:15:"MySQLManualBase";s:31:"http://dev.mysql.com/doc/refman";s:15:"MySQLManualType";s:8:"viewable";s:12:"PDFPageSizes";a:5:{i:0;s:2:"A3";i:1;s:2:"A4";i:2;s:2:"A5";i:3;s:6:"letter";i:4;s:5:"legal";}s:18:"PDFDefaultPageSize";s:2:"A4";s:11:"DefaultLang";s:8:"en-utf-8";s:26:"DefaultConnectionCollation";s:15:"utf8_general_ci";s:15:"FilterLanguages";s:0:"";s:14:"DefaultCharset";s:5:"utf-8";s:21:"AllowAnywhereRecoding";b:0;s:14:"RecodingEngine";s:4:"auto";s:16:"IconvExtraParams";s:10:"//TRANSLIT";s:17:"AvailableCharsets";a:31:{i:0;s:10:"iso-8859-1";i:1;s:10:"iso-8859-2";i:2;s:10:"iso-8859-3";i:3;s:10:"iso-8859-4";i:4;s:10:"iso-8859-5";i:5;s:10:"iso-8859-6";i:6;s:10:"iso-8859-7";i:7;s:10:"iso-8859-8";i:8;s:10:"iso-8859-9";i:9;s:11:"iso-8859-10";i:10;s:11:"iso-8859-11";i:11;s:11:"iso-8859-12";i:12;s:11:"iso-8859-13";i:13;s:11:"iso-8859-14";i:14;s:11:"iso-8859-15";i:15;s:12:"windows-1250";i:16;s:12:"windows-1251";i:17;s:12:"windows-1252";i:18;s:12:"windows-1256";i:19;s:12:"windows-1257";i:20;s:6:"koi8-r";i:21;s:4:"big5";i:22;s:6:"gb2312";i:23;s:6:"utf-16";i:24;s:5:"utf-8";i:25;s:5:"utf-7";i:26;s:14:"x-user-defined";i:27;s:6:"euc-jp";i:28;s:14:"ks_c_5601-1987";i:29;s:7:"tis-620";i:30;s:9:"SHIFT_JIS";}s:17:"LeftPointerEnable";b:1;s:19:"BrowsePointerEnable";b:1;s:18:"BrowseMarkerEnable";b:1;s:12:"TextareaCols";i:40;s:12:"TextareaRows";i:7;s:22:"LongtextDoubleTextarea";b:1;s:18:"TextareaAutoSelect";b:0;s:16:"CharTextareaCols";i:40;s:16:"CharTextareaRows";i:2;s:16:"CtrlArrowsMoving";b:1;s:10:"LimitChars";i:50;s:18:"ModifyDeleteAtLeft";b:1;s:19:"ModifyDeleteAtRight";b:0;s:14:"DefaultDisplay";s:10:"horizontal";s:18:"DefaultPropDisplay";i:3;s:14:"HeaderFlipType";s:3:"css";s:18:"ShowBrowseComments";b:1;s:20:"ShowPropertyComments";b:1;s:11:"RepeatCells";i:100;s:12:"EditInWindow";b:1;s:16:"QueryWindowWidth";i:550;s:17:"QueryWindowHeight";i:310;s:14:"QueryHistoryDB";b:0;s:17:"QueryWindowDefTab";s:3:"sql";s:15:"QueryHistoryMax";i:25;s:10:"BrowseMIME";b:1;s:13:"MaxExactCount";i:20000;s:18:"MaxExactCountViews";i:0;s:11:"WYSIWYG-PDF";b:1;s:12:"NaturalOrder";b:1;s:19:"InitialSlidersState";s:6:"closed";s:10:"TitleTable";s:61:"@HTTP_HOST@ / @VSERVER@ / @DATABASE@ / @TABLE@ | @PHPMYADMIN@";s:13:"TitleDatabase";s:51:"@HTTP_HOST@ / @VSERVER@ / @DATABASE@ | @PHPMYADMIN@";s:11:"TitleServer";s:38:"@HTTP_HOST@ / @VSERVER@ | @PHPMYADMIN@";s:12:"TitleDefault";s:26:"@HTTP_HOST@ | @PHPMYADMIN@";s:11:"ErrorIconic";b:1;s:14:"MainPageIconic";b:1;s:14:"ReplaceHelpImg";b:1;s:9:"ThemePath";s:8:"./themes";s:12:"ThemeManager";b:1;s:12:"ThemeDefault";s:8:"original";s:14:"ThemePerServer";b:0;s:17:"DefaultQueryTable";s:24:"SELECT * FROM %t WHERE 1";s:20:"DefaultQueryDatabase";s:0:"";s:8:"SQLQuery";a:5:{s:4:"Edit";b:1;s:7:"Explain";b:1;s:9:"ShowAsPHP";b:1;s:8:"Validate";b:0;s:7:"Refresh";b:1;}s:9:"UploadDir";s:0:"";s:7:"SaveDir";s:0:"";s:7:"TempDir";s:0:"";s:12:"GD2Available";s:4:"auto";s:14:"TrustedProxies";a:0:{}s:29:"CheckConfigurationPermissions";b:1;s:3:"SQP";a:3:{s:7:"fmtType";s:4:"html";s:6:"fmtInd";s:1:"1";s:10:"fmtIndUnit";s:2:"em";}s:12:"SQLValidator";a:3:{s:3:"use";b:0;s:8:"username";s:0:"";s:8:"password";s:0:"";}s:3:"DBG";a:3:{s:3:"sql";b:0;s:3:"php";b:0;s:7:"profile";a:2:{s:6:"enable";b:0;s:9:"threshold":0.5;}}s:11:"ColumnTypes";a:8:{i:0;s:3:"INT";i:1;s:7:"VARCHAR";i:2;s:4:"TEXT";i:3;s:4:"DATE";s:7:"NUMERIC";a:14:{i:0;s:7:"TINYINT";i:1;s:8:"SMALLINT";i:2;s:9:"MEDIUMINT";i:3;s:3:"INT";i:4;s:6:"BIGINT";i:5;s:1:"-";i:6;s:7:"DECIMAL";i:7;s:5:"FLOAT";i:8;s:6:"DOUBLE";i:9;s:4:"REAL";i:10;s:1:"-";i:11;s:3:"BIT";i:12;s:4:"BOOL";i:13;s:6:"SERIAL";}s:13:"DATE and TIME";a:5:{i:0;s:4:"DATE";i:1;s:8:"DATETIME";i:2;s:9:"TIMESTAMP";i:3;s:4:"TIME";i:4;s:4:"YEAR";}s:6:"STRING";a:18:{i:0;s:4:"CHAR";i:1;s:7:"VARCHAR";i:2;s:1:"-";i:3;s:8:"TINYTEXT";i:4;s:4:"TEXT";i:5;s:10:"MEDIUMTEXT";i:6;s:8:"LONGTEXT";i:7;s:1:"-";i:8;s:6:"BINARY";i:9;s:9:"VARBINARY";i:10;s:1:"-";i:11;s:8:"TINYBLOB";i:12;s:10:"MEDIUMBLOB";i:13;s:4:"BLOB";i:14;s:8:"LONGBLOB";i:15;s:1:"-";i:16;s:4:"ENUM";i:17;s:3:"SET";}s:7:"SPATIAL";a:8:{i:0;s:8:"GEOMETRY";i:1;s:5:"POINT";i:2;s:10:"LINESTRING";i:3;s:7:"POLYGON";i:4;s:10:"MULTIPOINT";i:5;s:15:"MULTILINESTRING";i:6;s:12:"MULTIPOLYGON";i:7;s:18:"GEOMETRYCOLLECTION";}}s:14:"AttributeTypes";a:5:{i:0;s:0:"";i:1;s:6:"BINARY";i:2;s:8:"UNSIGNED";i:3;s:17:"UNSIGNED ZEROFILL";i:4;s:27:"on update CURRENT_TIMESTAMP";}s:9:"Functions";a:69:{i:0;s:3:"ABS";i:1;s:4:"ACOS";i:2;s:5:"ASCII";i:3;s:4:"ASIN";i:4;s:4:"ATAN";i:5;s:3:"BIN";i:6;s:9:"BIT_COUNT";i:7;s:10:"BIT_LENGTH";i:8;s:7:"CEILING";i:9;s:4:"CHAR";i:10;s:11:"CHAR_LENGTH";i:11;s:8:"COMPRESS";i:12;s:3:"COS";i:13;s:3:"COT";i:14;s:5:"CRC32";i:15;s:7:"CURDATE";i:16;s:12:"CURRENT_USER";i:17;s:7:"CURTIME";i:18;s:4:"DATE";i:19;s:7:"DAYNAME";i:20;s:7:"DEGREES";i:21;s:11:"DES_DECRYPT";i:22;s:11:"DES_ENCRYPT";i:23;s:7:"ENCRYPT";i:24;s:3:"EXP";i:25;s:5:"FLOOR";i:26;s:9:"FROM_DAYS";i:27;s:13:"FROM_UNIXTIME";i:28;s:3:"HEX";i:29;s:9:"INET_ATON";i:30;s:9:"INET_NTOA";i:31;s:6:"LENGTH";i:32;s:2:"LN";i:33;s:3:"LOG";i:34;s:5:"LOG10";i:35;s:4:"LOG2";i:36;s:5:"LOWER";i:37;s:3:"MD5";i:38;s:3:"NOW";i:39;s:3:"OCT";i:40;s:12:"OLD_PASSWORD";i:41;s:3:"ORD";i:42;s:8:"PASSWORD";i:43;s:7:"RADIANS";i:44;s:4:"RAND";i:45;s:7:"REVERSE";i:46;s:5:"ROUND";i:47;s:11:"SEC_TO_TIME";i:48;s:4:"SHA1";i:49;s:7:"SOUNDEX";i:50;s:5:"SPACE";i:51;s:4:"SQRT";i:52;s:10:"STDDEV_POP";i:53;s:11:"STDDEV_SAMP";i:54;s:3:"TAN";i:55;s:9:"TIMESTAMP";i:56;s:11:"TIME_TO_SEC";i:57;s:10:"UNCOMPRESS";i:58;s:5:"UNHEX";i:59;s:14:"UNIX_TIMESTAMP";i:60;s:5:"UPPER";i:61;s:4:"USER";i:62;s:8:"UTC_DATE";i:63;s:8:"UTC_TIME";i:64;s:13:"UTC_TIMESTAMP";i:65;s:4:"UUID";i:66;s:7:"VAR_POP";i:67;s:8:"VAR_SAMP";i:68;s:4:"YEAR";}s:19:"RestrictColumnTypes";a:39:{s:7:"TINYINT";s:11:"FUNC_NUMBER";s:8:"SMALLINT";s:11:"FUNC_NUMBER";s:9:"MEDIUMINT";s:11:"FUNC_NUMBER";s:3:"INT";s:11:"FUNC_NUMBER";s:6:"BIGINT";s:11:"FUNC_NUMBER";s:7:"DECIMAL";s:11:"FUNC_NUMBER";s:5:"FLOAT";s:11:"FUNC_NUMBER";s:6:"DOUBLE";s:11:"FUNC_NUMBER";s:4:"REAL";s:11:"FUNC_NUMBER";s:3:"BIT";s:11:"FUNC_NUMBER";s:4:"BOOL";s:11:"FUNC_NUMBER";s:6:"SERIAL";s:11:"FUNC_NUMBER";s:4:"DATE";s:9:"FUNC_DATE";s:8:"DATETIME";s:9:"FUNC_DATE";s:9:"TIMESTAMP";s:9:"FUNC_DATE";s:4:"TIME";s:9:"FUNC_DATE";s:4:"YEAR";s:9:"FUNC_DATE";s:4:"CHAR";s:9:"FUNC_CHAR";s:7:"VARCHAR";s:9:"FUNC_CHAR";s:8:"TINYTEXT";s:9:"FUNC_CHAR";s:4:"TEXT";s:9:"FUNC_CHAR";s:10:"MEDIUMTEXT";s:9:"FUNC_CHAR";s:8:"LONGTEXT";s:9:"FUNC_CHAR";s:6:"BINARY";s:9:"FUNC_CHAR";s:9:"VARBINARY";s:9:"FUNC_CHAR";s:8:"TINYBLOB";s:9:"FUNC_CHAR";s:10:"MEDIUMBLOB";s:9:"FUNC_CHAR";s:4:"BLOB";s:9:"FUNC_CHAR";s:8:"LONGBLOB";s:9:"FUNC_CHAR";s:4:"ENUM";s:0:"";s:3:"SET";s:0:"";s:8:"GEOMETRY";s:12:"FUNC_SPATIAL";s:5:"POINT";s:12:"FUNC_SPATIAL";s:10:"LINESTRING";s:12:"FUNC_SPATIAL";s:7:"POLYGON";s:12:"FUNC_SPATIAL";s:10:"MULTIPOINT";s:12:"FUNC_SPATIAL";s:15:"MULTILINESTRING";s:12:"FUNC_SPATIAL";s:12:"MULTIPOLYGON";s:12:"FUNC_SPATIAL";s:18:"GEOMETRYCOLLECTION";s:12:"FUNC_SPATIAL";}s:17:"RestrictFunctions";a:4:{s:9:"FUNC_CHAR";a:23:{i:0;s:3:"BIN";i:1;s:4:"CHAR";i:2;s:12:"CURRENT_USER";i:3;s:8:"COMPRESS";i:4;s:7:"DAYNAME";i:5;s:11:"DES_DECRYPT";i:6;s:11:"DES_ENCRYPT";i:7;s:7:"ENCRYPT";i:8;s:3:"HEX";i:9;s:9:"INET_NTOA";i:10;s:5:"LOWER";i:11;s:3:"MD5";i:12;s:12:"OLD_PASSWORD";i:13;s:8:"PASSWORD";i:14;s:7:"REVERSE";i:15;s:4:"SHA1";i:16;s:7:"SOUNDEX";i:17;s:5:"SPACE";i:18;s:10:"UNCOMPRESS";i:19;s:5:"UNHEX";i:20;s:5:"UPPER";i:21;s:4:"USER";i:22;s:4:"UUID";}s:9:"FUNC_DATE";a:12:{i:0;s:7:"CURDATE";i:1;s:7:"CURTIME";i:2;s:4:"DATE";i:3;s:9:"FROM_DAYS";i:4;s:13:"FROM_UNIXTIME";i:5;s:3:"NOW";i:6;s:11:"SEC_TO_TIME";i:7;s:9:"TIMESTAMP";i:8;s:8:"UTC_DATE";i:9;s:8:"UTC_TIME";i:10;s:13:"UTC_TIMESTAMP";i:11;s:4:"YEAR";}s:11:"FUNC_NUMBER";a:34:{i:0;s:3:"ABS";i:1;s:4:"ACOS";i:2;s:5:"ASCII";i:3;s:4:"ASIN";i:4;s:4:"ATAN";i:5;s:10:"BIT_LENGTH";i:6;s:9:"BIT_COUNT";i:7;s:7:"CEILING";i:8;s:11:"CHAR_LENGTH";i:9;s:3:"COS";i:10;s:3:"COT";i:11;s:5:"CRC32";i:12;s:7:"DEGREES";i:13;s:3:"EXP";i:14;s:5:"FLOOR";i:15;s:9:"INET_ATON";i:16;s:6:"LENGTH";i:17;s:2:"LN";i:18;s:3:"LOG";i:19;s:4:"LOG2";i:20;s:5:"LOG10";i:21;s:3:"OCT";i:22;s:3:"ORD";i:23;s:7:"RADIANS";i:24;s:4:"RAND";i:25;s:5:"ROUND";i:26;s:4:"SQRT";i:27;s:10:"STDDEV_POP";i:28;s:11:"STDDEV_SAMP";i:29;s:3:"TAN";i:30;s:11:"TIME_TO_SEC";i:31;s:14:"UNIX_TIMESTAMP";i:32;s:7:"VAR_POP";i:33;s:8:"VAR_SAMP";}s:12:"FUNC_SPATIAL";a:16:{i:0;s:12:"GeomFromText";i:1;s:11:"GeomFromWKB";i:2;s:16:"GeomCollFromText";i:3;s:12:"LineFromText";i:4;s:13:"MLineFromText";i:5;s:13:"PointFromText";i:6;s:14:"MPointFromText";i:7;s:12:"PolyFromText";i:8;s:13:"MPolyFromText";i:9;s:15:"GeomCollFromWKB";i:10;s:11:"LineFromWKB";i:11;s:12:"MLineFromWKB";i:12;s:12:"PointFromWKB";i:13;s:13:"MPointFromWKB";i:14;s:11:"PolyFromWKB";i:15;s:12:"MPolyFromWKB";}}s:16:"DefaultFunctions";a:5:{s:9:"FUNC_CHAR";s:0:"";s:9:"FUNC_DATE";s:0:"";s:11:"FUNC_NUMBER";s:0:"";s:15:"first_timestamp";s:3:"NOW";s:9:"pk_char36";s:4:"UUID";}s:12:"NumOperators";a:8:{i:0;s:1:"=";i:1;s:1:">";i:2;s:2:">=";i:3;s:1:"<";i:4;s:2:"<=";i:5;s:2:"!=";i:6;s:4:"LIKE";i:7;s:8:"NOT LIKE";}s:13:"TextOperators";a:9:{i:0;s:4:"LIKE";i:1;s:10:"LIKE %...%";i:2;s:8:"NOT LIKE";i:3;s:1:"=";i:4;s:2:"!=";i:5;s:6:"REGEXP";i:6;s:10:"NOT REGEXP";i:7;s:4:"= ''";i:8;s:5:"!= ''";}s:13:"EnumOperators";a:2:{i:0;s:1:"=";i:1;s:2:"!=";}s:12:"SetOperators";a:2:{i:0;s:2:"IN";i:1;s:6:"NOT IN";}s:13:"NullOperators";a:2:{i:0;s:7:"IS NULL";i:1;s:11:"IS NOT NULL";}s:14:"UnaryOperators";a:4:{s:7:"IS NULL";i:1;s:11:"IS NOT NULL";i:1;s:4:"= ''";i:1;s:5:"!= ''";i:1;}s:8:"fontsize";s:3:"82%";s:7:"Servers";a:1:{i:1;a:9:{s:7:"verbose";s:0:"";s:4:"host";s:9:"localhost";s:4:"port";s:0:"";s:6:"socket";s:4:"3306";s:12:"connect_type";s:3:"tcp";s:9:"extension";s:5:"mysql";s:9:"auth_type";s:6:"cookie";s:4:"user";s:4:"root";s:8:"password";s:4:"5954";}}s:14:"PMA_IS_WINDOWS";i:1;s:20:"collation_connection";s:15:"utf8_general_ci";s:11:"PMA_VERSION";s:7:"3.2.2.1";s:17:"PMA_THEME_VERSION";i:2;s:20:"PMA_THEME_GENERATION";i:2;s:19:"PMA_PHP_INT_VERSION";i:50211;s:19:"PMA_PHP_STR_VERSION";s:6:"5.2.11";s:10:"PMA_IS_IIS";i:0;s:10:"PMA_IS_GD2";i:0;s:10:"PMA_USR_OS";s:3:"Win";s:19:"PMA_USR_BROWSER_VER";s:3:"1.9";s:21:"PMA_USR_BROWSER_AGENT";s:5:"GECKO";s:13:"enable_upload";b:1;s:15:"max_upload_size";i:2097152;s:8:"is_https";b:0;s:12:"theme-update";s:8:"original";}s:6:"source";s:16:"./config.inc.php";s:12:"source_mtime";i:1256219387;s:20:"default_source_mtime";i:1255384882;s:9:"set_mtime";i:1256221359;s:17:"error_config_file";b:0;s:25:"error_config_default_file";b:0;s:13:"error_pma_uri";b:0;s:4:"done";b:0;}PMA_Theme_Manager|O:17:"PMA_Theme_Manager":7:{s:12:"_themes_path";s:8:"./themes";s:6:"themes";a:2:{s:15:"darkblue_orange";O:9:"PMA_Theme":8:{s:7:"version";s:3:"2.9";s:4:"name";s:15:"Darkblue/orange";s:2:"id";s:15:"darkblue_orange";s:4:"path";s:24:"./themes/darkblue_orange";s:8:"img_path";s:29:"./themes/darkblue_orange/img/";s:5:"types";a:3:{i:0;s:4:"left";i:1;s:5:"right";i:2;s:5:"print";}s:10:"mtime_info";i:1255384882;s:13:"filesize_info";i:285;}s:8:"original";O:9:"PMA_Theme":8:{s:7:"version";s:3:"2.9";s:4:"name";s:8:"Original";s:2:"id";s:8:"original";s:4:"path";s:17:"./themes/original";s:8:"img_path";s:22:"./themes/original/img/";s:5:"types";a:3:{i:0;s:4:"left";i:1;s:5:"right";i:2;s:5:"print";}s:10:"mtime_info";i:1255384882;s:13:"filesize_info";i:271;}}s:11:"cookie_name";s:9:"pma_theme";s:10:"per_server";b:0;s:12:"active_theme";s:8:"original";s:5:"theme";r:658;s:13:"theme_default";s:8:"original";}PMA_Theme|r:658;SWEKEY|a:1:{s:7:"ENABLED";b:0;}errors|a:1:{s:32:"130f0437a1a5df3454b20bc46495bff2";O:9:"PMA_Error":11:{s:8:"

Daniel0 · October 22, 2009

So, does it still fail or does it work now?

mraza · October 22, 2009

no still blank page

Daniel0 · October 22, 2009

Does sessions work for other pages?

mraza · October 22, 2009

ok this time i get this error in apache error log:

zend_mm_heap corrupted
[Thu Oct 22 17:35:10 2009] [notice] Parent: child process exited with status 1 -- Restarting.
[Thu Oct 22 17:35:10 2009] [notice] Apache/2.2.14 (Win32) PHP/5.2.11 configured -- resuming normal operations
[Thu Oct 22 17:35:10 2009] [notice] Server built: Sep 28 2009 22:41:08
[Thu Oct 22 17:35:11 2009] [notice] Parent: Created child process 5576
[Thu Oct 22 17:35:11 2009] [notice] Child 5576: Child process is running
[Thu Oct 22 17:35:11 2009] [notice] Child 5576: Acquired the start mutex.
[Thu Oct 22 17:35:11 2009] [notice] Child 5576: Starting 64 worker threads.
[Thu Oct 22 17:35:11 2009] [notice] Child 5576: Starting thread to listen on port 80.

Daniel0 · October 22, 2009

Right, these things are irrelevant. Try checking if sessions work for other things than phpmyadmin. In that way we'll know if it's a problem with your PHP setup, or if it's a problem specifically with phpmyadmin.

mraza · October 22, 2009

now when i checked by opening other files of php, i see its creating other file in session path

title|s:3:"Mr.";name|s:5:"fasdf";lname|s:4:"asdf";insurance|s:4:"asdf";postal|s:4:"asdf";address|s:4:"asdf";phone|s:4:"asdf";email|s:4:"asdf";city|s:8:"Basildon";date|s:10:"17/11/2009";registration|s:3:"sdf";comments|s:4:"asdf";

mraza · October 23, 2009

bump

Sign In

2003 - Can't connect to MySQL server on 'localhost' (10061)

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information