Re: Root password forgotten in MySQL

2001-04-12 Thread B. van Ouwerkerk


Now I want to create new database for same but i forgot my root mysql 
password.

Take a look at the manual. It's there, so USE it.

You can also find the answer in this lists archive.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Berkeley DB and Slackware

2001-04-11 Thread B. van Ouwerkerk


  Did anybody succeed in compiling MySQL and Berkeley DB on a Slackware
7.x system and not get a SIGSEGV?

  Please let me know how you did it.

Yeah.. sure.. just tried it with 3.23.36.. Slackware 7.1.0 wanted to 
upgrade from 3.23.34a anyway.. installed from tarball.

How:
./configure --prefix=/usr/local/mysql --with-innobase
make
make install

Between make and make install I first killed the running mysqld..

MySQL runs as user mysql and the directory ownership is set as per 
Docs/manual.txt

Runs like a dream.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Please HELP ME!!!!!!!!!!!!!!!!!!!!!!!!!!!

2001-04-11 Thread B. van Ouwerkerk


[root@sp mysql]# chown -R root /usr/local/mysql -- The problem
chown: /usr/local/mysql: No such file or directory

Where is mysql installed this messages says it's not in /usr/local/mysql

Search your system.. and chown the equivalent of the /usr/local/mysql

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: MySQLmanager

2001-04-11 Thread B. van Ouwerkerk


I was trying to connect MySQL server through MySQLmanager. It is 
successfully connected to
server. But when trying to expend database
by double clicking on it, it is giving
error message :-

Error : Selecting database mysql.. )access denied for user [EMAIL PROTECTED] 
to database 'mysql'

 From where it takes ip address 61.0.81.14 (it is my local ip address) as 
 I am using
another host name to connect remote datbase.

Read the manual. Take a look at the grant statement.
Also, if you want to do things with the mysql database you must be root 
user.. mysql root user that is..

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: [MySQL] User name/password

2001-04-10 Thread B. van Ouwerkerk


The username used if not specified in the mysql command, is your *nix
username, so for instance, if I'm logged in as benji and type:

mysql -p
passwd prompt **

The mysql username is also benji.

I would NOT consider it a good idea to use the same username for a shell 
account and a mysql account..

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Q U E R Y

2001-04-10 Thread B. van Ouwerkerk

Suppose you buy a book and learn how to do it.. rather than asking others 
to solve your problem.

You've got MySQL and PHP.. so you should be able to do it..

Bye,


B.


I am using MySQL in RedHat 6.2 with PHP 4.0. I have a question on MySQL. 
Suppose I have two tables A and B in my database:
Table A
Name   Score
a45
b20
c75
d55

Table B
NameScore
a20
b9
c25

Now I need to subtract values of table B from table A and result should be
like:
Table C
NameScore
a25
b11
c50
d55

How can I do this?

Looking forward to hearing from you.

Warm Regards,
Deependra B. Tandukar


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: MySQL Server

2001-04-09 Thread B. van Ouwerkerk


I am new to MySQL.
I have Linux server through my hosting company.
I want to install MySQL on server.
I need your help in this regard how I can install the same on my remote 
server?

Read:
- this lists archive before sending questions
- www.devshed.com
- many many other websites.. you can find most of them via searchengines..

You need to study a LOT..

Bye,

B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: messed up app files

2001-04-09 Thread B. van Ouwerkerk


ISM file.  I opened them with notepad.  Now my scripts will not 
execute.  The ISD file says that it was modified today.  All 3 icons have 
changed to the notepad icon,  although this is not necessarily the most 
unbearable part of the whole thing.  Are they lost forever?   Can they be 
made to work again? Please help.

Aaah, yes.. Windooz.. Go to explorer and find the screen where you can 
associate files with apps. Somewhere next to edit.. then you can remove the 
association for these files..

I don't think this has damaged your tables.. as long as you didn't write 
back.. Otherwise you might want to try if you can repair them..
I'm not sure if M$ will put the last opened date or last edited date on the 
file..

