How to create users using phpMyAdmin

Discussion in 'Databases' started by Kimi Raikkonen, Sep 5, 2009.

  1. #1
    Hello,

    I want to install a wordpress blog in my domain but i didn't able to create username and password using phpmyadmin.

    See the [​IMG] of my home of phpMyAdmin.

    I have created a database but i didn't able to create the user

    see the [​IMG]
    for this

    If i require to create table, then please tell me the steps for the same.

    Please help me out of this
     
    Last edited: Sep 5, 2009
    Kimi Raikkonen, Sep 5, 2009 IP
  2. premiumscripts

    premiumscripts Peon

    Messages:
    1,062
    Likes Received:
    48
    Best Answers:
    0
    Trophy Points:
    0
    #2
    This is generally set up via cpanel, if you have it.
     
    premiumscripts, Sep 7, 2009 IP
  3. Kimi Raikkonen

    Kimi Raikkonen Peon

    Messages:
    69
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    i know how to create them in cpanel but cpanel is not available in my this site hosting.
     
    Kimi Raikkonen, Sep 7, 2009 IP
  4. chandan123

    chandan123 Prominent Member

    Messages:
    11,586
    Likes Received:
    578
    Best Answers:
    0
    Trophy Points:
    360
    #4
    just use this in sql window of phpmyadmin :)
     
    chandan123, Sep 7, 2009 IP
  5. Kimi Raikkonen

    Kimi Raikkonen Peon

    Messages:
    69
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    what should i write in locahost? my domain name?
     
    Kimi Raikkonen, Sep 7, 2009 IP
  6. ahsan11223

    ahsan11223 Active Member

    Messages:
    725
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    73
    #6
    There is a very easy option avialable in phpmyadmin to delete or add users.. so what a big deal..
     
    ahsan11223, Sep 7, 2009 IP
  7. chandan123

    chandan123 Prominent Member

    Messages:
    11,586
    Likes Received:
    578
    Best Answers:
    0
    Trophy Points:
    360
    #7
    just try once and test :p :)
     
    chandan123, Sep 7, 2009 IP
  8. Kimi Raikkonen

    Kimi Raikkonen Peon

    Messages:
    69
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    i used this code
    and i got this error

    [​IMG]
     
    Kimi Raikkonen, Sep 7, 2009 IP
  9. chandan123

    chandan123 Prominent Member

    Messages:
    11,586
    Likes Received:
    578
    Best Answers:
    0
    Trophy Points:
    360
    #9
    i just use localhost :) btw that pic is not visible properly
     
    chandan123, Sep 7, 2009 IP
  10. Kimi Raikkonen

    Kimi Raikkonen Peon

    Messages:
    69
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
  11. Kimi Raikkonen

    Kimi Raikkonen Peon

    Messages:
    69
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    Kimi Raikkonen, Sep 11, 2009 IP
  12. sevmax

    sevmax Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #12
    Kimi Raikkonen, as had been said, additing new user in phpMyAdmin isn't hard.
    And your last link is too small to watch what was wrote on it.
     
    sevmax, Sep 12, 2009 IP
  13. Kimi Raikkonen

    Kimi Raikkonen Peon

    Messages:
    69
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #13
    Kimi Raikkonen, Sep 13, 2009 IP
  14. sevmax

    sevmax Peon

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #14
    Kimi Raikkonen, it means that you don't have enough privilegies to create database. if you are admin of it - you should log into system as root and set needed permissiond for your current user. If you can't log into as root - cantact admin of this server to do it for you.
     
    sevmax, Sep 13, 2009 IP
  15. jkapadia1983

    jkapadia1983 Peon

    Messages:
    40
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #15
    go to http://localhost/phpmyadmin

    then Privileges

    click on add a new user
     
    jkapadia1983, Sep 30, 2009 IP