Re: permissions in information_schema

Thanks Rolando for your help. But there is one thing that is very stranger When I use Mysql Administrator to configure the permissions that I want for the user "MySqlMonitor" , everything works fine, as you can see in the image bellow: http://img801.imageshack.us/i

RE: permissions in information_schema

..@logicworks.net http://www.linkedin.com/in/rolandoedwards -Original Message- From: Darvin Denmian [mailto:darvin.denm...@gmail.com] Sent: Monday, August 30, 2010 4:10 PM To: mysql@lists.mysql.com Subject: permissions in information_schema Can somebody tell me why the last command bellow do

permissions in information_schema

Can somebody tell me why the last command bellow doesn't works? mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'senha' WITH GRANT OPTION; Query OK, 0 rows affected (0.02 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) mysql> GRANT SUPER,REPLICATION CLIENT,SELEC

Re: Permissions and Into Outfile

Hi all, >From the manual: *Any file created by INTO OUTFILE or INTO DUMPFILE is writable by all users on the server host. The reason for this is that the MySQL server cannot create a file that is owned by anyone other than the user under whose account it is running. (You should never run mysqld

Re: probably a permissions problem that I cannot figure out.

can you give us the error , it can be found on the file "/usr/local/mysql/data/Power-Mac-G5.local.err" Thanks Anand On Thu, Jan 14, 2010 at 9:49 AM, Chris Elhardt wrote: > mySQL-5.1.34-osx10.4-powerpc-64bit > > Not sure how this happened, but mySql will not start anymore, either from > the comm

probably a permissions problem that I cannot figure out.

mySQL-5.1.34-osx10.4-powerpc-64bit Not sure how this happened, but mySql will not start anymore, either from the command line or the system pref control panel. here's a startup sample: [I have blocked out the password] Power-Mac-G5:/usr/local/mysql chriselhardt$ sudo /usr/local/mysql/bin/ m

Need help with permissions between host, db and user tables

Hi, I'm trying to customize permissions for a particular database and have run into an odd problem. I'm hoping someone on this list can suggest what I'm doing wrong. The setup is as follows: Database: property User '[EMAIL PROTECTED]' should be able to run SELECTs on t

Re: Vexing permissions issue with partitioned CREATE TABLE

Thanks to everyone who offered their suggestions. Those of you who suggested I look into SElinux were correct - my admin adjusted the policy and rebooted the server, and my problem is solved. I've never run across that issue before, but I'll know to look for it in the future. The list & the comm

Re: Vexing permissions issue with partitioned CREATE TABLE

40 AM, Brad Heintz <[EMAIL PROTECTED]> wrote: > John - > > I've seen people confuse MySQL users with OS users, too. I'm not doing > that, and I understand the difference between MySQL privs and filesystem > permissions. MySQL is running as the mysql user. I'm r

Re: Vexing permissions issue with partitioned CREATE TABLE

Per - I am finding a lot of exit=-13 entries for the mysql user, but that's the same information as in the original error message. Is there anything else you're suggesting I look for? - Brad On Sat, Dec 6, 2008 at 6:48 AM, Per Jessen <[EMAIL PROTECTED]> wrote: > Brad Heintz wrote: > > > Thanks

Re: Vexing permissions issue with partitioned CREATE TABLE

ily endorse content contained within this > transmission. > > > > > > Date: Sat, 6 Dec 2008 10:40:17 -0500 > > From: [EMAIL PROTECTED] > > To: mysql@lists.mysql.com > > Subject: Re: Vexing permissions issue with partitioned CREATE TABLE > > > > >

RE: Vexing permissions issue with partitioned CREATE TABLE

: Re: Vexing permissions issue with partitioned CREATE TABLE > > John - > > I've seen people confuse MySQL users with OS users, too. I'm not doing > that, and I understand the difference between MySQL privs and filesystem > permissions. MySQL is running as the mysql user.

Re: Vexing permissions issue with partitioned CREATE TABLE

John - I've seen people confuse MySQL users with OS users, too. I'm not doing that, and I understand the difference between MySQL privs and filesystem permissions. MySQL is running as the mysql user. I'm running the query as MySQL's root. I am able to create partitione

Re: Vexing permissions issue with partitioned CREATE TABLE

Brad Heintz wrote: > Thanks for responding. > > The CREATE TABLE docs for 5.1 say that DATA DIRECTORY and INDEX > DIRECTORY take absolute paths (not relative), and will in fact reject > paths containing > the MySQL data dir. Because I'm out of other ideas, I did try > creating the directories un

Re: Vexing permissions issue with partitioned CREATE TABLE

filesystem permissions or people confuse mysql users with os users or think because they log into mysql as 'root' they have root privileges on the box. Regards, John What On Fri, 2008-12-05 at 16:41 -0500, Brad Heintz wrote: > Thanks, Martin, but that's not it. As I mentione

Re: Vexing permissions issue with partitioned CREATE TABLE

Brad Heintz wrote: I've googled extensively, searched the list archives, and exhausted every other avenue I could think of before posting to the list, but am no closer to an answer. Does anyone have any ideas? Have I missed something in the docs? SELinux? -- Florin Andrei http://florin.my

Re: Vexing permissions issue with partitioned CREATE TABLE

> > > > > > Date: Fri, 5 Dec 2008 15:44:06 -0500 > > From: [EMAIL PROTECTED] > > To: mysql@lists.mysql.com > > Subject: Vexing permissions issue with partitioned CREATE TABLE > > > > > All - > > > > Thanks in advance for help with a

Re: Vexing permissions issue with partitioned CREATE TABLE

at 4:01 PM, <[EMAIL PROTECTED]> wrote: > > I've never created a partitioned table, but... > > $ perror 13 > OS error code 13: Permission denied > > So I suspect some kind of file-system permissions issue... > > Are you sure that the path you are giving isn&#x

Re: Vexing permissions issue with partitioned CREATE TABLE

I've never created a partitioned table, but... $ perror 13 OS error code 13: Permission denied So I suspect some kind of file-system permissions issue... Are you sure that the path you are giving isn't "relative" to the mysql data dir? In which case it'

Vexing permissions issue with partitioned CREATE TABLE

(Errcode: 13) I'm pretty sure it's not a filesystem-level issue, because permissions on the specified folders are all 777: [EMAIL PROTECTED] foo]$ ls -al /foo total 32 drwxrwxrwx 4 root root 4096 Dec 5 13:56 . drwxr-xr-x 25 root root 4096 Dec 5 13:55 .. drwxrwxrwx 2 root root 4096 Dec 5 13:

