Mysql Error Code 10048
Read Home Forum vBulletin Legacy Versions & Products Legacy vBulletin Versions vBulletin 3.6 Questions, Problems and Troubleshooting Join us on Facebook, Twitter and YouTube. This section is an archive with no posting allowed. The software represented in this forum is no longer supported or updated. If you need help upgrading to a newer version of vBulletin please open a support ticket. You can also post in the section supporting the upgrade version you're planning to use. We are sorry for any inconvenience this may cause. Welcome to the vBulletin support forums! In the forums you can receive professional support and assistance with any issues you might have with your vBulletin Products. If you are having problems posting in the relevant areas for your software, please see this topic. Announcement Collapse No announcement yet. Can't connect to MySQL server on 'localhost' (10048) Collapse X Collapse Posts Latest Activity Search Page of 1 Filter Time All Time Today Last Week Last Month Show All Discussions only Photos only Videos only Links only Polls only Filtered by: Clear All new posts Previous Next dfe Member Join Date: Sep 2006 Posts: 55 #1 Can't connect to MySQL server on 'localhost' (10048) Thu 23rd Nov '06, 7:57pm Hi I am getting these errors on the forum, but on the same server I am running MS SQL with over 100 sites connecting to it without a problem. Is there anything I can check? Database error in vBulletin: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10048) ....\forum\includes\class_core.php on line 273 MySQL Error : Error Number : Date : Friday, November 24th 2006 @ 06:43:12 AM Script : http://www.4x4community.co.za/forum/search.php?searchid=16894 Referrer : http://www.4x4community.co.za/forum/showthread.php?t=6673 IP Address : 000 Username : Classname : v
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Having Issues with Mysql error 10048 Want to Advertise Here? Solved Having Issues with Mysql error 10048 Posted on 2009-09-18 PHP MySQL Server http://www.vbulletin.com/forum/forum/vbulletin-legacy-versions-products/legacy-vbulletin-versions/vbulletin-3-6-questions-problems-and-troubleshooting/215119-can-t-connect-to-mysql-server-on-localhost-10048 2 Verified Solutions 6 Comments 1,144 Views Last Modified: 2013-12-12 Dear sir, I am having issue with MySQL on two of my dedicated Windows 2003 servers.I am running Voipswitch software(Voip) and Database is mysql Server 5 .The issue I am having is Some times I am not able to connect to mysql.It gives me error"" ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't https://www.experts-exchange.com/questions/24744228/Having-Issues-with-Mysql-error-10048.html connect to MySQL server on 'localhost' (10048)""....some error like this.So the only way for me to make it work is to restart the servers.Issue is I am having this servers for 4 years now and this is the first time i am facin this issues.(since last 15 days)This happens daily and I had to restart and facing lot of calls from my clients.Please help me solve this. Regards, 0 Question by:Sam2009 Facebook Twitter LinkedIn Google LVL 20 Best Solution byGawai ref http://www.cryer.co.uk/brian/mysql/trouble_odbc_cant_connect_on_localhost.htm Go to Solution 6 Comments LVL 20 Overall: Level 20 PHP 12 MySQL Server 5 Message Accepted Solution by:Gawai2009-09-18 ref http://www.cryer.co.uk/brian/mysql/trouble_odbc_cant_connect_on_localhost.htm 0 Message Author Comment by:Sam20092009-09-18 Dear Gawai, I have done two things as I searched through the experts exchange database, 1)Start > Control Panel > Administrative Tools > Data Sources (ODBC). This will open up the "ODBC Data Source Administrator". On the "Connection Pooling" tab, double click the ODBC Driver you are using to connect to MySQL. This will open up the "Set Connection Pooling Attributes" dialog. To enable pooling select "Pool Conne
Reporter: p t Email Updates: Status: Closed Impact on me: None Category:MySQL Server Severity:S1 (Critical) Version:MySql https://bugs.mysql.com/bug.php?id=10498 4.0.24 OS:Microsoft Windows (XP SP2) Assigned to: View Add Comment Files https://blogsandip.wordpress.com/2008/02/19/error-2003-cant-connect-to-mysql-server-on-localhost-10048/ Developer Edit Submission View Progress Log Contributions [10 May 2005 6:33] p t Description: The problem only occurs on Windows XP and 2003, but works fine on Windows 2000. We have tried using MySql Connector .NET 1.0.4, MySqlDriverCS and MYODBC 3.51, but none of them mysql error have resolved the problem. The Problem: The ASP.NET and Windows applications run fine at the start but after a while when too many queries are made it refuses to connect to mysql and MySql connector .NET gives me the following error "Unable to connect to any of the specified MySQL hosts". When this happens, if I mysql error code try to login manually to mysql it says: "ERROR 2003: Can't connect to MySQL server on 'localhost' (10048)". After I leave it idle for a while it goes back to running fine but then crashes again when too much load is put on. Like I said at the start this is only an issue with Win XP and Win 2003, but not Win 2000. How to repeat: If using MySql Connector .NET, try the following code to connect to MySql public DataSet SelectQuery(string sql) { MySqlConnection conn = new MySqlConnection(); DataSet dset1 = new DataSet(); DataTable dtab1 = new DataTable(); MySqlDataAdapter da = new MySqlDataAdapter(); string connStr = "server=localhost;user id= USERNAME; password= PASSWORD; database=DotnetDB; pooling=false"; try { conn = new MySqlConnection(connStr); conn.Open(); da = new MySqlDataAdapter(sql,conn); conn.Close(); da.Fill(dset1); return dset1; } catch (MySqlException ex) { string temp = ex.ToString(); conn.Close(); return null; } } And then set up an infinite loop that calls the above function with a basic sql statement "Select * from DotnetDB" You m
using data connections in large numbers than sooner or later it will stop responding after some time and only way to make it working again is resetting iis service. Asp.Net is using Ephemeral Ports to connect MySql via ODBC but in Windows 2003 server there is no maximum port value defined in registry (surprisingly on Windows XP it is). So after consuming certain number of ports there are no ports available to connect and finally application crashes. I have resolved this issue by creating MaxUserPort value in registry in following way. This has solved my problem. 1. Click Start, click Run, type regedit.exe, and then click OK. 2. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters 3. On the Edit menu, point to New, and then click DWORD Value. 4. Type MaxUserPort and then press ENTER. 5. Double-click the MaxUserPort value, and then type the maximum value in decimal or hexadecimal. You must type a number in the range of 500065534 (decimal). Setting this parameter to a value outside of the valid range causes the nearest valid value to be used (5000 or 65534). 6. Click OK. 7. Quit Registry Editor. Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Use this solution on your Own risk. Share this:GoogleFacebookTwitterLinkedInPrintRedditEmailLike this:Like Loading... Related Written by Sandip February 19, 2008 at 1:31 pm Posted in Troubleshooting « Carbon Sequestration Edit OpenOffice docs without OpenOfficeinstalled. » 8 Responses Subscribe to comments with RSS. It worked for us also.. Thanks Sandip Venkat March 24, 2008 at 9:50 am Reply I had the same problem and I solved using the component MySQL Connector/NET instead of the usual framework ODBC library. You can take a look here for the documentation http://dev.mysql.com/doc/refman/5.0/en/connector-net.html and download source and binaries here http://dev.mysql.com/downloads/connector/net/1.0.html Abx78 May 21, 2008 at 2:21 pm Reply Thanks this helped me a lot. Muhammad Hasnain September 7, 2008 at 1:49 am Reply it really helped thanx i m using version 5,window xp aditya October 23, 2008 at 3:24 pm Reply You get this error due to the amount of connections you are establishing with the server. I had the same message here, and calculating how many trys I was trying, got something about 900*6! So.. how I fixed it? You can change your script to do just ONE try of connection, BUT if you did as I did, this is someth