I have been trying to install OpenEMR 5.0.1 on a hosted server following the instructions at
I downloaded the OpenEMR 5.0.1 zip file from the Windows section at
and uploaded it to my hosted account and extracted it.
I created a blank database and user with all privileges and used phpmyadmin to change the database collation to “utf8mb4_general_ci”.
When I go through the install steps in my Chrome browser, I selected that “I have already created the database”
I get an error when I do Step 3:
Connecting to MySQL Server… OK.
unable to execute SQL: ‘CREATE TABLE
drug_id int(11) NOT NULL,
selector varchar(255) NOT NULL default ‘’,
dosage varchar(10) default NULL,
period int(11) NOT NULL default ‘0’,
quantity int(11) NOT NULL default ‘0’,
refills int(11) NOT NULL default ‘0’,
taxrates varchar(255) default NULL, PRIMARY KEY (
selector)) ENGINE=InnoDB’ due to: Specified key was too long; max key length is 767 bytes
I get the same error if I in Step 2 I use Server Host = “localhost” or the IP address assigned to my hosted account.
When I go into the database in phpMyAdmin, it looks like 31 tables are created and some of them have rows added.
I contacted my hosting provider and when they attempted to install OpenEMR they also received the same error. They do not see any server side errors and note that it did connect correctly to the database. They suggested that I reach out to see if there are some recommendations for correcting the problem or possible server side changes/adjustments they may need to make.
I am unable to use the option of having the database create the database because I cannot connect to MySQL as root user on this account.
Thank you in advance.