Guest Posted February 21, 2007 Share Posted February 21, 2007 I'm tearing my hair out here - I've tried to avoid use of mySQL things like phpmyadmin so far because they just seem so user unfriendly and I haven't got time to be mastering sql.... but the Featured Products contribution requires that I run a file to create a new table in the database. No problems there, I think I could do that... IF I COULD JUST GET PHPMYADMIN TO WORK. Man I hate this stuff. Anyway, sorry for the angst - I'm getting this error message: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)I looked about on the internet - tried changing the hostname to 127.0.0.1 (but I thought that was the local machine?)... tried adding a bit about sockets which you can see below - this is my config file with some bits edited out: <?php/* * Generated configuration file * Generated by: phpMyAdmin 2.10.0-rc1 setup script by Michal ÄŒihaÅ™ <[email protected]> * Version: $Id: setup.php 9697 2006-11-13 08:32:28Z nijel $ * Date: Wed, 21 Feb 2007 10:50:01 GMT */ /* Servers configuration */ $i = 0; /* Server 213.171.***.*** (config:highsports) [1] */ $i++; $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; $cfg['Servers'][$i]['history'] = 'pma_history'; $cfg['Servers'][$i]['host'] = '127.0.0.1'; $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; $cfg['Servers'][$i]['controluser'] = '*****'; $cfg['Servers'][$i]['controlpass'] = '*****'; $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = '*****'; $cfg['Servers'][$i]['password'] = '*****'; $cfg['Servers'][$i]['only_db'] = 'HSsql'; $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['LogoutURL'] = '*****'; $cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock'; /* End of servers configuration */ $cfg['DefaultTabServer'] = 'main.php'; $cfg['DefaultTabDatabase'] = 'db_structure.php'; $cfg['DefaultTabTable'] = 'tbl_structure.php'; $cfg['LightTabs'] = false; $cfg['LeftFrameLight'] = true; $cfg['LeftFrameDBTree'] = true; $cfg['LeftFrameDBSeparator'] = '_'; $cfg['LeftFrameTableSeparator'] = '__'; $cfg['LeftFrameTableLevel'] = 1; $cfg['LeftDisplayLogo'] = true; $cfg['LeftDisplayServers'] = false; $cfg['DisplayServersList'] = false; $cfg['DisplayDatabasesList'] = false; $cfg['LeftPointerEnable'] = true; $cfg['ErrorIconic'] = true; $cfg['MainPageIconic'] = true; $cfg['ReplaceHelpImg'] = true; $cfg['NavigationBarIconic'] = 'both'; $cfg['PropertiesIconic'] = 'both'; $cfg['BrowsePointerEnable'] = true; $cfg['BrowseMarkerEnable'] = true; $cfg['ModifyDeleteAtRight'] = false; $cfg['ModifyDeleteAtLeft'] = true; $cfg['RepeatCells'] = 100; $cfg['DefaultDisplay'] = 'horizontal'; $cfg['TextareaCols'] = 40; $cfg['TextareaRows'] = 7; $cfg['LongtextDoubleTextarea'] = true; $cfg['TextareaAutoSelect'] = true; $cfg['CharEditing'] = 'input'; $cfg['CharTextareaCols'] = 40; $cfg['CharTextareaRows'] = 2; $cfg['CtrlArrowsMoving'] = true; $cfg['DefaultPropDisplay'] = 'horizontal'; $cfg['InsertRows'] = 2; $cfg['EditInWindow'] = true; $cfg['QueryWindowHeight'] = 310; $cfg['QueryWindowWidth'] = 550; $cfg['QueryWindowDefTab'] = 'sql'; $cfg['AllowAnywhereRecoding'] = false; $cfg['DefaultCharset'] = 'iso-8859-1'; $cfg['RecodingEngine'] = 'iconv'; $cfg['IconvExtraParams'] = '//TRANSLIT'; $cfg['GD2Available'] = 'yes'; $cfg['QueryHistoryDB'] = false; $cfg['QueryHistoryMax'] = 25; $cfg['BrowseMIME'] = true; $cfg['PDFDefaultPageSize'] = 'A4'; ?> If anyone could help me out with this I'd really appreciate it, grrrrrr!!!!! Going for lunch at 11am... I feel like that guy in Office Space. Quote Link to comment Share on other sites More sharing options...
Guest Posted February 22, 2007 Share Posted February 22, 2007 No one? Am I not providing enough information or something? Everyone that installed this contribution must have a config file like this..... if you could even just copy and paste yours in I'd appreciate it! Quote Link to comment Share on other sites More sharing options...
Guest Posted February 26, 2007 Share Posted February 26, 2007 Right, well I finally got it working - it's always the simple things. Despite reading what seemed like every post on the internet regarding this error, and trying about 100 different variations of the config file, it seems I was using the wrong username!!!! Typical. Not sure why this would cause the socket error but there you go. In the end I used a simple config file which I'll paste below for anyone that has similar problems to try... (although there seem to be thousands of solutions to this problem out there, good luck with that!). <?php/* * Generated configuration file * Generated by: phpMyAdmin 2.10.0-rc1 setup script by Michal Cihar <[email protected]> * Version: $Id: setup.php 9697 2006-11-13 08:32:28Z nijel $ * Date: Mon, 26 Feb 2007 10:25:30 GMT */ /* Servers configuration */ $i = 0; /* Server MySQL server IP (config:highsports) [1] */ $i++; $cfg['Servers'][$i]['host'] = 'MySQL server IP address here'; $cfg['Servers'][$i]['extension'] = 'mysql'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['compress'] = false; $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'username here'; $cfg['Servers'][$i]['password'] = 'password here'; $cfg['Servers'][$i]['only_db'] = 'HSsql'; /* End of servers configuration */ ?> There was a huge cheer from my little office when it worked... quickly followed by a huge grin when I realised what I'd been doing wrong :blush: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.