error: unable to connect to any specified mysql hosts

For users or potential users.
Post Reply
RotKT
Posts: 6
Joined: Wed Jan 21, 2009 10:01 pm

error: unable to connect to any specified mysql hosts

Post by RotKT » Tue Mar 24, 2009 12:51 pm

i tried to install open dental 4.8 as new server, everything went smoothly until i try to run the program; error: unable to connect to any specified mysql hosts
mysql service has been started
i completely disable all firewalls

another error: Image




plz help.
thanks
Last edited by RotKT on Tue Mar 24, 2009 1:17 pm, edited 1 time in total.

User avatar
Debbie OD Support
Posts: 70
Joined: Thu Feb 26, 2009 9:11 am
Location: Salem, OR
Contact:

Re: error: unable to connect to any specified mysql hosts

Post by Debbie OD Support » Tue Mar 24, 2009 1:13 pm

Have you tried to actually Stop and then Start the Mysql service? Sometimes when you first install is says that it is started but it did not really start. Can you try that?
Debbie
Open Dental Support
971-239-1150
service@opendent.com

RotKT
Posts: 6
Joined: Wed Jan 21, 2009 10:01 pm

Re: error: unable to connect to any specified mysql hosts

Post by RotKT » Tue Mar 24, 2009 1:21 pm

now when i tried to re-install it, i got this error (pic attached in the 1st post)
and i've tried to stop then start the mysql service but didnt help.
thanks

User avatar
Debbie OD Support
Posts: 70
Joined: Thu Feb 26, 2009 9:11 am
Location: Salem, OR
Contact:

Re: error: unable to connect to any specified mysql hosts

Post by Debbie OD Support » Wed Mar 25, 2009 7:18 am

So you are trying to install Open Dental and Mysql on the H: drive? Usually we do not recommend installing on a different drive other than C: because you will run into problems. The Open Dental program and the Mysql program do not take up that much space so I would keep them on the C: drive but you can put the OpenDentImages and Data folder on the H: drive that is what is going to eventually take space. So what you need to do is:

In the installer window you pick New Server then the only thing you change is the OpenDentImages and the opendental Database to the H: drive.

Then you install it.

After that you need to go to your C:\Program Files\Mysql\Mysql Server 5.0 and in there is a my.ini open that in notepad

Then you just change the datadir="C:/mysql/data/" from C: to H: and save it.

Then when you open up Open Dental after you choose your database you want to use it is going to ask for the Data Path. That is where you select the OpenDentImages that is on your H:

It could be a lot of other things too. Why are you trying to install 4.8? Do you have the full version? If so you should probably call us so we can take a look at your computer.

Also is the H: drive a removable drive? If so, it might be changing drive letter names when you take it off and put it back on your computer.
Debbie
Open Dental Support
971-239-1150
service@opendent.com

RotKT
Posts: 6
Joined: Wed Jan 21, 2009 10:01 pm

Re: error: unable to connect to any specified mysql hosts

Post by RotKT » Wed Mar 25, 2009 12:25 pm

no, H was the DVD-ROM drive where the opendental disc was in.

User avatar
Debbie OD Support
Posts: 70
Joined: Thu Feb 26, 2009 9:11 am
Location: Salem, OR
Contact:

Re: error: unable to connect to any specified mysql hosts

Post by Debbie OD Support » Wed Mar 25, 2009 12:40 pm

It would probably be best if you call us and we can take a look at your computer.
Debbie
Open Dental Support
971-239-1150
service@opendent.com

Post Reply