But, since you did make a backup every day it's not that much of a 
problem.. is it..

Bye,



B.

To satisfy the new spam filter:
You may query our database and buy products.. like books on sql.
Not that we sell any.. but is does satisfy the filter :-)


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: [MySQL] Backup error

2001-04-09 Thread B. van Ouwerkerk


Fortunately, these were only test databases so there won't be much 
loss.  My question is in the future, is there a recommended way of backing 
up the databases that will not cause any errors?

I'm using mysqldump to create backups.. but that's on linux, I'm not sure 
about windooz version. Probably the same..

Bye,


B.

To satisfy the new spam filter:
You may query our database and buy products.. like books on sql.
Not that we sell any.. but is does satisfy the filter :-)


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: ./configure help

2001-04-07 Thread B. van Ouwerkerk

At 17:25 7-4-01 +0200, com2 wrote:
hi everybody we get this err mex when we run:
./configure --prefix=7usr/local/mysql

Hrrr, 7usr/local/mysql ? dunno if that's the reason.. but it 
might not be able to find such path.

/usr/local/mysql perhaps??

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: HELP me!

2001-04-06 Thread B. van Ouwerkerk


please : give me the solution!

Just a few thoughts.. you connect via PHP.. your php.ini is not pointing to 
the right location mysql.sock would normally live in /tmp Normally.. 
other location could be..

Do a ps -ax and see if mysqld shows up.. If not, it's not running at all.. 
otherwise it is..

Take some time and investigate.. search for mysql.sock
find -name mysql.sock would do nicely.

How did you install.. which OS.. RPM??

Bye,

B.



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: newbie problem... (error 2002)

2001-04-06 Thread B. van Ouwerkerk


when i try to run phpmyadmin i got an error message and the log from mysql
says:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)

AAARG if you would have taken the time to check the archive you would 
have know it has to do with the location where PHP thinks mysql.sock is. 
Normally it would live in /tmp
Change your php.ini to match this.

2th option: mysqld isn't running. To find out: ps -ax If it's not running 
start it.. check the manual for more info.

If you can't find it in the MYSQL lists archive, check the archives at 
www.php.net this has been answered at least 75 times..

Even a newbie can check the archive :-)

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: A Beginner's Query

2001-04-05 Thread B. van Ouwerkerk


query processed . But how to view the structure of the table. I mean I am 
not able to do anything  even after mysql prompt appears. I have the 
documentation. Can Anyone guide me on this

I could write it all, I'm sure many on this list can. It's pretty useless 
though..

Checkout the manual at www.mysql.com if you did move over to 
www.devshed.com and go to the MySQL section.. Follow some links from the 
MySQL manual on www.mysql.com

Next, go to a bookstore and buy the book MySQL from Paul DuBois.. this 
should help you..

Please, before posting: checkout the archive.. many many many questions are 
found there, with answers.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: huidziekte

2001-04-05 Thread B. van Ouwerkerk


Vijf jaar voordat deze foto's werden genomen werd bij mij diagnose
reumatische artritis gesteld en als zodanig ook behandeld. Niets hielp.
Toen de ziekte zich zo manifesteerde zoals u hieronder kunt zien..

THis message is send in Dutch, my native language. I'm not going to 
translate this for you guys.. it's about an illness, has absolutely nothing 
to do with MySQL.

I'll reply to the sender to tell her about this list, target.. and hope she 
stops.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: query problem with MySQL

2001-04-05 Thread B. van Ouwerkerk


one.in case if he selects multiple fields, how could i
provide my user with all set of records which contains
what all data he placed in query form.

I think you want to study a bit more on MySQL and PHP. If you take the time 
to go to sites like www.devshed.com you might get an idea of how MySQL 
works. If you feel you need to study more (and I think you do), buy a good 
book like MySQL written by Paul DuBois.