Re: Permissions

I know it.Thanks. I'm sorry that I had a mistake to what you said. On Thu, Oct 23, 2008 at 2:32 AM, Ian Christian <[EMAIL PROTECTED]> wrote: > 2008/10/21 Moon's Father <[EMAIL PROTECTED]>: > > Could you please give me an idea of how to manage the privileges inside > > mysql? > > http://www.google

Re: Permissions

2008/10/21 Moon's Father <[EMAIL PROTECTED]>: > Could you please give me an idea of how to manage the privileges inside > mysql? http://www.google.co.uk/search?q=mysql+grant first hit :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://list

Re: Permissions

; > > I run a shared Apache, Perl, PHP, Mysql, on FreeBSD environment. > > > > Here is a question: > > > > IF I have a user, that has no permissions, but with a decent password, > (in the mysql 'Users' table), > > AND that user only has access to hi

Re: Permissions

On Tue, Oct 14, 2008 at 1:49 PM, Grant Peel <[EMAIL PROTECTED]> wrote: > > Hi all, > > I run a shared Apache, Perl, PHP, Mysql, on FreeBSD environment. > > Here is a question: > > IF I have a user, that has no permissions, but with a decent password, (in > the

Permissions

Hi all, I run a shared Apache, Perl, PHP, Mysql, on FreeBSD environment. Here is a question: IF I have a user, that has no permissions, but with a decent password, (in the mysql 'Users' table), AND that user only has access to his/her database through the local host (i.e. perl or P

error log file permissions

ce to how to set the permissions on that file. I use logadm to rotate the error log file and restart the server. The problem is my monitor software wants to read that file and can't. There's no problem with it being world readable since the server is dedicated to MySQL and no one can log in t

MYSQL db no-no: deleted root permissions (smile)

Hey folks, As with many lessons in linux world it takes a big oop for a big lesson. system: gentoo OS webmin/virtualmin frontend I was trying to apply permissions to usetrs so they can only access certain DB's. This involved removing the associated user permissions from the permissions

Re: user permissions to all DB

solidzh wrote: 2007/8/21, Jay Pipes <[EMAIL PROTECTED]>: Terry wrote: Hello, I want to grant a user all permissions to all DBs on the system as well as any new DBs that show up. I want to avoid having to modify permissions everytime a new DB is added. Is there a way to do this?

Re: user permissions to all DB

2007/8/21, Jay Pipes <[EMAIL PROTECTED]>: > Terry wrote: > > Hello, > > > > I want to grant a user all permissions to all DBs on the system as > > well as any new DBs that show up. I want to avoid having to modify > > permissions everytime a new DB is added

Re: user permissions to all DB

ndo on this. Rolando, Although I agree with you, I was only trying to answer Terry's question :) Cheers, Jay Rolando Edwards wrote: > You must be very careful when granting permissions on every database this way. > > Here is why: > > By giving a user permissions on all data

Re: user permissions to all DB

Terry, I absolutely agree with Rolando on this. Rolando, Although I agree with you, I was only trying to answer Terry's question :) Cheers, Jay Rolando Edwards wrote: You must be very careful when granting permissions on every database this way. Here is why: By giving a user permis

Re: user permissions to all DB

You must be very careful when granting permissions on every database this way. Here is why: By giving a user permissions on all databases this way, you also give away permissions to the 'mysql' schema. This is where the grant tables live. A person could 1) insert new users into mysql

Re: user permissions to all DB

Yep. Terry wrote: Just to verify, will that include all new databases? On 8/20/07, Jay Pipes <[EMAIL PROTECTED]> wrote: Terry wrote: Hello, I want to grant a user all permissions to all DBs on the system as well as any new DBs that show up. I want to avoid having to modify permi

Re: user permissions to all DB

Just to verify, will that include all new databases? On 8/20/07, Jay Pipes <[EMAIL PROTECTED]> wrote: > Terry wrote: > > Hello, > > > > I want to grant a user all permissions to all DBs on the system as > > well as any new DBs that show up. I want to avoid

Re: user permissions to all DB

Terry wrote: Hello, I want to grant a user all permissions to all DBs on the system as well as any new DBs that show up. I want to avoid having to modify permissions everytime a new DB is added. Is there a way to do this? GRANT SELECT, INSERT, CREATE, ... ON *.* TO 'username'

user permissions to all DB

Hello, I want to grant a user all permissions to all DBs on the system as well as any new DBs that show up. I want to avoid having to modify permissions everytime a new DB is added. Is there a way to do this? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: permissions on mysql db

Thank u krishna. On 7/3/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote: Hi, Yes, it is possible. the command i have given in my previous email will make u to connect from mysql database server. The command below will make you to connect from the client computer The command is " grant a

Re: permissions on mysql db

Hi, Yes, it is possible. the command i have given in my previous email will make u to connect from mysql database server. The command below will make you to connect from the client computer The command is " grant all privileges on *.* to 'user1'@'192.169.6.%' identified by password" The command b

Re: permissions on mysql db

Hi Krishna, If i execute a new grant statement, then the new previlage will over ride the old previlage, if this happens, then i will not be able to connect from other client machines. I want to connect from client also from the local host. Is this possible. regards anandkl On 7/3/07, krishna c

Re: permissions on mysql db

Hi Everybody, The user which has been created with all previleges on all db, will only work from the client machine only. If you want to access from the mysql database server you have to create a user "grant all privileges on *.* to '%'@'localhost' identified by password". I hope this should work

Re: permissions on mysql db

you mean at os On 6/28/07, Rolando Edwards (DBA) <[EMAIL PROTECTED]> wrote: check your Linux/Unix user privileges *Ananda Kumar <[EMAIL PROTECTED]>* wrote: Hi All, I have created a user and grant all previlages on all db and the user can connect from any machine with in the same doiman. Now,

permissions on mysql db

Hi All, I have created a user and grant all previlages on all db and the user can connect from any machine with in the same doiman. Now, when i login from a mysql client machine, i am able to see all the databases, but when i login directly from the mysql database server, I am able to see only th

block root(linux) reset permissions

Hi, I want block root(linux) reset permissions mysql server. Is possible? Thanks Geisel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Permissions and Into Outfile

Thank you. It's working now. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Permissions and Into Outfile

Ok, on my linux (slackware 10) /var/www is owner by root.root with permissions rwxr-xr-x (755). Say you want mysql to put your data in a subdirectory under /var/www named data. As root, do: mkdir /var/www/data chgrp mysql /var/www/data chmod 775 /var/www/data Now mysql has write permissions to

RE: Permissions and Into Outfile

at my school). I am unfamiliar with the syntax you were using with the username in front of :mysql. I didn't know of any way other than chmod nnn to change permissions for UGO (user,group,other). Could you post one or two sample command line statements that illustrate this syntax in action. I did a

