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.
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 execute
ects 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 ch
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 a
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 "
n, all tables are created 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 mysq
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
phpMysqlAdmin
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 th
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 --pass
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 (2
2013/3/31 Norah Jones
> 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 ?
Manuel.
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.
I know, all the shell command can do this. Thanks.
2010/8/25 Moon's Father
> 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.
>
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.
>-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 mis
ngton, CT 06032
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
John
I think you can do this way on shell:
mysql -h db_server -u user -pPASSWORD -e "truncate table
table1"
Carlos Eduardo Caldi
> Date: Tue, 16 Mar 2010 14:12:42 -0700
> From: joli...@john-oliver.net
> To: mysql@lists.mysql.com
> Subject: Trancate t
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 &
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 ha
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
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
10/02/2009 05:30 PM
To
Lucas CTR Heuman/ACT/CNTR/f...@faa, "mysql@lists.mysql.com"
cc
Subject
RE: The Execute from the command line
Mysql -vv
See mysql --help for more info
Regards,
Gavin Towey
---
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
tName,TimeStamp,Ext,Status,Location,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,
Innotop can satisfy you demand.
On Thu, Apr 16, 2009 at 4:36 PM, Hitesh Shah 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
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
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
pp which can administrate MySQL and would later add a GUI over it.
>
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
For your p
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 you
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
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 PROTEC
to:[EMAIL PROTECTED]
> Sent: Wednesday, January 23, 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
t: 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
SYS_IPADDRESS = &value passed from above;
[/sni
[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
--
M
[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_LOC
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_LOC
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 sufficien
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
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&
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&
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
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 simil
mysql --version" which 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/re
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 clie
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 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: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 l
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 us
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 pro
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 p
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.
Unf
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: Yo
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 y
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 cli
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
> 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 a
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,
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 entirel
nt
---
-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
to go in and kill 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 fro
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
Regards
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
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} -e"GRANT select,
update, insert, delete ON $DBNAME.* TO [EMAIL PROTE
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
ber 2005 4: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 -
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
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 sl
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} -e"GRANT select, update, insert,
delete ON $DB
a one-liner, though, the above will work.
>
> -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
> >
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.,
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
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
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.1
way to pass the information in an option file. 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 f
b/mysql
41079 p0 SL+0:00.02 mysql -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 li
nt: 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 will see something like "mysql
-p x ".
As I said before, y
-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&
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 script
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' bett
=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 t
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 i
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 p
=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 amoun
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 "repai
=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"
-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 -pdbpasswor
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 on th
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"
ecause you 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
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 pas
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
ng 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 &g
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 m
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 o
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
Export as CSV.
MySQL command line client.
Run a script with LOAD DATA INFILE.
Chris
On 5/23/05, Andrew Dixon - MSO.net <[EMAIL PROTECTED]> wrote:
> Hi Adam.
>
> I need to get all the data.
>
> Andrew
>
>
> Adam wrote:
>
> >Drew,
> >
> &
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 281 matches
Mail list logo