After all this reading you know what you're up against, and you'll get an 
idea about how you can do what you want.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Firewall logged probes on mysql port

2001-04-05 Thread B. van Ouwerkerk

It's late.. I want to catch some sleep.. but I found a few on the incidents 
list..

http://www.securityfocus.com/bid/926
http://www.securityfocus.com/bid/975


According to some people on the incidents lists there seems to be one or 
two probes going on for MySQL servers.. dunno what they're looking for.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Storing pictures in mySQL

2001-04-04 Thread B. van Ouwerkerk

At 08:55 4-4-01 +0200, Nicolas Villatte wrote:
is it possible? If yes, how ?

Yes.. BLOB (BinaryLargeOBject) Check the archive, and manual.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Running mysqld as another user

2001-04-04 Thread B. van Ouwerkerk


We are getting problems in running mysql after installation.
Since you have already running mysql we seek your advise on the
following.

Do you already have a mysqld running (ps -ax).

Also please guide how users are created and groups are set to user
mysql.

Read the manual and/or buy the book MySQL written by Paul DuBois.

I remember several posting about MySQL on RH 7 and RPM's being no good. The 
advice was to compile from source.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: PLEASE HELP ME TO START

2001-04-04 Thread B. van Ouwerkerk

At 10:41 4-4-01 +0200, hanan khader wrote:
Hi friends ...
I have sent once my problem, but don't know why, I haven't recieved any 
answer or solution for it ...

Perhaps because you try to run MySQL on Windows.. I think most people on 
this list are familiar with MySQL on Linux.

I found a link in the manual:
http://www.analysisandsolutions.com/code/mybasic.htm This is supposed to be 
a beginners MySQL tutorial for setting up MySQL on Windooz.

Many many links can be found if you use your favorit searchengine.

Bye,


B.



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Can't connect to MYSQL Server

2001-04-04 Thread B. van Ouwerkerk


When I type mysql from the command prompt ... an error occured :
  ERROR 2003: Can't connect to MYSQL server on 'localhost' (10061)
What is the problem?
Hanan

Don't send me a copy of your message.. I'll get mine from the list..

Did you follow all instructions as found in the manual and from the link 
found a my previous message??

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: BSDI 4.1

2001-04-04 Thread B. van Ouwerkerk


I am just a user on the system, so NOT root. The system is from our ISP
and webhoster (named xs4all). They say that I have to setup and install
it my self.

Someone out there ? That knows?

Try to install to another location, like your userdir.

If that's not working find yourself another hoster.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Provider claims 'it's normal that mysql crashes', is that true?

2001-04-04 Thread B. van Ouwerkerk


After further asking I got a personal answer that says:
"it's normal the mysql-servers die because of heavy load".
"We can't help that the mysql task keeps crashing if to many users access it.
That's totally normal for a mysql database"

Running 3.22.32 that's prehistoric (sort of).. I think I even remember some 
problems with 3.22.32 .. not sure though..

Our own mysqlservers have an average downtime of 1 hour (maybe 2 hours) per 
year, per server!! mostly because of maintenance.

To many users accessing their MySQL server.. can be.. but then you increase 
the amount of servers you've got. An average of 71000 users per server 
might be a little to must.. even if only 10 percent would use MySQL 
sound still as to many users.

Time to find yourself another ISP.. if they can't be convinced in spending 
a few DM extra that is..

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: TheCasino.com: Registration Confirmation

2001-04-04 Thread B. van Ouwerkerk

At 10:19 4-4-01 -0600, Nathan wrote:
I sincerely hope this is the result of a virus.

Dunno, one of the PHP lists is also being harrased by this kind of 
messages.. Perhaps Billy boy G. has to much time to spend ;-)
Or it might be a programm in a nasty loop.

The PHP list admin has blocked all traffic from these guys.. Perhaps the 
MySQL listadmin can do the same..

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Database Design

2001-04-04 Thread B. van Ouwerkerk

