PDA

View Full Version : wordpress blog program...



jdbaker
09-24-2004, 10:29 PM
Hey all,

I just tried installing wordpress (http://wordpress.org) on my account, but it uses MySQL which I'm really not familiar with. I installed PhpMyAdmin and created a DB called "wp" (with no tables or anything like that, the instructions said to just create the db and the install would set up the tables etc...) and when I try to run the install I get an error:

Error establishing a database connection!

Now, this is most likely due to the fact that I'm not setting this up correctly. It asked for a few changes in the config file, and I'm not sure if I set those right and I am sure that is my problem, but I'm not sure what to set them to. These are the setting they are asking for:

define('DB_NAME', 'DB_NAME'); // The name of the database
define('DB_USER', 'DB_USER'); // Your MySQL username
define('DB_PASSWORD', 'PASSWORD'); // ...and password
define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value

I am guessing that "DB_NAME" will be "wp" (that is what I named the database). But I'm not sure what I would use for the "DB_USER". Is that my domain (without the extension)? How do I know that is? And then the passworrd, is that the password to get into PhpMyAdmin, or is it a unique password for this specific database (I don't remember setting a password up for the database, don't even know if you can do that). Can you tell I really don't know what I'm doing :)

Any help with this would be appreciated, I think I'm really close to getting this to work.

wildjokerdesign
09-25-2004, 06:25 AM
You have two options.
First you should be able to use
DB_USER = root
DB_PASSWORD = the password you entered when you installed MySQL

Second you can use phpMyAdmin to create a new user with a password and use those.

You are correct about the database name and the host is localhost. I have set up Wordpress on an account and it does work with WH without any other steps other then what is mentioned in the set up instruction that come with it. It might be a bit more secure to use a new user and password but if I remember Wordpress does encode these so don't know if it really is neccesary. Some folks simply like to keep things seperate.

Let me know if you need any more help.

jalal
09-25-2004, 07:35 AM
Wordpress is great, I'm just upgrading my site to make use of it... stay tuned.

wildjoker has explained what you need to do, but just to clarify, when you installed MySQL it asked for a password, this then became the MySQL root password (user: root, pass: whatever).
This MySQL root is nothing to do with your 'root' account on the server, it is a separate thing.
Normally, one would start up PhpMyAdmin (or use mysql under ssh) and then create a 'normal' user with whatever permissions were needed and then use that user for the web access to the database.
But, for now, you are probably fine with using the root user.

PhpMyAdmin, I seem to remember, uses .htaccess to control access to the program, so that is a different user/password.

Hope that Helps...

wildjokerdesign
09-25-2004, 08:36 AM
Thanks jalal for catching my mistake in the password. I had forgot that it was created when MySQL was installed. I edited my orginal post to reflect that.

torrin
09-25-2004, 09:16 AM
I've been thinking about setting up wordpress myself. For those of you that have, can you post the URLs so we can see some examples?

jdbaker
09-25-2004, 11:02 AM
You guys ROCK! I changed it to "root" and it worked. I love when it works :). Thanks again for your help, I am really a newb when it comes to DB stuff. I have only used MySQL once before (for a calendar program), and my friend helped me set it up so I don't know what I did when I set it up. I'm excited for this blog thingy, it's actually for my wife. She wanted a way to keep her family updated about us and I thought this would work out good for that. I just have to now edit the template to look like the site (hope that's not too hard). Thanks again for all of your help, you guys are great.

wildjokerdesign
09-25-2004, 11:57 AM
Hi Torrin,

I have an install of it on my test site (http://hahajoca.com/wordpress/) I'll PM you with the admin user name and password so you can check out that part of it if you want.

torrin
09-25-2004, 02:14 PM
Thanks.

jalal
09-25-2004, 07:39 PM
I've been thinking about setting up wordpress myself. For those of you that have, can you post the URLs so we can see some examples?

A couple I've setup recently are:
http://www.fwz-freiburg.de/
and
http://www.nsthealth.com/

It's hard to tell much from the outside though, its all hidden in the backend where the users get to post things. They are working sites so I can't give you admin access.

One site of interest is:
http://www.opensourcecms.com/
which has dozens of CMS/Blog/Commerce packages installed and open for administrators to play around with.

torrin
09-26-2004, 03:56 PM
A couple I've setup recently are:
http://www.fwz-freiburg.de/

Thanks, but unfortunately, I can't read german. LOL. So I wasn't exactly sure what the click on to get to wordpress, or is the whole site a modified wordpress? I wasn't sure.


One site of interest is:
http://www.opensourcecms.com/
which has dozens of CMS/Blog/Commerce packages installed and open for administrators to play around with.

I've seen that site before and didn't even think about going to it before making my request. I see there are lots of options in the backend or workpress. That's pretty cool. Thanks for replying. I also took a look at wildjokerdesign's setup. Interesting.

wildjokerdesign
09-26-2004, 04:48 PM
...or is the whole site a modified wordpress? I wasn't sure.


I was wondering that also. I have done something similiar on a site I am setting up for someone but not to that extent if that is what jalal has done.

BTW jalal... both your examples are really nice sites. If they are run of wordpress and even if not you did a great job on layout and graphics. I am strugleing a bit with changeing the layout of Wordpress on the site I am working on but I am also trying to keep it W3C compliant on both XHTML and CSS (thethomastree.com)

jalal
09-27-2004, 12:06 AM
Thanks for the compliments... but the site design is done by my partner, I do the admin and the programming.

Neither of those sites are done completely with Wordpress, only the pages where the client wants to enter the data themselves and not have to contact the designer to update the news items. The design of the site is done first and then I come along and make the pages 'work' dynamically.

So neither are blogs in the traditional sense. My upgrade to codeworks will be more along the lines of a blog though, so when that goes live you can see something along more traditional lines.

Wordpress designs: wordpress.org have a forum (community section of the site) where folks can show off their designs and its well worth looking through some of the links there to see what is possible and what other have done.

Particularly impressive is:
http://binarybonsai.com/kubrick/

jalal
10-28-2004, 03:08 PM
Wordpress is great, I'm just upgrading my site to make use of it... stay tuned.

Well, I said I'd let you know when the new site appeared, so here it is:

http://codeworks.gnomedia.com/

based on Wordpress, using Kubrick theme and a bunch of customizations... let me know if things don't work or if they look funny.

8)

wildjokerdesign
10-28-2004, 04:06 PM
Nice work Jalal. Im jelous! :) Everything seems to be working fine. I checked it out this first time using IE 6 on ME if I remember I'll give it a check on FireFox later although I would imagine you have that covered.

torrin
10-28-2004, 06:07 PM
Nice work Jalal.

Agreed. I reading it right now from Firefox 0.9 on Windows XP. No problems at all. Looks great!

By the way, your westhost url (http://codeworks.gnomedia.com/westhost) seems to have stopped working. Is there a new place?

wildjokerdesign
10-28-2004, 07:49 PM
I think it has moved here:
http://codeworks.gnomedia.com/westhost-introduction/

jalal
10-29-2004, 01:20 AM
Hmm, it should have redirected automatically, I'll check that out.

Thanx all...

:)