The forums have permanently moved to forum.kirupa.com. This forum will be kept around in read-only mode for archival purposes. To learn how to continue using your existing account on the new forums, check out this thread.


Results 1 to 6 of 6

Thread: my sql problem

  1. #1

    my sql problem

    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)
    Last edited by MyDNA; July 13th, 2005 at 08:57 AM.

  2. #2
    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

  3. #3
    Quote Originally Posted by ramie
    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..

  4. #4
    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?

  5. #5
    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

  6. #6
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012