The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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. osirion

    MySQL Database Restoration from Full Backup

    osirion, Jun 14, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    53
    cPanelMichael
    Jun 14, 2017
  2. akash7130

    Import database in mysql?

    akash7130, May 19, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    85
    cPanelMichael
    May 22, 2017
  3. raafat1994

    Problem with MySQL database

    raafat1994, May 3, 2017, in forum: Database Discussions
    Replies:
    2
    Views:
    119
    cPanelMichael
    May 4, 2017
  4. brianmp1

    Switch to Remote MySQL Database

    brianmp1, Mar 3, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    398
    cPanelMichael
    May 8, 2017
  5. copernic2006

    Converting RoundCube database from MySQL to SQLite question

    copernic2006, Feb 28, 2017, in forum: E-mail Discussions
    Replies:
    2
    Views:
    233
    cPanelMichael
    Feb 28, 2017

Share This Page