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 User Permissions Problem

Discussion in 'General Discussion' started by procam, Jun 4, 2008.

  1. procam

    procam Well-Known Member

    Nov 24, 2003
    Likes Received:
    Trophy Points:
    I have a serious problem with a mysql user on one of my boxes , this user exists created by me for the purpose of a script operating on other multiple remote boxes the script runs by cron and uses this mysql user name to login drop a table from a database on multiple sites and then copy the table from the origination site to the database.
    So heres the problem each night when cpanel updates on this newly rebuilt server, {its a fresh os install nuff said} it modifies this users ability to create tables i.e. it removes the permission settings so each morning I have to login and reset that user to ALL permissions again or when my scripts run they login drop the tables and fail to copy the data to the sites on this unit thus leaving me with websites with missing data base information.
    How can I stop or lock this users permissions so nothing cpanel does can remove my existing permission settings -- and does anyone know WHY all the sudden this is happening Ive been running things this way for oh about 5 years now and all the sudden on this new build the problem happens.
    Oh and I did narrow it down to cpanel because if I run a /scripts/upcp --force all the sudden my permissions are revoked.
    #1 procam, Jun 4, 2008
    Last edited: Jun 4, 2008
  2. viraj

    viraj Well-Known Member

    Sep 28, 2006
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    DataCenter Provider
    When upcp is run manually or automatically every night, it resets the permissions of the MySQL users on their respective databases. I've seen this problem mysqlf, it's rather a bug, which I think will be fixed in the next release. Or did you try updating the version of the control panel to the latest one released few days back ? If yes, & you still do have the same problem, I'd recommend you to open up a ticket with cPanel Support for further investigation.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Commrade

    Commrade Member

    Feb 19, 2006
    Likes Received:
    Trophy Points:

    Which version of WHM /CPanel are you in If not in Relase version Please update the whm to the release version and then later try to run /scripts/upcp and then try /scripts/mysqlup to update mysql

    Please try to check out if this helps.

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.
    Dismiss Notice