Set Limits
When I was on a shared server I used to manage (access, edit, etc.) my databases with phpMyAdmin
Now, on a dedicated server I am the super-user trying to get the same.
Under "privileges" I can create new users (for a virtual server)
If I check (allow) any of the global privileges he will see and browse ALL existing databases.
The only way I see to avoid this is only to set privileges to some existing databases.
A new user would want to create new ones to start his project not to use existing ones.
How can I set wide privileges to a user keeping visible only his databases?
Limit number of databases?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Row Limits
SELECT JID, JState, JClass, JClass2, JTitle FROM JPosts WHERE `JobClass` ='Designers' ORDER BY JTitle, JState With this giving many results per state: a) how can the results be limited to 2 rows per JState? b) how to limit to 2 of the same JClass2 per JState (where JState still has 2 row maximum also) notes: JTitle is a job title JClass2 is a 2nd type class, here it could be 'Floor_Designers'
View Replies !
View Related
About Limits
I have 256 databases with around 30k tables in them (running a bloggind service). I've been using tuning-primer.sh for sometime now and I've been trying to edit some settings as recommended. So far so good, except 2 limits that are being ignored. Open_files_limit is stuck at 65535, no matter what I set it in my.cnf Table cache is stuck at 32712, no matter what number I try to set higher that that. I am using CentOS 5.2 64bit, with WHM/Cpanel. Using Mysql 5 and PHP 5. I've tried using ulimit -n, but once I logout it resets back to 1024.
View Replies !
View Related
Selecting And Limits
I Have SELECT * FROM authors WHERE auth_id = $auth_id LIMIT 1 and that does exactly what it is supposed to do BUT, perhaps I wanted to select everything EXCEPT the first result? How would I filter that one out?
View Replies !
View Related
Mysql Limits ?
I have a site i am working on that uses a Mysql database for a forum. However I would like to have a site search function as well. is it possible to use a Mysql database for more than one task?
View Replies !
View Related
Subqueries And LIMITs...
I want to display a subset of data from another query... Basically I've got 3 tables which are all joined together in a query... Lets say I have 300 results rows displayed from that query. Is there a way I can then limit those results without effecting the original query (I still need to be able to pull all the results as well) I've tried (and it didn't work)... Quote: SELECT * FROM products, manufacturers, brands WHERE (SELECT stock_code FROM products, manufacturers, brands WHERE (manufacturers.manufacturer_id = brands.house_id) AND (products.brand_id = brands.brand_id) ORDER BY manufacturers.manufacturer_name, brands.brand_name, products.stock_code) LIMIT 0 , 10
View Replies !
View Related
Database Table Limits?
I'm having some trouble with accessing or altering my tables in database and I was wondering if this was due limitations in table size. I created a few tables with about 4000 rows at least 3 columns When I attempt a SELECT * and use PHP to print out the Table, the browser just gets stuck loading the data. Also, any attempt to CHANGE field names gives me the same result. I tried ALTER TABLE tableName CHANGE oldname newName INTEGER and the browser also gets stuck loading the page. Are these tables simply too large to handle? what's wrong?
View Replies !
View Related
Limits On Large Files?
I am developing a secure file upload/download site. My approach is to use an account driven system which allows for file upload/download. The files will be "absorbed" into the database directly, as opposed to leaving them on the web file structure. The file downloads will be by "releasing" from the database. My basic application operates currently, however, I am running into a limit problem. I cannot upload beyond 17 MB file. I am on WinXP, PHP v 4.3.10, MySQL v 4.1.8, and access to Apache v2.0.52 (port 80) and Abyss v 1.2.3.0 (port 8000). I have learned that these variables with upload influences are... PHP: file_uploads = on PHP: post_max_size = 30MB PHP: upload_max_filesize = 30MB MySQL: max_allowed_packet = 30MB
View Replies !
View Related
Pushing MySQL Limits?
I'm a total idiot when it comes to MySQL stuff and that is exactly why I am posting here. I'm developing a script for a specific site of mine. Basically, it's a “cast your vote” type of thing. There are basically 50 categories that my users will be voting on for each article. I expect to get at least 1,000 votes per article (maybe even 100,000 votes by the end of next year) per day and I the number of articles could be in the thousands as well. These votes would need to be averaged out occasionally to display the most popular articles in their given field. How practical is this kind of database load? It seams like this would be an enormous load on any MySQL database. What kind of hardware budget are we talking to make sure this setup could be stable? All of my php code would be verified by a mega php programmer to make sure it's as efficient as possible and I'd probably pay a MySQL expert to make sure the code is as efficient as possible on the server end as well.
View Replies !
View Related
Limits On Table Types And Database?
I have been using the mysql database in my project. It recently came to mind that their may be limits on how much data a table or database itself can hold. I did some googling on it. I found this on table types - InnoDB has no limit MyIsam is limited to 4gb - but I found a site that showed how the limit could be increased. So there are size limits on certain types of tables - but what about the database itself? I have a database that consists of a large amount of tables. Some tables are holding bytes (column type = mediumblob; to store images) in their rows. I'm concerned that when I go live with my project that I might run into problems if a limit is reached or exceeded.
View Replies !
View Related
Show Limits Of A Data Interval ... Formatted
I've executed this query successfully... SELECT NAME,DATE_FORMAT(DATEBORN,'%d/%m/%Y') AS BDAY WHERE WEEK(DATEBORN) = WEEK(CURRENT_DATE()) ORDER BY DATEBORN ASC This script is executed every friday with cron, and shows all the people whom had birthday in last 7 days... Now, How could I modify query to show something like: "Listing of people whom had birthday between 20/07/2005 and 27/07/2005" (I'd like to know how to get the date limits in this interval of 7 days selected) I mean, how to show date interval/range of people whom were selected in the script execution, no matter which day script was execd.
View Replies !
View Related
|
TRACKER
