[linux-help] Re: Mysql permissions

[gLaNDix (Jesse Kaufman) <glandix@xxxxxxxxxxxx>]

as far as GRANT syntax and options go, i would suggest looking into
phpMyAdmin.  it's a great tool that makes managing a database extremely
easy.  i use it at work w/ MySQL-4.x for all the databases i've developed=
.
 it has lists of privileges and lots of documentation (or links to
pertinant documentation on mysql.com).  also, for anything you do, it
shows the SQL command for doing the same thing (if you're concerned about
the idea of using gui and never getting to learn the actual CLI).

gLaNDix

> bruce bales wrote:
>> Tom Hull wrote:
>>
>>>Another way to dump a table or a whole database would be to use the
>>> mysqldump program. This produces a file which can be redirected into
>>> mysql to restore the table/database.
>>>
>>
>> [bruce@bertha temp]$ mysqldump -u bruce -p class50 email >
>> /tmp/email.dat Enter password:
>> [bruce@bertha temp]$
>>
>> This also worked, but the output would require considerable editting.
>>  There was a bunch of information at the top and each line was
>> prefixed
>> with "INSERT INTO email VALUES ."
>
> Those are SQL statements. If you wanted to restore a dump, you'd create
> a new database then redirect stdin for mysql to the dump file: each of
> those statements inserts a record into the database.
>
>> Now I can do what I was trying to do, but still interested in knowing
>> why I can't select to a file.  I am convinced that 'mysql bruce'
>> doesn't  have write permission to any of the directories I have tried
>> to write  to.  An interesting exercise.
>
> Try selecting into a new file in /tmp/ -- that directory should always
> be world-writable. If it can't do it you probably still have a GRANT
> problem. If you can it's just a file permissions problem. The file is
> being written as user/group mysql/mysql, since that's what the server i=
s
> running as.
>
> If you have a GRANT problem take a look at /etc/my.cnf to see if there'=
s
> anything suspicious there. I don't know what this might be -- don't hav=
e
> the problem here -- but I have an account with an ISP who disallows
> GRANT FILE somehow, so I suspect that there is a configuration way to d=
o
> so. (Like I said before, there are security issues with this.)
>
>> Thanks to all of you for the help,
>> bruce
>
> --
> /*
>   *  Tom Hull * thull2(cox.net) * http://www.tomhull.com/
>   */
>
> -- This is the linux-help@xxxxxxxxx list.  To unsubscribe,
> visit http://www.complete.org/cgi-bin/listargate-aclug.cgi



-- This is the linux-help@xxxxxxxxx list.  To unsubscribe,
visit http://www.complete.org/cgi-bin/listargate-aclug.cgi