Granting MySQL Command Line Permissions To A User
Is there any safe way to grant command line permissions to a user/specific account? One that only allows them access to databases on their account.
The problem is that this user intermittently runs queries that cause their database to hang (including PHPMyAdmin, so they can't view the processlist through there), and I have to manually kill that process, because they can't.
Server is 2.4.21 with MySQL 4.0.27, admin is cPanel WHM.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
MySQL Forgetting User Permissions
Does anyone know what could be the cause of this issue? I located a few others over at cpanel.net that have this problem, but no solution has been found. [url] I am running a VPS server with the following: WHM 10.8.0 cPanel 10.9.1-S14304 RedHat 9 i686 - WHM X v3.1.0 phpMyAdmin - 2.9.0.2 MySQL client version: 4.1.10 mysql version: 5.0.27-standard I have a database user that needs "Super Privileges" and so this was done. However, when Cpanel is updated the user permission is reset automatically from "ALL PRIVILEGES" to "USAGE". Here's a look at the database permissions from phpMyAdmin. Code: User Host Password Global privileges Grant hello localhost Yes ALL PRIVILEGES Yes hello_ % No ALL PRIVILEGES Yes hello_ localhost No ALL PRIVILEGES Yes The user "hello" loses its "ALL PRIVILEGES" and switches over to "USAGE" if an update is triggered. Updates to cpanel, creating/removing a database/user, and updating the account password will cause the switch.
View Replies!
View Related
What Are Common MySQL User Permissions
I want to use something like PHPBB forums and using one MySQL user and database. Just wondering, what are common user permissions I should set for the user? I want to try to minimize any permissions that can cause big risk to the server security. Here is a full list of permissions I can grant to the user (via Webmin): -Select table data -Insert table data -Update table data -Delete table data -Create tables -Drop tables -Grant privileges -Reference operations -Manage indexes -Alter tables -Create temp tables -Lock tables
View Replies!
View Related
Zip From Command Line
Im trying to zip up an sqlite database backup. I execute this command Code: zip ../d/db/backup.zip ../d/db/09-02-15.sqlite backup.zip never appears. Instead, I get some random filename in the directory. Like ziOHokOw If I try to zip a smaller file(last weeks backup) everything runs fine? Code: zip ../d/db/backup.zip ../d/db/09-02-08.sqlite So the 134mb file zips fine, but the 200mb one seems like its failing and im left with some type of temporary file. I tried downloading the weird filename and unzipping it. It has partial info like directory structure, the filename but the actual file inside is corrupt.
View Replies!
View Related
Ip Adjustment Via Command Line
Got a centos / cpanel box. Had to change the block of IP's with an entirely new block of 8. Problem is I cannot access cpanel/whm due to this, but only via ssh. If I run the below, it shows the old IP's /etc/init.d/ipaliases start How do I replace the old block with the new? I've never done it via command line before.
View Replies!
View Related
Command Line On Shared Hosting
I have been looking around for a new shared host, I am currently with GoDaddy =( And it would be helpful to have command line access for some things I am trying to do. Particularly with Zend Gdata API (which GoDaddy has trouble with anyway) Is this reasonable to ask for? I also need at least 150GB/month bandwidth for some relatively high quality streaming video.
View Replies!
View Related
Website Backup Over Command Line
We have a dedicated server, with chroot access enabled. We are wanting to backup each site on this server, as well as all mysql dbs on a weekly basis. Is it possible for us to run a cron job to do this? If so, what commands would we want to use? We have a local FTP server here, so would like to ftp these backups this machine. I know it all sounds a little vague, but I just need to know where to get started.
View Replies!
View Related
How To Detect Raid Harddisk Specs From Command Line
how can i remotly( SSH) figure out what kind of raid controller is on my system?! and how many harddisks my system has and what size?! I am working on Linux( Centos4) if i do #df -h then i get 146 G so if my system has raid1, does it mean that the harddisk is 2 X 146 G? or i should actually see it as 146 / 2?
View Replies!
View Related
Live Traffic View By VPS (or IP) Via Command Line
Back in the day, there was a commandline version of 'ntop' allowing a view of live traffic stats in the format of 'top'. Does a similar tool exist today effectively allowing us to figure our which VPS or IP address is under DDoS attack? The only way I could fix this was via KVM access to netstat -an | grep etc... Not too
View Replies!
View Related
BackupPC Restoring Files Without GUI Or Command Line
I got our server staff to install BackupPC on our dedicated server and run daily backups. All is well (from what I can tell) but i've come to a point where I want to actually use an archived file. So I jump into my ftp client, navigate to the backup folder, and download the file. The problem is, the file reads as jibberish. I'm assuming that BackupPC has compressed it. So the question is two-fold: 1. How do I decompress it on windows (command line stuff is well beyond me) 2. Is there any browser/windows apps that I can use to manage the backups?
View Replies!
View Related
Clear A Specific Email Account In Cpanel Or A Command Line Way
I just recently logged into my user email account "the one which was created by the name of the user of the account" and found it had 8000 emails but none are showing up in either horde or squirrelmail. How can i delete all these emails without deleting the other bla@domain.com emails? Is there a way just to clear a specific email account in cpanel or a command line way. I think if i just delete the mail folder it would kill all the emails of that account and I just want to 'reset' that one.
View Replies!
View Related
ERROR 1044 (42000) At Line 15: Access Denied For User
My server is new from SoftLayer when i try to restore Data Base He Give Me this Massege ERROR 1044 (42000) at line 15: Access denied for user 'mov_uu'@'localhost' to database 'mav2' i try to restore another data base he give Also A masseges ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near And i have Upload Center It Was Work 100% Suddenly He give me Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request ------------------ also Warning: Unknown: failed to open stream: Permission denied in Unknown on line 0 Fatal error: Unknown: Failed opening required '/home/nameofuser/public_html/vb/index.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in Unknown on line 0
View Replies!
View Related
Rsync Backup - User Permissions
I have a problem with my rsync backup First of all my setup is thus: I have a Linux box at the office which has an rsync cron on it which pulls from my web server as a backup. It pulls websites, mysql, conf files etc. My web server is running debian etch LAMP etc. When I originally set it up I used root user to log into the web server, and setup keys to authenticate, this worked perfectly. I then decided that having direct root access to the web server was a bad thing so I have turned off root login (PermitRootLogin no in sshd_config) I then setup a backup user which works fine for the website files but fails on permissions for the mysql data files (/var/lib/mysql) How can I get over this without granting root access to the backup user which would defeat the object of not allowing root access. I have been told about host authentication based on ip address but I have dynamic address at the office so that would be no good
View Replies!
View Related
Upgrading To VPS - User And Group Permissions
I've finally made the leap to upgrading from shared hosting to a VPS. I'm still setting up my configuration before I point the domain name to my new server, but for now, I have the site mirrored and I'm ensuring that all is running well. For the most part, everything is working, but I am running into a few permission issues... As of right now, all the files in my htdocs directory are owned by root, and I am logging into my FTP client as root. However, I'm pretty sure that this is not how I should be doing this, because I need to allow write permissions to some folders from my php scripts. I was just curious, how do you you guys set up the users and groups on your linux servers (running apache). I'm just not certain of the best way to handle it. Should I make a new FTP user, and if so, what group should it go in? Should that user be the owner of all the web files? When is it safe to set folder permissions to 777?
View Replies!
View Related
How To Edit FTP User Permissions On A CPanel Account
My Pink Floyd website has a photo section of rare concert pictures that our members upload. We have about 3,000 of these pictures, that our members upload via an FTP server that is hosted on a simple cPanel web hosting account. Someone logged into the account and not only deleted all the pictures, but uploaded obscene pictures and index.html files to some really nasty stuff. We delete all the obscene stuff, but before we re-upload all the pictures I need to know... On a cPanel account is there a way to have the FTP User only able to upload files and not edit/delete/change? Somehow we can edit their permission? I asked HostGator about this and the ChatTech said this cannot be done, and I was a bit surprised. I could easily do this on my own server, but i'm not sure where to start at the user level.
View Replies!
View Related
ERROR 1044 (42000) At Line 21: Access Denied For User 'umar_cs'@'localhost' To Data
in ssh i try create new database root@server1 [~]# mysql -uumar_cs -ppassword umar_cs </home/umar/public_html/localhost.sql it is show direct ERROR 1044 (42000) at line 21: Access denied for user 'umar_cs'@'localhost' to database 'umar_cs' i try from script same message i think maybe the problem from the size in this file /etc/my.conf set-variable = max_connections=500 i change to set-variable = max_connections=500M and restart mysql and i try create same problem!
View Replies!
View Related
SCM Command? MySQL Won't Start
What command could I use to see all the currently running services on my Windows (vista) computer? I'm trying to start my MySQL server, but it won't start. I think I know what the problem is though I'm not sure. I think that the service name "MySQL" is already running...and I need to remove it or something. Btw...my apache and php is fine. Though...I cannot use my MySQL from php obviously...since it's not running.
View Replies!
View Related
Mysql/user Is Marked As Crashed
I am trying to start mysql but i am getting the following error MySQL manager or server PID file could not be found! [FAILED] Starting MySQL................................... [FAILED] I checked my hostname.err file in /var/lib/mysql and this is the error message it shows. 070130 17:59:41 mysqld started 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 mysqld ended how I would repair that to get mysql to start again?
View Replies!
View Related
MySQL Replication For User On Shared Server
I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this. I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to: 1. execute: GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa'; [url] 2. Stop mysql server and Add in my.cnf: [mysqld] log-bin=mysql-bin server-id=1 slave-compressed=1 binlog-do-db=user_main start server[url] 3. execute: SHOW MASTER STATUS; we need values of colomns File and Position from output of above command[url] So my questions are: Is there any security risk? Is there significant extra resource usage? Is this even done on shared environments?
View Replies!
View Related
Mysql User Privilege Changed By Cpanel Or What
I am using Cpanel. One Cpanel account is backup. I use it to backup my database. Under mysql, I gave this account ( backup ) many priviledges. But when the backup script ran, error said that backup account can not 'lock table'. I gave "lock table' priviledge again and run the script, it is ok. But after a while, when the script ran autmatically on daily basis, it lost the 'lock table' priviledge again. I wonder if Cpanel is messing me up? What can I do about it? anyone knows?
View Replies!
View Related
MySQL: Access Denied For Root User
When I deleted a database, the user apparently was orphaned because when I tried to recreate it, it returned "user already exists". I've never encountered that problem although from Googling, I see others have and they delete the user to get around it. When I log into mysql using the da_admin@ account and attempt to remove the user with drop user <user_name>; I receive the following error message: ERROR 1227 (42000): Access denied; you need the CREATE USER privilege for this operation It seems I don't have rights even as the root user. How can I get remove the orphaned user?
View Replies!
View Related
Weird MySQL: User/pass Stops Working After A While
I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each. Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem. Also on the server we have Fantastico.
View Replies!
View Related
Command To Stop The Wget Command
Is there a command i can type into the ssh console to stop a current transfer that i started wit the wget command? the file im wgeting always stuffs up at 51% but then the server just retries and starts again, its done it 3 times so far and i just want to completely cancle the process if possible....
View Replies!
View Related
1Gbps Dedicated Line What Does That Mean?
I do not understand what network: 5 mbps and the traffic 1Gbps mean ========= CPU Intel Core2-Duo E4500 2.2GHz-FSB 800MHz -L2 2MB RAM DDR2 PC2-5300 (667Mhz) 2GB HDD SATA2 250GB (7,200rpm) LANcard Intel PRO/1000 PF Server Adapter Rack Type 1U (4.5cm) Network: 5Mbps Traffic 1Gbps Dedicated Line =======
View Replies!
View Related
Security Question Regarding T1 Line ..
This is our setup: We have two locations about 120 miles apart. We have direct connection with a T1 line. My question: How much safer is our data passing through the same T1 everyone else is using. Most people sending data through the same T1 line are using ISP, so are safer by not using an ISP? .........
View Replies!
View Related
Linux Get Last Line Of Output
What command could I use to get the last line of an output? Heres why... I use this command: netstat -plan|grep :80|awk {'print $5'}|cut -d: -f 1|sort|uniq -c|sort -nk 1 I would like to get just the last line of the output, the output looks like this: 1 203.118.105.* 1 80.195.165.* 1 87.211.51.* 1 91.40.90.* 8 82.2.222.* 213 The reason is because I'd like to get that last figure to place into a file on a certain time period (through a cron), which will then be graphed with PHP.
View Replies!
View Related
Trixbox Server Line
if anybody in the community looks for trixbox as the os to be installed on a dedicated server. I am looking for a new line of servers to provide and i am thinking that Trixbox could be one of them.
View Replies!
View Related
If There's 2 Ethernet Line, How Will The Traffic Be Like
I've a rack in the datacentre, and actually sharing the ethernet line with another partner's rack. Something like: Bandwidth -> Switch 1 -> Switch 2 (partner's rack) Bandwidth -> Switch 1 -> Switch 3 (my rack) After a previous uplinks issue, i'm never able to hit above 4Mbps of download speed to my home's cable broadband anymore. I have no idea whether it's because my partner capped my bandwidth from Switch 1, or his usage has increased such that it's affecting my traffic too. I can't be too concerned about it with him, as he's paying the bulk of the bandwidth costs. For the whole rack, i'm not able to hit above 5Mbps accumulatively, and my normal bandwidth usage is only about 1-2Mbps. So i'm thinking of getting another line for bandwidth directly from the datacentre to my Switch 3, perhaps starting from just 1-2Mbps only. How will things improve? Just a silly thought, whether my total available bandwidth can now be 5Mbps + 2Mbps = 7Mbps.
View Replies!
View Related
|
TRACKER
