Open Dental First Time Installation

For users or potential users.
Post Reply
Jaynez
Posts: 6
Joined: Thu Mar 14, 2013 9:50 am

Open Dental First Time Installation

Post by Jaynez » Thu Mar 14, 2013 9:56 am

Hello, this is my first post on this Forum..
I am trying to use the trial version for first time as you can see in the image.. but don't know why the access is denied,, according to the application, for first enter doesn't require password and the default username is "root"..
Image

isomers
Posts: 2
Joined: Fri Mar 08, 2013 1:45 pm

Re: Open Dental First Time Installation

Post by isomers » Thu Mar 14, 2013 10:42 am

Hello Jaynez,

I believe this error comes up because the Grant Tables location is incorrect or missing from the mysql data path. Open the Open Dental Installer and check the MySQL Server 5.0 grant tables. Then push on install, This should fix the issue.
Ian Somers
Support Tech #136
Open Dental Software
Phone: 503-715-0049
Fax: 503-485-5202
service@opendental.com

User avatar
jsalmon
Posts: 1571
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Open Dental First Time Installation

Post by jsalmon » Thu Mar 14, 2013 10:53 am

My guess is that you didn't uncheck the box that says "Launch the MySQL Instance Configuration Wizard" at the end of the MySQL installer. That wizard makes you create a MySQL root password by default. Running the grant tables like isomers suggested should do the trick or you can be extra sure by uninstalling MySQL from the control panel and then rerun the Open Dental trial installer and click the Update MySQL button and then click install which will start over fresh. If you still get this error after doing one of the suggested solutions you should give us a call and we will most likely be able to get you up and running.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

Jaynez
Posts: 6
Joined: Thu Mar 14, 2013 9:50 am

Re: Open Dental First Time Installation

Post by Jaynez » Thu Mar 14, 2013 11:15 am

isomers wrote:Hello Jaynez,

I believe this error comes up because the Grant Tables location is incorrect or missing from the mysql data path. Open the Open Dental Installer and check the MySQL Server 5.0 grant tables. Then push on install, This should fix the issue.
already did, the box si checked by default

Jaynez
Posts: 6
Joined: Thu Mar 14, 2013 9:50 am

Re: Open Dental First Time Installation

Post by Jaynez » Thu Mar 14, 2013 1:57 pm

Problem solved, it was denied becoz of i didn't install the app with Admin on.. so i needed to rigth click, run as admin for that to work

ylkuek
Posts: 1
Joined: Sun Sep 08, 2013 1:22 am

Re: Open Dental First Time Installation

Post by ylkuek » Sun Sep 08, 2013 8:18 am

having similar error with the trial OD installation.

did what was suggested above but still getting the same error......

User avatar
jsalmon
Posts: 1571
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Open Dental First Time Installation

Post by jsalmon » Sun Sep 08, 2013 6:22 pm

If you actually did the steps above, you should probably give us a call and we can help you install the trial correctly. If you can't wait and want to look at the problem in more detail I would recommend you to the following pages:
http://opendental.com/manual/mysqlsecurity.html - Our internal page which is pretty much a friendlier version of...
http://dev.mysql.com/doc/refman/5.5/en/ ... ement.html - The actual MySQL documentation which is where you can find technical information on why root@localhost does not have permissions to create a connection.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

Post Reply