CMS Made Simple Forums

I'm an expert on html and css, but an almost total noob when it comes to the skills necessary to install this cms. I do have PHP+Apache+SQL installed on my local win/2k, but even that was a struggle, despite step-by-step instructions written for the 'fencepost' crowd.

I'm hoping that someone can point me to some tutorials I can study to learn the very basic things I need to do the job. I have only a hazy knowledge of the command line, but I have used it once or twice.

I looked at the install page, but frankly even that stuff increases my anxiety level. I know, it's super basic, but not quite basic enough, I'm afraid.

I tried setting up Etomite, but there was some permission error I couldn't solve and the forums there were no help at all. I'm not asking for personal help, just a clue where to start bootstrapping up to the level I need to be.

BTW, if I can actually get this going, I'd be happy to donate some time providing any CSS advice I can. Some say I am pretty knowledgeable in that area.

This should be a good experience, if you're willing to hang in there. I'd like to get together some documentation on a Windows based install anyway, so this is good.

First of all, let's start with mysql. Did you download the mysql essentials package and install it as any other app?

In the install process, you setup a root password. I hope you remember it.

Start Menu->MySQL->MySQL Server Version 4.x->MySQL Command Line client

Enter the root password when it comes up

Now, to create the database, you'd use:
create database cms;

To add a user, you would do:
grant all privileges on cms.* to cms_user@localhost identified by 'cms_pass';

All that basically does is add a new user (cms_user), set his password (cms_pass) and give him all privileges to the cms database that you created in the previous step.

Now do a:
\q

That's it! Your database is setup.

Let me know if you get that far. If it's a different version of mysql, let me know and we can try to narrow down how to accomplish the same thing.

wishy wrote:This should be a good experience, if you're willing to hang in there. I'd like to get together some documentation on a Windows based install anyway, so this is good.

I take the same attitide with my CSS work. The newbies teach me the most about how to teach.

wishy wrote: First of all, let's start with mysql. Did you download the mysql essentials package and install it as any other app?

Yes, and i just spent all day with a guru frien of mine, so finally mysql is up and running. There is still some odd issue with the root password, but I can get in with it from the prompt okay. I guess phpmyadmin is having a weird issue with a root pw, but a blank one seems to work. I'll get it straightened out tomorrow.

wishy wrote: To add a user, you would do:
grant all privileges on cms.* to cms_user@localhost identified by 'cms_pass';
All that basically does is add a new user (cms_user), set his password (cms_pass) and give him all privileges to the cms database that you created in the previous step.

I did manage to create a new user, but phpmyadmin is still rejected with a password, and I'm advised to upgrade! With a new install yet. Oh well, I'll get it eventually. I'm used to nutty stuff happening. Computers never miss a chance to diss me. Oy.

Anyway, standby while I hammer out this bugger (and I will too!). No way am I going to be enslaved to the command prompt. Homey don't play that.

After it's all done, feel free to give me the third degree for your docs, okay? And I mean that about CSS help too.