-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08 Oct 2003 23:06:59 +0200, Michiel v.d. linden wrote:
> I'm trying to install Mysql from the RH80 cd's. Right now it looks like
> I'm in a endless loop..see install efforts below
>
> [EMAIL PROTECTED] RPMS]# rpm -iv mysql-3.23.52-3.i386.rpm
> war
Hi Parminder,
RH 9 comes with both mysql server and mysql client. During
installation it may be installed or may not be installed. You can
verify by the command
rpm -q mysql (for mysql client)
rpm -q mysql-server (for mysql server)
if both are found then you are done. you can start with them. Y
On Mon, Oct 06, 2003 at 11:25:34AM +0100, Parminder Singh Chauhan wrote:
> Can any one please tell me is the Mysql server package is included in
> the RH9 when apache server is installed and run.
[...snip...]
AFAIK you also need the mysql-client rpm installed. Then everything should be as you
want
I'm betting you can find the list you're looking for here
http://lists.mysql.com/
--
Hardy Merrill
Red Hat, Inc.
--
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]
https://www.redhat.com/mailman/listinfo/redhat-list
On Fri, 2003-10-03 at 11:15, Richard F. Hobson wrote:
> I am starting to work with MySql 4.x.(have it installed and running on
> my RH 9 machine) I am not new to relational databases (SqlServer,
> Informix), but am new to MySql. Can someone recommend the appropriate
> list when learning MySql fr
On Tue, 2003-09-02 at 15:45, Sambit Nanda wrote:
> Hi Can any one aswer my question pls ?
>
>
>
> --- Sambit Nanda <[EMAIL PROTECTED]> wrote:
> > I want to keep Multi instance of DB and log in
> > different file system, I know i can keep or
> > configure
> > multi my.cnf but i am not sure how t
Hi,
I thought that they were in /var/lib/mysql if I am not wrong !
Cheers,
Aly.
On Tue, 2003-09-02 at 14:45, Sambit Nanda wrote:
> Hi Can any one aswer my question pls ?
>
>
>
> --- Sambit Nanda <[EMAIL PROTECTED]> wrote:
> > I want to keep Multi instance of DB and lo
Hi Can any one aswer my question pls ?
--- Sambit Nanda <[EMAIL PROTECTED]> wrote:
> I want to keep Multi instance of DB and log in
> different file system, I know i can keep or
> configure
> multi my.cnf but i am not sure how to configure
> that,
> and what should i define for different datadi
I cant find /usr/lib/libmyodbc.ini
[EMAIL PROTECTED] /]# ls -alh /usr/lib/libmyodbc.so
ls: /usr/lib/libmyodbc.so: No such file or directory
[EMAIL PROTECTED] /]# find . -name libmyodbc.so
[EMAIL PROTECTED] /]#
which unixODBC are you running ?
I went here
http://at.rpmfind.net/opsys/linux/RPM/redha
As a disclaimer, I've never used ODBC with MySQL on RH, but I
stepped through what you described and, with some adjustments,
was able to successfully attach to a database with "isql".
First:
/usr/lib/libmyodbc.so is on my system and came with the MyODBC
package.
my /etc/odbcinst.ini was already s
*This message was transferred with a trial version of CommuniGate(tm) Pro*
hi Stephen
i solve the problem.
thank you.
On Sat, 2003-08-09 at 10:07, Stephen Kuhn wrote:
> *This message was transferred with a trial version of CommuniGate(tm) Pro*
> On Fri, 2002-08-09 at 16:56, [EMAIL PROTECTED] w
On Fri, 2002-08-09 at 16:56, [EMAIL PROTECTED] wrote:
> *This message was transferred with a trial version of CommuniGate(tm) Pro*
> hi,
>
> i'm getting an error : ~ "mysql dead but subsys locked".
> when i try to run mysql:
>
> "ERROR 2002: Can't connect to local MySQL server through socket
> '/
we run mysqlhotcopy script to copy the database to a different slice on
the disk, and then make the backup of that slice to a magnetic tape.
/usr/local/mysql/bin/mysqlhotcopy password=your_passwd databasename
/path/to/backup/dir
mysqlhotcopy is a perl script that locks the table for updates while
: RE: mysql clustering toolkit
Thanks Kristof, since downloading the clustering toolkit is an enigma now, I
could try configuring replication. Isnt replication and clustering the same?
Regards,
Ajay
- Original Message -
From: "Kristof Kowalski" <[EMAIL PROTECTED]>
Date: Mo
000
To: <[EMAIL PROTECTED]>
Subject: RE: mysql clustering toolkit
> Looks like the Prometheus Tool Kit page is down, can't resolve the files
> links at all, I'm assuming that's the one you're after.
>
> Check out the usual p2p networks and/or mirrors quite pos
Looks like the Prometheus Tool Kit page is down, can't resolve the files
links at all, I'm assuming that's the one you're after.
Check out the usual p2p networks and/or mirrors quite possibley, someone
might have it.
Kristof Kowalski | Staesis Network | www.staesis.net
-- Internetworking Consul
DuSTiN KRySaK wrote:
Hi there - just learning redhat, and I need to learn a SQL - now I was
wondering what the diff was between Mysql VS postgreSQL? Is one easier for a
beginner than the other? One more stable? One play nicer with web pages
(that will be my use for it).
You probably won't seem much
On Mon, 10 Mar 2003, DuSTiN KRySaK wrote:
> wondering what the diff was between Mysql VS postgreSQL? Is one easier
They are similar but different. The best thing to do is to determine what
functionality your relational database needs, and then pick the one that
comes closest to meeting those requ
On Mon, 10 Mar 2003 [EMAIL PROTECTED] wrote:
> I have found a whole bunch of MySQL RPM's for redhat, but there are
> many with very similar files names. Can someone point me toward the
> lastest full version of MySQL that will work in RedHat 7.3? Below is
> my detailed version information
>
> Lin
On 3/10/03 1:23 PM, "Terry Hobart" <[EMAIL PROTECTED]> spit this out onto my
computer screen:
> If you are looking for a windows tool to maintain data, databases, & tables
> in mysql, we use dbtools. It is sometimes not totally intuitive( you have to
> hit the save button after making any changes
If you are looking for a windows tool to maintain data, databases, & tables
in mysql, we use dbtools. It is sometimes not totally intuitive( you have to
hit the save button after making any changes ) but it works fine.
Terry
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PR
[EMAIL PROTECTED] wrote:
I have found a whole bunch of MySQL RPM's for redhat, but there are many with very similar files names. Can someone point me toward the lastest full version of MySQL that will work in RedHat 7.3?
Use "up2date" to install the latest versions from Red Hat.
--
redhat-li
On Mon, Mar 10, 2003 at 01:16:55PM -0500, Mikkel L. Ellertson wrote:
> On Mon, 10 Mar 2003, DuSTiN KRySaK wrote:
>
> > Can anyone recommend a MySQL Gui besides phpMyAdmin? I also tried the
> > MySQLcc as well and it just locks up on connection to the SQL
> > server
> >
> >
> > Dustin
> >
On Mon, 10 Mar 2003, DuSTiN KRySaK wrote:
> Can anyone recommend a MySQL Gui besides phpMyAdmin? I also tried the
> MySQLcc as well and it just locks up on connection to the SQL
> server
>
>
> Dustin
>
I have MySQLcc workign fine on a couple of 7.3 systems. Connecting to
both local and
I use mysqlnavigator. Pretty nice interface. For RH8 there is an rpm at
http://mysqlnavigator.fear.cz/ that I just installed yesterday that works
like a charm. (Building from source failed as there must be some library it
wasn't finding) Just a note on the left window you have a tree view of th
Take a look at squirrelsql
Squirrel SQL Client: A Java Front-end
A program written in Java can interface with MySQL database using the
JDBC (Java DataBase Connectivity) technology. Squirrel SQL Client is a
GUI application written in Java.
On Mon, 2003-03-10 at 05:17, DuSTiN KRySaK wrote:
> Can
y not that scary ;)
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=backup.html
/B
- Original Message -
From: "Juan Nin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 11:19
Subject: Re: MySQL vs. PostgreSQL
> F
PROTECTED]
Behalf Of Ryurick M. Hristev
Sent: Thursday, February 27, 2003 5:57 PM
To: [EMAIL PROTECTED]
Subject: Re: MySQL vs. PostgreSQL
On Wed, 26 Feb 2003, Joe Giles wrote:
> Question about backing up...
>
> Sorry if this is not on the lines of what you guys are talking about,
> but I
Ryurick M. Hristev
Sent: Thursday, February 27, 2003 5:57 PM
To: [EMAIL PROTECTED]
Subject: Re: MySQL vs. PostgreSQL
On Wed, 26 Feb 2003, Joe Giles wrote:
> Question about backing up...
>
> Sorry if this is not on the lines of what you guys are talking about,
> but I set up MySQL and I
/maintenance.sql -U $DB_USER $DATABASE
- Original Message -
From: "Ryurick M. Hristev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 27, 2003 14:56
Subject: Re: MySQL vs. PostgreSQL
> On Wed, 26 Feb 2003, Joe Giles wrote:
>
> > Questio
On Wed, 26 Feb 2003, Joe Giles wrote:
> Question about backing up...
>
> Sorry if this is not on the lines of what you guys are talking about,
> but I set up MySQL and I sym link the database from one file system to
> another for redundancy purposes. So, when I upgrade, I just break the
> link an
I am using MySQL. It is getting about about 3 million records a month
added to it. It does not fail under the load, but slowes down to the
point where it is not usable. What we have to do is move the data out of
the active table into another table.
david
On Wed, 26 Feb 2003, Juan Nin wrote:
>
On Jue 27 Feb 2003 02:32, Joe Giles wrote:
> Question about backing up...
>
> Sorry if this is not on the lines of what you guys are talking about,
> but I set up MySQL and I sym link the database from one file system to
> another for redundancy purposes. So, when I upgrade, I just break the
> link
On Mié 26 Feb 2003 18:58, Ryurick M. Hristev wrote:
>
> > That's true with all the database systems I have used (Informix, Oracle
> > and PostgreSQL).
> > It has to do with how diferent versions handly the database files, and
> > how it changes. Any way, you don't have to do a dump-restore with pa
Well, I stated that for redundancy I created sym links. That isn't the
proper wording I should have used. What I meant to say was I created sym
links from one file system to another for space reasons. I ran out of
space on the /var part. so I linked the databases to another fs. Sorry
for the misund
Joe Giles said:
> Question about backing up...
>
> Sorry if this is not on the lines of what you guys are talking about, but
> I set up MySQL and I sym link the database from one file system to another
> for redundancy purposes. So, when I upgrade, I just break the link and
> upgrade, then re link.
Question about backing up...
Sorry if this is not on the lines of what you guys are talking about,
but I set up MySQL and I sym link the database from one file system to
another for redundancy purposes. So, when I upgrade, I just break the
link and upgrade, then re link. It has worked so far (well
On Wed, 26 Feb 2003, Martin Marques wrote:
> On Mié 26 Feb 2003 16:19, Juan Nin wrote:
> > From: "David Busby" <[EMAIL PROTECTED]>
[...]
> > I've heared that upgrading is more painfull with PostgreSQL, since you have
> > to dump the databases and restore them again after the upgrade
[...]
> Th
Juan Nin wrote:
I've heared that upgrading is more painfull with PostgreSQL, since you have
to dump the databases and restore them again after the upgrade
Dump and rebuild is an easy and reliable way to preserve your data through
db engine updates. Are you saying that if the binary formats were
c
From: "David Busby" <[EMAIL PROTECTED]>
> Juan,
> After performing the Dump/Import for the upgrade once it's cake.
There
> are two utilities that you can use
> pg_dump
> to dump data
> psql < [file]
> to restore
> so before I upgrade I simply
> pg_dump [options] [dbname]
> to my ar
amp;file=backup.html
/B
- Original Message -
From: "Juan Nin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 11:19
Subject: Re: MySQL vs. PostgreSQL
> From: "David Busby" <[EMAIL PROTECTED]>
>
> > I'
From: "Stefan Neufeind" <[EMAIL PROTECTED]>
> Well yes and know to the use / not use MySQL-question. I wouldn't
> rate the university-use "mission critical". It runs good, that's what
> I hear from many people. And it's stablizing more and more. Got a
> bugfix-newsletter yesterday which only in
> I've heared that upgrading is more painfull with PostgreSQL,
> since you have
> to dump the databases and restore them again after the upgrade
Yes it's true you need to dump the databases and restore them, but I
disagree that it's painful.
It's fairly quick and easy with `pg_dumpall`. In fact y
On 26 Feb 2003 at 11:28, nate wrote:
> Juan Nin said:
>
> > but I've heared that the new MySQL 4.x branch changes this a bit,
> > and that from MySQL 4.1 there are nested queries support, etc
>
> I most certainly would reccomend AGAINST using mysql 4.x unless your
> app has a long development ti
> I most certainly would reccomend AGAINST using mysql 4.x unless your
> app has a long development time to give mysql 4.x time to stabilize(I
> would not use it for probably at least a year). It still isn't "final"
> according to mysql.com. And even after it is I would not deploy it
> immediately.
I have to preface this by saying that I haven't personally used
Postgres for anything...
I use MySQL for database-driven websites and a db-driven chat system
that I am toying with. While the sites I have running are low-volume,
I would note that I ran ApacheBench against one of them to see ho
Juan Nin said:
> but I've heared that the new MySQL 4.x branch changes this a bit, and that
> from MySQL 4.1 there are nested queries support, etc
I most certainly would reccomend AGAINST using mysql 4.x unless your
app has a long development time to give mysql 4.x time to stabilize(I
would not u
Personally speaking I must tell you that I like MySQL very much
because of its compactness (in the 3.x-releases). But at some points
you're right, it wasn't the best database-solution to choose because
of it's features - but I was able to "emulate" a lot through php-
scripts.
The 4.x-branch chan
From: "David Busby" <[EMAIL PROTECTED]>
> I've always loved PostgreSQL I use it for large and small projects, with
> some real nasty/ugly nested queries. It still performs great even under
> some heavy load. Make sure you get a real (real) fast HDD (LVD SCSI 15K
> RPM), the slower the drive the
I've always loved PostgreSQL I use it for large and small projects, with
some real nasty/ugly nested queries. It still performs great even under
some heavy load. Make sure you get a real (real) fast HDD (LVD SCSI 15K
RPM), the slower the drive the slower the database in my experience.
/B
-
> errors occured while rotating /var/log/mysqld.log {
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> error running prerotate script --
> leaving old log in place
look in /etc/logrotate.
Let me take a shot at my now born knowledge:
Insert disc 3
>From the command line as root type:
Rpm -ivh /mnt/cdrom/RedHat/RPMS/my*
I think that will do it or try
Up2date my*
And see if Red Hat will update it.
Good luck
Buck
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMA
Thanks, Went there and that cleared it up.
Terry
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Matthew Saltzman
Sent: Tuesday, January 14, 2003 8:20 PM
To: [EMAIL PROTECTED]
Subject: RE: Mysql will not answer outside localhost
On Tue, 14 Jan 2003
On Tue, 14 Jan 2003, Terry Hobart wrote:
>
> I did notice on the bug page that this is listed as a 'CLOSED' item. How so?
> It clearly effected me even with a full up2date update. And I saw nothing
> from RedHat on the page as to an 'Official' fix/work around. Is a
> puzzlement.
You need to read
2003 4:01 PM
To: [EMAIL PROTECTED]
Subject: RE: Mysql will not answer outside localhost
I could swear glibc was updated for both 7.3 and 8.0 to work around
this... Since it hasn't, use the fix for mysql mentioned here:
http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=74943#c16
On Tue,
Larry Brown
Sent: Tuesday, January 14, 2003 12:44 PM
To: [EMAIL PROTECTED]
Subject: RE: Mysql will not answer outside localhost
I though up2date was what broke his install. I have mysql loaded on two
fresh RH8 systems and both work just fine from remote clients.
Larry S. Brown
Dimension Networks
st about come to that conclusion
> myself. It's good to get confirmation.
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Graeme Coates
> Sent: Tuesday, January 14, 2003 4:47 AM
> To: [EMAIL PROTECTED]
> Subject: Re: My
27;s address in - 10.1.10.3 localhost.localdomain
localhost - which crashed mysql all together.
I could use an example.
Terry
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Graeme Coates
Sent: Tuesday, January 14, 2003 4:47 AM
To: [EMAIL PROTECTED]
Subject: Re:
Sent: Tuesday, January 14, 2003 7:47 AM
To: [EMAIL PROTECTED]
Subject: Re: Mysql will not answer outside localhost
> You restarted MySQL after the update?
>
>
> On Mon, 2003-01-13 at 22:04, Terry Hobart wrote:
> > Well my hopes for an upgrade fix are dashed. I rhn-ed the whol
> You restarted MySQL after the update?
>
>
> On Mon, 2003-01-13 at 22:04, Terry Hobart wrote:
> > Well my hopes for an upgrade fix are dashed. I rhn-ed the whole server today and
> > still no joy connecting to the server from anywhere but localhost. I am bumbed.
The rhn up2date won't help on an
On Mon, 2003-01-13 at 22:55, Joshua Schmidlkofer wrote:
> brilliant response.
I'm aware you follow this list and so try to limit my response to what I
know you can understand.
--
Cliff Wells, Software Engineer
Logiplex Corporation (www.logiplex.net)
(503) 978-6726 x308 (800) 735-0555 x308
--
Terry
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Gordon Messmer
Sent: Tuesday, January 14, 2003 12:53 AM
To: [EMAIL PROTECTED]
Subject: Re: Mysql will not answer outside localhost
You restarted MySQL after the update?
On Mon, 2003-01-13 at 22:04, Terry H
since.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Gordon Messmer
Sent: Tuesday, January 14, 2003 8:53 AM
To: [EMAIL PROTECTED]
Subject: Re: Mysql will not answer outside localhost
You restarted MySQL after the update?
On Mon, 2003-01-13 at 22:04
You restarted MySQL after the update?
On Mon, 2003-01-13 at 22:04, Terry Hobart wrote:
> Well my hopes for an upgrade fix are dashed. I rhn-ed the whole server today and
> still no joy connecting to the server from anywhere but localhost. I am bumbed.
--
redhat-list mailing list
unsubscribe
brilliant response.
--
VB programmers ask why no one takes them seriously,
it's somewhat akin to a McDonalds manager asking employees
why they don't take their 'career' seriously.
signature.asc
Description: This is a digitally signed message part
>
> > Terry
> >
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> > Behalf Of Gordon Messmer
> > Sent: Sunday, January 12, 2003 10:59 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Mysql will not answer outside
s may
> seem naive but the last thing I suspected was glibc.
>
> Terry
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Gordon Messmer
> Sent: Sunday, January 12, 2003 10:59 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Mysql
]]On
Behalf Of Gordon Messmer
Sent: Sunday, January 12, 2003 10:59 PM
To: [EMAIL PROTECTED]
Subject: Re: Mysql will not answer outside localhost
On Sat, 2003-01-11 at 16:28, Terry Hobart wrote:
> I have an RH 8 stock installation (meaning I have not yet updated it
> from rhn). I had it install
[Grr. Once again my post goes through blank]
On Mon, 2003-01-13 at 08:54, Terry Hobart wrote:
> Sorry, brain fart. Was typing telnet 10.1.10.3:3306
>
> Using the correct syntax I got 'connection to host lost'.
>
> And that's correct - no telnetd on this server. I will go ahead and install
> it a
back.
Once again, you don't need telnetd. You only need telnet. Please
reread my last post.
> Terry
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Cliff Wells
> Sent: Monday, January 13, 2003 7:35 AM
> To: [EMAIL PROTEC
L PROTECTED]]On
Behalf Of Cliff Wells
Sent: Monday, January 13, 2003 7:35 AM
To: [EMAIL PROTECTED]
Subject: Re: Mysql will not answer outside localhost
On Sun, 2003-01-12 at 21:54, Terry Hobart wrote:
> I agree it is not a firewall issue. I have no firewall running on this
machine
> and a
m: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> > Behalf Of Terry Hobart
> > Sent: Sunday, January 12, 2003 6:41 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Mysql will not answer outside localhost
> >
> > I checked all that out and even re-did some user
On the computer not running MySql with the data base, but running Linux
and MySql enter:
mysql -h 10.1.10.3 -u root -D database-wanted
This will start mysql on the local machine, but connect to the mysql
database on the remote computer.
david
On Sat, 11 Jan 2003, Terry Hobart wrote:
> Forgive
On Sat, 2003-01-11 at 16:28, Terry Hobart wrote:
> I have an RH 8 stock installation (meaning I have not yet updated it
> from rhn). I had it install MySQL from the disks. I cannot however
> access it from outside the localhost box.
Then update the system from RHN.
MySQL sets its stack size too s
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Terry Hobart
> Sent: Sunday, January 12, 2003 6:41 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Mysql will not answer outside localhost
>
> I checked all that out and even re-did some users with no luck. They all
> check
>
ECTED]
Subject: Re: Mysql will not answer outside localhost
I checked all that out and even re-did some users with no luck. They all
check
out with % in the Host column and Y in all the privleges. I set this machine
up befor using the rpm directly from the mysql site and it worked fine. I
wanted t
s correct once I'm back
> up-and-running).
>
> Mike
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
> Behalf Of Terry Hobart
> Sent: Sunday, January 12, 2003 8:11 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Mysql will not answer outs
I haven't put the firewall in yet. Defaulted the install to no firewall. I am
going to roll my own when I am done setting up this system. I am using
postfix compiled to talk to mysql for virtual users. Eventually I will use it
for coldfusion MX. But I need to use my dbtools for now on a workstation
I've never used MySQL, but this couldn't be a firewall thing could it?
Lot's of things don't connect from stock install unless you customize the
firewall at install time.
Regards,
---
Edward Dekkers (Director)
Triple D Computer Services P/L
--
redhat-list mailing list
unsubscribe mailto:[EM
just died from a HD
failure, so I will find out if my memory is correct once I'm back
up-and-running).
Mike
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Terry Hobart
Sent: Sunday, January 12, 2003 8:11 PM
To: [EMAIL PROTECTED]
Subject: Re: Mysql
I checked all that out and even re-did some users with no luck. They all check
out with % in the Host column and Y in all the privleges. I set this machine
up befor using the rpm directly from the mysql site and it worked fine. I
wanted to use RedHat's rpm this time because I want to maintain it wi
Take a look at your user table in the mysql db. Make sure they are listed
properly as being able to access from their computer. If they are listed as
being able to access from their computer, list their computer's name in the
/etc/hosts file along with their IP just to make sure it is not some dn
Did you set up the users in the user table to access from remote hosts?
Try this when logged in on the local host, then restart MySQL
INSERT INTO `mysql.user` (`Host`, `User`, `Password`, `Select_priv`,
`Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`,
`Reload_priv`,
Forgive the ignorance but can you explain the -h server-name further. I can
only log in as root when on the localhost.
Thanks
dbrett wrote:
> Did you try the "-h 'server-name(or ipaddress)'" option as well when
> logged in as root?
>
> david
>
> On Sat, 11 Jan 2003, Terry Hobart wrote:
>
> > I h
Did you try the "-h 'server-name(or ipaddress)'" option as well when
logged in as root?
david
On Sat, 11 Jan 2003, Terry Hobart wrote:
> I have an RH 8 stock installation (meaning I have not yet updated it
> from rhn). I had it install MySQL from the disks. I cannot however
> access it from outs
On Sat, 2003-01-04 at 21:33, Christensen Tom wrote:
> Ok, I have a redhat 8.0 install, well actually 2 of them
> and mysql works fine as long as I'm connecting over Unix sockets,
> but if I try to connect to the server remotely (yes the permissions are
> right!)
> I get a "Error 2013: Lost connect
Fixed it,
it was a dns issue, my reverse dns wasn't working... pah
so for whatever reason mysql can't deal with that. :)
From: RTS <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: Re: Mysql problems
Date: Sun, 5 Jan 2003 00:03:42 -060
Do you have a whole opened up in iptables or ipchains and an allow line in
hosts.allow for access to it from outside the local machine.
RTS
>
>
> Ok, I have a redhat 8.0 install, well actually 2 of them
> and mysql works fine as long as I'm connecting over Unix sockets,
> but if I try to connect
True, I know this one, but by default the other database servers support
case-insensitivity, this includes oracle, mysql, sapdb if I am not wrong
since its oracle compatible.
We had to change our application to deal with this by lowercasing all
the data which we never had a problem with in MySQL p
Referential integrity is only a small part of the relational idea. In
fact, I should mention that no database system that I know of implements
the relational idea fully. However, MySQL is just much further away than
others.
Jon
On Mon, 18 Nov 2002, Todd A. Jacobs wrote:
> On Mon, 18 Nov 2002,
> The only thing that I dislike about Postgres is the case-sensitivity of
> data in the database, if anybody knows how to turn it off let me know.
You can use select statements like this:
select * from abc where upper(xyz) = 'SEARCH';
select * from abc where xyz ~* 'search';
POSIX Regular Express
On Mon, 18 Nov 2002, Jonathan Bartlett wrote:
> MySQL does not support the relational idea very well.
Sure it does. It's just that support for referential integrity is fairly
recent.
--
"Whenever I feel blue, I start breathing again."
- Unknown
--
redhat-li
> i've been a fan of mysql as of late because it's simple and fast. AND the
> documentation is great. postgres is the opposite of all of the above.
ctually, the 7.x series of Postgres is quite fast. Using Postgres on an
RH system is as easy as service postgresql start; su postgres -
createuser;
ated to SAP itself?
> >
> > Cheers,
> > Ronald
> >
> >
> > -Original Message-
> > From: Jonathan Bartlett [mailto:[EMAIL PROTECTED]]
> > Sent: maandag 18 november 2002 15:11
> > To: [EMAIL PROTECTED]
> > Subject: Re: Mysql or Postgresql
> &
tation for free.
Jon
On Mon, 18 Nov 2002, Ronald Hermans wrote:
> Never heart of SAP DB. Is it related to SAP itself?
>
> Cheers,
> Ronald
>
>
> -Original Message-
> From: Jonathan Bartlett [mailto:[EMAIL PROTECTED]]
> Sent: maandag 18 november 2002 15:11
>
It maybe simple and fast but you are required to do alot in the
programming end to compensate for stuff that a database server should do
for you maybe Oracle has spoilt us with triggers and the like, merge
tables are worth crap they don't work as advertised in the docs, maybe
in MySQL 4.x.
The onl
i've been a fan of mysql as of late because it's simple and fast. AND the
documentation is great. postgres is the opposite of all of the above.
On November 18, 2002 04:50 am, Shiva Haddad wrote:
> I want to have client , server database in redhat for a IP Telephone system
> product, it must be
At 11:50 PM 11/17/02, Shiva Haddad wrote:
I want to have client , server database in redhat for a IP Telephone
system product,
it must be multi-user & ...
which one is better , Mysql or postgresql ?
From what I've read, it appears to depend on what you will do. If your
system will be largely i
wrote:
> Never heart of SAP DB. Is it related to SAP itself?
>
> Cheers,
> Ronald
>
>
> -Original Message-
> From: Jonathan Bartlett [mailto:[EMAIL PROTECTED]]
> Sent: maandag 18 november 2002 15:11
> To: [EMAIL PROTECTED]
> Subject: Re: Mysql or Postgres
Never heart of SAP DB. Is it related to SAP itself?
Cheers,
Ronald
-Original Message-
From: Jonathan Bartlett [mailto:[EMAIL PROTECTED]]
Sent: maandag 18 november 2002 15:11
To: [EMAIL PROTECTED]
Subject: Re: Mysql or Postgresql
Before I start, let me first say that you have left out
1 - 100 of 235 matches
Mail list logo
