Mysql Disable INSERT Access To Specific User/table
How can I disable INSERT access to specific table.
The user should have full access the the DB except insert to specific table.
The tables_priv allow to set what enable and not what disable.
I'm using mysql v5
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
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
Disable Hotlinking FOR Specific Site
I have came across site in my statistics that apperantly runs with about 99% of my content flash files. He put adsense all around them, too - sneaky. I know it is possible to disable hotlinking from other sites using htaccess, but is it possible to disable hotlinking for ONE site? I need to block .swf that come from example.com domain.
View Replies!
View Related
Mysql Insert/Update Makes Apache Go Crazy
I run a wordpress blog with apache2+mysql5+php5 in a Debian vps with 1024mb ram (plus swap). When you read the website everything works quick and smooth, but when you have to add data to the database (edit posts, write posts, write comments) something weird happens. monitoring the system with the top and I see that, for example, as soon as an article has been posted (already got the "article posted" message in the page) the free ram goes suddenly down (some seconds) from 800mb to 0. Swapping starts and the website stops responding. in the meanwhile cpu "wa" goes high (90%++). Typing ps aux I can see that is not mysql process's fault, actually it seems more that it's apache to cause this ram hogging, in fact an apache restart brings back tons of free ram. this is my current my.cnf: Code: client] port= 3306 socket= /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # This was formally known as [safe_mysqld]. Both versions are currently parsed. [mysqld_safe] socket= /var/run/mysqld/mysqld.sock nice= 0 [mysqld] # # * Basic Settings # user= mysql pid-file= /var/run/mysqld/mysqld.pid socket= /var/run/mysqld/mysqld.sock port= 3306 basedir= /usr datadir= /var/lib/mysql tmpdir= /tmp language= /usr/share/mysql/english skip-external-locking # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address= 127.0.0.1 # # * Fine Tuning # myisam_sort_buffer_size=64M max_connect_errors=20 connect_timeout=15 interactive_timeout=100 join_buffer_size=1M sort_buffer_size=1M read_buffer_size=1M bulk_insert_buffer_size=16M key_buffer= 64M max_allowed_packet= 16M thread_stack= 128K thread_cache_size= 8 max_connections = 600 table_cache = 256 #thread_concurrency = 10 # # * Query Cache Configuration # query_cache_limit = 1M query_cache_size = 16M # # * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. #log= /var/log/mysql/mysql.log # # Error logging goes to syslog. This is a Debian improvement :) # # Here you can see queries with especially long duration #log_slow_queries= /var/log/mysql/mysql-slow.log #long_query_time = 2 #log-queries-not-using-indexes # # The following can be used as easy to replay backup logs or for replication. #server-id= 1 #log_bin= /var/log/mysql/mysql-bin.log # WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian! #expire_logs_days= 10 #max_binlog_size = 100M #binlog_do_db= include_database_name #binlog_ignore_db= include_database_name # # * BerkeleyDB # # Using BerkeleyDB is now discouraged as its support will cease in 5.1.12. skip-bdb # # * InnoDB # # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. # Read the manual for more InnoDB related options. There are many! # You might want to disable InnoDB to shrink the mysqld process by circa 100MB. skip-innodb # # * Security Features # # Read the manual, too, if you want chroot! # chroot = /var/lib/mysql/ # # For generating SSL certificates I recommend the OpenSSL GUI "tinyca". # # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem
View Replies!
View Related
Limiting Ssh User To Specific Folder
I may have this wrong, but I think it's possible. I have a friend who wants to run a process on one of my servers, now I don't particularly 'care' about this server, it's just used for a couple of unimportant things so I'm okay with him running it, but I don't want the hassle of sorting out things if he decides to delete everything, so I'm hoping it's possible to limit his directory. For example, I have the folder "people" in the top most directory, inside that I have "arthur", I want to limit the ssh user "arthur" to the folder "arthur", I don't want him to be able to cd ../../ and delete stuff, is this possible?
View Replies!
View Related
How Can I Give A Customer Access To His Specific Domain On Godaddy
I have an account on godaddy, with more than 20 domains registered and well, so far i have been in charge of the updates of these domains and the websites they represent. But now I have this customer who is asking me to have access to his specific domain so he can upload files by him self, the thing is that i dont have a clue of how to do it. I tried to create a new account in godaddy for this customer and tried to transfer this domain into his account and I was not allowed to. I cannot give him my username and psw cause he wont only have access to his website but all those i have registered under my account. I will really appreciate some advises to help me work this out.
View Replies!
View Related
MySQL Table Crashed
Table '231_message' is marked as crashed and should be repaired I haven't ever had this happen, is all my data truely lost or can i 'repair' it i was moving sites to a different server (VPS -> dedicated) and on the vps i have a max of 20gb storage, well as i was using the cpanel transfer it filled this up because it didnt have a warning about this (i dont accept blame ) either way it seemed at this time someone on my site tried to make an adjustment to the table and it crashed it since there wasnt room? i really need to get this fixed asap so I can properly move this site with a working database
View Replies!
View Related
Optimizing Large MySQL Table
I optimized a mysql table of 2 million records and about 500MB.. it took about 15 minutes.. However, on the same DB now i have another huge table of 88 million records, it size is 2.2 GB and it has about 30 MB to optimize... my questions.. 1.- How can I speed up the optimization process so it can take the less possible time? any tweaks to my.cnf? 2.- Should I repair it using phpmyadmin or just from the shell? 3.- Should I stop http traffic during this optimization? This is a dedicated db mysql server that handles a large VB forum with 5-8 users online average: Code: Intel Xeon 3.2 x4 procs, 32 bits, 4 GB ram /etc/my.cnf Code: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-locking skip-innodb skip-bdb query_cache_limit=1M query_cache_size=48M query_cache_type=1 max_connections=1200 interactive_timeout=100 wait_timeout=300 connect_timeout=10 thread_cache_size=128 key_buffer=48M join_buffer=8M max_allowed_packet=16M table_cache=2036 sort_buffer_size=1M read_buffer_size=1M read_rnd_buffer_size=2M max_connect_errors=10 # Try number of CPU's*2 for thread_concurrency thread_concurrency=4 myisam_sort_buffer_size=64M # Add max_heap_table_size = 48M tmp_table_size = 48M low_priority_updates=1 concurrent_insert=2 [mysqldump] quick max_allowed_packet=16M [mysql.server] user=mysql #basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid log-slow-queries=/var/log/slow-queries.log On the other side, i have the same hardware for the webserver..
View Replies!
View Related
Disable User 'nobody' From Sending Emails
In our quest to stop 'some' of the spamming techniques, I was wondering if there is a way to disable user 'nobody' from sending emails on either a domain or account level - rather than server-wide? Reason for asking is that I would like to allow 'nobody' emails to just a handfull of trusted clients that have never had problems.
View Replies!
View Related
How To Alter Tabel And Create Table In Mysql
I have a script and there are some modifications that I want to make In the instructions it says ALTER TABLE and CREATE TABLE in myqsl but I dont know exactly how to do this. I have tried to google but everything i find is very technical and doesnt explain the easiest way to do it. Should I use phpmyadmin or whats the correct way?
View Replies!
View Related
Mysql: Incorrect Key File For Table
I have a server with many db on mysql 5 Any db contains 5 table with data This data is processed by routine Many time routine die with the error: "Incorrect key file for table '/var/tmp/#sql_3018_0.MYI'; try to repair it" The table sql_3018_0.MYI not exist, think that this is refered to a temporary table but is deleted by process..
View Replies!
View Related
MYSQL Incorrect Key File For Table
what I can do about the following database error in mysql? Incorrect key file for table '/tmp/#sql_(number of table.MYI); try to repair it I've repaired, optimized and checked the database in phpmyadmin. Initially 2 tables were showing overhead, but the error message is for a temp table and I'm not sure how to try to repair a temp table.
View Replies!
View Related
IIS : Disable HTTP Access
I have a series of web services that are exposed to the world via IIS. The problem is I only want users to have HTTPS access to these. At the moment everything is working fine, however users can access services via HTTP (port 80) and HTTPS (port 443). Using the IIS manager I have attempted to remove port 80, however it will not allow me to do this. So the question is, how can I close of HTTP access within IIS?
View Replies!
View Related
Recommend A UK LAMP Host - With Some Specific Mysql Privilege Requirements
I have a moderately successful site, which makes enough money to cover my current hosting costs of 7 per month. I know, millionaire row it ain't, but it's popular. But my database is getting big and my current host wont allow the user of EXECUTE and SUPER privileges which I need to run triggers and stored procedures to keep the page load times sensible. So, I need another UK host with: - 2Gb of space (the site serves up big PDF documents) - 70Gb of bandwidth (I said they were big) - mysql privs available as above Customer service with my current host, uk web solutions, is great (apart from refusal to countenance the privileges) so I need my new host to be as good. Budget? well, you can see what I'm paying now, and I have a psychological £10/month barrier which I don't want to cross.
View Replies!
View Related
Disable Shell Access :: Users Can Read Files For Other Websites
i have a Dedicated server and i installed firewall and i fixed all cpanel option and i disable shell access for all users and ...... but my users can upload shell hack files (Like:c99 ) then they can access to another website ,,,, they can`t Write ,,, they can Read files only but there is a problem because the hacker will read the config files so my Database websites will hack soon
View Replies!
View Related
Single User Can't Access Any Site On My Server
I have a user who says he cannot get to any site on my server from either home or work. He has been a user for many years, and has never had any problems. He has also checked with his IT at work and they confirmed the site is not available. He is computer savvy, so I trust he is telling the truth. His work and home are only 10 miles apart. Do you guys have any ideas what could be happening? Is there a DNS entry wrong somewhere? He can't access the site even when putting in the IP address. There is one other user reporting something similar but other than that no other complaints. The site works fine for everyone else. site is gm-trucks.com
View Replies!
View Related
Giving Chrooted User Access To Mysqldump
I have a chrooted ftp user that I use on my server. I would like to run a cron job using this user that backs up my mySQL databases. When I execute the job, it complains about date and mysqldump not existing. I was able to fix the date problem simply by copying it from the actual /bin to the chrooted /bin. However, I can't simply copy mysqldump because it depends on several libraries. Anybody know how I can give this chrooted user access to commands that aren't in his chroot?
View Replies!
View Related
Cpanel Not Allowing Access To User Accounts
On a new server we have running CPanel, we have manually created a user account and when i try and log into mydomain.com/whm with that username/password it doesn't let me. Now my second thought is that I should be logging into mydomain.com/cpanel rather than mydomain.com/whm but I get a 404 for /cpanel. If i'm logged in as root, i cannot transfer into the user account cpanel either...
View Replies!
View Related
Access Denied For User 'root'@'localhost
I'm getting the error after running [root@server ~]# mysqladmin processlist Quote: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' I'm running plesk on FC4. Not too sure why it says failed or denied, as I'm root?
View Replies!
View Related
DirectAdmin - Access Denied For User 'apache'@'localhost' (using Password: NO)
I get the following error when let my site connect to my database: Access denied for user 'apache'@'localhost' (using password: NO) But when im running lil test script which connect to my localhost with the same passwords and it gives the status 'Connection OK' (im running on admin account, made a MySQL account with DA) Code: <?php $link = mysql_connect('localhost','admin_removed','removed'); if (!$link) { die('Could not connect to MySQL: ' . mysql_error()); } echo 'Connection OK'; mysql_close($link); ?>
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
Access RAM Memory & CPU Usage By User Files
I don't really now how this can be done, but as far as I can remember when I was in shared hosting, they always complaint about memory usage.... but they always know what specific files were cosing the most load on the server. So, I remember I have this count.php file that was constantly hited and the complaint and tell me exactly what file it was cosing the heavy load. This is just an example, but looks like they always knew the specific files that were cosing problems, so what the hell, this can be done! Now that I have my own server I would like to know these things as well, so I can know what files need to be optimized. I searched and searched and searched and... OK, you'll get the point, and I just HAVE NOT find any information on this. Can someone tell me this "secret"? What do you use to get the files that are cosing the most heavy load on a Linux server?
View Replies!
View Related
ERROR 1045 (28000): Access Denied For User 'root'@'localhost' (using Password: NO)
Im trying to setup a mysql server on my centos vps server. Ive installed mysql server and done chkconfig and the mysql server has started. My problems start when i want to set a mysql root password. Quote: mysqladmin -u root password yourrootsqlpassword mysqladmin -h server1.example.com -u root password yourrootsqlpassword I get an error "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)" Which i totally dont understand because why would it want a password when im trying to set the password?
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
How To Permanently Disable Http/ftp/mysql/courier With LXADMIN/KLAXO
I have a small VPS that is used only to send mail. It uses the HyperVM software, so I installed "Klaxo" (LXadmin) on it and set up the domain, etc.. I then went into the "Server : Linux --> Services" page and disabled everything except qmail. (I also set them so they are not auto-started at bootup.) The problem is that after about 10 minutes or so... all the services are automatically restarted. I have no idea what process is doing this, and it's driving me a little nutty. Does anyone know how to permanently disable a service using the Klaxo/lxadmin control panel? (Or at least, where I can find whatever monitoring system is checking if they are up, and then restarting them?)
View Replies!
View Related
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
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
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
Media Change: Please Insert The Disc Labeled
I just bought a new dedicated server, and when I try to apt-get something (anything like, bzip2, build-essential) I get this error: Quote: Media change: please insert the disc labeled 'Debian GNU/Linux 5.0.0 _Lenny_ - Official i386 CD Binary-1 20090214-16:29' in the drive '/cdrom/' and press enter I mean it's pretty self-explanatory, but seeing as how I can't put the CD in, because the box is not here, I have no clue what I'm supposed to do. I've had a couple VPS's before, and never encountered this problem. I'm running Debian 5.0 stable.
View Replies!
View Related
What Do I Insert Under DNS In My Registrar's Domain Options
I was able to finally set up a dedicated server, and now I'm finallly off to the easier stuff. Two quick questions: 1) How do I make it so my domain name takes me to my server's address? You know, just like how shared hosts give you the nice little DNS addresses that make everything magically work. I could just forward the domain to my server's IP, though that would not display the domain name in every page, the way it's supposed to be. 2) When I visit my server's IP, it gives me the apache welcome screen saying everything was successfully installed. That page is locaed under /var/www/apache2-default. I find that "var" directory a bit strange, is it supposed to be there? And more importantly, when I add the real stuff I want on my site, should it all go under the "apache2-default" directory? It seems to be set as the default home page dir, right?
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
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
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 Replies!
View Related
MySQL DB Access Allowed? Are There Any?
For window hosting are there any that offers sql db external access without ip limit? I've seriously requested thought the forums and actually signed up with few but all of em are either offered it but not anymore(security issue) or not even offering at all. If you have any experience with hosting company that actually does offer sql db external access please share please! vps nor dedicated servers are not my choice unfortunatley and i don't think there's any free hosting that offers this. 99% freehostings use localhost
View Replies!
View Related
Mysql Access Denied
I've setup a mysql user and assigned a password for it. When I try logging in to it with Quote: mysql -u USERNAME -p and then providing the password I get an error: Quote: ERROR 1045 (28000): Access denied for user 'USERNAME'@'localhost' (using password: YES) I don't have trouble logging in as root and when I check the user table there, the password assigned to the user is same as the value the mysql function PASSWORD gives me. Really driving me nuts here, why is it telling me the password is wrong when it's not? I've tried: Restarting mysql setting new password changing username Using mysql server 5.1.34
View Replies!
View Related
Mysql Account Access
I run a shared hosting OS:centos with whm/cpanel and would like to restrict access to mysql database example: username:user1 created database:user1_db1,user1_db2 etc.. and can only access his own databases so user2 can't access user1_db1.db2 etc.. and user1 can't access user2_db1,db2 etc..
View Replies!
View Related
Allow Remote Mysql Access
I have a Ubuntu Lamp server setup in my building which is used for development purposes. So I also have phpmyadmin setup and am using a Mysql Query browser and Mysql Administrator desktop programs to administor the database on the server. However I am not able to connect to the server from my desktop. I am able to login to my myphpadmin but not able to login via the Mysql Query Browser program. Hopwing someone can help. I have read about port forwarding and also read a post about editing the my.cnf file on the server and changing the Bind-Address= 127.0.0.1 to the actual hostname but before I start editing the actual configuration files on the server I want to see if their is another way as I am worried that if I change the me.conf file that the phpmyadmin may stop working?
View Replies!
View Related
|
TRACKER