At 16:25 4-4-01 +, Jonathan Duncan wrote:
Does anyone know of a good site or reference on database design?  That would
be efficient database design.  I can make a database but I want to know how
to plan one and make it very good.  Any ideas?  Thanks in advance.

www.devshed.com (database normalization and other articles)

the book MySQL written by Paul DuBois

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Perl-MySql DBD Errors

2001-04-04 Thread B. van Ouwerkerk


Msql-Mysql-modules-1.2215.tar.  For the life of me I can't find the
mysql.h file that it keeps asking for?  Any ideas where this is...is it
a bug with this version.

Type find -name mysql.h
I found mine (MySQL 3.23.36) in /usr/local/mysql/include

Sometimes it helps to use a very basic method to search your system.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: ownership/permission problems

2001-04-03 Thread B. van Ouwerkerk


I haven't had any success so far finding any help in the manual or Monty's 
book about this particular condition, so any help is appreciated.

I don't know about the RPM's. But if you would install from source there is 
a directory called Docs containing a manual.txt I did NOT compare this with 
the online manual but this one states clearly how to start MySQL as another 
user.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Starting Mysql with system

2001-04-02 Thread B. van Ouwerkerk


How can i put mysql to start with my system, im worcking with RedHat Linux

RTFM: go to your sourcedir, cd Docs and read manual.txt.. or one of the 
other manuals.. like the one at www.mysql.com

Bye,


B.



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Running mysqld as another user

2001-04-02 Thread B. van Ouwerkerk


I have set up a user called mysqlusr which belongs to the group 
mysqlgrp.  I want to run the mysqld as this user, but am unsure how to.

Info on this can be found in the manual.txt file found in your_sourcedir/Docs

Bye,



B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: MySQL 3.23.36 is relased

2001-04-02 Thread B. van Ouwerkerk


Everyone: why did the volume of the source distribution jump from
something like 5+ MB to 10+ MB ? This is not likely from a bugfix. Am I
downloading lots of new stuff I will probably not use?

http://www.mysql.com/downloads/mysql-3.23.html says:
MySQL 3.23.34a and newer source releases include the full source for
Berkeley DB and Innobase tables; By using these table handler you can use
transactions in MySQL.

That might explain something. Dunno if you're going to use it.. perhaps 
sometime.. somewhere..

Bye,

B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: unable to get access

2001-04-02 Thread B. van Ouwerkerk


   I cant get access into mysql.  I get access denied for user when
trying to log into mysql as root with password. Anyone help?

You did go through the complete installation?? Including the create_db 
stuff and the root password setting stuff..

If not, read the manual.. it will help you to get things going.

If this is an older install which ran fine, you might want to check the 
manual on removing the root password..

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Newbie question

2001-04-02 Thread B. van Ouwerkerk


I've installed mysql 3.22.32 and created a test table via mysql. now, when 
I try to run

safe_mysqld --log 

Do you run this while you already could connect via mysql?? if so, then 
your server was already running.. No need to start it twice..

Also, checkout www.devshed.com and the fine MySQL manual at www.mysql.com 
or in your sourcedir/Docs. Please do yourself and us a favor, read those..

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: how to make SQL command by a file?

2001-03-30 Thread B. van Ouwerkerk


command in mysql:
How can I do?
how can I write it?

Create a .sql file.. check the archive, same question has been asked 1 or 
two days ago. Otherwise read info on websites about MySQL and other SQL 
languages

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: web-based accounting system

2001-03-28 Thread B. van Ouwerkerk


  I hope someone could tell me where to find one.



Off-topic, take a look at www.php.net for php scripts. Otherwise checkout 
www.cgi-resources.com

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




RE: MySQL books

2001-03-28 Thread B. van Ouwerkerk


I was at the store tonight. Did not see an O'Reilly book but believe I saw
the book by Paul DuBois. There was also a book, one of the Teach Yourself
(MySQL) in 21 Days, series.

