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 Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
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?
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?
User Permissions
I'm kinda new to administering MySQL. I have a remote db that I want to backup to my local MySQL server (windows). I can do a dump of the db from phpMyAdmin on the remote server. I try running it on my local server through the MySQL Control Center, and it says "Read Only". I don't have to enter password for root@localhost to login to the Control Center. I assume I don't have permissions to run DDL scripts as this user, and I can't figure out how to change this users permissions or create a new user with different privileges.Someone please help. I need to set this notebook up so I can work while out of town this week.
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:
Inheritance Of User Permissions
how the user permissions can be inherited... or if they can be herited or not. how do you do manage this and what options do you have?
User Permissions: MySQL DB Design
There is a huge problem I have been breaking my head over in the field of setting user permissions for my CMS. It is still in the development stage so I have all the freedom I need for any adjustments I need to make. My main focus of worry is on how to set the permissions, not in a static, but in a dynamic way. The end goal is to install the CMS for a variety of people. They will then have the control to make their own user groups and permission rules for each group and post. What I am having problems with is the following: Figuring out how to design the database to give me the options to: -Set read, write, edit, move, delete, vote, comment, attach permissions for posts. -Users can only do these things on posts of their user-level and lower or if they are the author. IF the post category allows this. Update: Where I am at now: I have decided to go with assigning 'levels' to each group and for each action. Level 0 is the admin level, the admin can do whatever he wants. Level 255 is a ban. I think I should set level-requirements on different types of posts. Let's say an admin announcement has edit-requirement level 0 where as an author article would have edit-requirement level 1 so only trusted mods can change it but reading-level 10 so all people can read it. (example level values). I was thinking something like this: posts[post_id....post_level_id=ì«'] post_permissions[permission_id=ì«', read_level=ཆ' edit_level=Ƈ' delete_level=Ɔ'....etc] Do you guys think this would be a good way to go? And how would you integrate this into the database? As stated before I edited the post a bit.
Security Question For User Permissions
I've had a site for half a year now, and I have this set up: 1 User with all permission to add/edit/delete etc. data 1 User with SELECT and INDEX permissions My question is do I need to make this (second) user to be secure? Because on my new site I want to my users(going to create user system) to be able to add comments and such and I don't want injections or etc. security hazards.
Access And MySQL User Permissions
I'm wondering how Access FrontEnd Users' username and passwords may be sent within a connection string when performing a query on MySQL tables. Maybe I'm just missing how Access and MySQl communicate here? If I set up security permissions on the Access front end forms/reports and database/table/record priveleges in MySQL how do I get them to work in conjunction with each other? The only way I know how is to create the database connection in code using ADO and pass the username and password of the current user in the connection string. I don't know how to get a handle on the current user's username and password that were supplied when logging into Access. Could anyone shed some light as to how this arrangement is supposed to operate when verfiying user permissions on MySQL objects?
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?
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?
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.
Permissions
I connect to my MySQL database using MyODBC. I have a table called 'log' in a database called 'home'. When I try to do an insert like this: insert into log (userid,event,event_date) values (blah blah.... I get this error response from MySQL: 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 'log (userid,event,event_d ate) values ('nt','HomeDB Started',now())' at line 1 However, if I use : insert into home.log (userid,event,event_date) values (blah blah....I have another table in the same database which doesn't exhibit this problem. Is this some sort of permissions or access rights issue?
Permissions
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'.
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?
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)
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.
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?
MySQL 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?
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.
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.
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
Database Permissions
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?
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.
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?
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.
Need Info On LOB's And Permissions
i want to know wat the equivalents to LOB's of oracle i mean we have clob and blob in oracle so wat do we have similar to that in Mysql, And i notice after installation of mysql it is some thing like a raw database kinda thing... we got to create our own users and so... can you tell me how to create new users and wat tare the access permissions that i can use for common environments where i want to develope a client- server kinda environment. I mean some thing similar to 'grant'in oracle.
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.
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:
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). The long story is: Code:
Backing Up Users Permissions
I was wondering how I can backup user rights to a database that I have. I am able to create a dump of the database but how can I backup the user rights.
Whoops! Removed Root's Permissions :-o
I've been running a vanilla mysql installation on a Mandrake Linux server for a couple of years. The db is being used to host a webforum for a group of friends. Everything has been running perfectly, that is, perfectly until I accidentially removed roots permissions to the mysql database. I was using webmin and was too fast on the mouse with too little coffee. Roots only remaining permission is 'select'. Now all we get from the forums is "Critial Error: Unable to connect to database". I've logged in via command line and verified that the database is running. I've also verified that no other changes were made to the db. I have other users that have all permissions, but I'm a mysql command line neophyte. Is there anything I can do to re-establish root's permissions?
Username Won't Work In Permissions Script
I am setting up a classified site. I can run my build scripts, but when I try to run the permission scripts, and try to grant access for my username DB_234608_mysql_user, it says no user or group found in the database...Though it clearly says on my database manager what the DB login name is. My server has confirmed the correct username, and the software manufacturer says I need to talk to my hosting server, because it's set up acurrectly in my SQL script.
Problem With MySQL Connection Permissions.
I'm running mySQL locally on my computer. When I run my C# application I have the connect as string MySQLDBConnect = "DRIVER={MySQL ODBC 3.51 Driver};" + "SERVER=localhost;" + "DATABASE=filetransfer;" + "UID=********;" + "PASSWORD=********;" + "OPTION=3"; Everything works fine when it's set at localhost. But that's pretty useless as it onlly works on mmy PC. So instead I'll put in my IP adress. Let's say I change Localhost to 111.111.111.111. Then I get an error. ERROR #0 Message: [MySQL][ODBC 3.51 Driver] Host '111.111.111.111' is not allowed to connect to this MySQL server. Native: 1130 Source: SQL: HY000 The database does get connected. I can tell because I can see the connect going through my firewall. But I get a premission error. I'm guessing it's with my database setup but I couldn't be sure.
Creating Group Permissions In MySQL
I would like to be able to assign my employees to groups based on what department they are in (all users in accounting would belong to the accounting group, all users in customer service would belong to the customer service group). Then I want to be able to grant database permissions based on what group a user is in: something like GRANT SELECT TO myTable FOR AccountingGroup (obviously not ANSI SQL). Is there an easy way to do this?
Giving Permissions To Hosts On Subnet
I would like to give permissions to a user that comes only from hosts on our subnet. So any host that is coming from 24.xx.xx.209/28. so, for instance(from the MYSQL docs): GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION; I would like monty to have access only when he logs into a db from the network above. Is this possible or do I have to create an entry for every machine that I want this for?
Setting Permissions For Local Users
I am wondering if anyone can help me.I am installing GPTEngine locally, I am using using Apache Webserver.Everything goes well until it is time for the engine(software) to connect to SQL.I get an error cannot connect to database. Im not quite sure what the problem is. The software says I need to have full table priviliges,not entirely sure how to do this. I created the database but it is up to the software to create the tables. It will just not connect to SQL.I find the documentation on the MYSql sight confusing can anyone give me any pointers,and point me to a website that has easier to follow instructions?
Newb Starting MySql-Permissions
I have debian running and this is how I have it setup # ls -ld /var/lib/mysql drwxr-xr-x 4 mysql mysql 4096 Aug 19 11:29 /var/lib/mysql I was shown how to setup a password for user mysql here http://dle.ascendant.ca/restoring-mysql-root-HOWTO.txt, because at one time all I would have to do it hit enter after # mysql -h localhost -p -u mysql Enter password: (no password is added I just hit enter) Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 16 to server version: 4.0.14-log Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> ( can do whatever I want now???) If I type in the correct password it lets me in, if I type in no passowrd it lets me in, if I type in the INCORRECT password it does NOT let me in. How can I make it so that if no password is typed it still treats it as incorrect?
Passwords, Permissions, And Blank Users
I have Apache 2 server, PHP5, and the latest MySQL installed on my system. I'm currently reading PHP and MySQL for Dummies (I told you I was a newbie) and trying to work through a few of the examples.One thing I noticed when I looked at the "users" table in the "mysql" database is a blank user with all privileges on localhost. I deleted that entry, set a password for my "root" account, and created another account with a non-blank password. The problem I am having is that I am trying to connect to the database as "root" with a blank password, and it's still working. I then tried a blank user, and it worked. I tried a random assortment of letters and numbers, and it worked.
Load Data Infile Permissions
I'm trying to import data using the mysqlimport tool, however I get a "Error: Access denied for user 'ODBC'@'localhost' (using password: NO)" message. Where can I change the permissions for this or how do I use a username and password within the 'load data infile' command.
Permissions In Mysql Control Center
I need to allow 3 different servers to access my MySQL Server. How do I do this? Also, I was told that having MySQL configured so it doesn't restrict access is bad - how do I make sure that's not the case?I feel like I know what they're saying, but I don't know how to actually implement this in the Control Center, and I must be using the wrong keywords because when I look it up, all I find is stuff on how to connect to the MySQL Server from my web page using php (which is what I'm using and already doing).
Select / Count Not Showing Records ... Permissions?
I imported 600,000 records from SQL Server 2005 to mySQL. I know they are in there -- I just can't see them! When I do a SELECT, it processes for a while, and then returns nothing. Same with a count, it sits there processing, and then returns a '0' However when I do the same on a table I know has no rows, it definitely comes back right away. I'm logged in as root. Do I need to assign myself some permissions to see these records? And the count numbers?
How Do I Create A Table For Holding File Permissions?
I am wanting to make file sharing website. So users can upload files and have control over who access the files. I am wanting to use MySQL for storing the users, passwords, home folders and access permissions for each file. I want to make a table that has the userid and a list of all the files he can access. But I don't know how to make the table that would hold a list of files.
Create Temporary Table With Read Permissions Only
In one database I made a query like this create temporary table tempT type=heap select * from orig_table1; insert into tempT select * from table2; SELECT column1, column2, column3, sum(column4) as sumOfColumn4, etc, WHERE date = 20070306 and name = "jan" GROUP BY Column4 order by name desc; drop table tempT; But on another server I only have read permissions. Is there a trick to do such a thing when you only have read permissions. Can I add the output in a variable and then merge the second select in the variable and if necessary empty the variable?
Updating Events, Permissions For Root, Access Denied?
I created an event, no problem, and now want to update it. Since I created the event, we've moved the server from the office into a colo; instead of logging in from the local domain I'm now logging in over the VPN. MySQL refuses to let me, logged in as root, change the EVENTS table in the information_schema schema using an ALTER EVENT query.
Root User Denied Access To Fetch User List.
I can still log onto MySQL administrator or the command line program but I somehow appear to have lost all priveliges to alter or view the user list from this account. Even under the command line interface I can login but it tells me access is denied when I try to alter "root" permissions on a database. I cannot seem to log onto any of the other accounts created but obviously if I could get into the user admin I could solve this.
Retrive Category Names Where Categoryid Is Different From User To User
I am trying to retrive category names where categoryid is different from user to user I know LIKE works with one int(1), but I want it to work with more ints (1,3,5) SELECT * FROM `categories` WHERE categoryid LIKE (1) Working SELECT * FROM `categories` WHERE categoryid LIKE ( 1, 5 ) Not working
Copy User Privileges To A Newly Created User.
I have just created a user with specific permissions to certain tables in different databases. Now I have to create serveral more users with the same permission. Is there a command in MySQL that allows me to create the new user by copying the privileges from a template user?
Deleted Root User From 'user' Database!
I so stupidly deleted the root user from my mysql > user database. Now I can't login to mysql. I uninstalled the rpm and reinstalled it but it still won't let me setup a new root user. How can I delete the mysql data files so that I start again, fresh? Where are these files located? I can't find them anywhere after removing the RPM but they are obviously there because upon reinstalling the RPM I'm still in the same position--I try to do mysqladmin -u root password 'password' but it says "Access denied for user root@localhost"
|
TRACKER
