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'
Check to see if MySQL service is running
sudo systemctl status mysql
--
Jerry Feldman
Boston Linux and Unix http://www.blu.org
On Wed, Oct 23, 2024, 12:10 PM dan moylan wrote:
>
> running fc40
>
> root ~[231] dnf install mariadb
> Last metadata expiration check: 0:37:33 ago on Wed 23 Oct 2
On Wed, 23 Oct 2024 12:07:58 -0400
dan moylan wrote:
> root ~[232] mysql -u root
> ERROR 2002 (HY000): Can't connect to local server through
>socket '/var/lib/mysql/mysql.sock' (2)
>
> suggestions?
You probably need to enable and start the service:
systemctl enable --now ma
running fc40
root ~[231] dnf install mariadb
Last metadata expiration check: 0:37:33 ago on Wed 23 Oct 2024 11:25:12 AM
EDT.
Package mariadb-3:10.11.9-1.fc40.x86_64 is already installed.
Dependencies resolved.
Nothing to do.
Complete!
root ~[232] mysql -u root
ERROR 2002 (HY000)
> 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;
+---
dan moylan wrote:
> fresh install of fc35 on lenevo thinkpad T460.
> dnf install mariadb
> dnf install mariadb-server
> however /var/lib/mysql/mysql.sock was not created, though
> it had been in previous installations. what have i missed?
greg rundlett writes:
> The socket file only exists
fresh install of fc35 on lenevo thinkpad T460.
dnf install mariadb
dnf install mariadb-server
however /var/lib/mysql/mysql.sock was not created, though
it had been in previous installations. what have i missed?
tia,
ole dan
j. daniel moylan
84 harvard ave
brookline, ma 02446-6202
617-777
I have to admit that I wasn't familiar with mysql-config-editor.
But also, in a VPS controlled by Ansible deployment (you know exactly
who has access to the server -- mostly just 'you') it's helpful to be
able to quickly grab the random DB password (from /root/.my.cnf) for
GUI client setup of MySQ
>Better practice is to have a ~/.my.cnf file or elsewhere[...]
I am surprised that nobody mentioned the command "mysql_config_editor"
and mysql's --login-path option, which permit passwordless database
logins more securely than storing plaintext passwords in .my.cnf.
https://dev.mysql.com/doc
Greg Rundlett writes:
> The -p option is forcing the prompt. When using your config,
> don't use the -p (password) option.
violla! many thanks -- to all.
ole dan
j. daniel moylan
84 harvard ave
brookline, ma 02446-6202
617-777-0207 (cel)
j...@moylan.us
www.moylan.us
[BLM]
added those -- same old, same old. i must have missed or
> misunderstood something.
>
See Greg's mesasge.
You may need to add teh commandline option to name your .cnf file; and you
.cnf file must be chmod 700 of course
___
Discuss mailing list
Discuss@
bill ricker writes:
>> ok -- i created ~/my.cnf as follows:
>> [mysql]
>> user=moylanus_moy
>> password="***"
>>
>> [mysqldump]
>> user=moylanus_moy
>> password="***"
> [client] and [server] are the useful sections AFAIK. Try those instead of
> [mysql] and [mysqldump]
added
> ok -- i created ~/my.cnf as follows:
>
> [mysql]
> user=moylanus_moy
> password="***"
>
> [mysqldump]
> user=moylanus_moy
> password="***"
>
>
[client] and [server] are the useful sections AFAIK. Try those instead of
[mysql] and [mysqldump]
On Sat, Nov 21, 2020 at 9:13 AM dan moylan wrote:
> mysqldump -u moylanus_moy -p'' -l moylanus_dat > moylanus_dat.sql
>
the script runs fine on my local computer, but on the remote
> one i get a warning that the password on the command line is
> insecure -- access denied. is there some
On Sat, Nov 21, 2020 at 9:13 AM dan moylan wrote:
> mysqldump -u moylanus_moy -p'' -l moylanus_dat > moylanus_dat.sql
>
the script runs fine on my local computer, but on the remote
> one i get a warning that the password on the command line is
> insecure -- access denied. is there some w
needing to dump on a regular basis a data base on a computer
owned by my hosting service, i generated a bash script:
mysqldump -u moylanus_moy -p'' -l moylanus_dat > moylanus_dat.sql
the script runs fine on my local computer, but on the remote
one i get a warning that the password on th
22 matches
Mail list logo
