close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Can't connect to mySQL database

Thread began 10/15/2010 2:21 pm by connie386947 | Last modified 10/15/2010 3:40 pm by Jason Byrnes | 656 views | 3 replies |

connie386947

Can't connect to mySQL database

I successfully uploaded the PowerStore files to my server and began the Installation wizard at cart/

The first step has tripped me up. I have input the host server/database name/username/password, but it highlights the host/username/password in red and tells me to verify them. I am clearly using the wrong something, but what?

Here are the steps and actions I took, along the usernames and passwords.

The domain is "raindroptraining.com" and when asked for the host/server, that is usually what I input. However, as a webdesigner, I have a hosting package that allows me to create multiple websites. The actual host server is server20.mtl.net.equalserver.com

The ip is: 199.204.44.130
I don't think this applies to my problem, but my access to MY HOSTING account WHM administration is <deleted> and the root access pass is <deleted>

HOWEVER!

FOR THIS PARTICULAR WEBSITE where I am trying to install PowerStore
I achieve access to mySQL through raindroptraining.com/cpanel
username:<deleted>
pass: <deleted>

This morning in the <deleted> Admin I created a new database called "cart"

mySQL Admin shows that database's full name to be:

<deleted>

I assigned an existing user to have access to that cart
The user for that mySQL database is "rainev" and the full name is shown as:

<deleted>

The password is: <deleted>

When running the PowerStore Installation Wizard, here are the settings I provided:


Server/Host Provider: raindroptraining.com

Database name: raindrop_cart
(i also tried it just "cart" without the raindrop_ - unsuccessful, obviously)

Username: <deleted>
(I tried this with and without the raindrop_ -- and I also tried it with just the raindrop)

Password: <deleted>


Have I provided you with enough information to identify what I'm doing wrong? Any advice you can give will be greatly appreciated.

Connie

Sign in to reply to this post

Jason ByrnesWebAssist

My Guess is that the MYSQL Servername is not correct.Try entering Localhost for the mysql server address.

If this does not work How is your hosting provider? they should be able to tell the correct MySQL Server name to enter


Note: I deleted all of the usernames and passwords from your post, this is a public forum. You may want to change the username and passwords with the host.

Sign in to reply to this post

connie386947

Thank you, Jason, now...

Thanks for deleting those user/passwords. Wasn't even thinking about the open forum. (desperation can truly make you stupid!)

Anyway, I tried localhost as you suggested and got a different error message, which I consider to be serious progress!

ERROR: Your MySQL user (name_removed) needs the CREATE VIEW privilege. Please update the user permissions and try this step again.

I have a ticket in with my hosting provider to help me with this.

Thanks again for your assistance!

C

Sign in to reply to this post

Jason ByrnesWebAssist

If you're host cant help you add the Create View privilege to the MySQL user, there are updated files in the PowerStore download center that will fix the issue. Look in the Known Issues section.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...