Welcome, Guest Login

Support Center

No Connection to User DB...Access denied for user

Last Updated: Jan 02, 2015 01:57PM 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…Access denied for user..."

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]Access denied for user:" and then a name, "@" and then usually the workstation name or IP address.

Unless the error includes "Access denied for user", then this is article does not apply to the issue you are experiencing.  Continuing with the solutions on this page when it is not this issue can make the problem more difficult to resolve.

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

Causes
 
MySQL user was not created

MySQL has its own user/password system independent of Windows or anything else.  This error means that the MySQL login the program is trying to use either doesn't exist or does not have access to the program's database.

The most common cause is that the MySQL user was not created by the program's Server Setup.

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

Using different MySQL login

For some reason the workstations were configured to use a different MySQL login than what was actually created on the server.

This can happen if a different computer has been set up as the server.  A specialized configuration was used initially, but the new server is using the default MySQL user.

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

A+/Anywhere Learning Systems

The server is also hosting a database for A+/Anywhere Learning Systems.  This program uses a non-standard MySQL installation that prevents the Server Setup from creating the need MySQL login. 

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

Resolution

MySQL user was not created

If MySQL is already installed when the server setup is run, the setup will ask for the "root" password for MySQL.  If MySQL was installed by MindPlay, there is no password for this account.  If a password was entered (such as the password for the user account being used for the installation), the intended MySQL login for the program will not be created.

Note:  If MySQL was installed by another product first, a password on the root account may have been set.  Without knowing that password, the server installer cannot do what it needs to do.

To fix this situation after the server setup has been completed, there is a utility on the Setup CD that can be run:

1. Insert the program's Setup CD.
2. If setup comes up, click on Cancel and then Exit Setup.
3. Open My Computer.
4. Right-click on the CD drive that contains the Setup CD and select "Open" from the menu that appears.
5. Double-click on the Installs folder.
6. Double-click on the Utility folder.
7. In there, double-click on "MySQLSecure".
8. On the Welcome screen, click on Next.
9. The next screen asks for the MySQL root password.  Enter in the MySQL root password click on Next.  (If unsure, leave the password box blank.)
10. The next screen contains the MySQL login information.  Just click on Next.
11. On the next screen, click on Next.  The MySQL login will be created.
12. Click on Finish.

At this point, try running the program on workstation again.

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

Using different MySQL login

The easiest way to fix the problem is to create the MySQL user the workstations are trying to use at the server.  This should fix all the workstations instantly.  The alternative is to reconfigure each workstation be hand.

To create the desired MySQL user, you first need to know the MySQL login the workstations are trying to use.  To get that information, go through the following steps:

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. Make sure the "Encrypt Login information" is not checked.
11. Click on the Next button.
12. Click on the Finish button.

Go back up a directory to the "MRC" directory.  In there is the file "PhonxG"; double-click on that file.

In the Notepad window that comes up look for "[PROVIDER]".  Under that is a line that starts with "Path=".  What appears between "UID=" and the semi-colon is the MySQL username.  What appears between "PWD=" and the semi-colon is the MySQL password.

Write down the MySQL username and password.

The next step needs to be done at the server hosting the database.

1. Log in to the server as a power user or administrator.
2. Insert the program's Setup CD.
3. If setup comes up, click on Cancel and then Exit Setup.
4. Open My Computer.
5. Right-click on the CD drive that contains the Setup CD and select "Open" from the menu that appears.
6. Double-click on the Installs folder.
7. Double-click on the Utility folder.
8. In there, double-click on "MySQLSecure".
9. On the Welcome screen, click on Next.
10. The next screen asks for the MySQL root password.  Enter in the MySQL root password click on Next.  (If unsure, leave the password box blank.)
11. The next screen contains the MySQL login information.  Enter in the username and password you obtained from the workstation.  (You will need to enter the password twice.)
12. On the next screen, click on Next.  The MySQL login will be created.
13. Click on Finish.

At this point, try running the program on workstation again.

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

A+/Anywhere Learning Systems

First, you will need to check the ALS documentation or contact AEC (American Education Corporation), developer of A+, to obtain a MySQL login that will work with other programs (i.e. the administrative login).

Second, to make sure any future installs work, the server configuration file needs to be updated.  To do this, go through the following steps.

1. Log into the server hosting the program database with an Administrator-level login.
2. Insert the program's Setup CD.
3. If setup comes up, click on Cancel and then Exit Setup.
4. Open My Computer.
5. Right-click on the CD drive that contains the Setup CD and select "Open" from the menu that appears.
6. Double-click on the Installs folder.
7. Double-click on the Utility folder.
8. In there, double-click on "MySQLSecure".
9. On the Welcome screen, click on Next.
10. The next screen asks for the MySQL root password.  Just click on Next.
11. The next screen contains the MySQL login information.  Enter in the username and password you obtained from AEC.  (You will need to enter the password twice.)
12. On the next screen, click on Next.  The MySQL login will be created.
13. Click on Finish.

Note:  This will not affect A+ or MySQL.  All this will do is make any new My Reading Coach installs use the desired MySQL login.

Third, if My Reading Coach has already been installed on any workstations, these need to be reconfigured to use the MySQL login from AEC.  This can be done by following the steps below.

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 "User Id" to the username given by AEC.
11. In both password boxes, enter in the password given by AEC.
12. Click on the Next button.
13. Click on the Finish button.
14. Try running My Reading Coach.

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