I am experienced a problem of using MYSQL GUI on windowME to connect mysql server,
which was v3.22 and installed on open linux .
I couldn't make any connection with it and don't know why.
I checked my password and Ip address, they both are correct and working properly.
please be kind to giving
Hey Scott,
Try:
GRANT ALL ON DATA.* TO user1@"%" IDENTIFIED BY "password"
/or simply/
GRANT ALL ON DATA.* TO user1 IDENTIFIED BY "password"
Not specifying a domain defaults to %.
HTH
Ben
-Original Message-
From: Scott Meesseman [mailto:[EMAIL PROTECTED]]
Sent: 09 April 2001 01:27
To:
Hi there,
the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes,
the master is running. the user name and password are correct. actually i
dont think it gets to the state of actually verifying the user name and
password. even if i do just a mysql -h 192.168.1.2 it gives me
On Mon, Apr 09, 2001 at 10:37:36AM +0530, MCA Department PESIT wrote:
> the error that i specifically get when the slave tries to connect to
> the master is
>
> 010409 10:44:58 Slave thread: error connecting to master:Can't connect to
> MySQL
> server on '192.168.1.2' (111)(107), retry
Where is your server located? On the same LAN?
You sure the mysql server is running?
- Original Message -
From: "MCA Department PESIT" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 12:48
Subject: Cannot Connect to remote host for replication
> hi there,
>
Hi there,
the error that i specifically get when the slave tries to connect to
the master is
010409 10:44:58 Slave thread: error connecting to master:Can't connect to
MySQL
server on '192.168.1.2' (111)(107), retry in 60 sec
even if i try to run mysql -h master the same error happens.
Yeah, yeah alright then...
database,sql,query
Happy?
Now for my message...
I downgraded to 3.22.xx and the same thing happened.
It seems like it's something else.
Slackware Current.
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from
/usr/li
hi there,
i have been trying to implement replication, however the error that i
get is
ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111)
i try to do this at the linux prompt at the slave with mysql-h hostname and
the same error is displayed. what could be wrong ??
thanks in
You need to escape it with another "\". Look up the manual about escaping
special chars.
- Original Message -
From: "Jack A. Tinsley Jr." <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 12:34
Subject: Disappearing "\"
> First, things, first
On Sun, Apr 08, 2001 at 10:34:17PM -0600, Jack A. Tinsley Jr. wrote:
>
> First, things, first - I am a newbie to MySQL but I have it up and
> running quite well. The only thing I haven't been able to figure
> out is why I'm losing "\" (back slashes) in my stored data. I have
> a application I'm
First, things, first - I am a newbie to MySQL but I have it up and running quite well.
The only thing I haven't been able to figure out is why I'm losing "\" (back slashes)
in my stored data. I have a application I'm considering MySQL for and one table must
have a column containing a UNC path
Mysql has many command line options. Try mysql --help for a list, and you
will see that the -h option is used to specify the host.
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.fr
I was wondering if there is a tool or special way to merge all of the
contents of Filemaker Pro 5 files so they can be used in mySQL.
Here is my scenario: Currently I have a fileserver for my website that uses
FileMaker 5 and I am looking to merge those attributes and settings so they
can be used
Hello,
Does anyone know off hand what the command is (in mySQL interactive mode )
to connect to a remote mySQL server?
Thanks for your time,
Scott
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
>Description:
When one uses the "alter table tbl_name rename [to] new_tbl_name" command, it works
when "to" is not included in the command, but says there is an error in the SQL syntax
when "to" is included. My understanding is that "to" is optional and it should work
both ways.
>How-To-Repea
Hi,
Just a guess, but I expect that the first response will be to use gcc 2.95.2
or later
Quentin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, 9 April 2001 1:30 p.m.
To: [EMAIL PROTECTED]
Subject: REXEXP in select only works with short expressions
I have a (dumb!) program that performs SELECT statements with a quote around
the table and the fieldname; see the portion from the trace log below:
Cardfivefffe35e1:fffed875 EXIT SQLExecDirect with return code -1
(SQL_ERROR)
HSTMT 0x00cf17ac
UCHAR * 0x00ae6
>Description:
When transfering a database application to use an Alpha Linux server
rather than intel Linux previously working regular expressions fail to work.
It appears to be due to a length limit. This effects both binary downloads
and home compiled distributions.
>How-To-Repeat:
Sim
On Sun, 8 Apr 2001, Realbad Atgames wrote:
>
> --- [EMAIL PROTECTED] wrote:
> >
> > > Hello, I'm new to MySQL and have ran into a
> > problem in
> > > designing my database. I have a table of items, A,
> > and
> > > each item should have any number of other records
> > from
> > > another table,
Hello,
Is there a new wildcard character in 3.23? I am trying to use the grant
statement
GRANT ALL ON DATA.* TO user1@% IDENTIFIED BY "password"
It doesnt seem to like the % as it returns an sql error
Thanks for your time,
Scott
--
that worked, thx
I also installed PHP4, should I uninstall that? I installed it as a tar. and
if so how do I do it?
Dave
-Original Message-
From: Steve Ruby [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 08, 2001 7:46 PM
To: David Loszewski
Subject: Re: uninstalling MySQL
If rpm -qa
>Description:
Programs, compiled with mysql++ on that machine, abort with a
segfault at an attempt to connect to the mysql server, while
programs using Mysql C API (for instance, mysql's own
benchmark suite) and the same programs executed on a local
Linux m
--- [EMAIL PROTECTED] wrote:
>
> > Hello, I'm new to MySQL and have ran into a
> problem in
> > designing my database. I have a table of items, A,
> and
> > each item should have any number of other records
> from
> > another table, B, associated with it. I also need
> to
> > have any number of
Your absolutely right, my question was not clearly
specified. So here's a concrete problem:
Let's say table A has 2 fields: PRODUCT_ID (unique) and
PRODUCT_NAME,
table B has 3 fields: PRODUCT_ID,COMPANY_ID and
LAST_PRODUCTION_DATE,
and finally table C : COMPANY_ID and CONTACT_INFO
Table A is the m
Hello, I'm new to MySQL and have ran into a problem in
designing my database. I have a table of items, A, and
each item should have any number of other records from
another table, B, associated with it. I also need to
have any number of records from table C associated
with table B. They need to be
On Wed, Apr 04, 2001 at 05:26:39PM +0200, Gunnar von Boehn wrote:
>
> As I asked them why their mysql-server die so often, I got their
> standard problem email-answer that claims "mysql is scaling rather
> badly".
The truth is probably closer to "we are scaling mysql badly". A well
run MySQL ser
Ian,
I may be way off the mark here, but I've found MySQL usually starts quoting
the line from the place at which the error occurred, thus indicating it
didn't like the "insert" part. Not being able to see the preceding lines I
can only suggest it may not have an active database to write to.
Whe
I'm confused, and wondering if anyone can help me.
I'm running 2 virtual servers, let's say server1.domain.com and
server2.domain.com. These virtual servers sit on servers named host1.isp.com
and host2.isp.com respectively (I hope I haven't lost anyone yet).
I have a perl script, that lists the
Hi (if needed you can find my environment setup below)
I wish to load some data files at the mysql command prompt but seem to be
failing due to Swedish characters being incorporated. Here is the error:
ERROR 1064: You have an error in your SQL syntax near 'insert into category
(categoryid,descri
Suppose I have this:
---
mysql> UPDATE blah blah...
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
---
How can I see the warning information, such as a detailed message?
(BTW I *did* ch
Is there an explanation somewhere about the rules mysql uses when lock
tables?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
On Sun, Apr 08, 2001 at 04:33:32PM -0400, Marc Bragg wrote:
>
> Will mysql operate on a dual processor system under linux? Any
> appreciable performance advantages?
Yes. In fact, there was a thread about this on the list about a week
ago.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technic
How I learned to love number gaps:
I have a database of colleges and universities. Every degree listing
as a numbered id. This used to be auto-incremented. After several
deletes and additions, I found it advantageous to have gaps between
schools to add new degree listings, so that I didn't get
Will mysql operate on a dual processor system under linux? Any
appreciable performance advantages?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi,
I have compiled mysql 3.23.36 from tarball source under debian. So I try to
modify some defaults to fit to the filesystem layout, used under debian
(2.2r2, potato, Kernel 2.4.1). All seemed to work fine. So I make a dump
from our database and insert the dump into the new system. After this I c
>Description:
when doing a select replace(fieldname, 'lookforstring', 'replacestring'), the
replace never occurs. It works fine if searching on a static string. The behaviour is
correct on my Red Hat machine.
>How-To-Repeat:
- easy to repeat (bug was in 3.22.23 as well) - just tr
You can do the same thing with like:
where concat(",",myField,",") like "%,$searchString,%"
this will of cause be somewhat slow, how about normalizing your database:
header(id,fields)
type(id,dataset)
header(1,)
type(1,black)
type(1,dark)
...
now you can select * from header,type where (id=
On Sun, 8 Apr 2001, Stephen U. Lee wrote:
> i want to replace all occurences of www to http://www in all columns of a
> table.
> the column contains blocks of text.
>
> is there any way to do this directly in mySQL?
Check the manual for the infinite String manipulation functions.
If all your r
anyone know where (or even just how-to) find info on getting mysql to
start with system boot?
thank you in advance.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi
At 18:13 08/04/2001 +0200, Kobus Myburgh wrote:
>Folks,
>
>I am totally new to databases, haven't got the foggiest of what's going on
>here. I have downloaded and installed MySQL 3.23.29 a while back, but I
>still don't know how to even configure it, even though I have read several
>articles
> How would you actually overcome that? Wouldn't it be good if
> MySQL would be adapted to actually do this for you?
I think that not reusing deleted numbers is easier (i.e. more efficient).
IIRC, earlier versions of MySQL in fact reused the numbers.
There are 2 ways to overcome this:
1) Check
On Sun, 8 Apr 2001, John Hart wrote:
> I am working on a rather large database project, in which I am making a text column
>that contains different data, seperated by commas. What I need to do is run a query
>where I will return only the datasets that contain any of sets that partially, or
>f
I don't know if the manual says anything about this but if you check Paul's book page
150 (paul now we are referencing your book down to page level) it says:
"creating a table by selecting data into it does not automatically copy any indexes
from the original table"
regards,
thalis
On Sun, 8
Probably should change that first line to
rpm -qa | grep -i mysql
Roel Vanhout wrote:
>
> rpm -qa | grep mysql
>
> if nothing found,
>
> rm -rf /usr/local/var
> rm -rf `find /usr/local/bin/ | grep mysql`
> rm -rf /etc/my.cnf
>
> This should catch about everything.
>
> cheers,
>
> roel
>
>
rpm -qa | grep mysql
if nothing found,
rm -rf /usr/local/var
rm -rf `find /usr/local/bin/ | grep mysql`
rm -rf /etc/my.cnf
This should catch about everything.
cheers,
roel
On Sun, Apr 08, 2001 at 12:24:08AM -0400, David Loszewski wrote:
> how do I uninstall MySQL 3.22 after installing it? wo
No, what is meant here is that:
He has record 1 2 3 and 4. Now deletes 2 and 3. Now create 2 new records. MySQL
creates them as 5 and 6, instead of 2 and 3 again...
--Kobus
>>> Lindsay Adams <[EMAIL PROTECTED]> 2001-04-08 19:42:12 >>>
I can understand not wanting to have holes, but..
If it is
How would you actually overcome that? Wouldn't it be good if MySQL would be adapted to
actually do this for you?
-- Kobus
>>> "Jens Vonderheide" <[EMAIL PROTECTED]> 2001-04-08 19:25:48 >>>
> When I first added about 10 records and then deleted a few records and
> then added more records it did
I can understand not wanting to have holes, but..
If it is a primary key, how are you going to handle updating tables that
rely on that key id?
If your id numbers were to shift, like you want, and you had a related sub
table (one to many) and this was say, an shopping cart, then all of a sudden
Hello,
We're using MySQL on a small local area network with an average of 4
clients hitting the database with SELECTS, INSERTS and UPDATES. We're
using a Win2K file server with UDMA/100/7200 HD's and 256 MB Ram. Each
client is accessing the DB through MyODBC. Actually it's a VB6 App using
t
> When I first added about 10 records and then deleted a few records and
> then added more records it didn't replace the missing records.
That's MySQL's usual behaviour. auto_increment only garantees to create
unique keys. "Holes" left by deleting data are not filled.
Jens
> I have not been able to figure this out, yet. I found the file
> /usr/share/mysql/make_binary_distribution and tried a make on it; no
> luck. I scoured the documentation on the web and in my own distribution
> and have not been able to find out what to do next. See Below. I would
> appreciat
In my version of WinMySQLadmin (v 3.23.33 running on Windows98, said on the
MySQL site to have been modified 3/1/1), in the Databases tab, in the Table
Columns frame, the Fields do not display properly. The first one is ok,
but then the name of the second field/column is in the column labelled
"P
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
INSTALL-BIN f
I have not been able to figure this out, yet. I found the file
/usr/share/mysql/make_binary_distribution and tried a make on it; no
luck. I scoured the documentation on the web and in my own distribution
and have not been able to find out what to do next. See Below. I would
appreciate getting
I have a primary key listed as ID
When I first added about 10 records and then deleted a few records and
then added more records it didn't replace the missing records.
When I select all records to view I now get:
1
2 why didn't it go to 3, 4 and 5 after 2?
6
7
8
When I add a record it becom
Folks,
I am totally new to databases, haven't got the foggiest of what's going on here. I
have downloaded and installed MySQL 3.23.29 a while back, but I still don't know how
to even configure it, even though I have read several articles about using it, and
consulted our webmaster, but he's go
i want to replace all occurences of www to http://www in all columns of a
table.
the column contains blocks of text.
is there any way to do this directly in mySQL?
thankx. =)
---
Stephen U. Lee
Hello Michael,
Sunday, April 08, 2001, 4:21:18 AM, you wrote:
Peter>> No it's not but it has just a couple of collisions per 100.000
Peter>> records.
MW> The problem with a not unique key is that MySQL will do an extra check
MW> if it should use the key during the optimization stage. If the
Is there a way to link FoxPro to MySQL without using ODBC ???
This question is just to satisfy my curiosity, it is not something I need to do.
Regards
Chris.Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com">http://www.hotmail.com.
Dear sir/madam,
I am new to MySQL and downloaded it last night. I now have it running on my Windows
2000 Server but have a rather large problem. This may sound stupid but everywhere in
the manual etc there are commands for me to enter, eq I an learning from zdnet.com how
to use MySQL and it ha
Hi!=20
i use mysql for windown version and i have this problem,
as i know the mysqlGUI is a graphical tool to help you to make tables =
fields and other thinks for your database.
I can change the password ,give sql commands but from the menu =
commands->tables it doesn't work create table, edit t
Hi,
Im not sure but:
Is it safe to assume that row[0] and row[1] are valid (ie not NULL and not
garbage)!(?)
...
> row = mysql_fetch_row(res);
> printf("[%s:%s]\n", row[0], row[1]);
...
> mysql_data_seek(res, 0);
...
> row = mysql_fetch_row(res);
> printf("[%s:%s]\
How do you do.
Although it was poor English, since the problem was never
unsolvable, it mailed.
I tested by Japanese version Winows using Borland 5.5 and
mysql-3.23.36-win.zip. However, if easy sauce is written,
it will crash at the time of main() end.
The following is the sauce.
//
Hi!
i use mysql for windown version and i have this problem,
as i know the mysqlGUI is a graphical tool to help you to make tables fields and other
thinks for your database.
I can change the password ,give sql commands but from the menu commands->tables it
doesn't work create table, edit table
> Why does it give the old version number ? Have I done something wrong
> ? Should I put --with-mysql=/path/to/mysql ?
Yes, you should. If you leave out the path, PHP uses a MySQL library shipped
with the PHP source code. You should have gotten a warning after the
./configure for PHP, explaining
Hello mysql,
I've installed the MySQL from RPM version 3.23.32. Then, I install
also php4.04 from source with option --with-mysql without giving the
path-to-mysql information. It works so far but I get the following
information when using the phpinfo() :
mysql
MySQL Support enabled
66 matches
Mail list logo
