derek writes:
>On Thu, February 13, 2025 3:20 pm, dan moylan wrote:
>>
>> i'm wondering exactly where mysql writes exported files.
>>
>> MariaDB [moylanus_dat]> select * from cal where cnm = 'calsch'
>> and ca0 = 'fix' into outfile 'fixit';
>> Query OK, 961 rows affected,
https://stackoverflow.com/questions/11484471/cant-find-the-file-created-by-outfile-in-mysql
Seems to imply it's in the MySql data directory (like /var/lib/mysql)
-derek
On Thu, February 13, 2025 3:20 pm, dan moylan wrote:
>
> i'm wondering exactly where mysql writes exported files.
>
> MariaDB [
i'm wondering exactly where mysql writes exported files.
MariaDB [moylanus_dat]> select * from cal where cnm = 'calsch'
and ca0 = 'fix' into outfile 'fixit';
Query OK, 961 rows affected, 1 warning (0.019 sec)
MariaDB [moylanus_dat]> select * from cal where cnm = 'calsch'
> From: dan moylan
> [...]
> from my original message:
>
> MariaDB [(none)]> grant all on *.* to moylanus_moy@localhost identified by
> 'x';
> Query OK, 0 rows affected (0.009 sec)
>
> the Querey OK was the response -- indicating OK.
"response OK" means the computer thinks it went OK
dale worley writes:
>> From: dan moylan
>>
>> setting up mysql has always worked for me using this process
>> but now, i seem to be denied for some reason.
>> [...]
> I don't know anything about this aspect of mysql, but in the O.P. I see
> that you do a "show grants", then a "grant all ...".
> From: dan moylan
>
> setting up mysql has always worked for me using this process
> but now, i seem to be denied for some reason.
> [...]
I don't know anything about this aspect of mysql, but in the O.P. I see
that you do a "show grants", then a "grant all ...". What does "show
grants" return
did my usual weekly fc40 upgrade yesterday, and today mysql
comes up just fine for me.
puzzled as usual,
ole dan
j. daniel moylan
84 harvard ave
brookline, ma 02446-6202
617-777-0207 (cel)
j...@moylan.us
www.moylan.us
[BLM]
___
Discuss mailing list
Di
setting up mysql has always worked for me using this process
but now, i seem to be denied for some reason.
root ~[121] mysql -u root
MariaDB [(none)]> show grants;
+---