untz wrote:
Hello there!
This is a continuation of a previous posting of mine... I noticed that
that
the CocoaMySQL v0.7b2 client lists the Database, Socket, and Port
fields as optional,
so I filled the other fields and when I clicked on "Connect",
I received this error message:
"Unable t
Rhino wrote:
- Original Message - From: "untz" <[EMAIL PROTECTED]>
To:
Sent: Friday, December 02, 2005 10:47 PM
Subject: Clear Screen in MySQL?
Hello there,
Is there a way to clear the screen in MySQL's command line prompt
(mysql>)?
I am using OS X Tiger with MySQL 5
I don
- Original Message -
From: "untz" <[EMAIL PROTECTED]>
To:
Sent: Friday, December 02, 2005 10:47 PM
Subject: Clear Screen in MySQL?
Hello there,
Is there a way to clear the screen in MySQL's command line prompt
(mysql>)?
I am using OS X Tiger with MySQL 5
I don't have a Ma
Jaime,
please post the COMPLETE UNEDITED .err log.
The log sequence number would mean that your InnoDB tablespace has not been
used after it was created:
051130 19:01:26 InnoDB: Started; log sequence number 0 43634
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row
Hi,
I've downloaded the "mysql-max-4.1.15-apple-darwin8.2.0-powerpc.dmg"
and tried to install it, but I keep on getting the error "You cannot
continue. There is nothing to install".
I've also tried the "mysql-max-5.0.16-osx10.4-powerpc.dmg" and the
"mysql-standard-4.1.15-apple-darwin8.2.0-p
Greetings all,
I've got some headaches I need to make go away over the weekend. I
used phpMyAdmin to backup some small mysql databases. (So I've got a
bunch of _dbname_.sql files)
I have a different machine with a newer version of MySQL (4.1.13a)
running and configured so that I can connect from t
It's my understanding that when you specify localhost, the mysql client
program will use the UNIX socket (ie, mysql.sock), and not look at port
information.
cheers,
jenni
Michael Williams wrote:
Hi all,
I'm trying to use "mysqldump" over SSH. I'm pretty familiar with port
forwarding in an
That means that the MySQL server installed on the machine on which you
issued the command is running AND that it can be connected to by the local
loopback address (127.0.0.1). This still does not mean that you can
connect to it from any other machine as your firewall may permit local
(within th
"YL" <[EMAIL PROTECTED]> wrote on 12/02/2005 03:54:44 PM:
> I'm setting up a mysql server on OS X Tiger powerbook for development.
> I've also a mysql server on my win2k pro machine.
> Tiger has ip 192.168.0.100 and win2k has ip 192.168.0.101
>
> Both db servers work fine locally but I can connec
I'm guessing that you are running 10.4.3 on your Powerbook. In this
latest update, Apple took extra security measures and starts MySQL
with the --skip-networking option. This means only processes running
on the local machine can connect to it (through a Unix socket file),
like PHP running u
Hi,
I tried with
"telnet localhost 3306"
locally, and got the message as:
"Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
=
5.0.16-standard!QS//?.e,7~9>iw;]E!r=Connection closed by foreign host."
What is this meaning?
Thanks,
Jenny
On 12/2/05, Fernando Antunes <[EMAI
I'm setting up a mysql server on OS X Tiger powerbook for development.
I've also a mysql server on my win2k pro machine.
Tiger has ip 192.168.0.100 and win2k has ip 192.168.0.101
Both db servers work fine locally but I can connect from Tiger to Win2k
while not from win2k to Tiger.
The version of
[EMAIL PROTECTED] wrote:
Hi,
I haven't admin'd MySQL in a couple of years, and I have forgotten and lot
(and probably never knew even more.)
I recently installed the current 4.1x MySQL release in Windows XP. I am
trying to track down problems, and can't seem to get an error log. I
expected to
This fixes my problem. Thanks!. Now to figure out where I got the ampersand
from I thought it was in an example.
On 12/2/05, Jesse Castleberry <[EMAIL PROTECTED]> wrote:
>
> Have you tried using "?" instead of "&"? I'm very new to both MySQL and
> Stored Procedures, but I've got seversl stored pro
I did nothing special to the mysql database for my english-chinese
multi-language web applications.
And it worded just fine.
column 'first_name' in this case is replaced by multiple columns according
to the number of languages:
first_name, b5_first_name, gb_first_name
Language is a session varia
Hi,
I haven't admin'd MySQL in a couple of years, and I have forgotten and lot
(and probably never knew even more.)
I recently installed the current 4.1x MySQL release in Windows XP. I am
trying to track down problems, and can't seem to get an error log. I
expected to see a file, mysql.err in the
sorry :( but thanks.
From: [EMAIL PROTECTED]
To: "Umit tas" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: important! help plsss
Date: Fri, 2 Dec 2005 13:29:35 -0500
Sorry, but no.
a) I do not accept attachments from people I do not know.
b) I will help you to learn how to use
I'm having a problem getting parameters working.
Mysql 5.0.16
mysql-connector-net-1.0.7
VB.NET 1.1
mysql> SHOW CREATE PROCEDURE tbl_slct \G
*** 1. row ***
Procedure: tbl_slct
sql_mode:
Create Procedure: CREATE PROCEDURE `tbl_slct`(IN tbl CHAR(64))
R
Yes, I did try both hostname and IP, but can't work although I can ping to
the two boxes from each other.
Just wondering if it is because of the port(3306) got disabled??
Thanks,
Jenny
On 12/2/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
>
> Jenny Chen <[EMAIL PROTECTED]> wrote on 12/
Jenny Chen <[EMAIL PROTECTED]> wrote on 12/02/2005 12:27:33 PM:
> Hi,
>
> I'm trying to connect to the MySQL server on the RedHat AS 4 from a
remote
> Solaris SPARC box. When I run the command:
>
> mysql -h HOSTNAME
>
> I got the error as
>
> ERROR 2003 (HY000): Can't connect to MySQL server
"Octavian Rasnita" <[EMAIL PROTECTED]> wrote on 12/02/2005 10:39:16 AM:
> From: "Stephen Cook" <[EMAIL PROTECTED]>
> Subject: Re: Cannot start MySQL under Win2000
>
>
> > You must not install 5.0 over 4.1, put it somewhere else.
> >
> > Also, instead of naming the service "MySQL" both times, cal
Sorry, but no.
a) I do not accept attachments from people I do not know.
b) I will help you to learn how to use MySQL. Unless you want to pay me
for consulting, I will not take the risk of compiling and running your
source code.
c) You need to learn how to do this, yourself. Part of that is lear
Hello,
Something weird happened on Wednesday: My Mac OSX Server unexpectedly
restarted itself around 7PM. Everything seemed to be functional after
that. However, I just noticed that basically a week worth of changes
to a MySQL database have disappeared. Gone. Vanished. Objects that
were c
Hi,
I'm trying to connect to the MySQL server on the RedHat AS 4 from a remote
Solaris SPARC box. When I run the command:
mysql -h HOSTNAME
I got the error as
ERROR 2003 (HY000): Can't connect to MySQL server on 'HOSTNAME' (145)
Could anyone please explain what the mean of the error message
Hello.
mysqldump connects to the local host by default though the Unix socket..
Add -h127.0.0.1 to its options.
Michael Williams wrote:
> Hi all,
>
> I'm trying to use "mysqldump" over SSH. I'm pretty familiar with port
> forwarding in and of itself, so I doubt that's the issue. N
Hello.
Use mysqlmanager. MySQL Instance Manager is included in MySQL
distributions from version 5.0.3, and can be used in place of the
mysqld_safe script to start and stop the MySQL Server, even from a
remote host. See:
http://dev.mysql.com/doc/refman/5.0/en/instance-manager.html
mel
Hello.
Because you're using MySQL not from RHEL shipment you might have to
install the required packages manually. For MySQL install
MySQL-shared-xxx rpm. BTW - upgrade to 5.0.16 - it has a lot of bug fixes
and is much more stable. Because of for php-mysql and other packages you
might need
Hello.
> music> mysql -u root -p
>..
> music untz$ mysql music_development http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html
untz wrote:
> Hello there!
>
> I am experiencing an error trying to make a DDL execute
>
> Am using Mac OS
Hello.
May be it is an UDF worm? See:
http://dev.mysql.com/tech-resources/articles/security_alert.html
Gary wrote:
> I have installed Apache PHP and MySQL over a year ago on a WINXP machine
> and suddenly a file, presumably there all that time is found to be
> infected by an upto date
Michael Williams wrote:
Hi all,
I'm trying to use "mysqldump" over SSH. I'm pretty familiar with port
forwarding in and of itself, so I doubt that's the issue. No matter
what port I forward (or to where for that matter), "mysqldump" still
connects to the local MySQL server and dumps loca
From: "Stephen Cook" <[EMAIL PROTECTED]>
Subject: Re: Cannot start MySQL under Win2000
> You must not install 5.0 over 4.1, put it somewhere else.
>
> Also, instead of naming the service "MySQL" both times, call it
> something else (i.e. "MySQL41" and "MySQL50"). If you use the Windows
> installe
Hi,
When I started out I used to do a single query and store the data in a Perl/PHP
datastructure.
I've noticed with time that I'm treating MySQL as though it were part of
PHP/Perl. ie I call a MySQL
primitive everytime I need to read a table/lookup table etc. I develop
Shoppingbaskets/CMS sys
First - always CC: the list for every response (I just click - REPLY TO
ALL - so I don't accidentally forget). In case I had become unavailable,
anyone else could have answered. This is mostly volunteer help here.
Hardly anyone that contributes to this list actually works for MySQL.
Second - th
"Shaun" <[EMAIL PROTECTED]> wrote on 12/02/2005 10:09:44 AM:
> Hi,
>
> I am having a problem with using dates grouped by week where it spans
over 2
> months. I would like the query to return all hours worked by week
number,
> however week 48 is causing problems because it spans 2 months - act
"Bing Du" <[EMAIL PROTECTED]> wrote on 12/02/2005 09:41:21 AM:
> Hello everyone,
>
> I've ever seen some document about how to install multiple versions of
> MySQL on the same server. But I don't remember where I saw the
document.
> Anybody know anything about it and happen to have some pointe
"Umit tas" <[EMAIL PROTECTED]> wrote on 12/02/2005 04:59:15 AM:
> hello i'm umit Tas;
>
> i have a problem.
>
> i'm writing programme in visual basic 6.0 but i must use MySQL server.
>
> i'm installed MySQL server and executing my program (no problem) but my
> problem is :
>
> MySQL must be i
Hi,
I am having a problem with using dates grouped by week where it spans over 2
months. I would like the query to return all hours worked by week number,
however week 48 is causing problems because it spans 2 months - actually I
am presuming this is the problem!
mysql> SELECT DATE_FORMAT(T.Da
"wangxu" <[EMAIL PROTECTED]> wrote on 12/01/2005 09:40:27 PM:
>I do a select with command-line.But the results can't show in a
> screen because there are a lot of rows.Can i show the results with
> separated pages?
I don't know about the other shells but in a CMD or COMMAND shell (either
o
Hello everyone,
I've ever seen some document about how to install multiple versions of
MySQL on the same server. But I don't remember where I saw the document.
Anybody know anything about it and happen to have some pointers? If I
want to install multiple versions, I have to install from source
Umit tas wrote:
hello i'm umit Tas;
i have a problem.
i'm writing programme in visual basic 6.0 but i must use MySQL server.
i'm installed MySQL server and executing my program (no problem) but my
problem is :
MySQL must be installed "A" computer and my programme must be installed
"B" comp
Hi all,
I'm trying to use "mysqldump" over SSH. I'm pretty familiar with
port forwarding in and of itself, so I doubt that's the issue. No
matter what port I forward (or to where for that matter), "mysqldump"
still connects to the local MySQL server and dumps local data. It's
as if it
Umit tas wrote:
hello i'm umit Tas;
i have a problem.
i'm writing programme in visual basic 6.0 but i must use MySQL server.
i'm installed MySQL server and executing my program (no problem) but my
problem is :
MySQL must be installed "A" computer and my programme must be installed
"B" comp
mel list_php wrote:
Hi,
This may be a strange question, but I was wondering if it is possible
to have a user starting/stopping the mysql server who wouldn't have
access to the data.
To explain: I want to set up a server as user "Groupinstaller" for
example. This is a virtual user to allow ot
Hi,
This may be a strange question, but I was wondering if it is possible to
have a user starting/stopping the mysql server who wouldn't have access to
the data.
To explain: I want to set up a server as user "Groupinstaller" for example.
This is a virtual user to allow other people of my group
hello i'm umit Tas;
i have a problem.
i'm writing programme in visual basic 6.0 but i must use MySQL server.
i'm installed MySQL server and executing my program (no problem) but my
problem is :
MySQL must be installed "A" computer and my programme must be installed "B"
computer
in LOCAL a
Nope it 's tis-620. Man.
Please feel free to reply to this email if you have additional questions or
concerns
???
01-7499093
? ???, ???, ? ???. 01-749-9093, 02-938-8301
http://www.Ea
UTF-8 is the encoding would want to use for Thai. Also see:
http://dev.mysql.com/doc/refman/4.1/en/charset-asian-sets.html
Cory.
Peter Lauri wrote:
I am in the situation to develop an web site for a Thai school and it will
be in Thai and English. How can I setup so that my tables understand
Best groupmember,
I am in the situation to develop an web site for a Thai school and it will
be in Thai and English. How can I setup so that my tables understand the
Thai decoding (think it is UTF-8)?
Thanks
You must not install 5.0 over 4.1, put it somewhere else.
Also, instead of naming the service "MySQL" both times, call it
something else (i.e. "MySQL41" and "MySQL50"). If you use the Windows
installer distribution, it is one of the options; if you are doing it by
hand then you already know ho
49 matches
Mail list logo
