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/img801/6225/capturadetelabe.

RE: permissions in information_schema

Information_schema is a read-only memory database. When you create'MySqlMonitor'@'localhost', you will still see the information_schema. However, the information_schema will only contain table info 'MySqlMonitor'@'localhost' can access. Information_schema behaves more like a restricted view of

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: 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

Could you please give me an idea of how to manage the privileges inside mysql? Thank you very much. On Wed, Oct 15, 2008 at 5:01 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Tue, Oct 14, 2008 at 1:49 PM, Grant Peel <[EMAIL PROTECTED]> wrote: > > > > Hi all, > > > > I run a shared Apache, Perl,

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 mysql 'Users' table), > AND that user

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,

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

I experimented with a local /var/www folder. I assumed setting 2, 6, or 7 for the Other value would give mysql write privileges, but mysql would not settle for anything less than a 7 in that last slot. What was really curious to me was that the User and Group settings were inconsequential. I even s

RE: Permissions and Into Outfile

ctory 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: >> >

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

Kebbel, John wrote: I was trying to write the output of a select statement to a tab-delimited text file. I could not write the file to a folder inside /var/www or to my home file because of permission problems. After a moment's reflection, I realized /tmp had stuff written to it all the time, so

Re: Permissions Weirdness

Chris White schrieb: Normally I try to be as descriptive as possible with subject lines but.. not quite sure what else to call it. So basically, I was given ALL access by our sysadmin to a particular database. Now, somehow I was able to create a database and use it! It's my understanding th

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 total new

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

Dan Trainor wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Walter Johnson wrote: 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 ins

Re: Permissions

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Walter Johnson wrote: > 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 > instruc

Re: Permissions for /var/run/mysqld

/ "sheeri kritzer" <[EMAIL PROTECTED]> was heard to say: | That's odd. My mysql.sock is chmod 777, which happened automatically. Yes, the mysql.sock file is 777. But the directory that contains it /var/run/mysqld is 770 on boot. | Check the startup script. Is it calling mysqld_safe? Are you us

Re: Permissions for /var/run/mysqld

That's odd. My mysql.sock is chmod 777, which happened automatically. Check the startup script. Is it calling mysqld_safe? Are you using the regular startup script that came with mysql, or have you mucked with it? Make sure when you chmod that the file is still a socket. Shouldn't be a proble

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, PA

Re: permissions of ordinary users?

beginner <[EMAIL PROTECTED]> wrote: > Hi, > i got mysql 4.0.13 on my machine. When i installed it, > i did only basic stuff to get it running (bascilly hit > setup). > Now, i'm getting a little bit closer to mysql (the > system starts to became more friendly), but i got the > following problem: >

RE: Permissions

You could use views but they will not be available until version 5 or 5.1 In the doc you can find : Views are useful for allowing users to access a set of relations (tables) as if it were a single table, and limiting their access to just that. Views can also be used to restrict access to rows (a

Re: Permissions questions

If you insert records directly into the tables in mysql, then they only have the rights you specifically specify. GRANT is smart enough to handle a lot of the dirty-work for you. In particular, I like the: GRANT SELECT on *.* to readonly@'%' identified by 'readonly'; This will create the user

RE: permissions error for the slave server

nal Message- From: Dan Rossi [mailto:[EMAIL PROTECTED] Sent: Sunday, March 02, 2003 7:33 PM To: Dan Rossi; [EMAIL PROTECTED] Subject: RE: permissions error for the slave server has anyone got any idea why it wont let the slave connect properly ? here is my slave settings port

RE: permissions error for the slave server

-host=localhost report-port=3307 server-id=2 -Original Message- From: Dan Rossi [mailto:[EMAIL PROTECTED] Sent: Saturday, March 01, 2003 7:55 PM To: [EMAIL PROTECTED] Subject: RE: permissions error for the slave server hi there my sql slave server cannot replicate as its getting

RE: permissions error for the slave server

hi there my sql slave server cannot replicate as its getting permissions errors dont know what happened but its not happy now 030302 7:09:24 Slave I/O thread killed while connecting to master 030302 7:09:24 Slave I/O thread exiting, read up to log 'FIRST', position 4 030302 7:09:29 Slave I/O

Re: RE: permissions mysql.user

Hello Gavin, Thursday, October 17, 2002, 3:40:11 PM, you wrote: GL> Thanks for your reply Victoria . You're welcome. >> GL> How is the best way to reconstruct this table? >> Add users again. Or what you mean "reconstruct"? GL> What I wish to do is add users, I can read the sytax which gives me

re: permissions mysql.user

Gavin, Wednesday, October 16, 2002, 3:59:04 PM, you wrote: GL> I have a mysql database (version 3.23.47) running on a virtual server. GL> I have taken the running over from someone else and have been having trouble GL> with database permissions. To combat this I bypassed passwords by creating a

Re: RE: permissions questions...

umn level. The output of SHOW GRANTS means that 'usernew' has no global privileges (USAGE) and has SELECT privilege on the database 'Liste_MP3'. C> Thanks! C> -Original Message- C> From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] C> Sent: 1 août, 2002

Re: permissions questions...

on 8/1/02 11:32 AM, Victoria Reznichenko at [EMAIL PROTECTED] wrote: > C> Is there a way to create a user by giving access to only one database, > C> without giving him the permission to "mysqlshow --user=[thisuser] > C> --password=[thispassword]" and retrieve all database names? He should see >

RE: permissions questions...

27; | | GRANT SELECT ON Liste_MP3.* TO 'usernew'@'localhost' | +--- + 2 rows in set (0.00 sec) It's a new user I never entered before, and still, it generates this usage on *.*... Thanks! -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED

Re: permissions questions...

Caron, Thursday, August 01, 2002, 5:34:16 PM, you wrote: C> mysql> show grants for nouveau@localhost; C> +--- C> + C> | Grants for nouveau@localhost| C> +---

Re: Permissions problems

If mysql owns them, 0770 should be fine. System Administrator a.k.a. The Root of the Problem wrote: >USually all the databases sets up fine BUT recently, I have >had to adjust databases to 0777 in order to get them to >work and change the ownership. > >I prefer the more secure model of mysql. >

Re: Permissions problem

Since -p="" is not valid syntax, it should not work. There is no equal sign after the -p, and no space between the p and the password which needs no quotes. If you have no password leave out the -p option. Derek Fountain wrote: >Hi, > >I have a server running 3.23.41 on Redhat 7.1. The probl

Re: Re: Permissions are now denied from the mysql client

Ruben, Sunday, June 23, 2002, 10:51:59 AM, you wrote: RIS> Of course it's running. I can only get in as the root user RIS> of the system Check where your mysql.sock is located and check permissions on the socket file. RIS> On 2002.06.23 03:51 Brandon McCombs wrote: >> >> >> Ruben I Safir wro

Re: Permissions are now denied from the mysql client

Ruben I Safir wrote: > > I recently installed mysql on a new system and the client on works with root? > > Whats up? > > ruben@www2:~> !mys > mysql -p > Enter password: > ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > ruben@www2:~> > mysqld isn't runn

Re: Permissions are now denied from the mysql client

Of course it's running. I can only get in as the root user of the system On 2002.06.23 03:51 Brandon McCombs wrote: > > > Ruben I Safir wrote: > > > > I recently installed mysql on a new system and the client on works with root? > > > > Whats up? > > > > ruben@www2:~> !mys > > mysql -p > >

Re: Permissions for mysqladmin

Cindy Nelson wrote: > Hi, > > I am using SuSE 7.0 and MySQL 4.0.1. I had quite a time > getting the daemon started on Linux but finally succeeded. > I can start the daemon logged on as su and I can connect > to the database as user=mysql and modify the existing DB > called test. > > I set the p

Re: Permissions Question

At 20:27 -0700 3/14/02, Mike Hillyer wrote: >I am trying to make a database system in MYSQL, but I need to restrict >access to certain records in a table, is there any way to only allow access >to records in a table that have a field matching a certain value? MySQL's access system can restrict ac

Re: permissions problem

At 22:25 +0100 2/9/02, Nick Wilson wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >Hi all, >I'm having a spot of bother with permissions (i think) >I just set up MySQL for private developement at home with PHP and >created a db 'mydb' and granted all privs to nick@localhost > >Now, I can

Re: permissions problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Paul DuBois declared > Note that the message doesn't include a user name in front of the '@'. > > Which it would if you were specifying one. Hello Paul, I did notice that but I /am/ specifying a user mysql_connect($host, $user,

Re: permissions problem

At 23:31 +0100 2/9/02, Nick Wilson wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > > >* and then Paul DuBois declared >> Note that the message doesn't include a user name in front of the '@'. >> >> Which it would if you were specifying one. > >Hello Paul, > I did notice that but

Re: permissions problem

At 0:19 +0100 2/10/02, Nick Wilson wrote: >* and then Paul DuBois declared >> >BTW >> >er... I have your book here :) >> >> Ah. Well, in *that* case, check p429 and pp464-465. You may be getting >> bit by the phenomenon described there. >sql > >Aha! Well that certainly appears to be it b

Re: permissions problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql * and then Paul DuBois declared > Do you have an entry for user apache, host localhost in the user No just entries for 'nick' and 'root' > table, and have you deleted the entries for user='' and run FLUSH > PRIVILEGES? Certainly have. - --

Re: permissions problem

* and then Paul DuBois declared > >BTW > >er... I have your book here :) > > Ah. Well, in *that* case, check p429 and pp464-465. You may be getting > bit by the phenomenon described there. sql Aha! Well that certainly appears to be it but now I'm getting Access denied to user apache@local

Re: permissions problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql * and then Paul DuBois declared > Do you have an entry for user apache, host localhost in the user No just entries for 'nick' and 'root' > table, and have you deleted the entries for user='' and run FLUSH > PRIVILEGES? Certainly have. - --

Re: permissions problem

At 0:19 +0100 2/10/02, Nick Wilson wrote: >* and then Paul DuBois declared >> >BTW >> >er... I have your book here :) >> >> Ah. Well, in *that* case, check p429 and pp464-465. You may be getting >> bit by the phenomenon described there. >sql > >Aha! Well that certainly appears to be it b

Re: permissions problem

* and then Paul DuBois declared > >BTW > >er... I have your book here :) > > Ah. Well, in *that* case, check p429 and pp464-465. You may be getting > bit by the phenomenon described there. sql Aha! Well that certainly appears to be it but now I'm getting Access denied to user apache@local

Re: permissions problem

At 22:25 +0100 2/9/02, Nick Wilson wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >Hi all, >I'm having a spot of bother with permissions (i think) >I just set up MySQL for private developement at home with PHP and >created a db 'mydb' and granted all privs to nick@localhost > >Now, I can

Re: permissions problem

At 23:31 +0100 2/9/02, Nick Wilson wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > > >* and then Paul DuBois declared >> Note that the message doesn't include a user name in front of the '@'. >> >> Which it would if you were specifying one. > >Hello Paul, > I did notice that but

Re: permissions problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Paul DuBois declared > Note that the message doesn't include a user name in front of the '@'. > > Which it would if you were specifying one. Hello Paul, I did notice that but I /am/ specifying a user mysql_connect($host, $user,

Re: Permissions Problems

On Tue, 14 Aug 2001, Gerald Clark wrote: >You are connecting TO host www.4cdg.com, but the permission table entry >list the hosts you connect FROM. > Actually, it is just one host...I am running on FreeBSD and I have to specify the hostname on the command line. >You need to grant privileges to

Re: Permissions Problems

You are connecting TO host www.4cdg.com, but the permission table entry list the hosts you connect FROM. You need to grant privileges to the user and machine you connect FROM. Butch Evans wrote: > Can anyone explain why this is happening? > > > root@www:/# mysql -u dgadmin -h www.4cdg.com -p

Re: Permissions Problems

Hi, > Can anyone explain why this is happening? > > > root@www:/# mysql -u dgadmin -h www.4cdg.com -p cdgcatalog > Enter password: > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' > (Using password: YES) remove the space between -p and the password. Rgds, Indrek -- For technical

RE: Permissions Problems

Do not put a space between "-p" and "cdgcatalog", i.e. use "-pcdgcatalog". / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq > -Original Message- > From: Butch Evans [mailto:[EMAIL PROTECTED]] > Sent: 14. august 2001 07:48

RE: permissions, Help for Newbie, question

say i am running a server with mysql and phpmyadmin and i have some dbs (including of course the mysql db)... so when someone says to "set them up a 'MySQL account'" what exactly do they mean? and how do i do it? TIA At 9:41 PM -0500 7/30/01, [EMAIL PROTECTED] wrote: >Hi Nicole, >I guess the

RE: permissions, Help for Newbie, Nicole

Hi Nicole, I guess the first issue is to be certain that you have the correct password and a MySQL account set up. If you have a shell account try something like mysql -u[your user name] -p[your password]. Sometimes ISP's will use different passwords for MySQL than the standard log in, we often

Re: permissions - again

- Original Message - From: Carsten H. Pedersen <[EMAIL PROTECTED]> To: Robert Roberts <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, July 28, 2001 6:31 PM Subject: RE: permissions - again > > My assumption: > > mysql> GRANT SE

RE: permissions - again

> My assumption: > mysql> GRANT SELECT, INSERT, UPDATE ON client_db.* > TO db_user@localhost IDENTIFIED BY 'password'; > > Now this is where I get a bit confused. It's not clear to me where the > client is connecting from. I assume they are connecting from localhost > because everythi

Re: permissions - again

Robert Roberts wrote: > > I am new to this list. I posted a perfectly honest question, but all I get > back is an email from [EMAIL PROTECTED] saying NO SPAM PLEASE. I checked > appua.com. The site is in Russian. I don't understand why I'm getting this. > Perhaps someone can explain. In the meant

Re: permissions and table creation

> I'm very new to mysql and adminstration of database software in Have you tried phpMyAdmin to manage your db? Recommended: http://www.phpwizard.net/projects/phpMyAdmin/ -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683

Re: permissions

And what command did you use to create the user? - Original Message - From: "Peter I. Hansen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 5:32 Subject: permissions > Hi > > I'm currently adding users to a MySQL server on a LAN (www.xxx.yy), and > I want th

Re: permissions

At 11:32 PM +0200 6/6/01, Peter I. Hansen wrote: >Hi > >I'm currently adding users to a MySQL server on a LAN (www.xxx.yy), and >I want the structure to be like this : > >1) user X can connect from '%.xxx.yy' and from 'localhost'. >2) user X can only connect to database X. > >I can only make one o

Re: Permissions

mysql caches hostnames, so perhaps 13ave.com is connecting to your database server as well? say for instance: 13ave.com connects, mysql resolves that to $ host 13ave.com 13ave.com has address 12.111.170.18 web.web-ster.com comes along, mysql sees the reverse and says 'Hey, I've seen you before,

Re: Permissions

Yep that was it! Yesterday there was a messup with DNS that caused the reverse DNS to be 13ave.com I quickly changed it, but apparently MySQL cached that entry. It's been 24 hours, but still. As soon as I just did a flush-hosts it came right up. Thanks! At 12:12 PM 2/20/2001 -0800, Atle V