<?xml version="1.0" encoding="UTF-8"?>        <rss version="2.0"
             xmlns:atom="http://www.w3.org/2005/Atom"
             xmlns:dc="http://purl.org/dc/elements/1.1/"
             xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
             xmlns:admin="http://webns.net/mvcb/"
             xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
             xmlns:content="http://purl.org/rss/1.0/modules/content/">
        <channel>
            <title>
									Unable to access MySQL 8.0 - General Questions				            </title>
            <link>https://solidcp.com/forum/question/unable-to-access-mysql-8-0/</link>
            <description>SolidCP Discussion Board</description>
            <language>en-US</language>
            <lastBuildDate>Fri, 16 Oct 2026 11:38:15 +0000</lastBuildDate>
            <generator>wpForo</generator>
            <ttl>60</ttl>
							                    <item>
                        <title>Unable to access MySQL 8.0</title>
                        <link>https://solidcp.com/forum/question/unable-to-access-mysql-8-0/#post-10917</link>
                        <pubDate>Tue, 22 Sep 2026 23:08:08 +0000</pubDate>
                        <description><![CDATA[Hi Folks:  
Installed on my new Windows Server 2022 machine are MySQL 8.0, MySQL Connector/Net 9.7.0, MySQL Workbench 26.7.0, phpMyAdmin 5.2.3, and SolidCP 1.5.1.  Workbench and phpMyAdmin ...]]></description>
                        <content:encoded><![CDATA[<p>Hi Folks:  </p>
<p>Installed on my new Windows Server 2022 machine are MySQL 8.0, MySQL Connector/Net 9.7.0, MySQL Workbench 26.7.0, phpMyAdmin 5.2.3, and SolidCP 1.5.1.  Workbench and phpMyAdmin as well as WordPress for two test sites can access MySQL just fine, but SolidCP cannot.  Also if I go into a customer, Space Statistics, Import Resources, MySQL 8 Database (or User), it shows nothing, which I guess makes sense given the other issue.  In case it makes a difference, I did make two changes to my.ini to make v8 more compatible with the incoming v5.7 databases.  1) For sql-mode=, I removed <em>NO_ZERO_IN_DATE</em> and <em>NO_ZERO_DATE</em>, and 2) under , I entered <em>default-authentication-plugin=mysql_native_password</em>.  </p>
<p>When I try to save server settings for MySQL, even though the settings I've entered do seem to save, I get the error below.  (Please forgive the length; I don't write the code.)  </p>
<blockquote>
<p>Page URL: https://****.*******.com/Default.aspx?pid=Servers&amp;mid=260&amp;ctl=edit_service&amp;ServiceID=6&amp;ServerID=1<br />Logged User: serveradmin<br />Work on Behalf: serveradmin<br />Hosting Space: 0<br />Stack Trace: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---&gt; System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. ---&gt; System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---&gt; System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host<br />at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)<br />--- End of inner exception stack trace ---<br />at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)<br />at System.Net.PooledStream.Read(Byte[] buffer, Int32 offset, Int32 size)<br />at System.Net.Connection.SyncRead(HttpWebRequest request, Boolean userRetrievedStream, Boolean probeRead)<br />--- End of inner exception stack trace ---<br />at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)<br />at Microsoft.Web.Services3.WebServicesClientProtocol.GetResponse(WebRequest request, IAsyncResult result)<br />at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)<br />at SolidCP.Providers.ServiceProvider.Install()<br />at SolidCP.EnterpriseServer.esServers.InstallService(Int32 serviceId)<br />--- End of inner exception stack trace ---<br />at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)<br />at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)<br />at SolidCP.EnterpriseServer.esServers.InstallService(Int32 serviceId)<br />at SolidCP.Portal.ServersEditService.btnUpdate_Click(Object sender, EventArgs e)</p>
</blockquote>
<p>Any help would be most appreciated.  </p>
<p>Thank you!<br />Scott</p>]]></content:encoded>
						                            <category domain="https://solidcp.com/forum/question/">General Questions</category>                        <dc:creator>Scott</dc:creator>
                        <guid isPermaLink="true">https://solidcp.com/forum/question/unable-to-access-mysql-8-0/#post-10917</guid>
                    </item>
							        </channel>
        </rss>
		