Everybody! This is important. In a few days, these forums will be moving over to using the totally sweet Discourse platform. To ensure this migration happens smoothly with no loss of content, these forums are currently in a read-only mode. I do apologize for the inconvenience.

There is never a good time to turn the forums off for an extended period of time, but I promise the new forums will be a billion times better. I'm pretty sure of it.

See you all on the other side in a few days, and if you have any (non-technical) questions, please e-mail me at kirupa@kirupa.com. For technical questions, try to find a tutorial that corresponds to what you are looking for and post in the comments section of that page.

Cheers,
Kirupa

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