[Cpanel::Mysql]: Not Updating Privileges
Apr 11, 2008
On a cPanel server, running RHEL 4 I got the following error (from cpanel logs) while associating an user with a DB from the cPanel admin:
Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 268
Cpanel::Mysql::updateprivs('Cpanel::Mysql=HASH(0xa4a8768)') called at /usr/local/cpanel/bin/mysqladmin line 88
Fri Apr 11 17:02:47 2008 info [Cpanel::Mysql]: Not updating privileges for user (reseller login and no password specified in ~/.my.cnf) at /usr/local/cpanel/Cpanel/Mysql.pm line 268
In fact, from cPanel interface all privileges are added OK, but the MySQL itself is not connecting at all due to this error.
I already tried:
/scripts/mysqlup --force
/scripts/upcp --force
/usr/bin/mysql_fix_privilege_tables -u root --password=PASSWORD
View 2 Replies
ADVERTISEMENT
Aug 26, 2007
how do i backup mysql user privileges?
this will only backup the databases:
mysqldump --opt -u root -p --all-databases > data.sql
i would like to backup mysql user privileges too.
View 1 Replies
View Related
Jul 3, 2014
I'd want to create a user and set custom privileges using the standard mysql-client, ie. create user and grant privileges, but I know that sometimes Plesk overwrites my config files for other services.
View 2 Replies
View Related
Feb 16, 2015
I need a MySQL user that has the privileges to add routines and triggers. The default users that are created by Plesk do not have these rights. How would I be able to add these rights to a specific user, or all users, that doesn't care.
I already logged in over SSH as a root user:
Code:
mysql -uadmin -p`cat /etc/psa/.psa.shadow`
Then I tried to update the rights of the users:
Code:
mysql >UPDATE db SET Create_view_priv = 'Y', Show_view_priv = 'Y', Create_routine_priv = 'Y', Alter_routine_priv = 'Y';
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
This didn't work. So I wanted to add super privileges by doing this:
Code:
mysql> GRANT SUPER ON *.* TO 'user'@'%' IDENTIFIED BY 'mypassword';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
But also not of any effect. What's left to do?
View 4 Replies
View Related
Aug 5, 2008
i would like to update my CentOS Linux 5 but i don't want to update mysql and apache i need to use mysql 4. When i entered yum update i can see Total download size: 245 M i can see mysql i386 5.0.45-7.el5 base 4.1 M
how can update my server without updating mysql and apache
View 5 Replies
View Related
Jun 24, 2008
I can't seem to solve, perhaps you could give me some pointers or tips on how to fix this.
All the cPanel stats programs (Awstats etc..) haven't been updated since the 17th June but when I login to WHM it says the stats have been updated (within the past 24 hours).
On the 17th June I moved my hosting operations from the USA to the UK onto a new webserver.
How can I make sure these statistic programs are updated and shown from cPanel, even though I can tell it to update via SSH (completes) and claims in WHM with no problems (updated with in 24 hours), the new stats still fail to appear.
View 5 Replies
View Related
Oct 19, 2007
I have a server from ServerBeach Linux Powerline 2600. CentOS5.
It even has webmin on it.
But this is what I'm trying to do, trying to add a user so the user can use apache/php/mysql/cron and cannot look into other directories like /etc
SB is taking sometime, so I thought to post here as well.
I know it's a linux admin thing, but I'd like to get some quick help as well..
View 12 Replies
View Related
Feb 3, 2015
I'm trying to set permission for text file which is exists in Program Files (x86)MyFile directory. File should be accessible by psaadm and not accessible for psacln accounts. I've set permissions for psaadm Full Control Allow and for psacln Full Control Deny.
In my PHP script I'm checking file using is_readable function and no matter which user trying to read this file function always returns true (admin or customer account). I tried to find solution in Web but without success so I'd like to ask you about it.
Additionally, I've tried to create Plesk DiskSecurity XML with privileges settings. After Apply this settings privileges are correctly set for my file, but customers still can read this file.
Is there any other way to deny access to this file for customers and resellers?
View 2 Replies
View Related
Aug 4, 2008
I have a software program on my home PC that writes to files on my remote VPS every few minutes.
The only way I can accomplish this is to CHMOD the files to 777 and give the whole world write priveledges.
Is there a way I can give my external (home) IP address write priveledges to certain files on my VPS without CHMODing them as 777?
I run the latest version of cPanel and WHM on my VPS.
View 6 Replies
View Related
Sep 1, 2013
I recently upgraded the Plesk to 11.5.30. Now I am not able to create new MySQL databases. I am getting below error.
Code:
Error: Connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user 'admin'@'localhost' (using password: YES)
MySQL admin details are correct in plesk database, also the admin has full privileges. I am manually able to create databases, users from mysql prompt. It's just the plesk interface that's giving error.
Code:
C:Program Files (x86)ParallelsPleskMySQLbin>mysql -u admin -p*************** mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 68
Server version: 5.1.68-community MySQL Community Server (GPL)
[Code] .....
View 4 Replies
View Related
Jun 12, 2008
I recently had Fantastico update issues, my fantistico was giving me errors such as "This feature is currently not availabel, please contact your host." lol
I tried lodging a CRON job to do the update ...but waited 72 hours and nothing ! lol
Later i found our that the Fantastico licensing server was down for a while lol
Any one had this issue lately ... ?
View 6 Replies
View Related
Feb 10, 2009
i just installed rpmforge repo and updated the my vps everything went fine now every thing is fine exept ftp i have tried both pure-ftp and pro-ftp both are not workingh the port 21 is used by xinetd i am not able to find out what to due the ftp installs successfully but after installations is done it give Failed on restarting stopping or starting
WHat can i do to remove this i used the status command to
/etc/init.d/pureftpd status
Pureftpd is dead
this is what i got
Pro-ftpd gives error unable to bind ip at port 21
View 6 Replies
View Related