Anybody familiar with that one?

I would go for Paul's book (he should pay me for everytime I refer to his 
book :)) If you're starting with MySQL his book is great, explains how to 
connect with MySQL from C, Perl and PHP.
Wouldn't miss the O'Reilly book though.

I'm not familiar with the Teach Yourself MySQL book. Paul's book took me 2 
days..

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: SQL Documentation

2001-03-22 Thread B. van Ouwerkerk


trying to make a simple database for our alumni organization. hope to hear
soon!
Thanks,
Moin

First there is a very good doc on www.mysql.com and you can find info on 
www.devshed.com but also on many other websites. Use your favorite 
searchengine!
You might want to buy a good book. I'm using "MySQL  mSQL from O'Reilly" 
and "MySQL from New Riders (written by Paul DuBois)".
If you need a step by step guide I can recommend the book written by Paul 
DuBois. www.devshed.com will provide you with an online step-by-step guide.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Please

2001-03-21 Thread B. van Ouwerkerk


  Fatal error: Call to unsupported or undefined function mysql_pconnect() 
 in ./db_mysql.php on line 73

Wrong list. Help can be found via several lists: http://www.php.net
Before posting you really should read the manual, also found at php.net

Or try at least a few examples from:
www.phpbuilder.com
www.devshed.com
www.phpbeginner.com

That should get you up and running..

Bye,


B.



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Password option

2001-03-21 Thread B. van Ouwerkerk


password to MySQL and I cannot into it of course. Does anybody know how to
reset or disable this feature if you have root access to the machine?

Read the manual you can find at http://www.mysql.com

This is explained into great detail.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Redhat 7 newbie.....

2001-02-25 Thread B. van Ouwerkerk


when i try to use the client.  Could someone please clue me in as to home 
I get this baby going...

Thanks!

Tom

RTFM (Read The Fine Manual) :-) you can find it at www.mysql.com

Search the archive: http://lists.mysql.com

Checkout www.devshed.com

Bye,

B.



-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Problem installing MySQL php

2001-02-22 Thread B. van Ouwerkerk

At 19:25 22-2-01 +, Pope, Alan wrote:
Hi all,

Newbie alert, please be gentle.

Great resource: www.devshed.com including how to install MySQL and PHP with 
Apache.

You might want to apply all the patches from Redhat. RH 7.0 is not 
considered to be a good distro. NOT my opinion, others say so. /Me is using 
Slackware. I know quite a few people who 'upgraded' RH 7 to 6.x and could 
install without much of a problem.

I think a few other solutions can be found in the archive.

Bye,

B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Here you have, ;o)

2001-02-13 Thread B. van Ouwerkerk

 I had forgotton how much in love with it I once was, until Outlook
refused to behave as the help files said it would, and the help files
describe capabilities that were simply not available. I have moved to
Outlook, because I needed to access several email accounts, and the
older versions of Pegasus only handled one. I think you will find
Pegasus to be a superbly crafted program, by comparison.

Eudora handles at least as many mailboxes as OL.

By the way. Silly me has associated .vbs and .js with notepad.exe works 
great. I suggest anyone who hasn't got a really good reason for using .vbs 
and .js to do the same.

Bye,


B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Please give me a good FQ about mysql install.

2001-02-08 Thread B. van Ouwerkerk


I had some problem when I install MySQL.

 Could you kindly give me a good FQ about mysql install?

 Thank you.

www.devshed.com has some interesting info on using/installing MySQL.

Also on PHP and other stuff.

Greetz,

B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Creating of database with userid and password

2001-01-29 Thread B. van Ouwerkerk


   How do I Create a Database with Userid and Passwords. Eg. 
 CREATE DATABASE USER. Such that I am able to login and access the 
 database using this userid and password.

Check out the manual. Search for MYSQLADMIN and GRANT.

Much other info can be found at www.devshed.com

Bye,



B.


-
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




<    1   2