Root access to mysql?

Alright, I was trying to set up the forum, and just a little ways into it when I was using mysql to create the forum database (eg. create database forum;) it hit me with this error:

ERROR 1044: Access denied for user: 'odis@localhost' to database 'forum'

Reading through the install file I had already seen something about needing root access to mysql, so I just decided to try anyway.

So, do I need my system admin to do this for me? Or can I bypass that in someway?

Thanks!

You will need to get your system Admin's assistance,
but it will be easy enough for the admin to set
Grant All permissions to 'odis@localhost' for
for that database only.

There are two roots here - you don't need system (Unix) root access, you need mySQL root access. It depends how mySQL was installed. If you installed it yourself you may well have a blank root password, you could type:

mysql -u root

If not, and if you don't control the mysql root account then you need whoever does to grant you rights to that database. From memory they need to type something like:

grant all on forum.* to odis@localhost identified by "yourpassword"

They may need to actually create the database for you too. (ie. create database forum)

Alright, after I got my database setup everything went without a hitch! Horray! Except for one thing, when I look at my forum the little pictures don't show up on my computer. Since I'm running this off of here, I know I must have something wrong since I see the pictures on here and on Kris' forums. What shall I do?

Take a look, perhaps its just my comp:
http://ew.xidus.net/forum/

Thanks for all the help.

Never mind, I got it. Turns out I had to chmod the gif files to 755. Anyways, works fine now.

Check it out if you want:
http://ew.xidus.net/forum

But its nothing you haven't seen (considering it looks almost exactly the same as this..).

Thanks for the help.

Glad it's working for you. BTW - you don't need to be a moderator as well as administrator, administrators can do all a moderator can, and more.

You can change the look and feel somewhat by editing the control entries for the standard header and footer, and in particular by changing the GIFs (eg. do your own with different colour buttons, and change the background GIF to something else). That way it doesn't look exactly like this one.

Alright, its all working, except some of the pictures still won't show up (refresh, reply_to_subject, and new_subject, as well as bio) even if I chmod them to 755. Should I chmod them to something else?

I will be changing it, but right now (with my game opening on the 1st) I just had to stick it up and modify it a bit. I'll change it later when all my work/troubles die down.

Any suggestions?

The one that seems to be working - the background GIF is at:

http://ew.xidus.net/forum/images/background.gif

One that isn't is at:

/images/refresh.gif

Are you sure you have the images directory set up correctly?


One thing you might need to do is change the httpd.conf file to alias the images directory, like this:

Alias /images/ "/var/www/forum/images/"

Alternatively you could change the PHP source to point to a different spot.

Or, you could make a soft link to create a link from where the images should be to where they are.

I don't have root access to anything, or w/e it is, so I'm not sure exactly where it is looking for the images, but as for soft links, where do I need to go to set them up, because otherwise I'll have to do it by hand..

It depends how your web server is set up, but currently to resolve /images/blah.gif it needs to find the image directory in the HTTP "root" directory.

You clearly have a "forum" directory somewhere because I can see that you get the background gif from the subdirectory "images" of it. You need an "images" directory at the same level as the forum directory, and the images in it. Then it should work.

The forum directory is located at:
/home/odis/public_html/forum

The images directory is at:
/home/odis/public_html/forum/images

Shouldn't that work if it specifies the image src as /images?

Alright, once again I ask the question before I fiddle with it myself. I just needed to stick the images directory in public_html since /images refers to the top directory for my web stuff. Anyways, its working, I'll work on customizing it once I get my mud squared away. Anyways, thanks.

Yes, I think you've got it. The images directory was a subdirectory of forum, but it was expected to be a root directory (from the HTML root level).