Welcome, Guest Login

Support Center

No Connection to User DB...Can't connect to MySQL Server

Last Updated: Jan 02, 2015 01:58PM MST
Notice: 
My Reading Coach (MRC) is a server based program that was launched in 1998 and will have its life cycle ended in 2015. MindPlay has discontinued selling MRC and Technical support for MRC will end December 31, 2015.  You may continue to use the MRC product, but technical support, lost disks, reimaged computers, lost licenses, etc. will no longer be supported.  For information about the new cloud-based version, MindPlay Virtual Reading Coach (MVRC), launched in 2012, is available at www.mindplay.com .  Thank you.

"No connection to user DB...Can't connect to MySQL server..."

Applicable Versions and Operating Systems 

This Article applies to the following Program Versions and Operating Systems:

Versions
My Reading Coach Platinum (1.x, 2.x)
My Reading Coach Gold (1.x, 2.x, 3.x)
RAPS (1.0, 3.x)
Operating Systems
Windows Millennium, Windows 2000, Windows XP, Windows Vista, Windows 7

--------------------------------------------------------------------------------

Symptoms
 
When the program launches, instead of asking to select the class or school, a message comes up saying "No connection to User DB.  [MySQL][ODBC 3.51 driver] Can't connect to MySQL server on '(server name or IP address)' (10060)".

Unless the error includes "Can't connection to MySQL server", then this is article does not apply to the issue you are experiencing.  Please check for other articles that contain the error you are getting.

--------------------------------------------------------------------------------

Causes
 
Network connectivity issues

This error means that the program was unable to connect to the MySQL service running on the specified computer.

The first thing to check is that the workstations that have the program can connect to the server; especially if the program was working before.

--------------------------------------------------------------------------------

MySQL service not running

The workstation may be able to connect to the server, but the MySQL service is not running on the server.

--------------------------------------------------------------------------------

Firewall enabled

If using a workstation as a server or Windows Server 2008, the Windows Firewall (or a third-party anti-virus) may be preventing the database from being accessed.

--------------------------------------------------------------------------------

Name resolution issues

Another potential cause is that the program has been configured to find the server by its name and that is not working as it should.

This is commonly seen when using a workstation as a server.
 
--------------------------------------------------------------------------------

Resolution
 
Network connectivity issues

If the workstations have Internet access, the first thing to try is to pull up a website in a web browser.  If you are unable to access websites from a workstation that should have Internet access, then there is likely a network issue that needs to be resolved.  Once that has been resolved, try running the program again.

If you can access websites, continue through the list of other causes.

--------------------------------------------------------------------------------

MySQL service not running

If the MySQL service isn't running, then My Reading Coach will not be able to access the database.

To make sure the service is running, go through the following steps (assuming the server is running a Windows operating system).

1. Log into the server with an Administrator-level login.
2. Go to Start and select Control Panel.
3. Double-click on Administrative Tools.
4. Double-click on Services.
5. Scroll down the list of services until you see "MySql"

Under "Status", it should say started.  If it doesn't, right-click on "MySql" and click on "Start" in the menu that appears.

--------------------------------------------------------------------------------

Firewall enabled

If using a third-party anti-virus or firewall program, you will need consult that program's documentation on how to allow incoming connections on TCP port 3306.

For Windows Firewall, an exception can be made to allow the workstations to connect to the MySQL service running on the server.

If using Windows Server 2008:

1. Log in to the server with an administrator-level account.
2. Go to Start--Administrative Tools--Windows Firewall.
3. Click on Inbound Rules on the left.
4. Click on the New Rule link on the right.
5. Select "Port" from the list of types and click on Next.
6. Leave TCP selected.
7. In Specific local ports, enter in 3306
8. Click on Next.
9. Leave "Allow the connection" selected and click on Next.
10. Leave all the checkboxes selected and click on Next.
11. For Name, enter in MySQL
12. Click on Finish.
13. Try connecting from a workstation again.

If using a Windows XP workstation as the "server":

1. Log in to Windows with an administrator-level user.
2. Go to Start and select Control Panel.
3. Click on Security Center.
4. Click on Windows Firewall.
5. Click on the Exceptions tab.
6. Click on Add Port...
7. For Name, enter in MySQL
8. For Port number, enter in 3306
9. Leave TCP selected.
10. Click on OK.
11. Click on OK again.
12. Try connecting from a workstation again.

If using a Windows Vista workstation as the "server":

1. Log in to Windows with an administrator-level user.
2. Go to Start and select Control Panel.
3. Under Security, click on "Allow a program through Windows Firewall".
4. If asked if you want to perform the action, click on Continue.
5. In the window that comes up, click on Add Port...
6. For Name, enter in MySQL
7. For Port number, enter in 3306
8. Leave TCP selected.
9. Click on OK.
10. Try connecting from a workstation again.

--------------------------------------------------------------------------------

Name resolution issues

It's strongly recommended that the program be configured to connect to the server by the server's IP address if at all possible.  If the program is configured to find the server by name, it has to go through a process that converts that name to the server's IP address.  This is not always reliable and can result in the "Can't connect to MySQL server" error.

To make sure this is working correctly, go through the following steps:

1. Go to Start, select (All) Programs, select Accessories and click on Command Prompt.
2. In the box that comes up, type in ping <server name>  where <server name> is the name of the server.

If it comes back with the response that it cannot find the host, then either name resolution is not working or the server hosting the database is not accessible.

If you know the server's IP address, try pinging that.  If that does not get a response, then there is likely some network issue where the server is not accessible from that workstation.  If there is a response, then name resolution is not working—so that the server's name is not getting translated to its IP address.

If the server has a static IP address, it is recommended that the workstation(s) be reconfigured to use this IP address instead of the server name.  This can be done with a utility installed on the workstation.

Note:  If the machine hosting the My Reading Coach database is actually using DHCP or other dynamically assigned IP address, do not follow the steps below.  Doing so will result in the error reoccurring when the computer's IP address changes.

1. Log in to the workstation as a power user or administrator.
2. Open My Computer.
3. Double-click on the C: drive.
4. Double-click on Program Files.
5. Double-click on Mindplay.
6. Double-click on MRC.
7. Double-click on DBUtil.
8. Double-click on "MRC INI Editor".
9. Click on the Next button.
10. Change the "Server name/IP address" box to the IP address of the server.
11. Click on the Next button.
12. Click on the Finish button.

Try running the program again.  If it works, repeat the above steps on any other workstations where the program is installed.

Contact Us

  •  
  • Call Us Toll-free @ 800-221-7911
support@mindplay.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete