+ Reply to Thread
Results 1 to 7 of 7

Thread: php/sql permissions
      
   

  1. #1
    econstas's Avatar
    econstas is offline Second Lieutenant
    Join Date
    Jul 2006
    Location
    Durham, NC
    Posts
    105

    Default php/sql permissions

    Hello, I messed my webcalendar db and now I am having probelms with permission access to the db.

    Here is the error message:
    Access denied for user 'cncmmdly_wcln1'@'localhost' (using password: YES)

    mysql acces is:
    Connection StringsPerl$dbh = DBI->connect("DBI:mysql:cncmmdly_wcln1:localhost","cnc mmdly_cncmmdl","<PASSWORD HERE>");PHP$dbh=mysql_connect ("localhost", "cncmmdly_cncmmdl", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
    mysql_select_db ("cncmmdly_wcln1");


    I am not seeing the pasword option to set the permissions via phpADMIN. I also tried via the console - mysql . I need help.

  2. #2
    econstas's Avatar
    econstas is offline Second Lieutenant
    Join Date
    Jul 2006
    Location
    Durham, NC
    Posts
    105

    Default Re: php/sql permissions

    All,
    Fixed it! To anyone that wants to know.

    I opened ftp account... clicked on /phpcal folder changed settings so everyone could view webcalender. Then Noticed that there was a file that was hosed. Uninstalled and reinstalled - works fine now.

    www.holleyjohnson.net/phpcal/

  3. #3
    RSIGNS1 is offline Private
    Join Date
    Dec 2006
    Posts
    1

    Default Re: php/sql permissions

    I have a problem with php I created a form but when I try to submit it doesn't work can any one could help out thank

  4. #4
    Join Date
    Mar 2006
    Location
    Mallorca, Spain
    Posts
    6,313

  5. #5
    Mainsail is offline Private
    Join Date
    Feb 2007
    Posts
    3

    Default Re: php/sql permissions

    I was in the middle of setting up blogging by email in Wordpress when the vodahost server crashed last night. When it came back up I had over 3500 identical blank posts that I have to delete. I'm using phpadmin thinking it would be faster than manual deletes. However, it will not let me delete more than three records at a time

  6. #6
    Join Date
    Mar 2006
    Location
    Mallorca, Spain
    Posts
    6,313

    Default Re: php/sql permissions

    When using phpadmin, you can select ALL of the lines on a page(normally 30)
    and then hit the delete icon and it will delete ALL selected.

    Look at the bottom of the screen to select all first.......

    You can also use an sql command to delete ALL records with an id number greater than whatever


    be careful.............

  7. #7
    Watdaflip's Avatar
    Watdaflip is offline Major General
    Join Date
    Sep 2005
    Location
    Cincinnati, Ohio
    Posts
    2,119

    Default Re: php/sql permissions

    Using phpmyadmin you can also just empty the table (Clears row from it). Just click the link for the table on the left frame, and then once it loads the button at the top (should be second or third from the right) will be "empty", click that and it will do the job

    Register/Login Script
    Do you use a Password Protected Directory? Need a way to allow users to make their own account, try my .htaccess Login Script

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49