There are several weird hybrid ways of installing MySQL on Mac (the native
install as provided by Apple, tar or dmg from Oracle, Darwin Ports, brew
and Fink, if the latter is still around) all of which are utterly mutually
incompatible. But once it is up, it's behaviour is the same as a typical
un
Lucio Chiappetti lambrate.inaf.it> writes:
..
> Conversely, I have some private databases on my machine B. While I
> maintain them locally with full access, I grant select access to an user
> on another machine C. In this case he runs the mysql client on C which
> connects to the mysqld on my m
- Original Message -
> From: "Thufir"
> Subject: Re: ssh basics
> On Mon, 09 Mar 2015 16:00:08 +0100, Johan De Meersman wrote:
>
>> All in all, you've done the opposite of what I asked - you've told me
>> what you know and tried, but not wha
On Mon, 09 Mar 2015 16:00:08 +0100, Johan De Meersman wrote:
> All in all, you've done the opposite of what I asked - you've told me
> what you know and tried, but not what you were trying to figure out with
> your original question :-p
>
Do I really look like a guy with a plan? You know what I a
- Original Message -
> From: "Lucio Chiappetti"
>
> I may like a way to have a program (namely RSI IDL) to connect (bypassing
> the line mode mysql client) to the mysqld socket and issuing commands to
> it (essentially I want to issue a select into a table, and read back the
> output in a
*that* is the whole problem of the thread from the frist start: missing
basics and follow howtos not understanding what they are talking about
signature.asc
Description: OpenPGP digital signature
On Mon, 9 Mar 2015, Johan De Meersman wrote:
I'm interested in how ssh is used by MySQL.
SSH is not used by MySQL at all :-) SSH is a way of connecting to a
remote machine. MySQL is a database. You can use SSH to do things with
the database, but they're not intrinsically related.
True, how
- Original Message -
> From: "Thufir"
> Subject: Re: ssh basics
>
> I was being serious, I always appreciate a reply. I know it was worded
> oddly, but, yes, just take it at face value, please.
Oh, I didn't see anything wrong with wording, but text doesn
On Mon, 09 Mar 2015 13:44:51 +0100, Johan De Meersman wrote:
>> Thank you for explaining that.
>
> I can't quite tell wether you're being sarcastic or not, so I'm going to
> give you the benefit of the doubt
>
> Can you explain what you're trying to accomplish, without referencing
> sites you've
- Original Message -
> From: "Thufir"
> Subject: Re: ssh basics
>
> Thank you for explaining that.
I can't quite tell wether you're being sarcastic or not, so I'm going to give
you the benefit of the doubt :-)
Can you explain what you're
- Original Message -
> From: "Emil Oppeln-Bronikowski"
> Subject: Re: ssh basics
> Please, people, do we need that kind of thread?
Most action this list has seen since we had a thread about how little action
this list sees... :-p
--
The idea that Bill Gates appear
Please, people, do we need that kind of thread?
--
vag·a·bond adjective \ˈva-gə-ˌbänd\
a : of, relating to, or characteristic of a wanderer
b : leading an unsettled, irresponsible, or disreputable life
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
On Sun, Mar 08, 2015 at 08:03:05PM +, Thufir wrote:
> On Sun, 08 Mar 2015 08:43:41 -0400, Ruben Safir wrote:
>
>
> > gmail sucks
>
>
> You prefer yahoo mail? Just curious.
>
Your not curious.
>
> -Thufir
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.
On Sun, 08 Mar 2015 08:43:41 -0400, Ruben Safir wrote:
> gmail sucks
You prefer yahoo mail? Just curious.
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Sun, 08 Mar 2015 13:41:32 +0100, Reindl Harald wrote:
>> What's the advantage?
>
> that you can have a local application using mysql by -h 127.0.0.1 which
> is a complete different thing than a interactive shell?
Thank you for explaining that.
-Thufir
--
MySQL General Mailing List
For l
or GNU users for almost 2 decade so get off your ass and go look
this up, or ask the question in the porper location at least.
Or better, find a local user group, get off your damn cellphone, and get
some obviously much needed mentoring in GNU/Linux basics.
gmail sucks
>
> hmm, are yo
Am 08.03.2015 um 13:20 schrieb Thufir:
On Sun, 08 Mar 2015 10:47:17 +0100, Reindl Harald wrote:
oh my god... https://www.google.at/search?q=ssh+tunnel
hmm, are you thinking that I'm not using ssh? Because I'm using ssh
currently, and it works fine.
no, i am thinking you have
On Sun, 08 Mar 2015 10:47:17 +0100, Reindl Harald wrote:
> oh my god... https://www.google.at/search?q=ssh+tunnel
hmm, are you thinking that I'm not using ssh? Because I'm using ssh
currently, and it works fine.
How is ssh -L 3305:localhost:3306 thufir@192.168.1.3 any better o
Am 08.03.2015 um 02:38 schrieb Thufir:
how is this:
ssh -L 3305:localhost:3306 thufir@192.168.1.3
different from
ssh thufir@192.168.1.3
they seem functionally equivalent, neither gives me a MySQL console right
off the bat. (I'm reading the man page and trying to understand "bind"
and the -L
On Sun, 08 Mar 2015 01:30:46 +0100, Reindl Harald wrote:
> Am 08.03.2015 um 01:20 schrieb Thufir:
>> I want to ssh into Mysql, something like:
>>
>> thufir@doge:~$
>> thufir@doge:~$ ssh -L 3306:localhost:3306 thufir@192.168.1.3 bind:
>> Address already in use
>
> that is a pretty clear message
>
On Sun, 08 Mar 2015 00:20:26 +, Thufir wrote:
> I mean, I can ssh into tleilax and then fire up the MySQL console. Is
> there a better approach?
>
This just hangs:
thufir@doge:~$
thufir@doge:~$ mysql -u cron -h 192.168.1.3 -p
Enter password:
^C
thufir@doge:~$
because, I think, I d
Am 08.03.2015 um 01:20 schrieb Thufir:
I want to ssh into Mysql, something like:
thufir@doge:~$
thufir@doge:~$ ssh -L 3306:localhost:3306 thufir@192.168.1.3
bind: Address already in use
that is a pretty clear message
you can't use port 3306 if you have running a mysqld on both machines,
so
I want to ssh into Mysql, something like:
thufir@doge:~$
thufir@doge:~$ ssh -L 3306:localhost:3306 thufir@192.168.1.3
bind: Address already in use
Last login: Sat Mar 7 19:18:20 2015 from 192.168.1.2
Thank you for installing ViciBox Server v.6.0!
This software is available for free download at
select * from
(
SELECT ID_number, count( CU_number ) AS CC
FROM MyTable
GROUP BY ID_number
) T
WHERE CC =
(
select max(cc) from
(
SELECT ID_number, count( CU_number ) AS CC
FROM MyTable
GROUP BY ID_number
) T2
)
On Wed, Oct 15, 2008 at 5:08 PM, dave aptiva <[EMAIL PROTECTED]>wrote:
> Hello a
SELECT ID_number, count( CU_number )
FROM MyTable
GROUP BY ID_number
order by 2 desc
limit 10
will give you the top 10. Change 10 to whatever you want or take off the
limit clause to get all records.
On Fri, Oct 17, 2008 at 4:25 AM, dave aptiva <[EMAIL PROTECTED]>wrote:
> Hello all,
>
> I'm new
Hello all,
I'm new to sql and have a question if someone would be kind enough to help
me with, if I have a table that stores telemarketers by ID_number and the
customer that they spoke to by CU_number and I use a select statement such
as;
SELECT ID_number, count( CU_number )
FROM MyTable
G
2008/10/17 dave aptiva <[EMAIL PROTECTED]>:
>
> I tried SELECT ID_number, max( count( CU_number ) ) but this causes an error
> "# - Invalid use of group function "
# sqlite3
SQLite version 3.5.9
Enter ".help" for instructions
sqlite> create table moo (id_number, cu_number);
sqlite> insert int
Hello all,
I'm new to sql and have a question if someone would be kind enough to help
me with, if I have a table that stores telemarketers by ID_number and the
customer that they spoke to by CU_number and I use a select statement such
as;
SELECT ID_number, count( CU_number )
FROM MyTable
G
Hello.
The output of INNODB MONITOR is not clear for me (I hope only
for me, and someone more skilled could correct me). At:
http://dev.mysql.com/doc/mysql/en/innodb-locks-set.html
it is said that, SELECT ... FROM is a consistent read, reading a snapshot
of the database and setting no l
I've been getting the following error in my Python program which
accesses InnoDB tables:
OperationalError: 1213 Deadlock found when trying to get lock; try
restarting transaction
I've already tried all the basic steps that the documentation seems
to recommend:
- Set my TRANSACTION ISOLATIO
Hi.
You should really read the FAQ:
http://mysql.ensita.net/doc/mysql/en/Replication_FAQ.html
In case you want us to fine-tune replication for you, you may want to order commercial
support, go to: https://order.mysql.com/?ref=ensita.
ian douglas <[EMAIL PROTECTED]> wrote:
> Hi everyo
1. If a new database is created on db1, this is not replicated on db2
and db3. ... is there a better way to automate duplicating this
>>database on the slaves?
Yes put in your my.cnf on the master binlog-ignore-db=mysql,test this
means the master will replicate any event to any database other then
DVP
Dathan Vance Pattishall http://www.friendster.com
> -Original Message-
> From: ian douglas [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 02, 2004 9:30 AM
> To: [EMAIL PROTECTED]
> Subject: Replication basics
>
> Hi everyone,
>
> I&
Hi everyone,
I've been browsing the online archives for a while and haven't found as
much data as I'd like to feel really comfortable about replication. I've
been a pretty busy developer in terms of using MySQL, but never so much
in the way of administration. Also, I've only ever had to deal wit
Steve Grosz wrote:
Where would I find a good online tutorial that would step me through
understanding setting up seperate tables, and the relationships
between then?
Thanks so much!!
Steve
Did you try putting in google "MySQL Basics"
You'll get numerous results.
Here's one,
Steve -
This is a good place to start:
http://dev.mysql.com/doc/mysql/en/Tutorial.html
This is also very good for installing on MacOSX:
http://www.entropy.ch/software/macosx/mysql/
HTH...James
On Oct 20, 2004, at 9:44 PM, Steve Grosz wrote:
Where would I find a good online tutorial
Where would I find a good online tutorial that would step me through
understanding setting up seperate tables, and the relationships between
then?
Thanks so much!!
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Lou Olsten wrote, "You do not have to put a user into
the system for every location from
which
you want to connect. Instead, you can use wildcards
like:
GRANT ON *.* to 'Newbie'@'196.168.168.%'
or maybe 'Newbie'@'%.yourdomain.com'"
I don't know how to work with wildcards, but are you
descr
At 7:22 -0700 6/2/04, David Blomstrom wrote:
I've been studying MySQL for a few weeks now and am
about ready to publish some databases online. But I'm
confused about usernames and passwords. I understand
you can create usernames and passwords on three or
four different levels, like root, database,
which
you want to connect. Instead, you can use wildcards like:
GRANT ON *.* to 'Newbie'@'196.168.168.%'
or maybe 'Newbie'@'%.yourdomain.com'
Lou
- Original Message -
From: "David Blomstrom" <[EMAIL PROTECTED]>
To: <[EMAIL
I've been studying MySQL for a few weeks now and am
about ready to publish some databases online. But I'm
confused about usernames and passwords. I understand
you can create usernames and passwords on three or
four different levels, like root, database, etc. As I
understand it, "localhost" is the s
Please checks the documentation that comes with mysql. It is an excellent
source to learn MySQL.
-Original Message-
From: Robert McKerlie [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 26, 2002 12:27 PM
To: [EMAIL PROTECTED]
Subject: mysql basics
Can anyone suggest a good tutorial
Can anyone suggest a good tutorial for someone just starting out with MYSql?
Regards
Robert
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
Oh, and response time should be 'faster', since you can locate the different
tables on separate storage devices, allowing for concurrent drive access to the
different parts of the item.
Steve Brazill wrote:
> You should split the data-fields into tables containing 'categories' of
> fields.
>
You should split the data-fields into tables containing 'categories' of
fields.
* 'textual' (or informational) fields would be the main 'item' table
* 'quantity' and other 'numeric' fields that are updated frequently (i.e.
quantity sold, quantity on-hand) would be in the table that wou
Hi,
was wondering as am starting a database with just some 5000 different ID
entries and each entry having some 60 datafields, which would work
best/faster a single table of the data or divided into separate tables?
Jari Mäkelä
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 15, 2001 18:19
Subject: Real Basics on setting up server and client - please help
I wish to set up mySQL running on a Windows Server and a client on a lan
that can access it but am completely in the dark as to what to download
I wish to set up mySQL running on a Windows Server and a client on a lan that can
access it but am completely in the dark as to what to download and install.
Thanks
Kerry Matthews
EMAIL PROTECTED]
> Subject: Re: MORE basics!!
>
>
> I'm getting closer
> Thanks again!!!
>
> I have my root account set up on my local machine. I guess I need
> to figure
> out how to set up an account for my remote server. Does that sound right?
> Sorry, I'm sti
'. Isnt that what I want to do
somehow?
Thanks!
Mac
- Original Message -
From: Jacques Venter <[EMAIL PROTECTED]>
To: Mac Martine <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 1:18 AM
Subject: RE: basics!!
> Hi Mac,
>
> You shou
Hi Mac,
You should not be typing DOS commands within the mysql.exe utility, do the
following exactly:
Get yourself here:
C:\>
Type: cd mysql\bin
Result: c:\mysql\bin
Type: mysqld-nt --install
Result: c:\mysql\bin
Type: net start mysql
Result: MySQL Service has started successfully
Type: mysql
R
other error..
any help?
thanks-
mac
- Original Message -
From: Jacques Venter <[EMAIL PROTECTED]>
To: Mac Martine <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 12:08 AM
Subject: RE: basics!!
> Hi Mac,
>
> This is actually
; To: [EMAIL PROTECTED]
> Subject: basics!!
>
>
> allright, so i am a beginner with some very basic questions...
>
> I installed and set up mysql, but everything i read, talks about
> using ms-dos or something to use it. It looks the interface i
> have for mysql has all those
allright, so i am a beginner with some very basic questions...
I installed and set up mysql, but everything i read, talks about using ms-dos or
something to use it. It looks the interface i have for mysql has all those options, or
no??? Is whatever I will want to do not possible within that in
54 matches
Mail list logo
