SOLVED :: Stumbling at Step 10 of installation

[Eskymo]

Hi there

I've set up a MySQL 4 database [think it's 4.1 actually] and added a user and made a note of the username and password. I followed the instructions in step 10 but when I click to continue I get the following error message:

Could not connect to the database. Verify that username and password are correct, and that the user has access to the given database.

So I read the documentation again and if someone could explain the following that would be great:

Note 2: If you find you are not getting past this point, it may be that when you created the database (step 6) you didn't grant yourself permissions. It's insufficient simply to observe that the ALL check box has been ticked assuming that all permissions have been granted. You have to run a query, for which a go button may be positioned nearby that does this for you. Go back to the control panel (back to where you were before, eg. MySQLdatabase) and hit the go button.

Firstly I never saw anywhere stating 'grant yourself permissions' when setting up the database - there were no check boxes to check - not sure if that's because I set it up via a hosting package control panel or not.

Secondly the 'you have to run a query' is a bit vague as what query do you run and where do you run it. In the control panel there is nowhere to run a query. So I logged into PHPmyAdmin thinking I could find this elusive 'go' button and have no idea what to do next.

Any help much appreciated as I'm stumped. I'm not a programmer and this is the first time setting up a database and this is all very new.

Thanks

E

[Jack @ PharSide]

Its sounds like its a username or database location issue.

Could be a few problems:

1. Check the location of the MySQL DB (i.e. could be on the same server or on a totally different sevrer which you may need the domain or IP address for). For example, GoDaddy.com has remote MySQL servers and you need to replace the default with it's actual URL (no http)

2. Check with your hosting company or where this database is hosted and check their editing tools for your DB like PHPMyAdmin or something similiar.

You shouldn't ever have to set any permissions for the DB at all. Unless I am missing something specific about your hosting environment.

Here is what you need:

DB Location (localroot or address - i.e. mysql35.secureserver.net) THIS IS WHERE I THINK YOUR PROBLEM MIGHT BE
DB Username (same as DB Name)
DB Password

Hope that helps..

[Eskymo]

I thought the problem was that I set up the database, then set up the user and I've not assigned the user to the database - but I can't find anywhere to do that. I see your point about the DB location, but not sure what information to put in there. It defaulted to 'localhost' and so I presumed that was the right thing to insert...how do I find out my Database Host Address?

[sayitlikeitis]

Note 2: If you find you are not getting past this point, it may be that when you created the database (step 6) you didn't grant yourself permissions. It's insufficient simply to observe that the ALL check box has been ticked assuming that all permissions have been granted. You have to run a query, for which a go button may be positioned nearby that does this for you. Go back to the control panel (back to where you were before, eg. MySQLdatabase) and hit the go button.

I just happened to come across your post.  I'm no expert, and don't claim skills, much beyod your own, but I do claim credit for writing this piece of text.  When I first began using cmsms I found the help to be somewhat lacking.  The help was probably ok for experts, but after toiling away at it I got it installed and later thought I could improve on the doco.  Ok, I guess it needs more work.

Do have access to cPanel?  That is what is being referred to within the quote.  Your hosting provider gave you access to your site.  When I log into mine, cPanel starts. Its my window into my site.  I presume that may be the case with you too.  I'll assume so.  Can you see something called "MySQLDatabases"? If so, click on it. [Until you get the hang of this, do it with some test database. Lets create one called "testing".] Everything I refer to below is within the MySQLDatabases module of cPanel.

At the top is MySQLDatabases, and below it "New Database" and a text box.  Enter "testing" in the text box, and click the Create Database button.

Hopefully, this will be confirmed, go back, click.

Scroll down the page a bit, and find MySQLUsers, and below it "New User" and Username and Password etc and a couple of text boxes.  Enter a usercode and password, and click the Create User button.

Hopefully this too is confirmed, go back, click.

Scroll down again.  Under the Add User to Database you'll see a drop-down.  Click on it, and if all went well you'll see the username you just created.  Select it, then select the database you created a moment ago, and click on the Submit button.

A new screen presents.  This is where the ellusive check boxes are to be found to grant yourself the privileges.  This is the "go" button I was referring to.  So, cPanel has changed since I used it last, and there isn't actually a go button now (its a "make changes" button), but there used to be something like that when I did it.  Click on ALL PRIVILEGES, and then on the Make Changes button, go back, click.

On the old cPanel all the ticks were set, which gave me the impression that the priveleges were set.  They weren't. To make the change you had to click on the go button.  With this version of cPanel there are no tick boxes set, you have to do that yourself, then click on the Make Changes button, which is more intutitive.

Log out and try and finish your installation, and if all goes well have a cup of tea and a biscuit.

[Eskymo]

Thanks for your response..I don't have cPanel I'm afraid. My client is hosted on a windows server with Liquidsix and I have access to her Helm 4 Control panel which allows me to create a database and then create a database user - there is nowhere to assign permissions or add the user to the database. I have looked through their support files and can't find anythign useful, but to be honest I'm not really sure what I'm looking for as the cms documentation tells me to grant permissions but Smackdown above says I don't need to assign permissions.

I've also searched google for help but everything that comes back relates to cPanel.

Any further ideas?

Thanks
E

[sayitlikeitis]

No more ideas.

Though, the notion of a "windows server" caught my eye. Apache and PHP are terms I would be looking out for on a host.  Perhaps someone else might care to comment.  A lot of cmsms runs on PHP (no doubt other things come into play too), and in so far as I'm aware (but I'm not sure) PHP needs Apache to run.  So, I'm wondering, if this is a windows server and doesn't support Apache perhaps cmsms can't run on it.  But hell, what do I know, I might be way off beam here.  I'm a novice and probably shouldn't be offering advice.

[Eskymo]

I checked the requirements for CMSMS against what my client's hosting provides and it all looks fine...so don't think being on a windows server is an issue...

[Jack @ PharSide]

Are you using MySQL though? You can absolutely run PHP and MySQL on a Windows machine. But, you do obviosuly need to know the correct location of the DB. Usually with MySQL, the user name of the password is specific to each DB you create. So, there should not be a need to associate a user with a DB. It is automatic as the database name and user name are the same.

With a standard Windows config, I would assume you are using some other sort of DB (Access or SQL). There is a big difference between SQL and MySQL by the way. Totally different DBs.

Here is what I would do:
1. Confirm what kind of database is installed
2. If MySQL, locate the location (localroot if on same machine or IP if hosted on extrenal machine)

That's all I can suggest,
-Jack

[Eskymo]

yes I'm using MySQL.

The problem has been solved...I had to replace 'localhost' with 'sql02' but even though I had tried this before posting the problem up on the forum, it didn't work on my PC and I kept getting the same error over and over again, but for some reason, today, it did work on my client's PC so we've managed to install it OK. Not sure why it wouldn't work on my computer.

thanks for taking to the time to look into things for me.

E