OpenEMR 4.1.0, ICD 9, MySQL 5 error #1044

mangaleshjoshi wrote on Tuesday, August 28, 2012:

Hi!

I have locally installed OpenEMR 4.1.0 with XAMPP. Now, I am trying to load ICD 9 codes as per the given instruction by manually inserting database name as well as username and password. But when I try to import ICD 9 codes through PHPMyAdmin, I get the following error:
#1044 - Access denied for user ‘username’@‘localhost’ to database ‘strict’
Can anybody help on this please?
Thanks in advance.

Regards,
Mangalesh :slight_smile:

bradymiller wrote on Wednesday, August 29, 2012:

Hi,

Instructions to do this are here:
http://open-emr.org/wiki/index.php/OpenEMR_Billing_Setup_Howtos#Windows_Instructions

Note importing the ICD9 codes will be much simpler in OpenEMR 4.1.1 (likely gonna get released this weekend):
http://open-emr.org/wiki/index.php/Import_Standard_Tables#Import.2FUpgrade_and_activate_ICD9

-brady
OpenEMR

bradymiller wrote on Wednesday, August 29, 2012:

Hi,
Actually realized you weren’t trying the perl script. What you want to do (for 4.1.0 only) is import the sql/icd9-codes-insert.sql into the database via Administration->Other->Database.
-brady
OpenEMR

mangaleshjoshi wrote on Tuesday, September 04, 2012:

Hi Brady,

It seems I was trying to load the wrong file. Now, problem is solved, and it is working. Thanks a lot for the support.

Best regards,

Mangalesh