Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

mySQL Database Owner

Discussion in 'General Discussion' started by DaVeKH, Mar 16, 2004.

  1. DaVeKH

    DaVeKH Member

    Joined:
    Apr 4, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    151
    I changed an account username from a to b.
    I then edited the names of the mysqk databases in /var/lib the mysql databases now show up in the users phpmyadmin when he logs in under the new username but there are no tables in them. Is there a config file or do I have to change some permissions so that they show up under this different username?
     
    #1 DaVeKH, Mar 16, 2004
  2. bamasbest

    bamasbest Well-Known Member

    Joined:
    Jan 10, 2004
    Messages:
    531
    Likes Received:
    0
    Trophy Points:
    166
    Check your mysql database.

    Merely changing the database names, does not allow privs to the new user if the new username isn't granted access.
     
    #2 bamasbest, Mar 16, 2004
  3. DaVeKH

    DaVeKH Member

    Joined:
    Apr 4, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    151
    How do I grant the user access to it please.
     
    #3 DaVeKH, Mar 17, 2004
  4. bamasbest

    bamasbest Well-Known Member

    Joined:
    Jan 10, 2004
    Messages:
    531
    Likes Received:
    0
    Trophy Points:
    166
    Unless you are familiar with mysql shell commands, your best bet would be to use phpmyadmin via WHM.

    In the mysql database, you would edit all records for that user in the user table and db table to reflect the new user name.
     
    #4 bamasbest, Mar 17, 2004
(You must log in or sign up to post here.)
Loading...
Similar Threads - mySQL Database Owner
  1. BluePlanet

    New Thread Run a MySQL query on database on different cPanel account

    BluePlanet, Oct 19, 2018 at 9:35 AM, in forum: Database Discussion
    Replies:
    0
    Views:
    27
    BluePlanet
    Oct 19, 2018 at 9:35 AM
  2. steven_h

    The system failed to connect to the MySQL database issue

    steven_h, Sep 11, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    219
    steven_h
    Sep 18, 2018
  3. Daniel Enriquez

    Creating mysql databases with xmlapi.php issue

    Daniel Enriquez, Aug 21, 2018, in forum: cPanel Developers
    Replies:
    1
    Views:
    153
    cPanelMichael
    Aug 22, 2018
  4. Peter Sampson

    Using PHP to create Mysql databases issue

    Peter Sampson, Aug 21, 2018, in forum: cPanel Developers
    Replies:
    1
    Views:
    136
    cPanelMichael
    Aug 22, 2018
  5. ANOUCHKA MINKOUE OBAME

    SOLVED No File Manager or MySQL Databases Tools?

    ANOUCHKA MINKOUE OBAME, Jul 25, 2018, in forum: General Discussion
    Replies:
    5
    Views:
    191
    cPanelMichael
    Jul 25, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice