Hi,
How do I set the root password after installing MySQL server and client?
I followed the after installation instructions,@they don'T work.
mysqladmin -p password 'new-password' I don't get it.
Thx for helping
JP
__
Do You Yahoo!?
Get
On Thu, May 31, 2001 at 09:18:48PM +0200, Warren van der Merwe wrote:
Hi there
I have three sites, each runnin MYSQL. I want to replicate the data
between all three. I know I cannot do this with the standard
replication in MYSQL, because all three sites will add their own
records and the
On Thu, May 31, 2001 at 11:25:08PM -0500, Duane Stark wrote:
Hello all!
I have two servers (both running mysql and freebsd) .. I also have
data replication setup on them.. My question to you is this.. Both
servers are phyiscally located in different locations.. a) When the
data is
They do work. Just need to follow instruction a little more closely, though
I will agree with, the instructions do trip up many beginners. Remove
the -p switch. It is only used if you have already set a password but since
you haven't ...
Also quotes around new-password aren't required.
-
Thanks,
Will try that out.
Adrian
On Thu, 31 May 2001, g_gosho wrote:
You can try this link: http://www.bonev.com/s
there is PHP session handling librarary and documentation how to use it
- Original Message -
From: Adrian D'Costa [EMAIL PROTECTED]
To: php general list
Hi,
Thx Rolf for your help I did setup the password
Now, I have installed the RPM called mysql-DBI-perl-bin...rpm
But when I want to install the MySQL-bench...rpm it asks me for the MySQL-DBI-perl..rpm
Can someone tell me how to solve this probem?
thx
JP
Hello,
I have a following problem:
I created two simple tables and a query that uses both of
them. This works perfectly. See the example below.
The question is: is the same query possible when the two
tables are located in diffrent databases.
What I mean: Is it possible to write a
i have no idea on how to run mysqlhotcopy in the query tool
or it is not suppose to run in query
tool.
is this correct ?
mysqlhotcopy db_name
'/downloads/backupDB/'
if i want it to backup in my c:\downloads\backupDB
folder ??
Hello,
I am working on RH Linux 7.0
MySql is not working at all.
My MySql files are under /usr/bin.
It gives the following error on running any mysql command
Can't connect to localMySql server through socket 'var/lib/mysql/mysql.sock'(111)
Please Help me.
Thank You
Sachin
JZ On Fri, Jun 01, 2001 at 01:45:24AM -0400, David Freeman wrote:
The server is a quad xeon lh4, it will host a web site written in
php, and using a mysql database which holds 125,000 squ's and
descriptions. The server's only job is to host this site.
JZ Assuming you'll use Apache 2.x one
What OS?
Where do you enter the commands to install mySQL?? I know it's a stupid question,
but please, enlighten me.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello everybody,
I am learning sql but i am not new to programming.
I have a small problem, any help on this will be great. :)
I have table name category,..with the following details
SQL desc category;
NameNull?Type
---
database,sql,query
Hi!
I really need to know this: I have a column defined as char(2), default
'no', not null.
When I create new entry into the table, I skip entering value into mentioned
column
because I expect to be filled with the default value, that is 'no'. But that
doesn't happen!
Why?
On Fri, 1 Jun 2001 11:38:05 +0200
Toth Dalibor [EMAIL PROTECTED] wrote:
database,sql,query
Hi!
I really need to know this: I have a column defined as char(2), default
'no', not null.
When I create new entry into the table, I skip entering value into mentioned
column
because I expect to
Hello to all!
I'm useing MySql 3.23.33 for unknown-freebsdelf4.2
when i trt to select anything from command line
mysql select * from base.table where name like '%%';
i resieve many unuseful results (all DB)
it happends with diferent words
it does not matter in what kind of encoding i do this
We want to Configure MySQL database to JRUN as a jdbc datasource (Native).
If Anybody knows ,Please give reply.
_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com
After reading the manual and doing vaious searchs around
the net, I'm damned if I can work out the syntax for
mysql_info().
Could anyone give me an example please?
feelin' a bit dumb
Howard Picken
(Server, SQL, Query... etc)
[EMAIL PROTECTED]
On Fri, Jun 01, 2001 at 09:26:08PM +1000, Howard Picken wrote:
After reading the manual and doing vaious searchs around
the net, I'm damned if I can work out the syntax for
mysql_info().
Could anyone give me an example please?
In what programming language?
Greetz, Peter.
Using PHP4 and Mysql
After reading the manual and doing vaious searchs around
the net, I'm damned if I can work out the syntax for
mysql_info().
Could anyone give me an example please?
feelin' a bit dumb
Howard Picken
(Server, SQL, Query... etc)
[EMAIL PROTECTED]
Sorry,
the website is now at www.innodb.com
It should redirect users from www.innobase.fi, but that does not
seem to work now.
Thank you for the notice.
Heikki
Innobase Oy
At 04:44 PM 5/31/01 -0700, you wrote:
On Tue, May 22, 2001 at 07:26:40PM +0300, Heikki Tuuri wrote:
Hi!
I wrote a
Roberto de Martin Serqueira writes:
Hi
I'm forwarding you the attached file MYSQL_3.23.38_FIXES.ZIP which contains files
with some minor improvements
and fixes done by me, updated to MySQL version 3.23.38, and presenting the following:
- Directory \LIBMYSQL:
- file ERRMSG.C:
Joseph Bueno writes:
Hi,
[EMAIL PROTECTED] wrote:
I know this is bound to be something REALLY simple, but I can't seem to get
safe_mysqld to run in background (Solaris 7/MySQL 3.23.37)
If I try, as the root user, to start safe_mysqld from the /usr/local/mysql
directory thus...
D. Veerasamy writes:
Dear Sir/ Madam
Can you please help me with the GUI client running under linux.
I'm having an error message saying:
Can't connect to local MySQL server through socket (111)
Thanking you.
-
Hi,
I donot think it is supposed to show the number of
rows deleted or it should not show anything at all.I
agree if it is not a bug,at least it is an unwanted
thing .
When it always shows the affected number of rows as
zero though it actually deletes a million records,it
must be removed or made
Hi guys,
Are we talking about Symantec's ACT product?
Cheers,
Mikel
Rolf Hopkins wrote:
I've never heard of ACT2 but if you can export the data to a delimited text
file, you could import it into mysql. You may have to edit the file a bit
though.
- Original Message -
From:
Hi.
I'm using the C API to access mySQL database (trying to reuse a lot of
existing
software, mixing an old database mySQL, but it's not the point).
Due the way the old database (named Ideafix) run the keys sometimes the
translated
query produce too many rows (running out ot memory) although
Tried that.
mysql ALTER TABLE Craft type=MYISAM;
ERROR 1016: Can't open file: 'Craft.ISD'. (errno: 138)
I have tried to run the mysql_convert_table_format script but I can't find
any examples and I cannot get it to work either. I'm quite sure it's
operator error in this case.
We have
Hello mysql,
Today I played a little bit with two different ways of backup -
first one is to use BACKUP TABLE (which works for myisam only) and
the second one is SAVE DATA/LOAD DATA.
In both cases if I'm not mistaken the file is wrote by mysqld server
so there is no communication
hello all:
how can i run multiple instances of mysql server? i also looked
at mysqld_multi but i guess there is a problem with that too.
here is the error what it gave:
ABORT: Bad GNR: mysql2 See mysqld_multi --help
i also defined GNR in /etc/my.cnf
Any idea why the error?
...Rohit
Hi!
Redirection from www.innobase.fi to www.innodb.com now works from
my own computer. Please report to me if it does not work from your
computer.
The official InnoDB website is now www.innodb.com
My email address still stays the same [EMAIL PROTECTED],
but also that will probably change to
does anyone setting up mysql with quotas?? i need it for hosting.
--
%whois -R NULL-RIPN
PGP: http://null.magelan.ru/null.asc
Pager: +7 095 974-0003, #30369
-
Before posting, please check:
Hi!
At 05:44 PM 6/1/01 +0400, you wrote:
Hello mysql,
Today I played a little bit with two different ways of backup -
first one is to use BACKUP TABLE (which works for myisam only) and
the second one is SAVE DATA/LOAD DATA.
In both cases if I'm not mistaken the file is wrote by mysqld
As soon as the new month rolled over, it happened again.
The problem went away sometime in mid-May. The only difference between
the current problems and the old is that we're now running 3.23.38.
Any ideas?
Chris
--
At 7:19 PM +0530 6/1/01, Rohit Peyyeti wrote:
hello all:
how can i run multiple instances of mysql server? i also looked
at mysqld_multi but i guess there is a problem with that too.
here is the error what it gave:
ABORT: Bad GNR: mysql2 See mysqld_multi --help
i also defined GNR in
Hello, mysql:
Can anyone say if exist some function in the C API that do not store
all the requested rows before returning but it returns inmediatly for
each one and the storing be in the remote server.
Thanks a lot !
[EMAIL PROTECTED]
Hi Jeff
Can you give us a bit more step by step info
Then we will pont you the right way..
Simon
-Original Message-
From: Jeff Davidson [mailto:[EMAIL PROTECTED]]
Sent: 01 June 2001 18:13
To: [EMAIL PROTECTED]
Subject: what's the problem
We have installed the mySQL binary onto
On Fri, Jun 01, 2001 at 12:12:47PM -0500, Jeff Davidson wrote:
We have installed the mySQL binary onto Windows 2000 from a CD. (We
think we installed it) What next?? We've messed around with dos
commands with no luck. We are obviously missing something vital???
You are clearly missing
What you are asking to do is not built into MySQL :(
Mysql matintains its own internal database locking that would not
be shared amongs the other computers, if you have multiple machines
reading a writing to the same database file you will corrupt it
in short order.
Your best bet in such an
Hi
Have you installed the service in the CSM (console service manager) yet ?
Go to the command prompt and type [mysql_dir]\bin\mysqld-nt --install
(mysqld-max-nt for MySQL MAX).
Afterwards start the service by either going to the CSM and starting it or
by typing net start mysql from the
On Fri, 1 Jun 2001, Toth Dalibor wrote:
I really need to know this: I have a column defined as char(2), default
'no', not null.
When I create new entry into the table, I skip entering value into mentioned
column
because I expect to be filled with the default value, that is 'no'. But
Kenneth Kopelson wrote:
So, how do we get support in MySQL so that multiple instances of the mysqld
daemon running on separate machines can all access the same database files
located on a central server? I can see how the file system of the central
database server could be exported through
On Fri, Jun 01, 2001 at 09:13:45AM -0400, Beverly Baird wrote:
Tried that.
mysql ALTER TABLE Craft type=MYISAM;
ERROR 1016: Can't open file: 'Craft.ISD'. (errno: 138)
I have tried to run the mysql_convert_table_format script but I
can't find any examples and I cannot get it to work
Hello all,
I'm running MySQL on SuSE Linux 7.0.
I've been unable to connect to MySQL from a client on a remote system (both
systems behind the firewall) using a username/pw set up locally using the
GRANT ALL ON *.* TO user@% identified by password command.
I know this is a big security hole to
On Fri, Jun 01, 2001 at 03:35:57PM +0800, Alice wrote:
i have no idea on how to run mysqlhotcopy in the query tool or it is
not suppose to run in query tool. is this correct ? mysqlhotcopy
db_name '/downloads/backupDB/'
It's a stand-alone tool. If you run it without any command-line
Friday June 01 2001 12:12, Jeff Davidson wrote to All:
JD We have installed the mySQL binary onto Windows 2000 from a CD.
JD (We
JD think we installed it) What next?? We've messed around with
JD dos
JD commands with no luck. We are obviously missing something vital???
JD What is
I know that when it comes to deleting users from the user table, I could
revoke all privileges and use an SQL 'delete from' command, but I wonder
if there's an easier script/method for dropping a user? I've been combing
the manual for a couple days and while I can create users and grant/revoke
At 12:12 PM -0500 6/1/01, Jeff Davidson wrote:
We have installed the mySQL binary onto Windows 2000 from a CD. (We
think we installed it) What next?? We've messed around with dos
commands with no luck. We are obviously missing something vital???
What is it??? Help!!!
Thanks
If you're
Thank you Steve, I appreciate your response :) I have considered modifying
MySQL to do what I have asked for, but I didn't want to do that until I
verified it wasn't already available somewhere. I'll bet this feature is
something that others would be interested in as well.
On the note of
i want to import a series of text files into a MySQL database..
can anyone point in the direction of good documenation on this?..
thanks in advance..
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hi,
I've developed a simple search engine for a site I'm working on. Its
purpose is to display community events based on the users input criteria.
The problem is, if I use the DATE_FORMAT command to alter the appearance of
the events dates and times - then MySQL begins at the top of the list
Hi,
I was wondering if someone knew of a way to keep stats of records that
were being used from a Table in a DB.. i.e. I have a table with URL's in
them and when a search is done, it returns a certain number of records..
I want to know, which exact record the user click's on and uses, not the
On Fri, Jun 01, 2001 at 03:08:53PM -0400, Longo, Joseph wrote:
i want to import a series of text files into a MySQL database.. can
anyone point in the direction of good documenation on this?..
Search for LOAD DATA in the manual:
http://www.mysql.com/doc/
Jeremy
--
Jeremy D. Zawodny,
I think your doing FAR more work than you need to. I'm also not getting
what you mean by it not paying attention to the initial query.
I suggest you combine those 3 queries into one, just like this:
SELECT somefield1, somefield2, DATE_FORMAT(EventStartDate, '%W %M %D %Y') AS
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
On Wed, May 30, 2001 at 11:32:16PM -0400, Michael Villalba wrote:
I have a rather large MyISAM table (~230 million rows) running under
MySQL 3.23.30. It has 10 columns and 3 indices. The data and index
files each
Hi there,
I have five tables in the database: customers, orders, ordercontents, products and
payments. The problem is that I should get a list which shows some kind of a ledger
list (shows who has paid and so on).
My first try looks like this:
SELECT orders.OrderID, customers.Name,
- Original Message -
From: Glenn Emery
To: [EMAIL PROTECTED]
Sent: Friday, June 01, 2001 3:46 PM
Subject: Newbie Needs Help
Hi All,
I am not sure this is the correct list for this but here goes...If not
the correct list any idea where I might find some help?
I have a site that is
Thanks for your detailed and comprehensive response, Steve.
I should have mentioned that the RAID 5 array is provided by an A1000
RAID unit. It is configured to have one logical unit.
Both the MySQL data and temporary directories are on the A1000.
All 12 drives in the A1000 are 18 GB Seagates
On 01 Jun 2001 00:30:20 -0400, David Freeman wrote:
My question is, what is the best OS for a heavy usage, multi-processor
mysql database driven web site. We could use almost anything, but we
would prefer to use a free OS such as freebsd or Linux based OS.
Some people reported better
On Fri, Jun 01, 2001 at 12:28:17PM +0400, Ilya Martynov wrote:
JZ On Fri, Jun 01, 2001 at 01:45:24AM -0400, David Freeman wrote:
JZ Assuming you'll use Apache 2.x one day, I'd lean away from FreeBSD
JZ until the threading issues are resolved. I could envision you running
JZ 1 threaded
On Fri, Jun 01, 2001 at 03:50:30PM -0700, Florin Andrei wrote:
On 01 Jun 2001 00:30:20 -0400, David Freeman wrote:
My question is, what is the best OS for a heavy usage,
multi-processor mysql database driven web site. We could use
almost anything, but we would prefer to use a free OS
My mysql server is English but I have a chinese/english front end and users
type in both Chinese English.
- Original Message -
From: md [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 01, 2001 21:22
Subject: Unicode
Does anybody use mysql with Chinese or other Unicode
hello everyone... I am very new to mysql and I needed some help creating 1
admin account for 4 computers.
This is the error I keep getting.
mysql grant all on *.* to admin@% identified by password;
ERROR 1064: You have an error in your SQL syntax near '% identified by
password'
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 9:54 PM
To: [EMAIL PROTECTED]
Subject: ezmlm response
Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTECTED] mailing list.
This is a generic help message. The message I
At 10:13 PM -0400 6/1/01, daddius wrote:
hello everyone... I am very new to mysql and I needed some help creating 1
admin account for 4 computers.
This is the error I keep getting.
mysql grant all on *.* to admin@% identified by password;
ERROR 1064: You have an error in your SQL
At 2:17 PM -0400 6/1/01, Peter H. Burris wrote:
I know that when it comes to deleting users from the user table, I could
revoke all privileges and use an SQL 'delete from' command, but I wonder
if there's an easier script/method for dropping a user? I've been combing
the manual for a couple days
Hello:
This is how i defined in conf file:
[mysqld_multi]
mysqld=/usr/bin/safe_mysqld
mysqladmin=/usr/bin/mysqladmin
user=multi_admin
password=multipass
[mysqld2]
socket=/var/lib/mysql/mysql.sock2
port=3308
pid-file=/var/run/mysqld/mysqld.pid2
datadir=/var/lib/mysql2
66 matches
Mail list logo