delickate Posted October 9, 2011 Share Posted October 9, 2011 Hi, I just install vetrigo. its apache server running fine. but when i tried to connect phpmyadmin it gives following error #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) please help.... it didn't change its default setting. thanks Quote Link to comment Share on other sites More sharing options...
awjudd Posted October 9, 2011 Share Posted October 9, 2011 If your mysql server running? ~juddster Quote Link to comment Share on other sites More sharing options...
delickate Posted October 9, 2011 Author Share Posted October 9, 2011 Thanks for the reply, Yes, mysql server is running. and vertrigo is passing green signal. not sure why i'm unable to run phpmyadmin. Please guide. Thanks Quote Link to comment Share on other sites More sharing options...
awjudd Posted October 9, 2011 Share Posted October 9, 2011 Has the server's port changed? http://veerasundar.com/blog/2009/01/how-to-change-the-root-password-for-mysql-in-xampp/ ~juddster Quote Link to comment Share on other sites More sharing options...
delickate Posted October 9, 2011 Author Share Posted October 9, 2011 Thanks for the link, actually i don't need phpmyadmin password change. i've already changed port from 80 to 90 coz port 80 was busy. phpmyadmin look and feel opens but gives that error. i think it is related to some socket.... can you guide to about socketing setting. Thanks Quote Link to comment Share on other sites More sharing options...
awjudd Posted October 9, 2011 Share Posted October 9, 2011 Sorry for wrong link .. skimmed through it and thought it mentioned the server's port. As for the server's port, is MySQL server running on it's default port or a different one? ~juddster Quote Link to comment Share on other sites More sharing options...
delickate Posted October 9, 2011 Author Share Posted October 9, 2011 it is running on its default port. i didn't change port for mysql. just change the port for apachi. in my prev installation it works but required password. i tried its default user name and password but no luck. so uninstall and reinstall it. now it starts give that error. dont know why............. Quote Link to comment Share on other sites More sharing options...
fenway Posted October 9, 2011 Share Posted October 9, 2011 You need to verify that you actually know how your mysql server is configured, and that those settings match on both sides. Quote Link to comment Share on other sites More sharing options...
delickate Posted October 9, 2011 Author Share Posted October 9, 2011 Thanks for the reply, that is the main point, i don't know the phpmyadmin configuration. if i would know the configuration i'll. would you please guide me how to configure phpmyadmin. Thanks Quote Link to comment Share on other sites More sharing options...
awjudd Posted October 9, 2011 Share Posted October 9, 2011 There should be a configuration file for phpmyadmin somewhere (http://webmaster.iu.edu/tool_guide_info/phpmyadmin/phpmyadmin.shtml). Make sure that is using the correct port for your MySQL server (http://www.coderanch.com/t/298301/JDBC/java/which-port-mySQL-running) ~juddster Quote Link to comment Share on other sites More sharing options...
delickate Posted October 9, 2011 Author Share Posted October 9, 2011 Here is my phpmyadmin config file setting: $cfg['Servers'][$i]['auth_type'] = 'http'; /* Server parameters */ $cfg['Servers'][$i]['host'] = 'localhost';$cfg['Servers'][$i]['port'] = '90'; $cfg['Servers'][$i]['connect_type'] = 'tcp';$cfg['Servers'][$i]['socket'] = '/var/run/mysql/mysql.sock'; $cfg['Servers'][$i]['compress'] = false; /* Select mysqli if your server has it */ $cfg['Servers'][$i]['extension'] = 'mysqli'; /* rajk - for blobstreaming */ $cfg['Servers'][$i]['bs_garbage_threshold'] = 50; $cfg['Servers'][$i]['bs_repository_threshold'] = '32M'; $cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600; $cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M'; /* User for advanced features */ $cfg['Servers'][$i]['controluser'] = 'pma'; $cfg['Servers'][$i]['controlpass'] = 'pmapass'; /* Advanced phpMyAdmin features */ $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $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]['history'] = 'pma_history'; $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; $cfg['Servers'][$i]['tracking'] = 'pma_tracking'; well, i think it sucks... leave. can you tell me any best software package instead of vertrigo, xampp and wamp that can be run easily on window vista or 7. and its setting is easy and simple. Quote Link to comment Share on other sites More sharing options...
awjudd Posted October 9, 2011 Share Posted October 9, 2011 $cfg['Servers'][$i]['port'] = '90'; That should be your MySQL server port not your web server port. ~juddster Quote Link to comment Share on other sites More sharing options...
delickate Posted October 9, 2011 Author Share Posted October 9, 2011 i put both ports to 90. but no luck Quote Link to comment Share on other sites More sharing options...
awjudd Posted October 9, 2011 Share Posted October 9, 2011 Both servers cannot run connected to the same port. Either the server you stopped failed to start up again, or you didn't restart the server after adjusting the configuration. ~juddster Quote Link to comment Share on other sites More sharing options...
delickate Posted October 9, 2011 Author Share Posted October 9, 2011 thanks for the reply, my both servers are working fine.i've restarted a lot of time. it restarted well. just problem with phpmyadmin.... please guide,,, Quote Link to comment Share on other sites More sharing options...
awjudd Posted October 9, 2011 Share Posted October 9, 2011 What port is your MySQL server running on? Is this the port that you tell phpmyadmin? ~juddster Quote Link to comment Share on other sites More sharing options...
fenway Posted October 9, 2011 Share Posted October 9, 2011 thanks for the reply, my both servers are working fine.i've restarted a lot of time. it restarted well. just problem with phpmyadmin.... please guide,,, You're not listening to anyone offering help. Both servers cannot be working fine if they're running on the same port. Quote Link to comment Share on other sites More sharing options...
delickate Posted October 9, 2011 Author Share Posted October 9, 2011 thanks for the reply, sorry my mistake look my phpmyadmin using port 3406, default was 3606 my apache using port 90, default was 80 these port i set manually because this was not working before. after set ports it turns into red. now apche is working fine. but phpmyadmin is not working fine. so please help Quote Link to comment Share on other sites More sharing options...
awjudd Posted October 9, 2011 Share Posted October 9, 2011 Is your mysql server up and running on port 3406? If yes, have you updated the phpmyadmin configuration file accordingly? ~juddster Quote Link to comment Share on other sites More sharing options...
delickate Posted October 9, 2011 Author Share Posted October 9, 2011 no, but just update it and retry but no luck...... Quote Link to comment Share on other sites More sharing options...
awjudd Posted October 9, 2011 Share Posted October 9, 2011 No the server is not up and running, no the server isn't running on port 3406, or no phpmyadmin isn't working? Or no something entirely different? ~juddster Quote Link to comment Share on other sites More sharing options...
delickate Posted October 9, 2011 Author Share Posted October 9, 2011 thanks for reply, vertrigo shows three defferent singal. it turn ito green only when both apche and mysql starts running. if you move mouseover its icon it show on tool tip that mysql +apache is running. is there any other way where can i check is it running or not??? please help Quote Link to comment Share on other sites More sharing options...
fenway Posted October 9, 2011 Share Posted October 9, 2011 I don't what what vertigo is -- nor does it matter. Icons don't mean anything. Tools don't mean anything. Go to the command line, and try to connect to the server. Start the service, and see if it's started. There's nothing simpler than that. Quote Link to comment Share on other sites More sharing options...
delickate Posted October 9, 2011 Author Share Posted October 9, 2011 hi, thanks for the reply. i just tried to check in dos prompt. it shows port 3406 is listing, also for port 90. what does that mean? Quote Link to comment Share on other sites More sharing options...
fenway Posted October 9, 2011 Share Posted October 9, 2011 What's "it"? 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.