need some data base helps folks!!!

[InSoMnIa]

hey ive just bought some webspace and im trying to upload a gallery to it and its saying i need to put in my database settings now im a complete idiot,novice and ive no idea what its asking for can any one help?

 

[InSoMnIa]

anybody???

 

[Andy1.2]

My dads a whizz on databases, ill see if i can ask him this evening when hes home from work.

 

[sn00p]

Just enter the username & password you want for your database along with the name of it, that's what you'll use to access it.

 

[InSoMnIa]

it dont create one ive tried that

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /home/sites/insomniauk.co.uk/public_html/gallery2/lib/adodb/drivers/adodb-mysql.inc.php on line 366
localhost: Access denied for user 'root'@'localhost' (using password: NO)

 

[sn00p]

You won't want to be calling the user root!

 

[InSoMnIa]

no matter what i put in i get the same result

 

[InSoMnIa]

if provide some one with a ftp account can any one sort it for me???

im trying to install gallery2 on there

 

[sn00p]

right, I see, the screenshot you've put from above is from the gallery software....

...on your hosting providers control panel you need to create a:

database (call it gallery2)

and create a user for the database.

Then in the gallery screen above, type in that information. The mysql hostname will probably be shown in the hosting control panel or on some help page.

 

[FiDoDiDo]

It's trying to use root and no password, surely you didn't set it to that did you?

 

[KDF]

You wont be able to do it with ftp.. you really need either ssh access to the box.. or remote mysql access to create the gallery table !

I have set up gallery2 a few times now.. its a peice of piss !

Is this a new install ? have you setup your root password for the database or have you not touched the mysql server since it was installed ?

 

[InSoMnIa]

dam it time for work will have to have a look tonyt i new at all this it seems harder than i thought

thanks for ya help sn00p

 

[InSoMnIa]

You wont be able to do it with ftp.. you really need either ssh access to the box.. or remote mysql access to create the gallery table !

I have set up gallery2 a few times now.. its a peice of piss !

Is this a new install ? have you setup your root password for the database or have you not touched the mysql server since it was installed ?

its a new install aint set jack s**t lol and ive no idea what your talking about !!!

 

[KDF]

You wont be able to do it with ftp.. you really need either ssh access to the box.. or remote mysql access to create the gallery table !

I have set up gallery2 a few times now.. its a peice of piss !

Is this a new install ? have you setup your root password for the database or have you not touched the mysql server since it was installed ?

its a new install aint set jack s**t lol and ive no idea what your talking about !!!

Your gonna need to give more details.. is this your own system you've set this up on or a server your paying for ? if its your own system I can run you through how to get it working no probs.

If its a server your paying for then you need to find out what sort of access you have to it. Ideally if you have SSH access you can easily set it up, but even remote connections to the mySQL server will suffice ! Failing that I could write a php script that you would upload to the server and run that would create the database for you..

Give as much info as you can !

 

[cava83]

basically, you should have a kind of control panel for the web space you have bought.

One of the panels should be sql admin, or something along them lines.

You will need to create an account i.e user name and password and give it the rights you would like it to have. Then on the gallery interface put in those user details and it should work.

At the moment you are using the root credentials and you do not know them.

 

[KDF]

^^ not quite.

He has to also create the gallery table as the install scripts wont do that for you !

 

[cava83]

depends on the rights

hopefully that should make things a bit clearer for the young man.

 

[InSoMnIa]

kdf yhpm

 

[InSoMnIa]

r8 ome from work need to get this thing sorted can any one talk me throught what ive gotta do ?

its webspace ive bought with internet runner
the gallery in gallery 2
ive only just got the site ive not changed any setting
ive never used a database before

so i need a idiot guide

 

[InSoMnIa]

never mind ive worked it out

 

[InSoMnIa]

dam it

A file permissions error has occurred. Please check the permissions on the script and the directory it is in and try again.

http://www.insomniauk.co.uk/gallery2/main.php

 

[KDF]

Hi, glad you got it sorted.. sort of

You need to set the dirs and scripts to 755.

with ssh access you would

chmod -R 755 /path/to/gallery2dir

I think you can set file permissions through some ftp clients aswell. ideally your looking for

-rwxr-x-r-x as the file permissions directorys should show up as
drwxr-x-r-x

Good luck !

 

[InSoMnIa]

i cant get it to work