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 Complete Forum Thread with Replies
Related Forum Messages:
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 !
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 !
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 !
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 !
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 !
Change/Create User Permissions
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.
View Replies !
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.
View Replies !
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.
View Replies !
Restrict User Permissions Based On Column Value
I have a client who wants me to make a web database engine for a softball organization (many teams). he wants him to have administrator rights, and the coaches the ability to update only their roster. The catch is as the players mature and get older their profile will need to move to the next coach. For display purposes (using PHP) I will be doing something like ... "WHERE `team` = '14U'". I want to set it up so only coaches may update their profile if `team` = "14U" is this possible to do within one table? I have PHPmyAdmin so it should be very easy to checkmark permisions on/off. An aside, but I will be doing the database administration via phpmyadmin & via MS Access, which I am almost positive shall work, I believe I've done this before.
View Replies !
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 !
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 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 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 !
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"
View Replies !
Mac User First Database
Hi. Im trying to make a database. Seeing as im 14 i have barley any experience with databases. The only ever experience ive had is about 4 lessons of how to create a database in microsoft accses at school! Is there any program like microsoft accsess out there for mac?
View Replies !
Add A User To A Database
I would like to add a user to a database. A very simple thing you would think, but I can't get it to work. This is what I have: GRANT ALL ON database_name.* TO 'user'@'localhost' IDENTIFIED BY 'my password' flush Privileges; But for some reason this doesn't work. The user already exists, so could that be the reason? I just want to give it permissions to this new database i've created now.
View Replies !
Assign A User To A Database
ive just created a new database with no tables in as yet. ive created a new user 'myusername' with a 'password' and i have granted all the priviledges for my new user name and flushed but how do i assign myusername and password to my newdatabasename? e.g my database is called 'shop' how do i assign me to that database?
View Replies !
Is A New User Cannot Create Database?
I have recently installed MySql and graphical tools to manage. After installation with root password set, i have connected with graphical admin tool and created a user and set all the previlages to mysql database. I connected with the newly created user and, Using MySql Query browser, i tried to create a new database (or schema) I got an error Access denied for user 'ADMIN'@'%' to database 'TestDB' My host is : localhost My initial doubt is 'Whether a new user, created by root, cannot create his own databases?
View Replies !
1 MySQL Database Per User
Is there a way for me to limit one mysql user per database? For instance, I have 3 databases: A, B, C mysql_user: aaa mysql_pass: aaa mysql_hostname: locahost mysql_db: A mysql_user "aaa" can have access to database B or database C just by changing mysql_db to "B" or "C". I just want to assign database A to mysql_user "aaa", and not allow mysql_user "aaa" to have access to database "B" or "C" by changing mysql_db to "B" or "C".
View Replies !
Database - User Table - Propagation
I've started a new website and I want to have a database that works with all my other user tables in my other databases. This is my idea. Background. Example Setup Tree --Main Page: -->Forums -->Mail -->Collaboration -->Bug Reporting -->Etcetera -->Etcetera -->Etcetera *NOTE: Each subsection has it's own database with their own user tables ------------------------------------------------------------------------------- UserX visits my site. There's a register screen and UserX performs the standard Registration which is then added to the userdb in the usertable. I want to run a query that will update all subsequent user tables of their own databases. So, one query or multiple queries will register UserX's info into all those databases. Once the person is logged into the site, the don't need to register nor login into the other portions of my site, they just click on 'said' link and have access to that portion of the site.
View Replies !
Lock A User To A Specific Database
How can I create a new user, that only have access to his/hers database? It's because I host my brother and my own site on my own server, but I have access to his databases, and he has access to my. How can I solve this?
View Replies !
Can I Set Database User Password When No Root Pw Is Set
I have installed PHPBB MediaWiki and SugarCRM on Ubuntu Server LAMP. I initially tried to set the root password on install and then could not log back in. After reinstall this is what I did for a new non root user. root@invest:~# mysql -V mysql Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (i486) using readline 5.2 grant CREATE,INSERT,DELETE,UPDATE,SELECT on pauldb.* to paul@localhost; set password for paul = password('mysecretpassword'); flush privileges; exit; Then when i go to login with this user I can't. I have not set a password for root because the same thing happened when I tried to set root pw immediately after install of the database. This time I am trying to work out the access issue with a new user i have created. This way I still have access since and I won't have to reinstall the db.
View Replies !
Importing And Setting Up New Database And User
I am having trouble moving a database and website from another host. Do we need to use the same user name and password that was previously setup? We changed the code to use the root and root password, seems some pages work and some are blank. I could not see how to setup a new user? so then we can try and use that to connect. The pages refernce this page main.php that has the following code. <?PHP mysql_connect("localhost", "entaction", "2a3wHTp1"); mysql_select_db("entaction"); $size = 15; ?> This was changed to use the rooot user and password because we could not see how to setup the same user for the database, I was able to import the database fine and shows in the databases? Need help getting this working using: phpMyAdmin - 2.8.1 MySQL client version: 5.0.24 Thank you for any help.
View Replies !
Creating User Login With Database
I'm fairly new to using databases and I am wondering how you go about creating a user login with your database. I need to create a login system for a website. Would you use a CREATE USER statement every time you want to add a user, or is that a way for having developers access the database only? I also thought of creating a user table that would contain the users name and password, but how secure would that be?
View Replies !
Creating A User For Only One Database For The Web/ FORGET IT
If I wanted to create a user for only my website to only have access to one database and they will be connecting via php, what is the best way? I should manually insert into the users table, correct? INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'), 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); This is the example from mysql docs, but the whole page is huge and seems complicated. Will this mean that only a user coming from the local host will get in this way? And where would I specify the database? I'd like to have just php connecting to the database asside from root and that user only accessing one database to do inserts/updates/deletes and selects.
View Replies !
Unable To Add A A Normal User Into A Database
I hv installed MYSQL server version: 5.0.13-rc on my solaris 8 machine. I hv reset my root password to '' . Now when I m doing following to create a user with the name bugs, I m not able to see it after creating it . although I m not getting any error while creation. My steps are :- bash-2.03# mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 119 to server version: 5.0.13-rc Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> select user,host from user ; ERROR 1046 (3D000): No database selected mysql> use bugs; database changed mysql>GRANT ALL PRIVILEGES ON bugs.* TO bugs@localhost IDENTIFIED BY 'bugs' ; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges ; Query OK, 0 rows affected (0.00 sec) mysql> select user,host from user ; ERROR 1146 (42S02): Table 'bugs.user' doesn't exist I do not know why it is not showing the bugs user or what is wrong in my way.
View Replies !
Limited New User At Mysql With One Database!
example: i have account root at linux and i want to create new user at mysql server and create database for my new user. new user :alex password : made database :db_alex TO create new user: alex mysql> insert into user values('localhost','alex',password('made'),'Y','Y','Y','Y','Y','N','N','N','Y' ,'Y','N','Y','Y','Y'); To cresate database : db_alex mysql>create database db_alex Question : what script at php and mysql to limited user : alex , to access only one database : db_alex user alex can't access other database, except database db_alex. user alex can't drop, modyfi and alter other database, except database db_alex.
View Replies !
Access Denied For User ''@'localhost' To Database
Yesterday I got a new server with MySQL 5.0.22. Today I spent 10 hours trying to set up a database using webmin. Actually, it's not a problem to create a database, but the problem is that I can not connect. I tried different settings, no luck: Access denied for user ''@'localhost' to database 'mydatabase' I can connect from command line: [root@server8]# mysql -u myusername -p Enter password: *** Welcome to the MySQL monitor. Commands end with ; or g. ....... As you see I can connect. My settings from webmin: Code:
View Replies !
How To Grant 'create Database' Privileges To A User
I created a user and wanted to allow he to create a database, how to grant the 'create' database privielege to he. > create user joe identified by '123456'; > use mysql; > update user set Create_priv='Y' where user='joe'; I know I can update the user table,but I'd like to know if these is dedicated statement for this purpose
View Replies !
Database Sync Based On User-login
I really want to know if it's possible to tell a mysql database to sync whatever changes are done on it BY A PARTICULAR USER to another database. This sort of logic: If UserX logs in then whatever changes he makes: sync to secondary DB. Else do nothing; Is this possible?
View Replies !
Number Of User Accounts For Large Database
I have a large database (816 tables with 11 fields each, each field could hold up to 50 entires) and I'd like to know if each table should have its own user account (created in Cpanel and used in the config file to access the database). May sound like a simple question to some but I need to know in case we have a lot of traffic and 1 user account is not "enough" for all visitors to access the database info.
View Replies !
Two Sites Using The Same Forum Database User List
I know it's possible for TWO different sites to use the same database. Let me explain. I have siteA and it runs a forum. Through the site, users of the forum can login using their forum ID. I now create siteB on a different domain, but on the same hosting service. I want users from siteA to be able to login with their name from that site on siteB. How would I do this? I'm using myBB as my forum software.
View Replies !
Send User Comments To MySQL Database
I am trying to attempt(beginner here) to create a textarea for user comments and then upon submission have those comments stored in MySQL database. I have setup the database and table. The table has the following fields name, email, website and comments.
View Replies !
Site User To A Paid Member? Database Design HELP
I am currently working on a website where there are 2 types of users. The regular site user and a paid member. I am trying to figure out the best way to design the database (mysql) without redundancy issues. The site user can eventually become a paid member but a member does not necessarily have to be a regular site user (in terms of category). Information stored on a site user - first name, last name, address etc. The userID being the primary key. The member pretty much the same thing but new info will be memberID, join date, expiry date, status (pending, active, expired). I thought the easiest way to do this was to have separate tables. Do you think the best way? My thoughts are: When the regular site user becomes a member then store the userID in the members table. The issue I am faced with is how to store the other pieces of information. The address is not mandatory for the site user but is mandatory for the member. So, if the site user has an address then store it in the member table? that's redundancy there. Then a member do not necessarily have to be a site user in the sense of storing the info in that table. Design issues to think about - activation of membership once a confirmed payment has been received - Client is using Paypal. -What if the user clicks on membership and the user is also a site user? -What if the user is logged in as a site user and clicks membership? I would greatly appreciate your design recommendations.
View Replies !
#1044 - Access Denied For User When Im Traing To Create A Database
Im train to create a database in my host (not local) that support MySql-5-2 but when i type in the code show me the error: ---------------------------------------------------- -- -- Database: `database` -- CREATE DATABASE `database` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; MySQL said: Documentation #1044 - Access denied for user 'user'@'host' to database 'database' ---------------------------------------------------- my code is: ---------------------------------------------------- -- phpMyAdmin SQL Dump -- version 3.0.1.1 -- -- Host: localhost -- Generation Time: Mar 22, 2009 at 09:31 PM -- Server version: 5.0.51 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `database` -- CREATE DATABASE `database` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `database`;
View Replies !
Login As Root User, And Grant Create Database Privileges
I am new, and I have been trying to find info on this unsuccessfully. Ok, so I am using Unix Terminal from my Mac. From the command prompt, I use Shell>/usr/local/mysql/bin/mysql to log in to the localhost user. Now, from the command prompt, i have tried using ,mysql -u root, and it says command not found!
View Replies !
|
TRACKER
