Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Nov 2003
    Posts
    129

    Default Mysql User Permissions Problem

    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.
    Last edited by procam; 06-04-2008 at 02:03 PM.

  2. #2
    Member viraj's Avatar
    Join Date
    Sep 2006
    Location
    India
    Posts
    209
    cPanel/Enkompass Access Level

    DataCenter Provider

    Exclamation

    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.

  3. #3
    Member Commrade's Avatar
    Join Date
    Feb 2006
    Posts
    9

    Default

    Hello,

    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.

Similar Threads & Tags
Similar threads

  1. MySQL Forgetting User Permissions
    By leighj in forum cPanel and WHM Discussions
    Replies: 6
    Last Post: 07-03-2007, 07:46 PM
  2. MySQL User problem
    By mickalo in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 11-23-2006, 07:36 AM
  3. MySql User Creation Problem
    By odtufatih in forum Database Discussions
    Replies: 2
    Last Post: 04-26-2005, 05:07 AM
  4. cpbackup changes permissions to user.user just on homedir
    By 0utlier in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 10-24-2004, 06:55 AM
  5. MySQL User Permissions
    By justhost in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 10-04-2003, 02:46 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube