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!
  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. Shishupal Kumar

    How to Create Mysql Database using SSH in WHM

    Shishupal Kumar, Mar 12, 2018, in forum: Database Discussions
    Replies:
    5
    Views:
    158
    cPanelMichael
    Mar 15, 2018
  2. Luis Gil

    Database error, Can't connect to local MySQL server through socket

    Luis Gil, Feb 13, 2018, in forum: Database Discussions
    Replies:
    3
    Views:
    269
    Luis Gil
    Feb 15, 2018
  3. VJIADIS

    mysql databases (only) backup

    VJIADIS, Jan 18, 2018, in forum: Data Protection
    Replies:
    1
    Views:
    237
    cPanelMichael
    Jan 19, 2018
  4. coffeeboyuk

    unable to create a database from mysql command line

    coffeeboyuk, Nov 16, 2017, in forum: Database Discussions
    Replies:
    17
    Views:
    739
    coffeeboyuk
    Dec 5, 2017
  5. Sametto Chan

    MySQL Database crashed/CPU higher on server to down

    Sametto Chan, Oct 21, 2017, in forum: Workarounds and Optimization
    Replies:
    10
    Views:
    641
    Sametto Chan
    Oct 26, 2017

Share This Page