Setting up a database user using phpMyAdmin

Discussion in 'MySQL' started by lv211, Aug 8, 2006.

  1. #1
    How do you create a new database(mysql) user using phpMyadmin?

    Do you have to use the command line tool?
     
    lv211, Aug 8, 2006 IP
  2. mattmdesign

    mattmdesign Well-Known Member

    Messages:
    1,201
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    118
  3. lv211

    lv211 Peon

    Messages:
    168
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    No... Unfortunately.

    I'm using 1and1 for hosting. They're telling me you can't create a user from the phpmyadmin control panel.

    My control panel differs from the one in the site you posted. I don't have access to 'privileges'.
     
    lv211, Aug 8, 2006 IP
  4. Colleen

    Colleen Illustrious Member

    Messages:
    6,777
    Likes Received:
    725
    Best Answers:
    1
    Trophy Points:
    430
    #4
    Are you trying to add an additional user to the database?

    At 1and1, a user is created when you create the database, you can see here at the bottom, http://faq.1and1.com/applications/mysql_administration/3.html

    You'd think they'd offer you more info about how to go about doing this rather than just saying you can't.

    After some searching, I found this but it's older.
    From: http://www.colinwong.com/content/technology/1and1_Web_Hosting_Review.php
     
    Colleen, Aug 9, 2006 IP
  5. lv211

    lv211 Peon

    Messages:
    168
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I actually figured out my problem.

    I was trying to install drupal on my site. 1and1 hosts the database on a different server so I had to change "localhost" to the url of my database.

    Thanks for your help.
     
    lv211, Aug 9, 2006 IP
  6. dddougal

    dddougal Well-Known Member

    Messages:
    676
    Likes Received:
    19
    Best Answers:
    0
    Trophy Points:
    108
    #6
    1and1 dont sound to good!
     
    dddougal, Aug 10, 2006 IP