Reply to thread

Message

<blockquote data-quote="doveman" data-source="post: 971548" data-attributes="member: 67412">I created a new Server Instance on localhost port 3307. It couldn't connect on localhost, 127.0.0.1 or 192.168.1.64 but it said it might be because the server wasn't running so I continued through to the end of the creation. It defaulted to use my.ini but that's set to use port 3306 so I copied it to my2.ini and changed the port in it to 3307. I also changed the data folder to data2 so that it didn't use the same one as the first instance.&nbsp;So then I have two instances in the SQL Development column, the original one on port 3306 and the new one on port 3307. Comodo Firewall doesn't show anything listening on either port but netstat -an shows 3306 open, so probably Comodo just doesn't show local/internal connections. If I try to connect to the second instance on 3307 via &quot;Open connection to start querying&quot; or &quot;Manage Connections&quot; - Test Connection it says Can't Connect.&nbsp; Maybe I need to restart mysql before the second instance will work.&nbsp; However now I can connect to the original instance on 3306 via either method so I don't know why that's suddenly started working. It still just closes the window when I enter MediaPortal as the password in the Start Menu commandline shortcut though, which is weird.&nbsp;Anyway, now I can connect I'll try doing what jameson_uk suggested.</blockquote>

[QUOTE="doveman, post: 971548, member: 67412"] I created a new Server Instance on localhost port 3307. It couldn't connect on localhost, 127.0.0.1 or 192.168.1.64 but it said it might be because the server wasn't running so I continued through to the end of the creation. It defaulted to use my.ini but that's set to use port 3306 so I copied it to my2.ini and changed the port in it to 3307. I also changed the data folder to data2 so that it didn't use the same one as the first instance. So then I have two instances in the SQL Development column, the original one on port 3306 and the new one on port 3307. Comodo Firewall doesn't show anything listening on either port but netstat -an shows 3306 open, so probably Comodo just doesn't show local/internal connections. If I try to connect to the second instance on 3307 via "Open connection to start querying" or "Manage Connections" - Test Connection it says Can't Connect. Maybe I need to restart mysql before the second instance will work. However now I can connect to the original instance on 3306 via either method so I don't know why that's suddenly started working. It still just closes the window when I enter MediaPortal as the password in the Start Menu commandline shortcut though, which is weird. Anyway, now I can connect I'll try doing what jameson_uk suggested. [/QUOTE]

Verification