Thanks for suggestions, just downgrading now.
Alexander
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <
>Description:
I started replication from UNIX_server(Distrib 3.23.33) to
windows_server(3.23.35a for win95/98). When I creating a table JJJ on a
master host, i see table jjj on slave instead of JJJ.
And more - any created locally on slave side in upper case table appearing
as lower case ..
Hi,
I have to run my application under Solaris-2.6 (we cannot upgrade our
web server) and I need some 3.23.x functionality. I tried to compile the
3.23.35 sources but "configure" complained about the compiler.
Could somebody provide me a binary version of 3.23.x (the best would be
of course 35)
Hi everybody. I got a complexe question well according to me. I am working with PHP
and i am making some queries to some database. here is a description of the tables.
provider book video music
provider_id title title title
name provider_id provider_id provider_id
Hi everybody. I got a complexe question well according to me. I am working with PHP
and i am making some queries to some database. here is a description of the tables.
provider book video music
provider_id title title title
name provider_id provider_id provider_id
All,
Please note that my EMail system was atacked by an "AnnaKournikova" virus.
Though I'm well protected, and the virus was emidiatly discovered by my
Anti-virus softwares, I think it'd be a good idea to warn all of you.
Please do not open any attachment sent from my EMail address.
The subjec
Hi,
WHAT DO I WANT TO DO:
I want to have the binary value of a part of a decimal value.
1)I have a decimal value in column called intag : 262204
2)From this value I'am only interested in the last two bits of the HEX value of
this decimal
HEX value = 4003C
My interest 3C
How do i put in an integrity constraint?
ie. say i have 2 tables
Person (PersonID[pk], PersonName)
School (SchoolID[pk], SchoolName, PersonID[fk])
as you can see PersonID is the foreign key in School.
So how do keep update and delete restricted constraints etc,?
could anyone tell me the SQL
what are the basic differences in the CREATE TABLE command for the following
keywords?
I checked the MySQL manual but couldnt make much sense outa it.
KEY
INDEX
PRIMARY KEY
UNIQUE
plz. could anyone ellaborate more on UNIQUE AND PRIMARY KEY.? it seems that
both are doing the same job?...
duke.
make sure you send the right mimetype to the client with the php header
function.
some browsers try to detect the mime-type based on the file extension if
they are unsure about the sent mime-type, but you should not rely on this
and different browsers/version are likely not to generate the result
On Mon, Mar 26, 2001 at 12:26:51PM -0700, YI,LI (HP-USA,ex1) wrote:
> Hi,
>
> In my case, some of tables are created according to people's name, e.g.
>
> when user adds new name: firstname lastname
> it should create table in background => firstname_lastname
>
> But problem occurs when user n
Hi
Just a question. What about performance when storing audio files in a blob.
What effect does it have on the database(load, space requirements compared to
audio files,...) I will be confronted with this question in the near future
where I will have to decide to store on disk or in blob. I you ha
hy,
ive alway the problem with several users on a web-server:
each user should have the possibility to create a database -
this is ok - the databases are in ./mysql/var . If a user creates
a database all files are owned by the user root - and so the
owner of the db has no rights to copy the dbfi
Dear Sir, Re:MySQL Database - DSN
How to create a DSN for MYSQL DATABSE on online LINUX
server.
Pl provide me the syntax.
And also I need the syntax for FOREIGN KEY with references
to access two tables in MYSQL.
for eg. (A) Table name : Parent (column name is PARTY varchar(10)
To Whom It May Concern:
I have set up a mySQL server on a Windows NT Server and use the mySQL Gui
client on a Window 98 workstation to connect to the server. But the client
reports that Access is denied for user [EMAIL PROTECTED] (my
workstations DNS on the network). I am using the right password
Hi
Please read Chapter 6 - The MySQL Access Privilege System in the reference
documention
Regards
John
On Tuesday 27 March 2001 12:31, Neil wrote:
> To Whom It May Concern:
>
> I have set up a mySQL server on a Windows NT Server and use the mySQL Gui
> client on a Window 98 workstation to connec
Dear Sir,
I have created the following table:
create table test(name varchar(10) NOT NULL);
query is ok
I HAVE TRIED THE FOLLOWING QUERY :
insert into test values("");
MYSQL COMMAND IS ACCEPTING THE ABOVE QUERY WHICH VIOLATES NOT NULL
CONSTRAINTS.
PLEASE CHECK THE ABOVE QUERY
KINDLY INFOR
Ryan Worley writes:
> >From this feature list, it sounds like you are creating methods
> (multi-deletes, updates from joins) that will take the place of
> transactions. Is this the direction that MySQL is heading? Do you believe
> that these methods will be preferred over traditional rollbac
- Original Message -
From: "Ramasamy Palaniappan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 6:53 AM
Subject: help on mysql tables
> I have created the following table:
>
> create table test(name varchar(10) NOT NULL);
> query is ok
Yes, but notice that yo
Hello.
I have installed the source of RPM 3.23.35 (Mysql,client and devel) without
problems.
But when I execute a makefile of a easy program this error appears:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress':
my_compress.o(.text+0x97): undefined referen
- Original Message -
From: "Samantha Savvakis" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 12:39 AM
Subject: ADO problem with MYSQL datetime column
> I have a table that I'm querying that has 'datetime' columns. If these
> columns are null or 0 - "00
Hubert Feyrer writes:
>
> Well, subject says it pretty much all - I'm trying to build mysqlgui
> 1.7.4 on NetBSD 1.5/i386, and get linker warnings:
>
> single.o: In function `EditorEngine::LoadSQL(char const *)':
> /usr/cvs/pkgsrc/databases/mysqlgui.work/work.i386/mysqlgui-1.7.4/FL/wstrin
Jason B writes:
> I compiled all the required files and it seemed to work Ok.
> I just have one question. How do I start the mySQL GUI?
>
> Any help you can provide would be greatly appreciated.
>
> Thank, Jason
>
HI!
Just follow instructions from README. Here is an excerpt :
All yo
Hi,
i have a big problem ... why this doesnt work?:
INSERT INTO mytable (login, heslo) VALUES ('login', Password('heslo'));
SELECT * FROM mytable WHERE login='login' AND heslo=Password('heslo');
the second line gives me no result ... i have spent a lot of
time looking at that, but i cant find, w
Yes and I believe it's explained in the manual better than I can explain it
here.
Roughly speaking, if the field contains:
foobar
then
LIKE 'foo%' says match anything starting with foo. Since it's STARTING with
foo then the index can be used. Just like the Index of a book would be
useless if
On Tue, Mar 27, 2001 at 11:53:22AM -, Ramasamy Palaniappan wrote:
> Dear Sir,
>
> I have created the following table:
>
> create table test(name varchar(10) NOT NULL);
>
> query is ok
>
> I HAVE TRIED THE FOLLOWING QUERY :
>
> insert into test values("");
>
> MYSQL COMMAND IS ACCEPTING T
Neil writes:
> To Whom It May Concern:
>
> I have set up a mySQL server on a Windows NT Server and use the mySQL Gui
> client on a Window 98 workstation to connect to the server. But the client
> reports that Access is denied for user [EMAIL PROTECTED] (my
> workstations DNS on the network)
Key = Creates an index
Index = Same as above? (Not sure, the section of the manual I just glanced
at seems to indicate that they are the same thing)
PRIMARY KEY = Creates a primary key for the table. Each table should have a
primary key and it should be unique for that row in that table. (For mor
Hello
I am thinking to install our DB server in a 4-way machine with
Intel Xeon processors/1MB cache. I can see in the mysql documentation that mysql
works OK in a 2-way machine but that in a 4-way system has to be tested.
Is this true? Or the documentation is not updated?
Anybody out there wit
>How do i put in an integrity constraint?
>
>ie. say i have 2 tables
>
>Person (PersonID[pk], PersonName)
>
>School (SchoolID[pk], SchoolName, PersonID[fk])
>
>
>as you can see PersonID is the foreign key in School.
>So how do keep update and delete restricted constraints etc,?
>
>could anyone tel
>Hi everybody. I got a complexe question well according to me. I am
>working with PHP and i am making some queries to some database. here
>is a description of the tables.
>
> provider book video music
> provider_id title title title
> name provider_id provider_id provider_id
>
Peeps,
My problem is this. I'm not happy about storing plain text passwords in my database
for users, so was considering using the password () function in order to store a hash
of the password instead.
sample SQL.
$sql = "SELECT login,IPaddress,password,administrator,valid
FROM $user_detail
Hi, not too sure about the problem, been successfully using this PHP to
extract the info myself.
$sol = "SELECT login,IPaddress,password,administrator,valid
FROM $user_details_table
WHERE IPaddress =\"$address\" OR (login =\"$username\" AND password =
password(\"$password\"))
";
But I have re
Hi Kevin,
On Tue, Mar 27, 2001 at 02:27:55PM +0100, Kevin Williams wrote:
> Peeps,
>
> My problem is this. I'm not happy about storing plain text passwords in my database
>for users, so was considering using the password () function in order to store a hash
>of the password instead.
>
> sampl
Hi Neil
Do you have an entry in your mysql.host table for this host
(neil.qedi.co.za) ? You will not even be allowed to connect to your
server if there is not either this host or a wild card host similar to
it in the hosts table of the mysql database. If you modify the hosts
table remember to exe
>Description:
I got a message stating the length of CHAR was 0 and the configuration script
ended.
>How-To-Repeat:
Using ksh: CC=gcc CXX=gcc ./configure --prefix=/usr/local/mysql
>Fix: Unknown
>Submitter-Id: Remko de Keijzer
>Originator:Super-User
>Organization: Obragas H
You can't. You'll have to regenerate a new, random password and send that
out.
- Original Message -
From: "Kevin Williams" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 7:27 AM
Subject: Password function
Peeps,
My problem is this. I'm
make sure the field definition where you store your password is at least 16
bytes size (i.e. char(16) or varchar(255) or something). i guess such must
be a problem since your query looks just fine.
gl
rene
- Original Message -
From: "jsimlo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
select book.title, video.title, music.title from provider, book, video,
music where provider.name='providername' and
book.provider_id=provider.provider_id and
video.provider_id=provider.provider_id and
music.provider_id=provider.provider_id;
- Original Message -
From: "Amazing-Books.Com"
well, as easy as is: store the original password, or use a php/your
programming_language_specific function like encrypt() and decrypt().
password function is (and should be) irreversable, like a md5 hash. that's
where it's ment for.
- Original Message -
From: "Kevin Williams" <[EMAIL PRO
This may help - I use 'htmldoc' from easysw.com to convert from HTML to
Postscript - it means I can write reports etc in HTML and them simply
convert them to GS and throw them at the printer. htmldoc adds a couple
of custom HTML tags which you can add to your HTML, including a page break
tag, whic
excuse, this just won't work.
- Original Message -
From: "René Tegel" <[EMAIL PROTECTED]>
To: "Amazing-Books.Com" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 5:16 PM
Subject: Re: Complexe query
> select book.title, video.title, music.title from provider,
(I think) most people figure that the disadvantages of having images and
most other binary files stored within the DBMS far outweigh any
advantages. From the top of my head...
Advantages
--
- tidiness
- ease of backup - all data is in one respository.
Disadvantages
-
- DB
excuse me, this just wouldn't work. and excuse last unfinished message.
if one on of the tables matches none, the query will return no match, which
is maybe not what you want.
else it'll return all data matched against each other, which is again not
likely what you want (since you get multiple re
Sir,
please tell me how to stop mysql from accepting empty string values.
it accepts empty string values even when i enclosed in single quotes.
pl inform me with the syntax.
rgds
palani
>From: "Dennis Salguero" <[EMAIL PROTECTED]>
>To: "Ramasamy Palaniappan" <[EMAIL PROTECTED]>,
><[EMAIL P
Just since the subject was brought up...
Im going to relseas Lucas Web Server V2.0 in a few weeks, it stores
everything (htmlfiles,
images etc) in the DB. To add to the adv/dis list:
Advantages
---
Content management (for communites and larg corp)
Dis
--
Content magangment (for ot
Wouldn't using LEFT OUTER JOINs in your query work instead of just a where
clause? It still wouldn't give the optimum response but it would probably
give a usable one. Unfortunately, I don't see a way to do what the user
really wants to do in MySQL. In MySQL, the UNION clause does not mean what
On Tue, 27 Mar 2001, Sascha Eversmeier wrote:
> Hi,
>
> could anyone of you please take a look at this message:
> 'MySQL said: Got error 127 from table handler'
>
> This occurs when trying to access a specific table, like 'select * from
> someTab', but it works when appending ' limit 0, X'.
>
Test for it in your controlling language. (PHP, PERL, C, Java) and fail it
there. Off the top of my head I don't see a way to enforce it at the
database level with MySQL because the CONSTRAINT clause is for decoration
only.
Cal
http://www.calevans.com
-Original Message-
From: Ramasamy P
Q: I have the following table "grades":
+++
| name | score |
+++
| John |10 |
+++
| John | 8 |
+++
| Carl |10 |
+++
| Mary |6 |
+++
I want to select
select name, score from grades group by name;
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 10:14 AM
To: [EMAIL PROTECTED]
Subject: Distinct Selects...
Q: I have the following table "grades":
+
Use GROUP BY
SELECT names, score FROM grades GROUP BY names
regards,
-- Andrew
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 11:14 AM
Subject: Distinct Selects...
> Q: I have the following table "grades":
>
> +++
Try
SELECT name, min(score) FROM grades
GROUP BY name;
--Greg Johnson
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 11:14 AM
To: [EMAIL PROTECTED
Hi!
This release should fix the final bugs we accidently got into 3.23.34
and a long security bug that has been in MySQL a long time!
The main fixed bugs are that UPDATE didn't always use keys when
updating on something not based on a primary key and that 'affected
rows' wasn't returned to the
Would you please read this too :)
- Original Message -
From: Yusuf Incekara <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 7:08 PM
Subject: Mysql Server Client & Myodbc Silent Install
> Is there any spesification for
> Installing Mysql Server Clients & Myodbc.
On Tue, 27 Mar 2001, Cal Evans wrote:
> Key = Creates an index
> Index = Same as above? (Not sure, the section of the manual I just glanced
> at seems to indicate that they are the same thing)
> PRIMARY KEY = Creates a primary key for the table. Each table should have a
> primary key and it shou
Hi,
I'm trying to install mySQL on NT Server 4.0
I guess I need to install a Telnet Server so I can manage mySQL from a
workstation.
What's a good Cheap or Free Telnet Server for NT?
Also, any instructions on how to set this up would be great.
Thanks,
Chad
Chad M. Nielsen, GIS Programmer/Analy
When we use grant as following:
GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by
"peter";
Then peter can only select the field of col_name_1 on the tbl_name_1 of
db_name_1.
However, when peter issue the query: DESC tbl_name_1; he can see all the
structure of that table. Th
How do you differentiate between primary and secondary indexes? I'm not
familiar with the distinction.
Cal
http://www.calevans.com
-Original Message-
From: Thalis A. Kalfigopoulos [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 10:55 AM
To: Cal Evans
Cc: Duke; [EMAIL PROTECTED
There's a function in SQL to convert strings to upper case (sounds like to_upper()? ),
I don't have the reference book at hand, does anyone know the syntax or that function?
Thank you very much in advance.
-
Before posting, pl
Hello all.
I was wondering if anyone could help me out with a little project I have to do.
I have a win98 machine with a access database.
I would like to transfer everything into mysql on a red hat 7 linux box.
How would I do this?
Plus how would I be able to connect once it transfer to mysql th
http://www.mysql.com/doc/S/t/String_functions.html
UCASE(str)
UPPER(str)
Returns the string str with all characters changed to uppercase according to
the current character set mapping (the default is ISO-8859-1 Latin1):
mysql> select UCASE('Hej');
-> 'HEJ'
This function is multi-byte saf
Tha instructions on mysql web pages ,
downloaded documents and
relelased product versions are not the same for Windows.
I still could not understand did 3.23.35a or 3.23.36
support bdb on windows and if
supports how can i implement this.
Regards.
Hi,
I wonder if anyone had a problem like this one.
I have created a table with one field autoincrement. The field is
tinyint(4).
whenever I try to introduce more then 127 records it refuses to
introduce them.
I tried with tinyint(5) 6.. and so on. It works only with integer.
On Tue, 27 Mar 2001 11:22:20 -0600, Zhu George-CZZ010
<[EMAIL PROTECTED]> wrote:
I believe it's upper(col_name)
>>There's a function in SQL to convert strings to upper case (sounds like to_upper()?
>), I don't have the reference book at hand, does anyone know the syntax or that
>function?
>
Hi Folks!!
I have a question, How may set another location for my productions db,
so, for instance if i want put my db in /mydb filesystem in my Linux
Redhat???
because when i create a db, this is in /var/lib/mysql/data
Please , help me
Thanks !!
Pablo
-
You can use either ucase() or upper() functions.
ucase(str) or upper(str)
Seung-woo Nam
Zhu George-CZZ010 wrote:
> There's a function in SQL to convert strings to upper case (sounds like to_upper()?
>), I don't have the reference book at hand, does anyone know the syntax or that
>function?
>
Hi there ...
I am running mySQL Ver. 9.33 Distrib. 3.22.25 and I have run into the
following problem.
When I type:
mysql> select INSTR('foobarbar', 'bar');
it outputs
+---+
| INSTR('foobarbar', 'bar') |
+---+
| 7 |
+
I'll try to depict this here, though ascii form doesn't really help (this is where a
blackboard and some chalk do a better job)
Assume you have a table which is physically stored as:
ID TAG
-
1 lala
2 koko
3 haha
4 toto
If I create an index on ID, then t
yep. That's the point of a tinyint, it only holds numbers 0-127. if you
need more then try smallint, int or bigint. (and please read the manual
regarding data types. It's clearly explained there.)
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PRO
Hi,
I am trying to write a query that will INSERT into a table a set of
values if they do not already exist.
It is a join table.
$colOneName = 'staff_id';
$colTwoName = 'subject_id';
$colOneValue = 2;
$colTwoValue = 3;
$sth = $dbh->prepare ("REPLACE into $sqlTable ($colOneName,
$colTwoNam
OIC.
Thanks for the clarification. I wasn't aware that MySQL (or any other SQL
for that matter) stored records in a 'physical order'. I know in M$ SQL
there is no such concept as records are constantly being reused as the
contents are deleted. (and other optimization schemes are in place) These
At 7:49 PM +0200 3/27/01, Dacian Herbei wrote:
> Hi,
> I wonder if anyone had a problem like this one.
> I have created a table with one field autoincrement. The field is
>tinyint(4).
> whenever I try to introduce more then 127 records it refuses to
>introduce them.
> I tried w
I'm going to jump in here and give a little more information.
The password() function is in fact a one way encryption. For a two way
encryption use the encode() function. But beware, any data stored with the
encode() function is only as secure as the master password you assign it.
You can do so
In the last episode (Mar 27), Dacian Herbei said:
>
> I wonder if anyone had a problem like this one. I have created a
> table with one field autoincrement. The field is tinyint(4).
> whenever I try to introduce more then 127 records it refuses to
> introduce them. I tried with ti
At 12:56 PM -0500 3/27/01, Marglobal - Pablo Salazar (Jefe de Sistemas) wrote:
>Hi Folks!!
>
>I have a question, How may set another location for my productions db,
>so, for instance if i want put my db in /mydb filesystem in my Linux
>Redhat???
>because when i create a db, this is in /var/lib/mys
3.23.35-log reports it correctly.
Cal
http://www.calevans.com
-Original Message-
From: Gordon Werner [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 12:01 PM
To: [EMAIL PROTECTED]
Subject: mySQL INSTR function problem
Hi there ...
I am running mySQL Ver. 9.33 Distrib. 3.22.
On 3/27/01 1:14 AM, "Filip Sergeys" <[EMAIL PROTECTED]> wrote:
> 3)For the last two bits(3C) I like to have the binary value
> HEX value = 3C
> Binary = 00
> Final SQL query: BIN(substring(HEX(intag), (length(HEX(intag))-1), 2))
Bin() takes an argument that is assumed to be deciaml. So bin i
On 3/27/01 10:08 AM, "Cal Evans" <[EMAIL PROTECTED]> wrote:
> yep. That's the point of a tinyint, it only holds numbers 0-127. if you
> need more then try smallint, int or bigint. (and please read the manual
> regarding data types. It's clearly explained there.)
>
> Cal
> http://www.calevans.co
When I attempt to launch mysql server with command safe_mysqld, the console
return this:
"starting mysqld daemon with databases from /var/lib/mysql"
"010327 19:33:37 mysqld ended"
I use RedHat 7.0 Linux on Intel
--
Stéphane Pinel
39, Rue du Docteur Heulin
75017
Doesn't MySQL on NT support networking? You should be able to install the
mysql client on the workstation and give it the IP address, port number and
database name on the server to connect. You don't have to install telnet.
I don't use NT, so if there really is some reason MySQL on NT won't work
> -Original Message-
> From: Rafael Martinez [mailto:[EMAIL PROTECTED]]
> Sent: martes, 27 de marzo de 2001 15:28
> To: [EMAIL PROTECTED]
> Subject: Mysql in a 4-way / 2 GByte server / raid 5
>
>
> Hello
>
> I am thinking to install our DB server in a 4-way machine with
> Intel Xeon pro
> -Original Message-
> From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
> Sent: martes, 27 de marzo de 2001 10:00
> To: Nemholt, Jesper Frank
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: How to index this properly (to make it go faster) ?
>
[clip]
> > Why that, usertime & systemtime are da
Is it the only way to get mysql to work on d: is to install on c: then move
to d: ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To r
Hi,
I entered netstat and saw among other conections
this one:
tcp4 0 0 deepthroat.3179 web.mysql.com.auth TIME_WAIT
Deepthroat is my bsd machine. it's a pure webserver.
Why is my machine making a connection to mysql.com?(and why auth)
Mys
You DO NOT need to specify table field names when INSERTing records. For
instance, if the table were defined thus:
CREATE TABLE mytable (
valueA varchar(10) NOT NULL,
valueB varchar(25),
valueC varchar(30) );
This statement will insert one record:
INSERT INTO mytable VALUES("some text",
But could i use something like a subselect ... I know they are not supported
by mysql but i see in my book that there is a substitute for it.
Also i am not to familiar with LEFT JOIN ... and all those ... can you give
me explanation ?
So really would it make what would be the real answer to my p
Go back to version 3.22. It works very well. The most current vertion
hasn't been ported yet.
Brady...
Original Message Follows
From: "Esteban Cazarez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: mySQL for Sun Intel
Date: Mon, 26 Mar 2001 18:16:00 -0800
Has anyone found t
Hi All,
Does any one know where I can find one?
Thanks.
Yours cheerfully,
Andrew bush
http://www.bushpro.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
I had the same problem.
Ensure that /var, /var/lib, and /var/lib/mysql have their permissions set
to: drwxr-xr-x
-Original Message-
From: Stephane Pinel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 12:58 PM
To: [EMAIL PROTECTED]
Subject: [NEWBIE] safe_mysqld
When I attempt
Hi Chad
You do not need a Telnet client. Just install Myodbc and the mysql client.
To connect to your server, type "mysql -h yourhostname -u userID"
If you defined a password for the userID, add -p at the end of the line. The
system will prompt you for the password. See manual for more options.
Sorry i think this is my mistake the format that i gave did not get reoected
by the mailing liste
so my structure is
provider books music
video
provider_idtitle title
title
provider_name provider_id provider_id pr
Hi Rick,
You absolutely right, you are not required to specify field names in an
Insert. But it's a good idea to do so. 1) It makes you code more readable
for those following you. 2) If your table ever changes structure, your
Insert will still work. (Assuming you didn't remove one or more of t
Esteban Cazarez wrote:
>
> Has anyone found the lastest mySQL for SUN SOLARIS 7 Intel version? I know there's a
>SPARC binary for 3.23 but what about an Intel binary?
>
I was able to compile it fine on Solaris x86 2.6.
-- Josh
_
I can get the basic compiled version installed, but when I run
scrpits/mysql_install_db I get the following error.
ld.so.1: ./bin/mysql: fatal: libcrypt_i.so.1: open failed: No such file
or directory.
I'm a neebie when it come to Solaris sysadmin.. I've done a find and can
locate a file called
li
Hi!
On Mar 27, Patric de waha wrote:
> Hi,
> I entered netstat and saw among other conections
> this one:
>
> tcp4 0 0 deepthroat.3179 web.mysql.com.auth TIME_WAIT
>
> Deepthroat is my bsd machine. it's a pure webserver.
> Why is my machine making a connectio
On Tue, Mar 27, 2001 at 01:45:16PM -0600, Brady Orand wrote:
>
>
> Go back to version 3.22. It works very well. The most current
> vertion hasn't been ported yet.
I could build a Solaris Intel 2.6 binary if needed. It'll probably
work on Solaris 7.
Lemme know if there is interest...
Jeremy
Thanks Jean - Claude,
NT Workstation comes with a built-in client. but from what I can tell, NT
Server does not come with a built-in Telnet Server. The NT book I have says
:
"The Telnet program requires TCP/IP on both the client and server, and
requires an account set up on the server being cont
On 3/27/01 12:12 PM, "Yann Larrivée" <[EMAIL PROTECTED]> wrote:
> Sorry i think this is my mistake the format that i gave did not get reoected
> by the mailing liste
>
> so my structure is
>
> provider books music
> video
> provider_idtitle
You do not need telnet to access a mysql server - mysql has it's own
client-server protocol, accessible via the means described by Jean-Claude.
regards,
P
On Tue, 27
Mar 2001, Chad Nielsen wrote:
> Thanks Jean - Claude,
>
> NT Workstation comes with a built-in client. but from what I can te
1 - 100 of 151 matches
Mail list logo
