Hi,
I have a Solaris 8 Server. I have just compiled MySql 3.23.51.
My Solaris servershas 2 NIC's - 1 with the name/ip of burns, the other with
the name/ip vader
I have done a
make all;
make install;
mysql_install_db
I have then copied the mysql.serverto /etc/init.d/mysql_server
I start
Pada Sun, 28 Jul 2002 10:49:01 +0100
MySQL DBA [EMAIL PROTECTED] menulis :
./mysqladmin -u root password newpass
$ ./mysqladmin -u root password newpass
./mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
:D
Did you
This is why I am confused, this is a CLEAN mysql install.
I have only done a
make
make install
and mysql_install_db
I have not yet set a root password.
To double check this I deleted ALL /usr/local/mysql and re-did this.
Same thing again.
Matt.
-Original Message-
From: Dicky
Pada Sat, 27 Jul 2002 21:32:48 -0500
Paul Maine [EMAIL PROTECTED] menulis :
$string =1972 Ford Mustang
Using the following SQL statement:
SELECT * FROM whatevertable WHERE whatevercolumn LIKE '%$search%
I want to return all records that have Mustang AND 1972 AND Ford.
my suggestion :
Pada Sun, 28 Jul 2002 11:04:09 +0100
MySQL DBA [EMAIL PROTECTED] menulis :
./mysqladmin -u root password newpass
$ ./mysqladmin -u root password newpass
ok then, maybe you this can solve the problem
./mysqladmin -u root password newpass
--
panic(kmem_cache_init(): Offsets are wrong -
Tam,
Thursday, July 25, 2002, 7:35:20 PM, you wrote:
T Hi Victoria,
T Thanks. Does this mean in the future the -max version would be merged into
T one release or just for the 4.0.2a??
Most likely yes.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email
Rich,
Friday, July 26, 2002, 5:59:37 PM, you wrote:
RA Looks as if the MySQL DB crashed and recovered.
RA Linux 2.4.18-5smp #1 SMP
RA MySQL version 3.23.51
From the MySQL server while running mtop 26JUL02 ~6:45AM PST:
RA Unable to execute show procs [Lost connection to MySQL server during
Martin,
Friday, July 26, 2002, 11:01:20 AM, you wrote:
MP But when I do it I get:
MP ERROR 1034: sort_buffer_size is to small
Hm..
Error 1034 means:
Incorrect key file for table ...
not a sort_buffer_size is to small
How did you installed the server?
MP I compiled it from
Pekka,
Thursday, July 25, 2002, 7:13:45 PM, you wrote:
PS On my application's setup.php I have quite simple MySQL queries like
PS DROP TABLE IF EXISTS `ee_test`
PS Now, some users (perhaps 5 out of 1000) complain that they get an SQL error
PS on the first query with backquotes, and when I
Darrell,
Friday, July 26, 2002, 10:43:32 PM, you wrote:
DAS I am just getting started with MySQL and one of the first things I was
DAS trying is converting one of my larger tables to MySQL to see what kind of
DAS performance I would get from some standard queries that I run against it.
DAS I
Another clean install sorted it, there must have been a lingering file from
the make clean.
thanks,
Matt.
-Original Message-
From: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]]
Sent: 28 July 2002 11:12
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Cannot Set Root
Hi there
I'm doing fine with the command line interface of mysql, no complaints from
me. Howerver, another team member who knows nothign about mysql is more
familiar with the windows stuff like access. Is there an graphical interface
for mysql on red hat v7.3? I figured i'd ask here because
Hi there
I'm doing fine with the command line interface of mysql, no complaints from
me. Howerver, another team member who knows nothign about mysql is more
familiar with the windows stuff like access. Is there an graphical interface
for mysql on red hat v7.3? I figured i'd ask here because
Hi there
I'm doing fine with the command line interface of mysql, no complaints from
me. Howerver, another team member who knows nothign about mysql is more
familiar with the windows stuff like access. Is there an graphical interface
for mysql on red hat v7.3? I figured i'd ask here because
Hi,
I have copied the file ./support-files/mysql.server to
/etc/init.d/mysql_server.
I have edited the /etc/init.d/mysql_server to set the basedir to
/usr/local/mysql and the datadir to /usr/local/mysql/var
When I compiled mysql I set the --with-mysqld-user=mysqldba flag.
I run (as root)
Hi
Just a quick question.
I was reading the manuals on the MySQL web regarding the initial setup of
the program.
I have installed the program and all is going well and have a user called
root with full access and another user called mysql with limited rights
(used mainly for PHPmyAdmin).
Hi Eric
I dunno why people make 100 field tables, sounds a little harsh. I'll keep
you in mind the next time i wanna make a 100 field table.
Anyways, just to let you know mysql 4 will be supporting foreign key
constraints. And yes thoes other db technologies like postGrep already
support key
Ya... i'll give it a try, thanks :)
But do you know of any free graphical interfaces for linux that are not
browser based?
Thanks again (fast reply to )
desmond
From: Shashank Tripathi [EMAIL PROTECTED]
To: 'Desmond Lee' [EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: RE: graphical interface
Hi Desmond,
| But do you know of any free graphical interfaces for
| linux that are not
| browser based?
Did you try MySqlGUI from the MySql website? It runs on x-windows, so
should suffice (perhaps) although the jury is still out so to speak on
its interface
This is more of a php question. explode $string on (space) which will
give you an array. Loop through the array first with $sql.=WHERE
whatevercolumn LIKE '%$val%' then for every other entry change WHERE to
AND.
Serge.
- Original Message -
From: Paul Maine [EMAIL PROTECTED]
To:
Ray:
The only database you shouldn't mess with is the mysql database ... it is
the equivalent of the 'master' database found in other systems, and contains
all of the rights and privileges you invoke.
Get to know the 'GRANT' command in the MySQL Manual
(http://www.mysql.com/manual.php) ...
Hi
I need to retrieve records (10 at a time) for a search engine type site.
This will be quite easy using MySql V4 (SQL_CALC_FOUND_ROWS and FOUND_ROWS)
but I only have access to V3.23
Any help pleeaase
Lukas
-
Before
Dear Support,
Could you help me understand how to correct this error:
Error 1148: The used command is not allowed with this MySQL version
I have looked in the online manual under this section for help:
4.2.4 Security issues with LOAD DATA LOCAL
Unfortunately I am very new to MySQL and don't
Got this when i use make
libmysql.c
mkdir .libs
gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\
-DDATADIR=\/usr/local/mysql/var\
-DSHAREDIR=\/usr/local/mysql/share/mysql\ -DUNDEF_THREADS_HACK
-DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O3
-DDBUG_OFF -c libmysql.c -fPIC -DPIC -o
SELECT * FROM tbl WHERE this=that limit 1,10;
SELECT * FROM tbl WHERE this=that limit 11,10;
SELECT * FROM tbl WHERE this=that limit 21,10;
SELECT * FROM tbl WHERE this=that limit 31,10;
etc etc etc...
syntax: limit [start row],[# of rows to return]
To get a total first do a COUNT(*) on the
At 12:15 +0100 7/28/02, Matt Darcy wrote:
Hi,
I have copied the file ./support-files/mysql.server to
/etc/init.d/mysql_server.
I have edited the /etc/init.d/mysql_server to set the basedir to
/usr/local/mysql and the datadir to /usr/local/mysql/var
When I compiled mysql I set the
I've just tried out MyCC (also available at MySQL.com), which is
technically in alpha, but has many of the features that phpMyAdmin has. It
uses the QT widget set, so it looks nice, and I've found it to be
functional. I usually end up sticking with phpMyAdmin though. I find that
it's among the
On 26/7/02 6:07 pm, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Binary builds often break when tried with a newer version of Mac OS X
than the one they were built on. Can you try building from source?
I tried building with the following configure options:
./configure --without-server
Is there any storage / performance penalty for specifying '' or 0 as default
values, as opposed to allowing null's in the table structure?
sql, query
Thanks,
Charlie
-
Before posting, please check:
At 14:34 -0700 7/28/02, Charlie wrote:
Is there any storage / performance penalty for specifying '' or 0 as default
values, as opposed to allowing null's in the table structure?
NULL values take less storage space. (One bit per NULL value in a row,
if I remember correctly).
sql, query
hello,
i have a couple of questions about my SQL query.
1. if i want all rows in table 1 that may or may not have a counterpart
row in table 2, i use LEFT JOIN. this is HORRIBLY slow! why? if i make it
a simple join (i.e., without the words LEFT JOIN) then it is a little
faster.
2. secondly,
Hi,
I m using MySQL 4.0.2 which now supports multi-table
update query
I am getting error while throwing multi-table UPDATE
query, I don't know what the problem is
To generate an error run below query, it will create a
2 InnoDB table and inserts a dummy record in it
CREATE TABLE
Folk,
I know this is an old query, but still, problems . . .
I've tried these both, but something is amiss - probably my interpretation.
Every time I try to use LAST_INSERT_ID() I get a complaint that the query has a
problem.
E.G., $qry=$qry.;select LAST_INSERT_ID(); will blow up on me every
Hi,
Where should I change the autocommit setting to 0 (i.e no Autocommit). I'm
inserting row from perl script using DBI. I would like to bring up mySQL
server with autocommit false, so that I can explicitly commit from the front
end. But with lot of research in various docs I could not find
**
Un Abrazo sincero de parte!! Manny Castro Muñiz.
Director Hispa 21.
Escribeme a [EMAIL PROTECTED]
Visitame en: http://www.hispa21.com/sub/personal.asp?id=1310001
Si deseas contactarme via telefonica pudes hacerlo a este
So, one of my associates has made a linking table (some people also call it
intersection table, cross tab table, but i believe that the propper way to
model a many to many relationship is via a linking table). in the linking
table, there is no primary key defined.
Let us suppose you wish to
36 matches
Mail list logo