Can't connect Mysql server installed with Plesk

[glazok]

Hello !

Please help with issue.
Have a virtual dedicated windows server on Godaddy.com with Plesk Panel installed.

Can't connect MySQL server via Plesk panel using instructions given by hosting provider.

The first one:
To Connect to MySQL
Log in as "admin" on your Plesk account.
From Server>Database, select MySQL.
Add the following details:
Server name- localhost : 8306
Administrator's login- admin
Administrator's password- Plesk password
Click OK.

This not work and got a message: "access denied for user admin@localhost"

The second instruction:
Log in to your Windows server using Remote Desktop Connection.
From the Start menu, click Run....
Type cmd and press Enter.
Type the following, where "p" is your Plesk password, and then press Enter:
mysql -u admin -p
Type your Plesk password and press Enter.
Type the following, and then press Enter:
use psa;
Type the following, and then press Enter:
Select * from misc where param = 'mssql_admin_login' OR param ='mssql_admin_passwd';

This also not work - when typing "mysql -u admin -p" with Plesk passworg also got a message "access denied for user admin@localhost"

Suggest please how to proper connect to MySQL instaled with Plesk.
Which logon name and password houl be used and how to retrieve logon data.

Big Thanks for any help!

 

[henry@]

... switch to a different hosting provider. Lots of people have issues with godaddy.

 

[blitzzzz]

I have a virtual dedicated windows server on Godaddy.com with Plesk Panel installed as well. == We need to help each other out here. Can't beat the price.



I have not tried to get MySql working yet, but it's a must... I'll be tring to get it running in the next day or two.. I'll let you know how it goes.


PS: from what I have learned so far - THe godaddy Docs are BS. they don't help at all. Infact they steer you in the wrong direction.

 

[blitzzzz]

Note: "localhost" does not equal your IP by default with godaddy "virtual" hosting and Plesk. I had to change my host file so that localhost poits to my IP. I don't know but that might be an issue??

i'll let you know if mine works, when i get to it. very very soon.

 

[glazok]

MySql connection

Thinking it's a good idea to switch from godaddy because their technical support terrible. Howevwe I paid them for hosting in advance or half year and funds non refundable .

Finally after unadequated replies from godaddy's support I found the solution myself. To enable Mysql on virtual dedicates server installed with plesk 8.1.0 i did followed:

First of all get and install updated file as described on
http://kb.swsoft.com/article_0_1630_en.html

Then

1) Connect server via remote desktop.
2) In Administration-Services stop and disable the service called "Plesk MySql server"
3) Enable the service "MySql server" (not Plesk!)
4) Now finish your remote desktop session and connect server via Plesk Panel
5) At Plesk panel go Server-Services and manually start "MySql Server" lister there.
5) Now at plesk Panel go Services -> SQL Servers -> MySql Server, and connect using Your Plesk panel login and password. Don't forget to change connection port from 3306 to 8306!
6) After successful connection You'll then able to run Web Administration (pHP Admin) from the same Plesk panel page.

That's all, after that steps Mysql connection and web administration working fine.

Would like also to add here, that no valuable support in this case was provided by godaddy's support. There are their typicall replies:

"Thank you for contacting Online Support.
Unfortunately, since you are on a virtual dedicated server that does not have assisted server support, issues with connecting to a database within the virtual server do not fall within the scope of what we can support. I apologize for any inconvenience this may cause you.
Please let us know if we can help any other way.
"

"
...quickest resolution to this issue will be to reprovision the server. Please note, reprovisioning the server will result in the loss of all content, configurations and applications currently on the server. You will need to backup your content,...
"

and so on.

When this support will continue the same way, I'll in furhter to change hosting provider.

Can You sugget good hosting with dedicated or virual dedicated server?

My Bests!

 

[glazok]

Originally posted by blitzzzz
I have a virtual dedicated windows server on Godaddy.com with Plesk Panel installed as well. == We need to help each other out here. Can't beat the price.



I have not tried to get MySql working yet, but it's a must... I'll be tring to get it running in the next day or two.. I'll let you know how it goes.


PS: from what I have learned so far - THe godaddy Docs are BS. they don't help at all. Infact they steer you in the wrong direction.

Have u also godaddy hosting?

I tried to change "localhost" to IP address - useless. That not worked at any untill i did steps described in previous post.
After these steps done, connection working fine with "localhost".

And yet one moment. After I tried to restore a MySql database moved to godaddy from another server, to enable db connect the "host-name" in db configuration file must be changed from "mysgl" to "localhost:8306".
Until I did such chages, connection did't worked.

 

[blitzzzz]

ya on Godaddy too. Yea support does not help with much of anything.

thanks for posting the steps!

will make my life easier!

 

[blitzzzz]

glazok thank you agian for your post. what a pain. You saved me hours - I'm connected (was not easy). Thanks alot!

However have you tried to "reconfigure the MySql install?

I had no luck with that.
and don't kwon if i'm even going to try after the hastle getting connected in the first place.

 

[glazok]

Glad to help You!

Indeed that's only place were we can get help with godaddy hosting.

Yes, I also tried to reconfigure MySql installation - useless.