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.

How to know mysql user creation date?

Discussion in 'Database Discussions' started by capoinfra, Aug 25, 2013.

  1. capoinfra

    capoinfra Well-Known Member

    Joined:
    Oct 25, 2007
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    Uruguay
    Hello,

    Is there a way to know the creation date of the mysql users?

    Thanks!
     
    #1 capoinfra, Aug 25, 2013
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    I am not aware of any method to track when a MySQL username has been created. You could browse the cPanel access log (/usr/local/cpanel/logs/access_log) to see when the MySQL option was accessed by a user in cPanel. However, there is no log that lists the specific creation date for MySQL usernames. Is there a specific reason you require this information?

    Thank you.
     
    #2 cPanelMichael, Aug 26, 2013
  3. capoinfra

    capoinfra Well-Known Member

    Joined:
    Oct 25, 2007
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    66
    Location:
    Uruguay
    Hello Michael,

    I need to know about a user that was not created for me.

    Thank you.-
     
    #3 capoinfra, Aug 26, 2013
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    You can review active MySQL usernames under the "MySQL Databases" option in cPanel. There are no log files that will tell you when the MySQL username was created.

    Thank you.
     
    #4 cPanelMichael, Aug 26, 2013
(You must log in or sign up to post here.)
Loading...
Similar Threads - mysql user creation
  1. sidgrafix

    SOLVED mysqldump fails for non-root shell user

    sidgrafix, Aug 1, 2017, in forum: Database Discussions
    Replies:
    5
    Views:
    79
    cPanelMichael
    Aug 1, 2017
  2. Souther

    MySQL Profiles: user app migration to using remote server

    Souther, Jun 21, 2017, in forum: Database Discussions
    Replies:
    6
    Views:
    167
    Souther
    Jun 22, 2017
  3. Terry Bogard

    Mysql error : Access denied for user '[cpaneluser]'@'localhost' (using password: NO)

    Terry Bogard, May 8, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    358
    cPanelMichael
    May 9, 2017
  4. MarkoTitel

    SOLVED Account restoration mysql username too long

    MarkoTitel, Apr 17, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    283
    MarkoTitel
    Apr 19, 2017
  5. qtriangle

    Connecting to external MySQL db: "ERROR 1045 (28000): Access denied for user"

    qtriangle, Feb 26, 2017, in forum: Database Discussions
    Replies:
    5
    Views:
    755
    cPanelMichael
    Feb 28, 2017

Share This Page