MYSQL :: User Doesn't Have Permissions?

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 !

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 !

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 !

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 !

WHERE Doesnt Equal
I am trying to select something my DB where a clause does not equal something but for some reason I cant seem to make it work.

Here is what I have tried.

PHP Code:

SELECT * FROM golf_groups WHERE name!="something"

but this doesnt seem to work. i had done something like this before and thought that I had done it this way, but since this does not work,

View Replies !

It Doesnt Use My Index!
`player_1` mediumint(7) unsigned NOT NULL default Ɔ'
`player_2` mediumint(7) unsigned NOT NULL default Ɔ'
reffering to users' id-number in another table.

I have two indexes:

KEY `one` (`player_1`),
KEY `two` (`player_2`)
The cardinality of them is 6000 and 7000. My primary-key has cardinality 150 000.

When i run this query:

EXPLAIN SELECT *
FROM `gamebase`
WHERE player_1 =1
It uses the "one"-key (doh!).

But now, that I run my next query (using OR), it tells me that one and two are possible keys, but it uses neither, but loops through my entire table "Using where".

EXPLAIN SELECT *
FROM `gamebase`
WHERE player_1 =1
OR player_2 =1

View Replies !

Function Doesnt Work
i tried write simple function:

CREATE FUNCTION `getLastNumber`(some_guy INT(50), date DATE) RETURNS float
BEGIN
DECLARE a FLOAT;

SET a = NULL;

SELECT number INTO a FROM numbers p WHERE p.number_owner = some_guy AND p.date_created <= date ORDER BY p.date DESC LIMIT 1;

RETURN a;
END

that would return last inserted number into table for some person. When some_guy has number in table, then is everything ok and it returns last number, but when some_guy does not have row in table it returns: Query OK, -1 rows affected. Pls why? and how to fix it?

View Replies !

GROUP BY Doesnt Work
i have a table that contains the folowing fields:

some_table:

company_number
something_number
price
date_price_established

for a certain company i need to get all the dates that prices were established. and i dont want any date_price_established to repeat themselfs.

for example, for the following database:

1,1,15.5,1.1.2006
1,1,16,1.1.2006
1,1,17.5,1.1.2006
1,1,16,3.1.2006

the results will be : 1.1.2006, 3.1.2006.

this is what i've tried:

SELECT date_price_established
FROM myDb.some_table
WHERE company_number = 1
GROUP BY date_price_established";

View Replies !

Domain Name Now Doesnt Work
I have a software script I had installed on my server that works with a mysql database. It was working fine as far as pulling information from the database under my old domain name, however, I changed to a new domain name as primary on my server and now the database does not pull anything into the template.

I know this is probably simple but not sure how to fix this.

View Replies !

Where Clause Doesnt Work
im creating a website with a mysql database. ive jus got started. im havin a few problems
i have a product table and i execute a simple query but it doesnt seem to give me any results: heres the query:

Select * from product where ProductName = 'Age of Empires III';

the above query doesnt work but this 1 does
Select * from product where ProductName LIKE 'Age%';

View Replies !

Its Returning A Value That Doesnt Exist
Okay here is the deal. I am running a query to find out if there is an ID in my table that has a case number that matches the one being submitted. If there isnt once its should step into an if statement that would submit a number of records. Otherwise it should jump to the else statement.

I the problem comes from: the query keeps returning "Record id#2" but there is no record matching the case number being submited from the form.

if( isset($_POST['Submit'])){ //Begin If statement logic
$resultcheck = mysql_query("SELECT * FROM submissions WHERE wfmcase = " . $_POST['wfmc']) or die(mysql_error()); //Query string to test if wfmcase was already submitted
echo "Sucess, form varibles have been passed.<br />";
echo "Resultcheck query results: $resultcheck <br />";

if ($resultcheck == ""){ //Checks to see if the query was empty.
echo "There are no duplicate case escalations pending. <br />";

I added the echo statement so that i could see how far it was getting through the script. It dies after printing the varible $resultcheck which gives "Record id#2". It never enters the 2nd if statement because for what ever reason the query has the "record #id2" in it... What is causing this? I have verfied that there is no case that matches the one coming from the form and i get the same error.

View Replies !

Mysqldump Doesnt Work
i try to insert the followind data to mysql database
mysqlimport -u root -p anaktisi2 < phpbb_db_backup.sql

But this doesnt insert anything in the db.

View Replies !

Full Text Searsh Doesnt Work
I am trying to do a Full text search, but I have two problems.

1. If I enter a word that is found under multiple entries, I get no return. But it i search a word tha's only under one enetry, then it works.

2. This query works:
PHP

SELECT * FROM `site` WHERE MATCH (site_name,keywords) AGAINST ('mice') AND `approved`=Ƈ'

, but when I add WITH QUERY EXPANSION, it doesnt work.

PHP

SELECT * FROM `site` WHERE MATCH (site_name,keywords) AGAINST ('mice' WITH QUERY EXPANSION) AND `approved`=Ƈ'

I get this error:

MySQL said:

#1064 - 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 'WITH QUERY EXPANSION ) AND `approved` = Ƈ'
LIMIT 0, 30' at

View Replies !

SELECT Doesnt Select Anything WHERE Doule
I am running the next script
SELECT * FROM flcc_Tickets WHERE 'Match No'=1;
but dont get any results although there are lots of resords with 'Match No'=1 in a table. 'Match No' is DOUBLE . if run it with 'Match No'=0 i get all the table.

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 !

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 !

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 !

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 !

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 !

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 !

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 !

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 !

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 !

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 !

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?

View Replies !

Edit Permissions MySQL Administrator
How can I see/change permissions to alter table data using MySql Administrator? Of course I googled it first but I can't find the answer.

View Replies !

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).

View Replies !

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.

View Replies !

Permissions To Retrieve Field Names
What permissions are needed to get the field names from Mysql? Just SELECT? I have some code that stopped working and the only thing that I can think of that might be the cause is the permissions (I got all restrictive thinking I was being smart).

The user has SELECT, INSERT, UPDATE, DELETE only

View Replies !

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?

View Replies !

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.

View Replies !