gt;> >> Am 13.03.2018 um 22:59 schrieb Roger House:
>>> >>> In all respects except one, the treatment of Unicode works just
>>> fine.
>>> >>> I can write Unicode to database tables, read it, display it,
>etc.,
>>> >
2:59 schrieb Roger House:
>>> In all respects except one, the treatment of Unicode works just
fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I exec
espects except one, the treatment of Unicode works just fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I execute a SELECT statement to see rows in a table
>>
ust fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I execute a SELECT statement to see rows in a table
>>> containing the Venus and Mars Unicode c
, the treatment of Unicode works just fine.
I can write Unicode to database tables, read it, display it, etc.,
with no problems. The exception is mysql, the MySQL Command-Line
Tool. When I execute a SELECT statement to see rows in a table
containing the Venus and Mars Unicode characters, here is what I
Am 13.03.2018 um 22:59 schrieb Roger House:
In all respects except one, the treatment of Unicode works just fine. I
can write Unicode to database tables, read it, display it, etc., with no
problems. The exception is mysql, the MySQL Command-Line Tool. When I
execute a SELECT statement to see
Five months ago I posted the query shown below on StackOverflow. I got
one reply which was not of much help. So I am trying again, hoping a
more MySQL-centric forum might be able to solve my problem.
Roger House
How to get the MySQL Command-Line Tool to display Unicode properly?
I use
2017/10/18 18:32 ... Roger House:
I get the same behavior with the MySQL Command Line Tool when I run it on
Windows, Mac OS X, and Ubuntu, so I'm pretty sure the problem has to do
with mysql itself.
What do you know about the displays to which the client is writing?
In the case of "cmd&q
with these parameters:
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
In all respects except one, the treatment of Unicode works just fine. I can
write Unicode to database tables, read it, display it, etc., with no
problems. The exception is mysql, the MySQL Command-Line Tool
My Synology station is on 192.168.178.27,
the database listens to port 3306,
on my FritzBox I forwarded port 3306 to 192.168.178.27,
I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/
But when I try:
mysql --host=192.168.178.27 --password=* --user=wybo
I get:
ERROR 1045
Hi Wybo,
On 8/20/2014 3:47 PM, Wybo wrote:
My Synology station is on 192.168.178.27,
the database listens to port 3306,
on my FritzBox I forwarded port 3306 to 192.168.178.27,
I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/
But when I try:
mysql --host=192.168.178.27
Hello Wybo,
I cleansed your reply and cc:'ed the list again to share the answer.
On 8/20/2014 4:24 PM, Wybo wrote:
Hi Shawn,
Thanks for your prompt reply - I suppose I'll have to do that query via
phpMysqlAdmin. When I do that, the only host that appears is localhost.
However, when I browse
Yes, that worked - thank you very much!
On 2014-08-20 22:51, shawn l.green wrote:
Hello Wybo,
I cleansed your reply and cc:'ed the list again to share the answer.
On 8/20/2014 4:24 PM, Wybo wrote:
Hi Shawn,
Thanks for your prompt reply - I suppose I'll have to do that query via
2013/3/31 Norah Jones nh.jone...@gmail.com
Hi,
To source sqldump i can use the source command, but if I need to do the
same stuff using command line without going to the sqlpromt, can I achieve
that.
Hello,
You mean cat sqldump.sql | mysql -uwhatever -pwhatever whatever_database
I know, all the shell command can do this. Thanks.
2010/8/25 Moon's Father yueliangdao0...@gmail.com
Hi.
For example, entering mysql command line client,
mysql pager more ( or pager md5sum and so on.)
I want to know how many command the 'pager' follows? Any reply will be
big
In the last episode (Aug 25), Moon's Father said:
Hi.
For example, entering mysql command line client,
mysql pager more ( or pager md5sum and so on.)
I want to know how many command the 'pager' follows? Any reply will
be big appreciated.
Any command can be used as a pager. Some
Hi.
For example, entering mysql command line client,
mysql pager more ( or pager md5sum and so on.)
I want to know how many command the 'pager' follows? Any reply will be
big appreciated.
line?
Is there a way to use mysqladmin (or mysql) to truncate a table as a
one-off command from the command line?
I have an issue with importing data from one database into another, but
the second database might have columns that the first did not.
On database 1, I use mysqldump to grab
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
-Original Message-
From: ??? [mailto:ekilimc...@gmail.com]
Sent: Wednesday, March 17, 2010 1:57 AM
To: John Oliver
Cc: mysql@lists.mysql.com
Subject: Re: Trancate table from command line?
If you use *nix, you can use this form
-Original Message-
From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com]
Sent: Wednesday, March 17, 2010 10:07 AM
To: '??? '; 'John Oliver'
Cc: mysql@lists.mysql.com
Subject: RE: Trancate table from command line?
Am I missing something? Doesn't the -e parameter
Is there a way to use mysqladmin (or mysql) to truncate a table as a
one-off command from the command line?
I have an issue with importing data from one database into another, but
the second database might have columns that the first did not.
On database 1, I use mysqldump to grab certain tables
On Tue, Mar 16, 2010 at 02:12:42PM -0700, John Oliver wrote:
Is there a way to use mysqladmin (or mysql) to truncate a table as a
one-off command from the command line?
I have an issue with importing data from one database into another, but
the second database might have columns
) to truncate a table as a
one-off command from the command line?
I have an issue with importing data from one database into another, but
the second database might have columns that the first did not.
On database 1, I use mysqldump to grab certain tables, and when I try to
simply overlay those tables
Devart
Email: i...@devart.com
Web: http://www.devart.com
FOR IMMEDIATE RELEASE
CONTACT INFORMATION:
Julia Samarska
jul...@devart.com
26-Feb-10
Schema and Data Comparison and Synchronization Tools for MySQL Offer Command
Line Mode and Comparison Reports
MySQL database
Thanks that worked.
I was trying -v from the help.
Gavin Towey gto...@ffn.com
10/02/2009 05:30 PM
To
Lucas CTR Heuman/ACT/CNTR/f...@faa, mysql@lists.mysql.com
mysql@lists.mysql.com
cc
Subject
RE: The Execute from the command line
Mysql -vv
See mysql --help for more info
Regards
,Expire,BadgeNum);
and it works great, I just get no verification that anything has been
loaded in.. if I login it gives me back a little message saying it was
completed and how many are duplicated. How can I get this information from
the command line?
Wishing you the best you know you deserve,
Mysql -vv
See mysql --help for more info
Regards,
Gavin Towey
-Original Message-
From: lucas.ctr.heu...@faa.gov [mailto:lucas.ctr.heu...@faa.gov]
Sent: Friday, October 02, 2009 2:20 PM
To: mysql@lists.mysql.com
Subject: The Execute from the command line
I am using
linuxmachine:/var
Hello,
I'd like to know if there is a command line tool I can run to collect
vital health information for a remote mysql server (just like
mysqltop) for 5.0 - I often see mysql swapping to disk and would like
to know what causes that.
Thanks
Hitesh
--
MySQL General Mailing List
For list
Innotop can satisfy you demand.
On Thu, Apr 16, 2009 at 4:36 PM, Hitesh Shah hrs...@gmail.com wrote:
Hello,
I'd like to know if there is a command line tool I can run to collect
vital health information for a remote mysql server (just like
mysqltop) for 5.0 - I often see mysql swapping
Micah Stevens wrote:
If you want to control the server process, you'll need to start the
server process with those options, this mysqld, and the command line
options are here:
http://dev.mysql.com/doc/refman/5.1/en/server-options.html
Thanks for the link, I am going through it.
For your
Hi everybody,
I am working on a small GUI tool for managing MySQL server.
I would like to include one functionality to change the port number of
the server and restart the server just after the change took place. Is
there any command line tool which I can use to change the port number?
e.g
lists-mysql wrote:
in a *nix environment, restarting the mysql server is done with a
system-level command and requires *system* root privileges, not
something that the average db-admin is likely to have. also,
changing the port a service is listening on has potentially serious
implications as
, this mysqld, and the command line
options are here:
http://dev.mysql.com/doc/refman/5.1/en/server-options.html
For your purposes though, I would absolutely parse and use the config
file instead though because operating directly on the server daemon will
likely come into conflict with a lot of distribution
Hello All.
I'm new to mysql. I would like to issue a query from the command line
and pass the result to an update done on the command line within the
same script. See below.
My question is how can I run a select from the command line and pass the
values to an update
SELECT SYS_ID, SYS_LOCATION
[snip]
I'm new to mysql. I would like to issue a query from the command line
and pass the result to an update done on the command line within the
same script. See below.
My question is how can I run a select from the command line and pass the
values to an update
SELECT SYS_ID, SYS_LOCATION
[snip]
SELECT SYS_ID, SYS_LOCATION, SYS_IP FROM PROD_SERVER;
UPDATE TEST_SERVER
SET SYS_ID = value passed from above
SYS_LOCATION = value passed from above
SYS_IPADDRESS = value passed from above;
[/snip]
And here http://dev.mysql.com/doc/refman/5.1/en/user-variables.html
--
: executing query from the command line -- need help
[snip]
SELECT SYS_ID, SYS_LOCATION, SYS_IP FROM PROD_SERVER;
UPDATE TEST_SERVER
SET SYS_ID = value passed from above
SYS_LOCATION = value passed from above
SYS_IPADDRESS = value passed from above;
[/snip]
And here http
, 2008 11:29 AM
To: Brown, Charles; mysql@lists.mysql.com
Subject: RE: executing query from the command line -- need help
[snip]
SELECT SYS_ID, SYS_LOCATION, SYS_IP FROM PROD_SERVER;
UPDATE TEST_SERVER
SET SYS_ID = value passed from above
SYS_LOCATION = value passed from above
thanks
-Original Message-
From: obed [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 23, 2008 10:49 PM
To: Jay Blanchard
Cc: Brown, Charles; mysql@lists.mysql.com
Subject: Re: executing query from the command line -- need help
On Jan 23, 2008 2:36 PM, Jay Blanchard [EMAIL PROTECTED
I'm really not sure what to try next. ps -aux shows MySQL as hogging
the CPU, not PHP or Terminal:
When this happens, do a 'SHOW PROCESSLIST' in mysql to see what it's
doing.
I have, and I can't see anything unusual. There are a few scripts
that loop with very slow overhead (with
Hello,
I have a command-line PHP script--called Listener--that is designed
to run indefinitely with a predictable CPU usage and memory
footprint. In a nutshell, it's a multi-client socket server that
waits for incoming connections, processes incoming data, stores
results in a MySQL
hi, i have some questions about the command line of mysql for WIN32:
- does mysql have any macro system that lets you shorten often-used
commands, like expanding n5 mytable into select * from mytable
order by id desc limit 5
- how can tab completion be enabled (it does not work by default, even
Mørkrid [mailto:[EMAIL PROTECTED]
Sent: Sat 7/14/2007 3:38 AM
To: mysql@lists.mysql.com
Subject: command line questions
hi, i have some questions about the command line of mysql for WIN32:
- does mysql have any macro system that lets you shorten often-used
commands, like expanding n5 mytable
At 01:38 AM 7/14/2007, Olav Mørkrid wrote:
hi, i have some questions about the command line of mysql for WIN32:
- does mysql have any macro system that lets you shorten often-used
commands, like expanding n5 mytable into select * from mytable
order by id desc limit 5
- how can tab completion
Hi Cornelia,
On 10/16/06, Cornelia Menzel [EMAIL PROTECTED] wrote:
Anyhow, if somebody has a glue of what was or could have been the
problem, I am interested to know what it was. What really annoys me,
is that I have not found what it was.
Though I have used only 5.x versions but I got
Hello!
I have installed MySQL 4.1.21 on my iBook which is running Mac OS X
(Tiger 10.4.8). I have installed MySQL without any problems, I
activated PHP and CGI-Scripts in httpd.conf and erverything was fine.
With 'mysql' I have been able to log in to the mysql command line.
Unfortunately
The error message I receive is the following:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
This message indicates you tried to login without giving a password.
Add -p to your commandline. It will then prompt you for your password
and log you in if the
Am 16.10.2006 um 13:00 schrieb Dominik Klein:
The error message I receive is the following:
ERROR 1045 (28000): Access denied for user
'root'@'localhost' (using password: NO)
This message indicates you tried to login without giving a password.
Add -p to your commandline. It will then
Unfortunately, that is not the reason, why I get this message. I have
tried 'mysql', 'mysql -uroot', mysql -u root', 'mysql -uroot -p', 'mysql
-uroot -pMY_PASSWORD', but anything fails.
When I am using the password option, the error message is like this:
ERROR 1045 (28000): Access denied for
Am 16.10.2006 um 13:08 schrieb Dominik Klein:
Unfortunately, that is not the reason, why I get this message. I
have tried 'mysql', 'mysql -uroot', mysql -u root', 'mysql -uroot -
p', 'mysql -uroot -pMY_PASSWORD', but anything fails.
When I am using the password option, the error message is
The error shows that the passwords doesn't match. You just must have
made some mistake when resetting the password. But this can be fixed:
1) You can start the server with the --skip-grant-tables option that
disables password checking, then you log in as root, set the password,
and the restart
Am 16.10.2006 um 13:23 schrieb Anders Karlsson:
The error shows that the passwords doesn't match. You just must
have made some mistake when resetting the password. But this can be
fixed:
1) You can start the server with the --skip-grant-tables option
that disables password checking, then
the more
secure password encryption methods used by newer MySQL versions, and you
will get just the errors that you are getting.
So if you are using Linux, do a which mysql and see what mysql client
you are using. Also do a mysql --version which will show the command
line client version. You have
will show
the command line client version. You have to watch for this if the
client has version 4.0 or earlier, and you have server with version
4.1 or higher, then this is surely the problem you are experiencing.
Read more here:
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
I dumped a database from a 4.0 mysql and am attempting to move it to a
server running 4.1 - using the command line:
$ mysql -u root -pmypassword empty4.1db 4.0dump.sql
The result:
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL
words.
Carlos
On 9/26/06, Curious George [EMAIL PROTECTED] wrote:
I dumped a database from a 4.0 mysql and am attempting to move it to a
server running 4.1 - using the command line:
$ mysql -u root -pmypassword empty4.1db 4.0dump.sql
The result:
ERROR 1064 (42000) at line 2: You have an error
On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
Hi Chris,
I've noticed that a Ctrl-C will also leave the query
running (5.0.22 -
Linux) and I've had to use the kill from mysqladmin or
mysql client to
get rid of it.
Huh, that's odd, it should abort
On Tuesday 20 June 2006 08:23, Ciprian Vizitiu wrote:
On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
Hi Chris,
I've noticed that a Ctrl-C will also leave the query
running (5.0.22 -
Linux) and I've had to use the kill from mysqladmin or
mysql client
Quoting Ciprian Vizitiu [EMAIL PROTECTED]:
On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
Hi Chris,
I've noticed that a Ctrl-C will also leave the query
running (5.0.22 -
Linux) and I've had to use the kill from mysqladmin or
mysql client to
get rid
the command line and have it really stop
that query?
--
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com Novato, CA U.S.A.
--
MySQL General Mailing List
For list archives: http
Hi Scott,
mysqladmin can issue a kill from the command line. You will have to
issue a mysqladmin -u etc. etc. processlist to get the process id from
mysql and then you can issue a mysqladmin -u etc. etc. kill mysql
process id
Regards
them by hand.
CTRL+Z simply puts a process in sleep mode so it can be woken up later on.
CTRL+C will kill the MySQL process (thus killing the query). While I don't
like that method, it's the only one I've found so far.
Is there any easy way to abort from the command line and have it really
---
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 20 June 2006 8:37 AM
To: mysql@lists.mysql.com
Subject: Re: Aborting a greedy querry from the command line
On Monday 19 June 2006 04:02 pm, Scott Haneda wrote:
Sometimes I will issue something, slip of the fingers
On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
Hi Chris,
I've noticed that a Ctrl-C will also leave the query running (5.0.22 -
Linux) and I've had to use the kill from mysqladmin or mysql client to
get rid of it.
Huh, that's odd, it should abort everything
In the last episode (Jun 19), Chris White said:
On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
I've noticed that a Ctrl-C will also leave the query running
(5.0.22 - Linux) and I've had to use the kill from mysqladmin or
mysql client to get rid of it.
Huh, that's
Hello.
Is it possible that you leave some variable blank? Your script doesn't
produce any error for me:
[EMAIL PROTECTED] mysql-debug-4.1.14-pc-linux-gnu-i686]$ mysql
--defaults-file=my.cnf -u${DB_NAME} -p${DB_PASSWORD} -eGRANT select,
update, insert, delete ON $DBNAME.* TO [EMAIL
.
-Sheeri
On 10/21/05, Dustin Krysak [EMAIL PROTECTED] wrote:
Hi there, I was wondering if it was possible to issue multiple
commands to mysql from a regular command line? For example i know you
can issue a single by the following:
mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases
Hi there - I am trying to issue the following command in a terminal
window... I know my syntax is slightly off, however I can not see
what... it seems to be due to the OLD_PASSWORD function... any pointers?
mysql -u${DB_NAME} -p${DB_PASSWORD} -eGRANT select, update, insert,
delete ON
Sorry - but to add to this, the command is actually in a bash script.
I suspect it is the single quotes and or the () characters
Dustin
On 24-Oct-05, at 11:57 AM, Dustin Krysak wrote:
Hi there - I am trying to issue the following command in a terminal
window... I know my syntax is
Dustin Krysak [EMAIL PROTECTED] wrote on 10/24/2005
03:14:02 PM:
Sorry - but to add to this, the command is actually in a bash script.
I suspect it is the single quotes and or the () characters
Dustin
On 24-Oct-05, at 11:57 AM, Dustin Krysak wrote:
Hi there - I am trying to
:27 AM
To: mysql@lists.mysql.com
Subject: mysql command line error
Hi there - I am trying to issue the following command in a terminal
window... I know my syntax is slightly off, however I can not see
what... it seems to be due to the OLD_PASSWORD function... any pointers?
mysql -u${DB_NAME
I got it figured out.. of all things it was a line return. DOH!
Dustin
On 24-Oct-05, at 12:14 PM, Dustin Krysak wrote:
Sorry - but to add to this, the command is actually in a bash
script. I suspect it is the single quotes and or the ()
characters
Dustin
On 24-Oct-05, at 11:57 AM,
Hi there, I was wondering if it was possible to issue multiple
commands to mysql from a regular command line? For example i know you
can issue a single by the following:
mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases'
Now what if for example i needed to select a database, then run
On Fri, 2005-10-21 at 14:34 -0700, Dustin Krysak wrote:
Hi there, I was wondering if it was possible to issue multiple
commands to mysql from a regular command line? For example i know you
can issue a single by the following:
mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases'
Now
Dustin Krysak wrote:
Hi there, I was wondering if it was possible to issue multiple commands
to mysql from a regular command line? For example i know you can issue
a single by the following:
mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases'
e.g.,
-e 'show databases; use test
Hi!
Some days ago, there was a debate on this list about the visibility of
passwords using ps if they were given on the command line.
I have just come across this text. While it talks about the process
name, the info still applies to command line arguments as well:
| 1.13 How do I change
. The password
parameter needs to appear under the [client] tag, or the [mysql] tag if
you onyl want it to apply to the mysql command line client and none of
the other clients that would read the option file.
Best Regards, Bruce
Note1: I just forwarded to the list, because this could help
-h157.87.200.57 -utr8 -p
I can see my pwd if I do a ps
-Original Message-
From: Eugene Kosov [mailto:[EMAIL PROTECTED] Sent: Monday, August
01, 2005 7:03 AM
To: Ehrwin Mina
Cc: Nuno Pereira; mysql@lists.mysql.com
Subject: Re: mysql command line execution
Ehrwin Mina wrote:
That isn't true
Jason Pyeron wrote:
sorry, reply to error here
On Fri, 29 Jul 2005, Nuno Pereira wrote:
Michael Stassen wrote:
You can, but why are you reinventing the wheel? Option files have
already been provided for this purpose. In what way is storing the
batch user password in 'password_file'
Ehrwin Mina wrote:
That isn't true. If you make a ps, you will see something like mysql
-p x .
As I said before, you can use something like:
mysql -uUser --password=`cat password_file` db
FYI,
Nuno is correct you cannot see the password in the 'ps' and my scripts
can see my pwd if I do a ps
-Original Message-
From: Eugene Kosov [mailto:[EMAIL PROTECTED]
Sent: Monday, August 01, 2005 7:03 AM
To: Ehrwin Mina
Cc: Nuno Pereira; mysql@lists.mysql.com
Subject: Re: mysql command line execution
Ehrwin Mina wrote:
That isn't true. If you make a ps, you
, 2005 7:03 AM
To: Ehrwin Mina
Cc: Nuno Pereira; mysql@lists.mysql.com
Subject: Re: mysql command line execution
Ehrwin Mina wrote:
That isn't true. If you make a ps, you will see something like mysql
-p x .
As I said before, you can use something like:
mysql -uUser
=dbpassword
mydb=dbname
myhost=localhost
myport=3306
db1=mysql -u$myuser -pmypasswd -Dmydb -h$myhost -P$myport
echo repair table employee | $db1
echo unlock table | $db1
exit
This is no more secure, as it still puts the password on the command
line. Your script amounts to
echo repair table employee
commands against the db from the
command line, or in some kind of secure batch mode, without making the
password totally visible? We need to procedurize things like flush
tables with read lock, unlock tables etc. Is making the password
visible on the command line the only way?
Thanks,
Jeff
--
Jeff
-pmypasswd -Dmydb -h$myhost -P$myport
echo repair table employee | $db1
echo unlock table | $db1
exit
This is no more secure, as it still puts the password on the command line.
Your script amounts to
echo repair table employee | mysql -udbuser -pdbpassword -Ddbname
-hlocalhost -P3306
echo
=3306
db1=mysql -u$myuser -pmypasswd -Dmydb -h$myhost -P$myport
echo repair table employee | $db1
echo unlock table | $db1
exit
This is no more secure, as it still puts the password on the command
line. Your script amounts to
echo repair table employee | mysql -udbuser -pdbpassword -Ddbname
myhost=localhost
myport=3306
db1=mysql -u$myuser -pmypasswd -Dmydb -h$myhost -P$myport
echo repair table employee | $db1
echo unlock table | $db1
exit
This is no more secure, as it still puts the password on the command
line. Your script amounts to
echo repair table employee | mysql -udbuser
=dbpassword
mydb=dbname
myhost=localhost
myport=3306
db1=mysql -u$myuser -pmypasswd -Dmydb -h$myhost -P$myport
echo repair table employee | $db1
echo unlock table | $db1
exit
This is no more secure, as it still puts the password on the command
line. Your script amounts to
echo repair table
Hi!
Nuno Pereira wrote:
Michael Stassen wrote:
[[...]]
echo unlock table | mysql -udbuser -pdbpassword -Ddbname
-hlocalhost -P3306
The password is on the command line of the commands issued by the
script, so it can be seen with ps.
That isn't true. If you make a ps, you will see
sorry, reply to error here
On Fri, 29 Jul 2005, Nuno Pereira wrote:
Michael Stassen wrote:
You can, but why are you reinventing the wheel? Option files have already
been provided for this purpose. In what way is storing the batch user
password in 'password_file' better than than storing
Hi,
Is there a secure way of running mysql commands against the db from the
command line, or in some kind of secure batch mode, without making the
password totally visible? We need to procedurize things like flush
tables with read lock, unlock tables etc. Is making the password
visible
will be this
user your mysql command line client would read your .my.cnf file and
use that username and password unless told otherwise by the command
line calling mysql.
That said I stress again... it is still a plain text file and the
password is saved in readable text... if you forget
Jeff Richards wrote:
Hi,
Is there a secure way of running mysql commands against the db from the
command line, or in some kind of secure batch mode, without making the
password totally visible? We need to procedurize things like flush
tables with read lock, unlock tables etc. Is making
in my case.
Anurag
-Original Message-
From: Rich Allen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 20, 2005 6:20 AM
To: Cabbar Duzayak
Cc: mysql@lists.mysql.com
Subject: Re: MySQLDump - Command line password
have you looked at using a my.cnf file?
eMac:~ hcir$ mysqldump test /temp
Cabbar Duzayak wrote:
...
I have setup cronjobs to take daily backups of my db using mysqldump.
But the problem is, mysqldump requires the password to be passed via
command line, which means anyone on the same machine can take a peek
at my password using top, ps -ef, etc.
Is there a way
Hi,
I have setup cronjobs to take daily backups of my db using mysqldump.
But the problem is, mysqldump requires the password to be passed via
command line, which means anyone on the same machine can take a peek
at my password using top, ps -ef, etc.
Is there a way of avoiding this, i.e. making
and password of course are not 'username' and
'password'
On Jul 19, 2005, at 3:40 PM, Cabbar Duzayak wrote:
Hi,
I have setup cronjobs to take daily backups of my db using mysqldump.
But the problem is, mysqldump requires the password to be passed via
command line, which means anyone on the same
Is there any command to list all the datatypes available on mysql? I can get
the information about datatypes from mysql manual as well but I need to get
them from mysql command line. Is there any such command available?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Hi All.
Does anyone know of any tools to convert a MS Access file to MySQL from
the Linux command line?
Thanks.
Andrew
Hi Adam.
I need to get all the data.
Andrew
Adam wrote:
Drew,
That's vague. Specifically what do you want from the Access database (e.g.
schema, data, etc.)?
A-
1 - 100 of 272 matches
Mail list logo