I have installed mysql during the install of RH linux. When I try and
start the service, there is an entry in the error log stating it can't
find the host.frm file. Any ideas would be appreciated. I have copied
the host.frm file to every location under a ./mysql/ directory.
Thanks
Dane Knudso
Use the -p option to allow you to enter the password.
--zak
- Original Message -
From: "Tom Gao" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 07, 2001 12:46 AM
Subject: mysqladmin
> Hi guys
>
> I wanted to setup password for mysql access so I typed 'mysqladmin
> mypass
Hi guys
I wanted to setup password for mysql access so I typed 'mysqladmin
mypasswordhere' but now I have problems even doing mysqlshow
because it requires a password.
How do I disable the password ?
thanks
Tom
---
i use mysql 3.23.34a and using BLOB's and timestamps leads to errors (
when giving all timestamps the value "now()" only some of them return
the correct date the BLOB's don't even return anything ... )
... is this version that buggy ?
Try chmod 755 /var/lib/mysql/
Good luck!
Eduard
__
CityCom
Virtual Spaces Real Solutions
www : http://www.citycom.ro
E-mail : [EMAIL PROTECTED]
Tel./fax : +40 56 143062
__
-
I've had similiatr problems setting passwords on my redhat box.
Tried % mysql -p -u root mysql:
Got error message:
"Access denied for user root@localhost" (using password:YES)
Help, please!!!
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Sunday,
Yes, I checked that "/var/lib/mysql/mysql.sock" exists. It does. I tried
connecting with "/var/lib/mysql/mysql.sock" suffixed after "localhost." Same
error.
I tried substituting "127.0.0.1:3306." Again, no luck.
I very much appreciate all the help I've been getting on this list. Mysql
seems to b
Firstly, I'm not a Mac fan but from the list, I've read that it is possible.
Someone else may shed a light on this.
Since your not programmers, MS Access would be the easiest to use and set
up. Oracle, MS SQL server may be way too complicated without assistance.
However, Access doesn't handle a
>Description:
Compiled source on Slackware 7.2 Linux Sparc and install it. I then
ran mysql_install_db
and I get errors when installing the grant tables. It tells me that
mysqld caught signal 4.
>How-To-Repeat:
Either try and start mysqld or
I am currently investigating which software to use for a database and search
engine for a site currently under construction.
We are a mac-based design studio that has designed and constructed a 400 or
so page site, which is basically a product catalogue.
We want to include a simple search mechan
I am currently investigating which software to use for a database and search
engine for a site currently under construction.
We are a mac-based design studio that has designed and constructed a 400 or
so page site, which is basically a product catalogue.
We want to include a simple search mechan
So sprach kuttappan am Sun, May 06, 2001 at 11:20:40PM +0530:
> Is there a version of MySql for Windoze that supports BDB tables?
Don't know, but you can always compile it yourself, can't you?
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepag
Well... maybe it's off topic to some degree. There's also the PHP mailing
list, but I don't think they are quite as helpful.
Yeah, it's to do with the building of your .so file. I used mysql RPMs on
redhat system and built PHP from source. There are 2 particular options you
need to specify whe
hi list,
thanx for answering my question.
i recompiled mysql with CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS
and now it works for me.
special thx to Shankar, who declared my problem in better words than
mine
and to Paul for knowing all from mysqlDocu.
ttfn
stefan
--
st3V13h
nach diktat verreist
Yes,
If you use a Japanese OS for your server, you can set the language and
character set to Japanese. Manual will tell you how.
If you use an English OS for your server, leave the database as English and
use a front end that is capable of displaying and entering Japanese
characters. Viewing t
Hello,
I've got a problem:
My MySQL-Server gets signal 11 almost every day arround 0:00 am ... I have a
nice
mrtg - graph showing this ... ;o)
In fact every time the server crashes the statement shown in the server.log
(or a
similar one with other memID) is executed.
topsitesTEMP is a tempora
- Original Message -
From: "Gordon Stewart" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 2001 19:57
Subject: location of mysql.sock
> hi
>
> When I run the command
>
> shell> /usr/local/mysql/bin/safe_mysqld --user=mysql &
>
> it creates the file /tmp/mysql.sock
What I did was leave those fields blank and then just specify them in my VB
code. Works for me.
- Original Message -
From: "Warren van der Merwe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 2001 1:16
Subject: myODBC
> Hi there
>
> I have an ODBC connection to my d
Check to see if the socket file exists in the right place with the right
permissions.
- Original Message -
From: "Gordon Stewart" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 2001 0:08
Subject: Error 2002
> Hi
>
> I have installed Mysql from the latest tar file and
At 12:16 PM -0700 5/6/01, Simon Chan wrote:
>NEWBIE QUESTION
>Hello,
>
>Just installed mysql on a solaris2.7 sparc machine, but I don't seem
>to have permission to do
>anything! I add a user by typing
>
>useradd username
That creates a UNIX user account, not a MySQL user account. They have not
May mean that it is already running. Check with ps -ef | grep mysqld
- Original Message -
From: "Xiaowu Gai" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 05, 2001 6:07
Subject: mysql install problem
> Hi:
>
> I tried to install mysql on my machine. So I download the
- Original Message -
From: "Siomara Pantarotto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 05, 2001 4:32
Subject: Problem with a simple select
> Hi all,
>
> I am able to show all the table in a database but when I try a simple
selct
> in one of the table I get the f
The RPMS supplied by RedHat with version 7.1, work flawlessly. However,
on a redhat linux system, do an RPM install, making sure you meet all
the dependency requirements (i.e. libmysqlclient, etc). Most recent RPMs
already have a configuration to have the MySQL daemon automagically
start on boot..
I have had to install MySQL from a source distribution as the RPM
supplied with RH 7.1 doesn't work. Being new to Linux (stop laughing),
I have no idea how to get MySQL to start every time the server starts.
Anyone who has a detailed instruction sheet (I am a newbie) on how to
set-up the MySQL se
Is there a version of MySql for Windoze that supports BDB tables?
Rohit.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Sudhir" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, 03 May, 2001 9:23 PM
Subject: Re: Rolling back of a transaction
> At 5:34 PM +0800
If you wanted to do this using a SELECT you would do a LEFT JOIN or
equivalent action. Glancing over the DELETE syntax in the documentation it
does not look like DELETE supports any such mechanism. I dont think it is
possible to involve more than one table in a DELETE query.
ryan
> I have two ta
So sprach Alexander 'Digital Projects' Skwar am Sat, May 05, 2001 at 02:36:18PM +0200:
> So sprach [EMAIL PROTECTED] am Sat, May 05, 2001 at 12:30:27PM -:
> > Your message cannot be posted because it appears to be either spam or
> > simply off topic to our filter. To bypass the filter you must
Does you /var/lib/mysql/mysql.sock exist ?
If not, try connecting through TCP/IP by removing localhost and writing
"127.0.0.1:3306"
- Markus
- Original Message -
From: "Daniel Goldin (E-mail)" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 2001 9:41 P
Use
\u mysql;
to select the database
In the query:
insert into user (host, user, password) values
('localhost', 'myname' password('testpass');
you are missing a bracket after ...('testpass')
--zak
- Original Message -
From: "Simon Chan" <[EMAIL PROTECTED]>
To: "mysql Mail Li
Here's the saga.
1) I installed php, apache and mysql via redhat seven installation disks.
2) problems with mysql
3) reinstalled latest mysql from official site. (rpm wouldnt remove
distributions, so I renamed the old mysql bin files to a .bak extension
before installing new version on /usr/local
I have two tables with exactly the same structure :
CREATE TABLE
threadhardwarefr9 (numeropost bigint(20) unsigned DEFAULT '0' NOT NULL,
icone tinyint(2) unsigned DEFAULT '0' NOT NULL,
numreponse bigint(20) unsigned NOT NULL auto_increment,
contenu text NOT NULL,pseudo varchar(35) NOT NULL,
date
Hi, i have the Mysql install in 1 host. I create 2 databases for my project.
One program access a database and the other program access the second
database.
The problem is: when i start the 2 programs, the response is slow.
Are there anything form to optimize my project.
---
NEWBIE QUESTION
Hello,
Just installed mysql on a solaris2.7 sparc machine, but I don't seem to have
permission to do
anything! I add a user by typing
useradd username
BUT HOW DO I SET THE PASSWORD? Someone suggested doing this:
mysql>insert into user (host, user, password) values ('localhos
Simon Grabowski wrote:
> Hi,
>
> I have two tables: table1 and table2.
> Both tables share the same 'account_id'
> column. In table1 there is a column
> 'active' which is always either 'y' (account
> active) or 'n' (account inactive).
>
> Now here is what I want to do...
>
> I want to delete all
Hi,
I have two tables: table1 and table2.
Both tables share the same 'account_id'
column. In table1 there is a column
'active' which is always either 'y' (account
active) or 'n' (account inactive).
Now here is what I want to do...
I want to delete all entries from table2
with account_id matchin
Try
mysql_connect( "localhost:/where/your/real/socket/path/is", ...
or
mysql_connect( "127.0.0.1:3306", .
And make sure mysqld is really running.
- Markus
- Original Message -
From: "Daniel Goldin (E-mail)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 20
If anyone can tell what I'm doing wrong, I will be greatly appreciaed.
Here is the php code.
MySql Connection
And here are the error messages:
If anyone can tell what I'm doing wrong, I will be greatly appreciaed.
Here is the php code.
MySql Connection
And here are the
>I've seen this problem posted before but I can't find any replies.
>
>When I start the server I get the following
>
>./mysql.server: @HOSTNAME@: command not found
>./mysql.server: my_print_defaults: command not found
>
>Obviously I've setup something wrong.
Looks like you installed mysql.server.
if you are not getting a valid result set back,
then the sql server is returning some type of
error.
to find the error, try this:
if($select_=mysql_query($sql,$db->CONN)) {
//query is good
//continue code
} else {
//query is bad
$err=1
$errMsg="Failed Query
Have you looked at mysql_error() ? Are you sure $select_ is a valid php
variable name?
> Oi,
>
> I cannot get my head around that.
> I got a QS that worked fine, then I edited the PHP-script, not the part
> which is now causing errors, and it does not work anymore. That
> is strange,
> if there w
Hi~
I have inserted 1,000,000 record into table.
and selected 1 record using order by rand().
but, it was very very slow.
mysql> explain member ;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra
Hi.
Im occuring some proglems after the configure is done and I start the
'make' process, below is my result
Note: This is on Slackware 7.1, Piii 650, 128ram etc and so on
from 'make':
make[2]: Entering directory `/usr/src/mysql-3.23.37/libmysql'
make[2]: stat:libmysql.c: Too many levels o
Hi.
Im occuring some proglems after the configure is done and I start the
'make' process, below is my result
from 'make':
make[2]: Entering directory `/usr/src/mysql-3.23.37/libmysql'
make[2]: stat:libmysql.c: Too many levels of symbolic links
make[2]: *** No rule to make target `libmysql.c', ne
Hi,
I'm building a DBMs for distributed platforms using MySQL and CORBA. It's
completely written but I have a question 'bout the performance, does it
sound normal that I can call the next function ony 150 - 200 times a second
a PIII 700mhz with 128 mb ram??
int resolvequery(char * vraag, MYSQ
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject:table modification [ALTER TABLE DROP COLUMN name];
on large table (1.7gb) crashed mysqldnt
Description:- attempt to extract a longblob column from a large table
Hi,
if I use a query like
SELECT id FROM table WHERE id IN (7,2,100,65)
is it possible to get the results ordered in exactly the same way as the IN
list (7,2,100,65)?
Mit freundlichen Grüßen,
REDLINK Mediendienste
Jens Vonderheide, Dipl.-Inform.
Telefon: (0171) 8395997
---
Hi,
I constantly get error messages like "ERROR 1114: The table 'SQL4b3_0'
is full" for a fairly simple query.
It works if I leave the "ORDER BY" away, but I really need that. The
result only has something like 2500 Results and there is an index on the
field by which I want to sort.
What can I d
hi
When I run the command
shell> /usr/local/mysql/bin/safe_mysqld --user=mysql &
it creates the file /tmp/mysql.sock
the problem is that when i run the command
shell> mysql
it gives me this error:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.so
Dear J.T. -
Fowler, J.T. writes:
> This does not have to be fancy with lots of bells & whistles. In fact - the
> simpler the screen interface the better for the people who will be using
> this. I.E. text entry - tabular displays of valid entry values. Point and
> click would be nice but r
Oi,
I cannot get my head around that.
I got a QS that worked fine, then I edited the PHP-script, not the part
which is now causing errors, and it does not work anymore. That is strange,
if there was a mistake in my query qhy should it work on my PC but not on
the web? Well maybe different vers
50 matches
Mail list logo