RE: Permissions and Into Outfile

Another variant would be, to create a directory under your www area, and give it :mysql 775 permissions, or maybe :mysql 775 permissions, depending on what you want to do with the csv file. On Fri, April 27, 2007 16:41, Kebbel, John wrote: > cat /etc/passwd on my Macintosh 10.3 at work (I'

Re: Permissions and Into Outfile

Kebbel, John wrote: cat /etc/passwd on my Macintosh 10.3 at work (I'm using Linux at home) shows me this for mysql ... mysql:*:74:74:MySQL Server:/var/empty:/usr/bin/false The home directory for mysql is /var/empty, which does exist. Should I write ~into file~ output to this folder or should

RE: Permissions and Into Outfile

mysql home directory to some other folder? > -- > From: Gerald L. Clark > Sent: Friday, April 27, 2007 10:09 AM > To: Kebbel, John > Cc: mysql@lists.mysql.com > Subject: Re: Permissions and Into Outfile > > Kebbel, John wrote: > > I

Re: Permissions and Into Outfile

time, so its permissions must be wide open. I tried writing the file to /tmp and it worked fine. Since you cannot write to an existing file, you cannot create the file in advance and set its permissions. What is the trick to getting the file to write successfully anywhere you want it to be wr

Permissions and Into Outfile

o its permissions must be wide open. I tried writing the file to /tmp and it worked fine. Since you cannot write to an existing file, you cannot create the file in advance and set its permissions. What is the trick to getting the file to write successfully anywhere you want it to be wr

RE: Stored proc permissions question

> Better add "SQL SECURITY DEFINER" to it. I noticed that it works with and without this. I have added it to the procedure. Another quick question though. Since I have added the end user that will execute the procedure it works fine, until I drop the procedure and recreate it then I have to rea

Re: Stored proc permissions question

On 2007-02-28 Gary W. Smith wrote: ... > If I'm understanding the docs correct (which I'm probably not), I should > create the procedure with [EMAIL PROTECTED] > > CREATE [EMAIL PROTECTED] PROCEDURE Better add "SQL SECURITY DEFINER" to it. .. > The next que

RE: Stored proc permissions question

> The next question is what permissions do I need to give > [EMAIL PROTECTED] to just access that one permission? The sound of that thump thump thump is my head hitting the wall. There is like a single small line in the GRANT section of the how to that mentioned "TABLE|PROCEDURE|F

RE: Stored proc permissions question

user_password = P_password; END Is this correct? The next question is what permissions do I need to give [EMAIL PROTECTED] to just access that one permission? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Stored proc permissions question

On 2007-02-28 Gary W. Smith wrote: > Basically, here is the stored proc. It works, but only for root. Is it > possible to allow user to execute this without having SELECT access to > the table users? If so, how? Do you know about the "SQL SECURITY { DEFINER | INVOKER }" options to CREATE PRO

Stored proc permissions question

I have a set of tables that contain sensitive user information. I need to use this data for validation BUT I don't want the end user to have access to read this data. In MSSQL I used to be able to create a stored proc to do the work (even though the user didn't have access to the table). I was w

