my sql problem

[MyDNA]

hello i have an online database within my host.

now in my sql script the following lines are there but while installing the database won't reconice the code so some data is not vissible, i can't login and so on.. (on the website at the admin pages) is it because of the code or because of the online database.. Please someone help me..

the code is:

grant select, insert, update, delete
on databasename.*
to username@localhost identified by 'password';

(localhost is the name of the host to fill in)

[ramie]

grant select, insert, update, delete
on databasename.*
to username@localhost identified by 'password';

if its in the script like that it wont work, that makes no sense to me, unless your doing it from the command line.

have a look at the link below.

http://www.freewebmasterhelp.com/tutorials/phpmysql

[MyDNA]

if its in the script like that it wont work, that makes no sense to me, unless your doing it from the command line.

It is in the sql script thanks for the link i'll check it out..
At first it made no sense to me either, but i just can't login at the admin part and it doesn;t show any catagory or product in my shop..
I'll leave a message here if i can't find it but i'll do my best..

cheers..

[MyDNA]

TYhe book says: To set up this database on your system, run the "product_sc.sql" script through MySQL as the root user, as follows:

"mysql" -u root -p < product_sc.sql"

But how to do that if i have an onlione database at my webhost. (webhosting.lycos.nl) like tripod of lycos.com only professional but anyway..
How can i lounge this script? The shop on http://www.quiksilver.nl/shop does not show the catagories i placed in my database and i can't login thats why i need to place the sql code like i wrote on top. That is the only part i could not place..

Can someone help me please?

[ramie]

ok, you really need to read through that link I gave you previously, properly this time

pay particular attention to the section below

http://www.freewebmasterhelp.com/tutorials/phpmysql/2

Ray

[MyDNA]

I found the GRANT option.. but now is my problem my online MYSQL server won't recornize the problem.. Is it possible to add a code in PHP to GRANT the USER via the PHP script?

documentation about the GRANT Option:
http://dev.mysql.com/doc/mysql/en/adding-users.html