DB creating tables ok but not recognising user password for scripts

Discussion in 'MySQL' started by Audiomad, Apr 9, 2010.

0
  1. #1
    I've just set up mysql on my computer with phpmyadmin but I'm having a problem I can create db, from within the script setup I can get the tables and information to save to the db but after adding password + user for any scripts I'm trying to run I get password incorrect error. (in the script)

    How can I fix this? searching the the db shows the user created using the scripts and a password "encrypted".
     
    Audiomad, Apr 9, 2010 IP
  2. koko5

    koko5 Active Member

    Messages:
    394
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Hi Audiomad,

    phpmyadmin escapes strings you pass, so it's better using mysql console or GUI tools
    If this doesn't help please share a little bit code.
    Regards :)
     
    koko5, Apr 10, 2010 IP
  3. georgiivanov

    georgiivanov Member

    Messages:
    62
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    25
    #3
    Did you grant permissions to the user?

     
    georgiivanov, Apr 13, 2010 IP
  4. Audiomad

    Audiomad Peon

    Messages:
    1,028
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #4
    If done everything but doesn't seem to work, the script I'm using is supposed to be for php 5.20 and mysql 5 but I think there maybe a flaw in the script as if I use an older version of the same script all works fine.
     
    Audiomad, Apr 13, 2010 IP