Database Creation Permissions
I have setup different MySQL users. I have removed all permissions for the users, and granted them full permission to their default databases I created for the.
My question is, how can I grant the users permission to create databases. I want them to have full control to create databases, and delete any that they create. Is this possible, or do I need to create and remove databases for them as requested?
I'm running mysql 3.2.5 on Redhat 9. I am not using any host permissions, table, or row permissions on the databases.
View Complete Forum Thread with Replies
Related Forum Messages:
Database Permissions
I've got databases on one box i have to transfer to another box, both are running Linux one a Centos4 machine, the other rh9 i think. I could tar up the /var/lib/mysql directory, but i was lead to believe that was a bad idea. I don't know the permissions of the user's and i don't want to give out global permissions. What i was wondering is there a way i can do a mysqldump on the databases on machine1, which will drop everything needed to recreate them in to a .sql file, transfer that to machine2 and then use mysqladmin to load it and have all the settings back in business? I believe they're both mysql4 installs, though machine1 might be mysql3.23, not sure.
View Replies !
Creating A Database :: Don't Have Permissions
I put the commands in the terminal. mysql -h localhost -u metsuo -p Enter password: ******* then I get to where it shows "mysql>" then I type CREATE DATABASE shinko; and it says I don't have permisson as '@localhost' and I'm in root. Should I give write access to the directory?
View Replies !
Database User Permissions.
I have duplicated a working database which I wish to you. I have also duplicated the code (.asp) which reads, writes and updates the database. All works great when I am logged in to my PC because I have admin rights on this PC but when I test the exact same website with a general users account they get the following error:
View Replies !
Mysql Database Creation
I am using MySQL Control Center 0.9.4 beta to manage my MYSQL databases. I've installed MySQL version 4.1.21 with the standard configuration. Whenever I create a database using MySQLCC it creates it with no problems. It also allows me to create tables and input information into the tables without any trouble. When I close the interface and reopen and reconnect to the server, the database I have created is not there. Yet if I create a new database with that same db name, It contains all the information the original database I had created before had. I receive only this error when I reopen MySQLCC after previously closing it: The database: db1 in server: root@localhost:3306 was not found. (Where db1 is the name of my database I've created) What is going on? Is this a MySQL problem or a MySQL Control Center problem?
View Replies !
Database Creation Question
I want to know if mysql can merge two tables in a way that one certain column of both databases subtract each other. One table adds up all the numbers in that certain while it subtracts all numbers from the other table. At the end, it will output an answer for the total of the operation. I want to use this on my accounting database wherein the ORDERS table will be subtracted by the CREDIT MEMO table.
View Replies !
Table And/or Database Creation Time
Is there such thing as a table or database creation time in the SQL standard, that you could avail yourself of? I mean do databases keep this info. I think they do since they are like little OSs and many of them have internal back up features, that must use some kind of timing.
View Replies !
Limit Database Creation Privilege?
you all must know about it.. you buy a hosting account and you can only create mysql databases or something like it.. i was wondering how that is done.. i couldn`t find a limit database creation in the mysql manual.. or are those scripts just counting the databases and return false when it equals or exeeds a given number?
View Replies !
Database Permissions (Unable To Write To .CSV File)
My managed server is running 4.1.21-standard. We have been able to connect and read a .csv file into the tables, but can't write or append data from tables to a .csv file for import into another application even thought all permissions have been granted. Is this because File is not in the list of permissions to be granted? Also, first user gets kicked out when second user access the MySQL Account Maintenance page. Second user does not even have to log in to cause problems. Are these MySQL issues or cPanel issues? How can I fix them?
View Replies !
Giving Database User INDEX Permissions
Just setting a few database users in cpanel, I see that one option I can grant is INDEX. And I found this in the cpanel documentation: INDEX (Allows USERNAME to create index on table column in the database. This can speed up a database.) I won't be granting alter permissions, which is what I thought would be needed to add a permanent index? I'm wondering what exactly is meant by this? Does it mean, that they have access to an index key that already exists? Presumably mysql allows the word INDEX in the query that maybe replicates the above? In which case, giving a user INDEX permission means letting them create a "temporary index" in the query?
View Replies !
PhpMyAdmin Unable To Access New Database After Creation
I am a bit confused about something in phpMyAdmin. By default, there are two databases: test & mysql. I am able to access these via a php script w/o any problems. However, when I create a new database I am unable to connect to it and more disturbing is the fact that the newly created dB does not appear in the drop-down menu (LH side) along with the two default databases. I know the new db exists because if I try to create a new db with the same name, it says it already exists. Any idea what is going on here?
View Replies !
Permissions On Mac
I used MAMP to set up MySQL and Apache on my Mac and installed Drupal. Everything was working fine but I thought that I had forgotten to change the password for the 'root' user in mysql. So,with MAMP when you go to "localhost:8888 it gives you a start page where you can access mysqladmin and others. I used mysqladmin to change the root user properties but now when I try to launch the start page I get "could not connect with mysql server" Any idea how I can get to MySQL another way and fix it without having to reinstall? My Drupal installation still works so I know MySQL is working but I can't get to the admin/start page anymore. Also, I'm a complete newb at this stuff.. I know I can go to a terminal session on my Mac to access mysql directly but I don't know enough about it to do anything.
View Replies !
DB Creation.
Taken this example for a web site (like eBay) Don't care about analyze, it's just for the example. - table article, is a general table containing the article description. - table seller, all the datas about a seller. - table announce, all the datas concerning an announce - table bill, concerning the billing process the entities: - the seller may have 0 or N articles (0:n) - the annouce has (and must have) only 1 article (1:1) - the announce belong to 1 and must belong to 1 seller. (1:1) - the article has (and must have) only 1 announce (1:1) - every announce must have 1 or N bills (1:n) - every bill belong (and must belong) to 1 announce (1:1) - any other possible reference. May somebody give me the script for creating this database with referential integriry (MySql 4.0) I've no tool to create this and don't know the syntax.
View Replies !
Default Permissions
This is a fairly simple question but I'm new to mySQL. To log on to mySQL I need to type at the prompt: mysql --user='username' --password='password' as opposed to just typing mysql and being recognized without having to type identification. Anyone know how I can change this?
View Replies !
MySQL Have No Permissions
I have installed mysql (under SuSE 8.1) and everything seems to work fine when I am logged in as root. However, with my normal user profile I can get a mysql> prompt but have no permissions to carry out any database operations. I would really like to work with my normal profile and am hoping that it is merely a question of setting permissions correctly. Can anyone tell me which files and paths I should check (and change)? Ideally, I would like mysql to create and manage the database files in my normal /home directory (rather than in the mysql directories). Is this possible? Is this desirable? Which settings would I need to change to allow this? Or should I just let mysql create the databases in it's default directory and set the permissions there?
View Replies !
MySQL Permissions
I would like mysql to create and manage the database files in my normal /home directory (rather than in the mysql directories). Is this possible? Is this desirable? Which settings would I need to change to allow this? Or should I just let mysql create the databases in it's default directory and set the permissions there?
View Replies !
Permissions Change
Running MySQL 4.0.18 (upgraded from MySQL 3.x), I can set the host for a user to "%", and can connect from localhost just fine, as well as remote locations.On another server running 4.0.21 (clean install), if I set the host to "%", I cannot connect from localhost unless I also set a "localhost" entry as well for that user.
View Replies !
Permissions With New Db's
I've got php script that created a database, then the tables in the database. The user in which the script is run, doesn't have the permissions to create a 'new' db. Moreover, mysql says that because the user is trying to create a new db, and there isn't a row specifying that the use has permission, doesn't allow the user to create the db. My solution is that I can create a row in the mysql.db table that will allow for the user to have proper permissions. My problem is that once I insert that row, it takes another post to the page for the permission to actually take hold. Is there a way to have the permissions take hold sooner? Some of the things I have tried would be toRedirect the page to (with a php header call) to re-load the pageClose the mysql connection so that a new one would have to be opened
View Replies !
Resolving Permissions
I have mySQL Administrator (and subsequently mySQL) installed on my iBook. I want to connect to mySQL on my Red Had Linux 9 test server with the mySQL Administrator, but I get the following error message: Code: Could not connect to mySQL instance at [SERVER IP ADDRESS] Error: Host '[IBOOK IP ADDRESS]' is not allowed to connect to this mySQL server (code 1130) I'm sure there's an easy fix for this, but since I'm a bit new at this, I'm not sure where to look.
View Replies !
User Permissions
Is there a special permission required for a user to be able to run a "select ... into dumpfile" statement? I'm getting a 1045 error when attempting this on my server. I've already verified that file permissions are not an issue.
View Replies !
Custom Permissions
I need to assign different 3 different types of users, each with his own permissions and am unsure how to proceed. One of these users will require remote access to all records. I have mySQL 5 and mySQLadmin tool. Both are installed on WinXP and mySQL will be accessed through PHP's connection functions. Can someone show me an example of setting a user with specific table and row privileges for security purposes? ie: a a user can't modify adata in x table, only read. Another user can write in rows w and x of table y only and can read all of y table but not table z.
View Replies !
Trust Permissions
I am trying to configure a mySQL server on XP machine, and wish to allow ASP.NET application access the database from a remote machine. 1. How do I set Trust permissions to a catalog? 2. How do I allow remote connections?
View Replies !
Add Host To Permissions
Typically, one does something like "grant x,y,z on db.* to user1@localhost identified by 'password'". Is there a good way to clone the permissions for "user1@trusted-host1" et al? Particularly sometime later when one doesn't remember exactly what "x", "y" and "z" were exactly? I can look at the bazillion settings already there, but it's rather a pain to count exactly how many '"",''s and '"y",''s have to be where in the insert and what I really want is to just clone the entry, changing one field...
View Replies !
Outfile Permissions
I tried to write a query out to a file, but I got this message: ERROR 1 (HY000): Can't create/write to file '/home/jason/test.csv' (Errcode: 13) How can I set mysql to allow those permissions to write anywhere I want? When I don't specify the directory, the command works,
View Replies !
Root Permissions
root permissions are messed up, i'm unable to create new databases with root account and i cant change permissions for the root account while logged in as root mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
View Replies !
Permissions Problem
I can query my MySQL database with any SELECT, UPDATE, DELETE, etc. queries, and it works perfectly, but when I try to do a LOAD DATA INFILE query, I get a permissions problem. Any ideas why this might be?
View Replies !
User Doesn't Have Permissions?
I install a mysql backup utility to backup my database if things go wrong. I went to test it to make sure it would work as it emails me the sql file, I deleted my database (using phpmyadmin) and tried to import the sql file which shoots me an error giving me an error that I didn't have permission to create a database. How do I give myself permission to create a database?
View Replies !
4.0.15 Foreign Key Creation Bug?
The table creation script(at the end of this post) works fine on 4.0.1-alpha-win, but the foreign key constraints fail on 4.0.15-win. I am starting the server with the same command for both versions: mysqld-max-nt --console --transaction-isolation=SERIALIZABLE In 4.0.15-win I can extract the following error after I run the table creation script: [test01] ERROR 1005: Can't create table '.ibdata#sql-a14_3.frm' (errno: 150) Also, the InnoDB status in 4.0.150-win shows: ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 030930 19:38:49 Error in foreign key constraint of table ibdata/#sql-a14_3: Cannot find an index in the referenced table where the referenced columns appear as the first columns, or column types in the table and the referenced table do not match for constraint: FOREIGN KEY (contactInfo_fk) REFERENCES contact(pk) ON DELETE SET NULL See http://www.innodb.com/ibman.html for correct foreign key definition. But the above is wrong. I DO have an index defined on the foreign key, it IS the first column in the index, and their IS NO type mismatch. Since this works on 4.0.1, I have to think this is a bug. I need a working version of the server that supports transaction savepoints. Any help appreciated!! # Connection: test01 # Host: localhost # Saved: 2003-09-29 18:16:42 # CREATE TABLE orderjoin ( owner BIGINT,owned BIGINT ) TYPE=InnoDB; CREATE TABLE orders ( pk BIGINT UNSIGNED AUTO_INCREMENT NOT N.....................................
View Replies !
Format Creation
I have 2 tables: Table1 contains (among other things): ID Data1 Data2 Data3 1 aaa bbb ccc 2 ddd eee fff 3 ggg hhh iii Table2 contains (among other things: ID Key Value 1 20 zzz 1 30 yyy 1 40 xxx 2 20 www 2 30 vvv 2 40 uuu 3 20 ttt 3 30 sss 3 40 rrr I need a query that returns: ID Data1 Data2 Data3 Value Value Value (Key=20) (Key=30) (Key=40) 1 aaa bbb ccc zzz yyy xxx 2 ddd eee fff www vvv uuu 3 ggg hhh iii ttt sss rrr Any ideas?
View Replies !
Mysql Creation
I have installed Fedora core 3 with mysql database.Now I am able to connect to mysql database.But I have to create user and table .How to go ahead
View Replies !
Table Creation
I'm creating a table and would like to get the system date for my date column. How would I do this. I tried to use date date SYSDATE with no luck. Also when adding values to the DB, would I insert anything in this column or just leave it out like and auto increment column??
View Replies !
Getting Time Of Row Creation
I have some rows in a table and I was wondering if it was possible to find out through some PHP or mysql function when that row was added. Unfortunately, the structure was not setup to have a time or date column with timestamps.
View Replies !
Index Creation
im trying to create a couple indexes for some tables and keep getting errors with these ones. CREATE UNIQUE INDEX IX_TBLADDRESS_PRI_UNQ ON TBLADDRESS (CASE BISPRIM WHEN 1 THEN NOWNERI ELSE NULL END ASC, CASE BISPRIM WHEN 1 THEN SOWNERT ELSE NULL END ASC); CREATE INDEX IXDELEMAILQUEUE_MODIFIED ON TBLDELETEDEMAILQUEUE (STR(DTIMEMO,'YYYYMMDD') ASC); CREATE INDEX IXEMAIL_LOWER_EMAIL ON TBLEMAILADDRESS (LOWER(SEMAILA) ASC); CREATE UNIQUE INDEX IX_SCHOOLDOM_PRI_UNQ ON TBLSCHOOLDOMAIN (CASE BISPRIM WHEN 1 THEN NSCHOOL ELSE NULL END ASC); CREATE UNIQUE INDEX IX_TBLSCHOOLSTATE_SCHOOLHEAD ON TBLSCHOOLSTATE (CASE BISHEAD WHEN 1 THEN NSCHOOL3 ELSE NULL END ASC, CASE BISHEAD WHEN 1 THEN SMODULE ELSE NULL END ASC); CREATE INDEX SPONSORTRAN_LOWER_EMAIL_IDX ON TBLSPONSORLOADTRANSACTION (LOWER(SSPONSE) ASC);
View Replies !
Foreign Key Creation
I'm creating a calendar scheduling system with PHP and MySQL to keep track of lessons. I have one form in which the user enters the information about the event that needs to be scheduled. Then I need three entries to be made in three different tables. What I have is one table that keeps track of the entries in the calendar. Then I have two more, one for how much the teacher needs to get paid as a result of the number of hours and the other is how much the student needs to pay based on the hours. The only problem is that I want the student and teacher paying tables to have the unique ID of the calendar entry to which the payments are associated. So the problem is I can insert the entries into the calendar tables, and it will automatically create a unique ID for that entry, but then how can I take the ID for that entry and insert it into the two other tables. The best I could come up with is somehow query the last entry created but i'm not sure how, or even if that is a good way of doing it.
View Replies !
How To Set Creation Time
I have one table which i only fill with data once in a while. then i would truncate it and fill all data using INSERT INTO ... SELECT ... but that would not reset the creation date. so i cant know how old the data is. so i changed my scriot to drop the table and recreate it. but then the creation date is still the same. how can that be? i tried FLUSH with no success.
View Replies !
Set Date Creation
like to set the creation date of a table or the entry of new data with an old date. Ex: I want that a table results created on 10th December 2000. Or data wrote in table results old, wrote like 1 month ago. I think I can do that by using the TIMESTAMP or something like this statement.
View Replies !
Table Creation Sql
Is there any way to have MySQL supply the SQL used to create a table? Sort of like it does using the command line mysqldump tool, but direct from the actual MySQL server (i.e. one I could use to get the SQL from MySQL using PHP)?
View Replies !
Foreign Key Creation
I have a website that pulls data from a database. For some reason, after I add data to the database, from the site, the site will pull it up fine on the page, but then, sometimes, out of the blue, it does not. The data will be in the database, but it won't appear on the page. The strange thing about the whole situation is that when I add a new entry to the database, the site will find the information it couldn't find before and it will appear on the page...
View Replies !
Resetting Permissions On Windows
If I am using Win98 SE (yes yes, I agree...), will underneath still work: http://www.mysql.com/doc/en/Resetting_permissions.html ? I have tryed to follow above and similar advices, but haven't had a lot of luck. I will try again soon, but I was wondering wether there was an easier way (e.g. if there was a "reset" command I could run that also works on Win98). Code:
View Replies !
View User Permissions
Is there a way to query MySQL to find out what the permissions of the user currently connected For Example: Database: customer_contacts User : cust1 Table: Archives User Permissions: Read Only(SELECT). Is there a way to ask MySQL what User cust1 can do?
View Replies !
Remote Connection Permissions
I have mysql4 installed in RHEL4. I need to enable remote connection in this db so that application server can get connected to db server. For this, only creating user as grant all on db.* to remote@remoteipaddress identified by pwd; is this enough? or shud i do any other step.
View Replies !
Cannot Revoke Databases Permissions
I have Mysql 4.1.12 running on FreeBSD 4.9 in that i have 4 databases, mysql, test, new, and xyz I have one user abc, if i login through abc user i can see three databases new, test and xyz i want to remove access to xyz for user abc tried all command to remove access but didnt help and tried phpmyadmin also it seems when ever i create new abc user deleteing old it takes the old privileges of its own and again it shows access to 3 databases i just want access to test, new for user abc.
View Replies !
How To Check Permissions On Tables
I'm developing in Groupware (a php / template-based tool for making office-like applications). It creates mysql tables as it goes. I am not seeing those tables being created, and I'd like to determine if it's a permissions problem. I'm in a shell on a Linux system, but I'm very unfamiliar with Linux command line. So far, I can logon as root, use database, show tables; (this is how I know my tables aren't there.) So, what can I do to ensure that my permissions are set up correctly? When I was setting permissions in the Linux directories, I used 'chown'.
View Replies !
Stored Procedures + Permissions
I'm on a shared host with MySQL 5.0.33. I want to use stored procedures and functions. Unfortunately I'm getting an error message when I try to create a new function. For example: SQL CREATE FUNCTION `gutenTag`() RETURNS varchar(20) CHARSET utf8 RETURN 'Guten Tag' ... ends with: #1044 - Access denied for user 'blah'@'%' to database 'blahblah' How can I check if I have permissions to create procedures/function?
View Replies !
Getting Current User Permissions
I'm on a shared host, but I'm looking for a "global" solution, since I'm writing an installer. I'm trying to get a list of the current user's permissions, I'm trying the user table, but no go. That's most likely blocked. I'm looking through commands, but nothing. Searching isn't turning up either. Is it just trial and error I guess, and catching the errors? What I want to do is to check if the user has the SELECT/INSERT/CREATE/DELETE/ALTER/UPDATE permissions, before proceeding.
View Replies !
Multiple Databases Creation
I know that Mysql handles large database very well, but there is a project that requires more than 2000 small databases(about 20 talbes with a few rows) to be created within a Mysql server. Could somebody tell me does it make sense?
View Replies !
|
TRACKER