Re: Table permissions - before the table is created?

e existing application. At 11:57 30/08/2006, [EMAIL PROTECTED] wrote: Chris Jones wrote: > Can the mysql administrator grant permissions on a table in an existing > database if that table doesn't exist yet? This is part of planning for an > upgrade to an existing application. The m

Re: Table permissions - before the table is created?

Thanks for that. Will create the two tables ahead of time which won't affect the existing application. At 11:57 30/08/2006, [EMAIL PROTECTED] wrote: Chris Jones wrote: > Can the mysql administrator grant permissions on a table in an existing > database if that table doesn't

Re: Table permissions - before the table is created?

Chris Jones wrote: > Can the mysql administrator grant permissions on a table in an existing > database if that table doesn't exist yet? This is part of planning for an > upgrade to an existing application. The mysql administrator won't be there > when I add the table to

Table permissions - before the table is created?

Can the mysql administrator grant permissions on a table in an existing database if that table doesn't exist yet? This is part of planning for an upgrade to an existing application. The mysql administrator won't be there when I add the table to the existing database and I don&#x

Re: Permissions Weirdness

nding that there is nothing grantable with all that would allow this (correct me if I'm wrong). Then to make it even better, whenever I access/run whatever on the database, permissions get totally whack and nothing can login anymore. I'd love to google this but am not quite sure wher

Permissions Weirdness

thing grantable with all that would allow this (correct me if I'm wrong). Then to make it even better, whenever I access/run whatever on the database, permissions get totally whack and nothing can login anymore. I'd love to google this but am not quite sure where to even start. Thank

Re: Transfer users and permissions between servers

. On Wed, 7 Jun 2006 [EMAIL PROTECTED] wrote: > To: mysql@lists.mysql.com > From: [EMAIL PROTECTED] > Subject: Transfer users and permissions between servers > > Is there an easy way to transfer users and their > permissions from one server to another? We are moving > data

Transfer users and permissions between servers

Is there an easy way to transfer users and their permissions from one server to another? We are moving databases to a new server and have a lot of users to move as well. Thanks in advance! Donna

Re: Permissions block database creation

User ''@'localhost' just hasn't enough privileges to create databases. http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html Doug Pinkerton wrote: I'm a total newbie working through the tutorial in DuBois's _MySQL_. I've got MySQL running on my PowerBook. In Terminal, I can use the mysq

RE: Permissions block database creation

You need to set GRANTs to create on the host. http://dev.mysql.com/doc/refman/5.0/en/grant.html -Original Message- From: Doug Pinkerton [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 14, 2006 1:26 PM To: mysql@lists.mysql.com Subject: Permissions block database creation I'm a

Permissions block database creation

I'm a total newbie working through the tutorial in DuBois's _MySQL_. I've got MySQL running on my PowerBook. In Terminal, I can use the mysql client to get responses to things like SELECT NOW(). But the command CREATE DATABASE sampdb; results in the following error. ERROR 1044 (42000): Acce

Re: Permissions

CodeHeads wrote: On Thu, 2006-02-23 at 21:46 -0600, Walter Johnson wrote: #chown mysql:mysql /var/mysql-data #chmod 770 /var/mysql-data Try this, assuming the files are in there for the database. $chown -R mysql:mysql /var/mysql-data/* $chmod -R 770 /var/mysql-data/* Hope that h

Re: Permissions

On Thu, 2006-02-23 at 21:46 -0600, Walter Johnson wrote: > >> #chown mysql:mysql /var/mysql-data > >> #chmod 770 /var/mysql-data Try this, assuming the files are in there for the database. $chown -R mysql:mysql /var/mysql-data/* $chmod -R 770 /var/mysql-data/* Hope that helps. -- Best regards

Re: Permissions

Hi, Walter - What's the exact error there? We can't tell if you're talking about file permissions, or actual database permissions. Thanks - -dant -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozde

Re: Permissions

ysql-data either in the terminal > or the Finder? > > > thanks > -walter > Hi, Walter - What's the exact error there? We can't tell if you're talking about file permissions, or actual database permissions. Thanks - -dant -BEGIN PGP SIGNATURE- Version: GnuPG

Permissions

This is probably a simple question. I installed MySQL about a month ago on Mac OS X and I am new to this. During the installation (as root) I created a directory /var/mysql-data. Then, following the installation instructions: #chown mysql:mysql /var/mysql-data #chmod 770 /var/mysql-data Th

Re: Permissions for /var/run/mysqld

that I have to change, it's the directory. > | I don't really have much to add. > | a quick google search on "mysql.sock permissions" shows this bug: > | http://bugs.mysql.com/bug.php?id=11380 > | did you also upgrade mysql when you did the OS upgrade ? If so, ba

Re: Permissions for /var/run/mysqld

x27;t be a problem. I don't really have much to add. a quick google search on "mysql.sock permissions" shows this bug: http://bugs.mysql.com/bug.php?id=11380 did you also upgrade mysql when you did the OS upgrade ? If so, backup your stuff and run mysql_install_db. That's the only

Permissions for /var/run/mysqld

ct to mysql when I reboot the machine. The problem appears to be permissions related. On boot, /var/run/mysqld is owned by mysql and in the root group with 770 permissions. That means that dspam can't open /var/run/mysqld/mysqld.sock to connect to the database. I've been fixing the p

Re: cannot delete row but permissions ok

> | localhost | spamassassin | amavisd | Y | Y | Y > > > | Y | > > | 127.0.0.1 | spamassassin | amavisd | Y | Y | Y > > > | Y | > > > +---+------+-+-+-+-

Re: cannot delete row but permissions ok

visd | Y | Y | Y | Y | +---+--+-+-+-+-+-+ What is going on? -- Peter Hi - Have you ran a 'flush privileges' as root after granting the amavisd user permissions to do those actions? Thank you. That did it. You know I was looking for a related button on phpMyAdm

Re: cannot delete row but permissions ok

i - Have you ran a 'flush privileges' as root after granting the amavisd user permissions to do those actions? Thanks -dant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

cannot delete row but permissions ok

While on MySQL 4.0.24, I connect to my database: $ mysql -u amavisd -ppassword spamassassin This user can select and insert (that is confirmed) but cannot delete a row: mysql> delete from users where 'fullname' = 'bongo.net' limit 1; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to dat

RE: File Permissions On Database Files

vent --- -Original Message- From: Hal Vaughan [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 January 2006 7:54 AM To: mysql@lists.mysql.com Subject: File Permissions On Database Files My

File Permissions On Database Files

y the user mysql, and has limited read and write permissions (this is on Linux, btw). It would be a HUGE help if I could make sure every time MySQL creates any files, it creates them with at least group if not all read access for backup purposes. Is there a simple way to do this? Thanks!

Re: Min permissions to run `mysqladmin version`

At 16:33 -0800 12/9/05, Scott Haneda wrote: I need to run `mysqladmin version` from a remote host, on the same LAN, what are the min permissions for a user I need to set up to get this data? No permissions are necessary, you just need an account that has no privileges. The account needs only

Min permissions to run `mysqladmin version`

I need to run `mysqladmin version` from a remote host, on the same LAN, what are the min permissions for a user I need to set up to get this data? -- - Scott HanedaTel: 415.898.2602 <http://www.newgeo.

Re: fixing messed up permissions

[EMAIL PROTECTED] wrote: I screwed up the permissions on my database. Basically I revoked all the permissions of the root account on the mysql database. To try to fix this, I went through all of the instructions here: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html I

fixing messed up permissions

I screwed up the permissions on my database. Basically I revoked all the permissions of the root account on the mysql database. To try to fix this, I went through all of the instructions here: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html I changed this a little to do

Re: Permissions for the install

Bruce Martin wrote: What should the permissions be for the MySQL 5 install on Mac OS X. By default it was Owner = System Group = wheel. Could someone give me a list of directories and what owner:group settings I should have? Bruce Martin The Martin Solution PO Box 644 Delaware Water Gap

Permissions for the install

What should the permissions be for the MySQL 5 install on Mac OS X. By default it was Owner = System Group = wheel. Could someone give me a list of directories and what owner:group settings I should have? Bruce Martin The Martin Solution PO Box 644 Delaware Water Gap, PA (570) 421-0670

RE: Database user Permissions

Shawn, Thanks again for responding :o) All understood, it seems to me though that this is achieved when you create the user by specifying where the specific user can login from. So granting permissions to user@'%' means from anywhere while [EMAIL PROTECTED] means only when they access

Re: Database user Permissions

"Jeff" <[EMAIL PROTECTED]> wrote on 10/12/2005 08:43:16 AM: > Just rebuilt one of my servers and when setting up MySQL again an old > problem I'd had and worked around came up again. > > Why is it that if I grant a user@'%' permissions, that user can a

Database user Permissions

Just rebuilt one of my servers and when setting up MySQL again an old problem I'd had and worked around came up again. Why is it that if I grant a user@'%' permissions, that user can access the database from any other machine on the network, but that same user logon accessing

Re: Is this a permissions problem?

ny MySQL site to work on my local PC, but > they work fine remotely. I have just changed PC and now have IIS > whereas before I used to have Personal Web Server. I have just managed > to stop this happening with any microsoft access database site by > changing permissions, but I am not h

Is this a permissions problem?

ow have IIS whereas before I used to have Personal Web Server. I have just managed to stop this happening with any microsoft access database site by changing permissions, but I am not having the same kind of result with the MySQL sites. Do I need to change permissions for the MySQL databases? If so,

RE: MySQL account permissions

On Monday, March 28, 2005 15:07, Philippe Reynolds wrote: > Hi, > > I've just create an account and given it all privileges for > "database_name.*". However when I try to 'load data infile' it > tell's me that the account doesn't permit it. > > When I use the 'root' account everything is fine.

Re: [MySQL] mysql/snort/webmin/permissions

Mark Sargent wrote: Ashley M. Kirchner wrote: Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. Hi All, heck, how exactly do I do that..? Move the whole

Re: [MySQL] mysql/snort/webmin/permissions

Ashley M. Kirchner wrote: Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. Hi All, heck, how exactly do I do that..? Move the whole mysql dir to a path

Re: [MySQL] mysql/snort/webmin/permissions

Mark Sargent wrote: [EMAIL PROTECTED] pcre-5.0]# mysql -h mysql -p -bash: mysql: command not found You don't have mysql in root's path. Once you fix that little problem, you should be all set. -- H | I haven't lost my mind; it's backed up on tape somewhere. +-

mysql/snort/webmin/permissions

E, INSERT, SELECT, DELETE, UPDATE on *snort*.* to *snort*; Query OK, 0 rows affected (0.02 sec) mysql> exit bye I used webmin to create a new DB, snort, and gave permission to Username "snort" to create, insert, delete, select and update from host permissions. Is it the same as above

Re: Mysql permissions

"Nupur Jain" <[EMAIL PROTECTED]> wrote on 02/08/2005 01:26:06 PM: > I have problems with access permissions on a Solaris 9 installtion > of MySql-max 4.1. My user table shows this > > select * from user; > | Host| User | Password > | Selec

Mysql permissions

I have problems with access permissions on a Solaris 9 installtion of MySql-max 4.1. My user table shows this select * from user; | Host| User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv

  1   2   3   4   >