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.

SOLVED Deprecated MySQL databases

Discussion in 'Database Discussions' started by Nirjonadda, Jan 6, 2017.

Tags:
  1. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    418
    Likes Received:
    10
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    I am Getting email when doing update WHM 62.0 (build 1). Please let me know that how to remove this databases?

    Code:
    Deprecated MySQL databases
        
    
    The following MySQL databases have been deprecated and are no longer used by cPanel & WHM.
    Database Name : Database Username
    leechprotect  :   leechprotect
    modsec  :   modsec
    
    You can delete these databases and related database users at your leisure.
    This notice is the result of a request from “database_deprecations”. 
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    This is documented with the following entries in the cPanel Version 62 Release Notes:

    Information on how to delete a database is available at:

    How to Delete a MySQL Database - cPanel Knowledge Base - cPanel Documentation

    Let us know if you have any additional questions.

    Thanks!
     
    linux4me2 likes this.
  3. popeye

    popeye Well-Known Member

    Joined:
    May 23, 2013
    Messages:
    330
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    So can you just leave this alone or does it have to be removed?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    The notifications will stop once the database is removed. The existence of the database username won't result in continued notifications, however you can still remove the database users manually.

    Thank you.
     
  5. pearirha

    pearirha Registered

    Joined:
    Feb 7, 2017
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Indonesia
    cPanel Access Level:
    Root Administrator
  6. webhostuk

    webhostuk Well-Known Member

    Joined:
    Sep 11, 2013
    Messages:
    112
    Likes Received:
    11
    Trophy Points:
    18
    cPanel Access Level:
    Website Owner
    No it wont affect other databases or sites.
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    The previous post is accurate. Removing those databases will not alter or remove any other databases on the system.

    Thanks!
     
  8. WorkinOnIt

    WorkinOnIt Well-Known Member

    Joined:
    Aug 3, 2016
    Messages:
    113
    Likes Received:
    7
    Trophy Points:
    18
    Location:
    UK
    cPanel Access Level:
    Root Administrator
    Could you please clarify something - where does modsec now store the hits/entries? When I look at my modsec database, it is full of the most recent hits - I am not clear where it will store the hits info if I delete modsec database.

    "ModSecurity™ Tools) interface to use SQLite."

    What is SQLite and where can I find it in my database to check / view hits?

    Thanks
     
  9. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
  10. alpinist

    alpinist Member

    Joined:
    Jun 9, 2011
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    The documentation for How to Delete a MySQL Database only includes instructions using phpMyAdmin. I've received the deprecated database notifications for my DNSONLY servers, which do not have phpMyAdmin installed. How do I delete those databases?
     
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    The top answer on the following URL explains how to do this via the command line:

    How do I remove a MySQL database?

    Thank you.
     
  12. WorkinOnIt

    WorkinOnIt Well-Known Member

    Joined:
    Aug 3, 2016
    Messages:
    113
    Likes Received:
    7
    Trophy Points:
    18
    Location:
    UK
    cPanel Access Level:
    Root Administrator

    Thanks for your reply - but I'm not clear - are you suggesting I need to install something to access the data?

    At the moment, I just look through the server logs. Will that change?
     
  13. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    You can still find Mod_Security entries in the Apache logs. The information stored in the database is sometimes used for the purpose of third-party applications, in which case the following WHM API 1 function is still applicable:

    WHM API 1 Functions - modsec_get_log - Software Development Kit - cPanel Documentation

    Thank you.
     
Loading...

Share This Page