RE: mysql.sock

2004-07-24 Thread B. van Ouwerkerk
mysql.sock is created when mysqld starts and exists only while it runs. B. > -Oorspronkelijk bericht- > Van: Levi Campbell [mailto:[EMAIL PROTECTED] > Verzonden: zaterdag 24 juli 2004 20:53 > Aan: [EMAIL PROTECTED]; mysql > Onderwerp: Re: mysql.sock > > > it's not in /tmp, /var/lib/m

Re: PHP script cannot connect MySQL server

2004-03-22 Thread B. van Ouwerkerk
At 22:00 22-03-2004 +0200, Sami Maisniemi wrote: > Did you provide access to the databases as root? Is there a password > associated with access? For instance, how do you statr mysql from the > command line: mysql -u root -ppassword mydatabase I think I am using root access, but should I create

RE: New Microsoft Critical Patch

2003-12-04 Thread B. van Ouwerkerk
I have checked almost every M$ critical patch and other messages with the same content and as far as I can tell none came via this or any other list. Easy enough to find out: look at the headers. If it says: Received: from lists.mysql.com (lists1.mysql.com [213.115.162.31]) List-ID: Precedence:

RE: restoring mysqldump ???

2003-11-23 Thread B. van Ouwerkerk
Hit the right button on the wrong moment... It should be: Leaving a space between -u (=user) and the user_name should not be a problem it is if you supply a password on the commandline in the form of -p'your_password' :( > -Oorspronkelijk bericht----- > Van: B. van O

RE: restoring mysqldump ???

2003-11-23 Thread B. van Ouwerkerk
mysql -u user_name -p reporter < dumpfile Leaving a space between -u (=user) and the user_name should not be a problem it is if you supply a password on the commandline -p'your_password' but -u user_name B. > -Oorspronkelijk bericht- > Van: Mikael Fridh [mailto:[EMAIL PROTECTED] > Ver

Re: My SQL & OS X setup - utterly, completely, 100% stumped

2003-04-06 Thread B. van Ouwerkerk
You don't explain your problem. You don't even tell which versions you're running. If there is no mysql table then you didn't create it, or you trashed it. In the manual you will find references to how to install MySQL on MAC OS X. http://www.mysql.com/doc/en/Mac_OS_X_installation.html IMHO you

Re: unable to change password

2003-04-06 Thread B. van Ouwerkerk
At 08:28 06-04-2003 -0400, Devon Y. wrote: [Hisako:~] hisako% /usr/local/mysql/bin/mysql -u root -p mysql Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) This is the same thing that was happening to me! Then I discovered that my root password was not

Re: unable to change password

2003-04-06 Thread B. van Ouwerkerk
try: mysql -u root -p then it will ask for your password. or mysql -u root -pmysql_root_password no spaces between -p and your mysql root password This is well documentee :http://www.mysql.com/doc/en/User_names.html please check the manual before asking questions. B. At 12:50 06-04-2003 +0100, His

Re: MYSQL Newbie

2003-04-06 Thread B. van Ouwerkerk
1) Can you recommend some good online tutorials for learning the basics of MYSQL? (I can't even say I know exactly what it is; I think of it as some sort of language used to create "special effects" or special functions, similar to JavaScript.) If you found this list then you should have found

Re: Help MySQL Beginner please.

2003-04-02 Thread B. van Ouwerkerk
PHP? www.php.net (click links->tutorials) PHP/perl/MySQL? www.devshed.com Others will add quite a few too. devshed.com is pretty good. B. At 10:10 02-04-2003 -0500, [EMAIL PROTECTED] wrote: Hi all, The best thing that happened to me today is finding this list on the web. I am in deep problem. I

Re: Could we make this a web discussion forum?

2003-03-31 Thread B. van Ouwerkerk
> I really hate on-line forums. They're difficult to track because I > must remember visit them daily. OK this is the first issue - 95% of people who need MySQL info do not need it daily. Mailing lists are a poor tool for them. No but those in need of help does. And those ppl who are capable of h

Re: Could we make this a web discussion forum?

2003-03-31 Thread B. van Ouwerkerk
Most ppl don't like forums. Do you know even one serious project which uses a forum? I know Slackware did and it really was a PAIN. Mail to this list gets mirrored on more places then you can imagine, same goes for PHP lists. You can't blame this on the MySQL ppl. There would be less mail if pp

Re: MySql, PHP, and Dates

2003-03-30 Thread B. van Ouwerkerk
This is not a MySQL question. http://www.php.net/manual/en/function.explode.php (probably) visit: http://www.php.net/links.php for tutorials on PHP. If you can control the layout of the database you could use another type of column. See the MySQL manual for more information. B. At 21:47 28-

Re: AW: AW: Mysqld problem

2003-03-23 Thread B. van Ouwerkerk
Can't create file could be caused by not having enough free space left. Easy to check . I think I remember I got a different err number in a simular situation.. You did check permissions.. right? B. At 15:32 23-03-2003 +, Phil Dobbin wrote: On 23/3/03 15:27, "Stefan Siefert" <[EMAIL PROTECTE

Re: Mysql And Backup

2003-03-21 Thread B. van Ouwerkerk
I have been using mysqldump -a to backup my clients sites. I have discovered a problem with this aproach. I decided to try and restore it with mysqlimport on my local hd and it'll restore it up to a certian point then stop. What I'm looking for is any other recomendations to backup and restore 7

Re: images with mysql

2003-03-21 Thread B. van Ouwerkerk
ck if you have the right cookies. If you've been to the right previous page to see that picture, if not redirect to '/'; Do you get my point? I still believe that the blob i my saviour... (despite the obvious loss of performance) On Thu, 20 Mar 2003, B. van Ouwerkerk wrote: > Y

Re: images with mysql

2003-03-20 Thread B. van Ouwerkerk
pares the users rights to view that image, get's the blob from the database, sets right content-type for the page and then renders the binary data. That way... you can control frames/design (direct links to images can be avoided) und so weiter... //lars On Thu, 20 Mar 2003, B. van Ouwerkerk wrot

Re: images with mysql

2003-03-20 Thread B. van Ouwerkerk
, gradually growing. All of them are quite small, most around 30*30 gray scale. Would it still be faster to store them on disk? On Thu, 20 Mar 2003 13:57:06 +0100 "B. van Ouwerkerk" <[EMAIL PROTECTED]> wrote: > IMHO it's better to store a link. > I have seen databases (n

Re: images with mysql

2003-03-20 Thread B. van Ouwerkerk
IMHO it's better to store a link. I have seen databases (not MySQL) getting corrupted because the file inserted was to big. For the visitor it doesn't really matter whether you put it into the database or not. A link is less difficult and you don't have to retrieve pictures from the database so

RE: How to Archive and restore the data in MySQL database.

2003-02-10 Thread B. van Ouwerkerk
Perhaps you can search the manual before you send a question to this (or any other) list. You really should since several ppl spend time to create and keep it up to date. The manual is here: http://www.mysql.com/doc/en/index.html If you launch a search for the word backup you will find: http://ww

Re: MySQL IMAP Server

2003-02-05 Thread B. van Ouwerkerk
I don't know such product running with MySQL. There is something called Bill storage server which runs with PostgreSQL, perhaps someone knows a way to put MySQL behind it instead of PostgreSQL. B. At 17:26 04-02-2003 +, Ben Clewett wrote: MySQL, My first post, please go easy if this is t

RE: how to change mysql root password

2003-02-02 Thread B. van Ouwerkerk
This is a FAQ. Please search this lists archive or the manual: http://www.mysql.com/doc/en/Default_privileges.html Ppl have spend time to create a manual so you'd better take a look there.. If it's not clear please come back to the lists and explain which part you don't understand. You will find

RE: how to change mysql root password

2003-02-02 Thread B. van Ouwerkerk
Not related at all: If you would have done a quick search in the manual you would have found: http://www.mysql.com/doc/en/Access_denied.html To start with.. B. -Oorspronkelijk bericht- Van: stephane parenton [mailto:[EMAIL PROTECTED]] Verzonden: zaterdag 1 februari 2003 18:09 Aan: [EMA

RE: mysql.sock is missing - Please....

2003-02-02 Thread B. van Ouwerkerk
>If it gives errors about creating/writing mysql.sock, check the >permissions/ownership of directory /var/lib/mysql.. Check the manual for >the right permissions... Might depend on your distro, AFAIK mysql.sock would normally live in /tmp B. -

RE: MySQl and webpages

2003-01-26 Thread B. van Ouwerkerk
www.php.net --> links www.google.com --> search for tutorials mysql php --B. -Oorspronkelijk bericht- Van: Doug Thompson [mailto:[EMAIL PROTECTED]] Verzonden: zondag 26 januari 2003 16:39 Aan: [EMAIL PROTECTED]; Scott Lewis Onderwerp: Re: MySQl and webpages For decent explanations of

Re: Newbie - Where do I look for answers?

2003-01-02 Thread B. van Ouwerkerk
Hi, www.google.com www.mysql.com (the manual) www.devshed.com -->server side --> mysql devshed has some very good articles.. Not sure if you think those are easy. Have fun, --B. At 12:20 02-01-2003 -0600, DIetrich Speer wrote: I am a complete newbie to mysql and Linux. I completed the inst

RE: FAQ hosting site (was "Re: An Idea")

2003-01-01 Thread B. van Ouwerkerk
I'm not following this threath.. but.. Use PHP to fetch mail from a mailbox, insert all questions into a database. Create a searchtool to search the database. No need to have way to many ppl as author. If you want you could have some ppl maintaining a list of keywords per question or remove a qu

RE: php3.0.15

2002-12-27 Thread B. van Ouwerkerk
This is a PHP question. Visit: http://www.php.net/manual/en/function.mysql-connect.php for more information about the function mysql_connect. Or: http://www.php.net/links.php To find some tutorials to get you going. You really should upgrade to a newer release of PHP. Have fun, B. -Oo

RE: i need help

2002-12-21 Thread B. van Ouwerkerk
This has been answered a zillion times in the past. Search the archive. mysqld.sock will usually live in /tmp Change the appropriate paths. -B. -Oorspronkelijk bericht- Van: Rich Dodge [mailto:[EMAIL PROTECTED]] Verzonden: zaterdag 21 december 2002 16:10 Aan: [EMAIL PROTECTED] Onder

Re: OT: Spam Filter (again)

2002-12-18 Thread B. van Ouwerkerk
Allow postings from members only. or I think it's on the PHP lists, if a non-members sends a message he/she gets a message back. After replying to that message the original one hits the list.. mysql, query B. At 14:37 18-12-2002 -0500, Michael T. Babcock wrote: Just for anyone who cares (or ca

Re: Access to MySQL

2002-12-16 Thread B. van Ouwerkerk
Search the archive! Short answer: export to .txt and import in mysql or use ODBC B. At 13:20 16-12-2002 -0400, Yves Arsenault wrote: Hello, Is there a small program that would transfer the contents of an Access database to MySQL? TIA, Yves Arsenault -

Re: MySQL with Slackware -- wha?

2002-10-25 Thread B. van Ouwerkerk
IIRC Slackware 7 and 8 come with MySQL preinstalled. But.. it does compile fine here.. on both 7 and 8. But you really have to uninstall (pkgtool) the default installed.. next you follow all the staps as explained in the MySQL manual (actually a file in the docs directory). Have fun, B. At 1

Re: Im New :(

2002-09-26 Thread B. van Ouwerkerk
>My host is running 3.22.5 on a redhat. Im trying to log in and use the >LOAD command but I cant get past 'ERROR 2002: Can't connect to local >MySQL server through socket '/tmp/mysql.sock' (2).' > >I connecting remotely with putty and sshing in on port 22. at command >prompt I was told by host to

Re: Forgot Mysql-Root Password

2002-09-18 Thread B. van Ouwerkerk
> >How can i solve this Problem? I have alread reinstalled mysql, but >unforunatelly i keeps its password. Reinstall will only work if you remove the database containing the passwords and users (mysql). Personally I would prefer the way suggested in the manual. Bye, B. --

Re: a newserver would be better than this mailing list

2002-07-30 Thread B. van Ouwerkerk
At 18:38 30-7-02 +0200, Bart Burkhardt wrote: >I am not going to give my replys to every yours reply, because.. > >i just know and feel that i gave fair reasons, and i find your replys not >strong enough. Exactly why I don't spend much time on this. Your arguments aren't good enough. Consider th

Re: always this happenes to me

2002-03-12 Thread B. van Ouwerkerk
>an error "can't connect to MYSQL server through socket >/tmp/mysql.sock" This is a FAQ. Searching through the archive will get you somewhere around a zillion hits. Get through the filter: mysql, sql, query Bye, B. - Bef

Re: Need Help bad!.. today.. of all days!

2001-12-26 Thread B. van Ouwerkerk
>hope you version came out better thn mine.. in my mail it was all out of >shape.. maybe could attach a text file.. doubt the list allows that >thoough "alot dont" Upload it as your_code_name.txt to your website and send an URL to the list. filter: mysql query sql Bye, B. --

Re: Fw: PHP+MYSQL: unable to select database

2001-12-11 Thread B. van Ouwerkerk
If you plan on using MySQL a lot I suggest you buy the book MySQL written by Paul DuBois. You might start by reading information on www.devshed.com (click on MySQL, click on PHP) and www.php.net (click links) Bye, B. - Bef

Re: Nusphere is spamming me

2001-11-20 Thread B. van Ouwerkerk
>It'd be interesting to know if A LOT of people have had this happen. >If so, maybe we should apply some social pressure and see if they're >see the error of their ways. > >Thoughts? Yeah.. I think I remember there was a Federal Trading.. thing (forgot it's name) somewhere in the USA which was

Re: PHP4 and MySQL

2001-11-01 Thread B. van Ouwerkerk
At 05:17 2-11-01 +0800, Benj Arriola wrote: >PHP4.0.6 claims to have MySQL with it. > >Is this all installed with one installation file? Is it just one run of >the setup file and you have PHP and MySQL installed together? Nope. I remember a few websites where you can download a easy to install c

RE: manual

2001-09-12 Thread B. van Ouwerkerk
>I have tryed to download the mysql manual.pdf but for some reason I cant. >Would >anyone be able to email me the pdf version? > >[EMAIL PROTECTED] Hi, I think it's around 3MB.. so if say 10 persons would mail it to you you'll get about 30MB in your mailbox.. If you're using M$ IE you might n

Re: Mysql+web+????

2001-09-03 Thread B. van Ouwerkerk
>I intend to use linux for the server, mysql for the database, php for the >web-forms. >but what is with the diagramms? They were not pregenerated, they must be >generated as >a result of the user parameters. GD might be able to do what you want.. www.boutell.com/gd uhm.. quite sure :-)

RE: RE: Use of the MySQL logo - licensing agreement

2001-08-29 Thread B. van Ouwerkerk
At 16:10 29-8-01 +0100, Andrew Murphy wrote: >Why not get MySQL to make a series of slightly different logos you can >choose from like Sun and other companies do. Some are colour, others >greyscale, and some are inverse for placement on black backgrounds. It would still violate their trademark ca

RE: Use of the MySQL logo - licensing agreement

2001-08-29 Thread B. van Ouwerkerk
>Does that make any sense? I'm not trying to slam MySQL, I'm just concerned >about displaying the logo on a web site that says "powered by MySQL" or >modifying the logo like folks used to do to produce all kinds of cool >enhancements to the name MySQL. Did you try to get permission?? I'll bet i

Re: Lost Root password

2001-08-29 Thread B. van Ouwerkerk
At 03:39 29-8-01 -0700, temi odurinde wrote: >Dear List, >I have lost the root password to my MySQL installation. What is the >quickest way to remedy this situation, uninstall and reinstall MySQL or >what???. My installation runs on a RaQ4 server. Take a look at the manual and this lists archi

Re: Root password revisited

2001-08-29 Thread B. van Ouwerkerk
At 17:44 28-8-01 -0700, Gregg Baker wrote: >Hi all, I just joined list. I spent a couple hours in the archive and >decided MySQL better improve their install message regarding setting the >root password! Half the posts are about it going badly. ;) When installing from source you will get a messag

RE: how to create a table and a column..?

2001-08-19 Thread B. van Ouwerkerk
> >http://www.mysql.com/doc/C/r/Creating_tables.html > >Look over > >http://www.mysql.com/doc/index.html Also have a look at www.devshed.com for some tutorials.. mysql, query Bye, B. - Before posting, please check: http:

Re: [PHP-DB] Opps: Proper Case NOT lower case

2001-08-16 Thread B. van Ouwerkerk
Buy a good book (PHP 4 Bible)!! read some tutorials!! And CHECK the manual.. found at www.php.net what else did you think people created if for.. http://www.php.net/manual/en/ref.strings.php gives you all string manipulation fun stuff you want. ucfirst() is the solution. And last but not leas

Re: [PHP-DB] Proper Case Conversion

2001-08-16 Thread B. van Ouwerkerk
It's a bad habbit to crosspost!! strtolower() stroupper() sql mysql Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ

Re: Just wondering....

2001-08-06 Thread B. van Ouwerkerk
>I have been considering a database backend for a new website I am creating. >If this site becomes successful I may be looking at several hundred >concurrent users. Can MySQL handle this? Is there a limit to the number of >connections?? > >Any info would be greatly appreciated. Check this lists

Re: Connecting MySQL over a Novell network

2001-07-31 Thread B. van Ouwerkerk
>PC there communicates through Novell 4.11 server, some use >Windows protocol. I've used the same installation, and more, >one from Apache serverer PC can be connected alternatively to one >or to second network. In the first, it works, as I've mentioned earlier, >in the second the server sees him

Re: Looking for Support

2001-07-29 Thread B. van Ouwerkerk
If you're looking for support you can contact MYSQL AB (the creators of MYSQL) checkout www.mysql.com to see which supportcontracts they offer. But you could also try your luck on this list. Bye, B. At 15:00 29-7-01 -0400, Thomas Bernthaler wrote: >Hi, >I have mysql-3.23.40-sun-solaris2.

Re: MySQL on Windows CE

2001-07-29 Thread B. van Ouwerkerk
>Does anyone have any information on running MySQL on a windows CE handheld? Try it and let us know as soon as you've got it up and running.. Good luck. /me wouldn't even try.. but me wouldn't even try to run MySQL on any M$ product.. mysql, query Bye, B. ---

Re: Telnet

2001-07-28 Thread B. van Ouwerkerk
At 13:44 28-7-01 -0700, tj marlin wrote: >There are secure telnet packages. one for windows is SecureCRT. see >www.vandyke.com Rather use PuTTY.. it's free!! and a very good SSH client I wonder how many sysadmins still allow telnet.. Use your favorite searchengine to find PuTTY.. or find y

Re: Telnet

2001-07-28 Thread B. van Ouwerkerk
At 18:06 28-7-01 +0200, Marco Bleeker wrote: >I need to Telnet into my domain in order to run some MySQL utility like >mysqldump (for backup). I am not experienced with Telnet. Any pointers? >Any way around it (use mysqldump from PHP?) Good reason to learn it :-) You could try phpadmin (or was

Re: mysql.org

2001-07-18 Thread B. van Ouwerkerk
>As you are aware, we are forming a not-for-profit corporation to >focus on building and supporting a larger MySQL development >community and promoting MySQL. The mysql.org domain is expected >to be transferred to that organization. NuSphere has taken the >lead and is covering the costs of for

Re: mysql.org

2001-07-15 Thread B. van Ouwerkerk
Hi, Sorry.. can't keep my mouth shut.. A few comments on the legal matter: GPL has been spoken about more then enough here.. Trademark: If no license or agreement exists which allows nusphere to use MYSQL AB's trademark it's probably illegal. One could think of situations where it might be pe

Re: hi new to mysql

2001-07-12 Thread B. van Ouwerkerk
>helo > >anybody there to help me for my project >my project is on PERL and Mysql in Linux > >please say me the procedure to >study those stuffs. > >thanx in advance Buy the book MySQL written by Paul DuBois. Take a look at www.devshed.com and on webmonkey. Bye, B.

Re: now I have it compiled, ??

2001-06-14 Thread B. van Ouwerkerk
Complete tutorial on installing Mysql, PHP and Apache can be found on www.devshed.com Have fun. B. At 11:12 14-6-01 -0700, Mark Vann wrote: >Hey gang, I got the configure script to run with no >errors and got it installed in the /opt directory by >using the following. > >./configure --with-

Re: which the best

2001-06-05 Thread B. van Ouwerkerk
You're right.. wrong place to ask. I don't want to start a kind of religious war.. but I wouldn't go for M$ products. Further good reading on this is presented in this lists archive. Bye, B. > I know this is not list for ask about OS, but I wonder to know > that which OS you choos

Re: Need help on mysql/php

2001-06-05 Thread B. van Ouwerkerk
Great support.. Right.. take a look at www.devshed.com they've got a few nice tutorials.. if you plan to work a lot with MySQL you might want to buy the book called MySQL written by Paul DuBois or fill out the survey and hope you'll get one for free ;-).. Other interesting websites: www.phpbu

Re: Newbie with PHP

2001-06-05 Thread B. van Ouwerkerk
Just a few thoughts. Does the user who needs to insert have enough rights to do so. Is your mysql server up and running.. If you want to take a look at a tutorial: www.devshed.com Bye, B. At 09:09 5-6-01 -0600, Harry Bakken wrote: >I apologize if this seems simple, or stupid, or if there is

Re: install apache, php + mysql on linux redhat 6.2

2001-06-04 Thread B. van Ouwerkerk
www.devshed.com has a nice tutorial. Bye, B. At 22:41 3-6-01 -0400, Peter Kok wrote: >Hi all > >I installed the following version on redhat 6.2 but failed on installing >apache finally! >Please teach me > >apache 1.3.19 >php-4.0.5 >mysql-3.23.38-pc-linux-gnu-i686.tar.gz > >mysql can start: /

Re: mysql & php connection errors

2001-05-30 Thread B. van Ouwerkerk
At 22:00 30-5-01 +1000, Steve Sapsford wrote: >hi ppl, > >i am a newbie running apache, php & mysql on a redhat 7 server... > >i am getting the following error when i browse to my php file which access >my database called steve: > > >== > >Warn

Re: Cannot create table with file named INFILE

2001-05-28 Thread B. van Ouwerkerk
Please check the manual before sending a question to this list.. says every messages.. So: http://www.mysql.com/doc/R/e/Reserved_words.html Workaround: give your table another name. Bye, B. At 14:23 28-5-01 +0200, Alessandro Staltari wrote: >Hello. I'm new to MySQL but I have a problem tha

Re: How to transfer database from one machine to another without network

2001-05-14 Thread B. van Ouwerkerk
>i have created a database ,Now i want to copy it on the server. Is there >any way to do it or i have to make tables on the servers >if anybody knows >please reply a.e.a possible. Take a look at the manual (www.mysql.com).. mysqldump might be what you want. Bye, B.

Re: urgent!!

2001-05-13 Thread B. van Ouwerkerk
> >Can anybody please help me with the making of this database or atleast >guide me with the making of this..please. >Thank You I suggest you start reading on database normalization (www.devshed.com has an article on this in the mysql part of their website). Bye, B. --

Re: [mysql+ftp]

2001-05-10 Thread B. van Ouwerkerk
At 18:52 10-5-01 -0300, Gleidson Henriques wrote: >Hello list, > > I want to install a mysql with a ftp server, is it possible ?! If you mean you want to authenticate users with the userinfo from your database.. sure www.proftpd.org might need so work from the developers.. Bye, B. -

Re: running mysql as different users

2001-05-04 Thread B. van Ouwerkerk
>the script. However, after that, I could not run mysql as root or mysql. >It gave me the same error message as it could not connect to local MySQL >server through /var/lib/mysql/mysql.sock. /etc/my.cnf might have a line giving the uri above. Mysql.sock normally lives in /tmp change my.cnf ac

Re[2]: can not see data or tables in database

2001-05-03 Thread B. van Ouwerkerk
>B.> Perhaps a problem with rights.. (settings in phpmyadmin not being >saved?).. >B.> Not using phpmyadmin myself.. did read about it. > >None of the programs on the web can access the mysql not just >phpmyadmin. It was working fine before yesterday and now it just wont >work. is there anything

Re: can not see data or tables in database

2001-05-03 Thread B. van Ouwerkerk
>I set up a couple of databases last night in mysql and every thing is >working just fine. Today when I try to access the data it is not there >Using phpMyAdmin when I look at the databases that are completely empty >of tables and data that also includes the mysql database. If I start up >telnet

Re: mysqld daemon ended!!

2001-05-03 Thread B. van Ouwerkerk
>Please read "Security" section of the manual to find out how to run mysqld >as root! >010503 16:57:03 Aborting > >mysqld ended on Thu May 3 16:57:03 SGT 2001 > >anyone have idea on this? Perhaps exactly what the message says :-) You tried to run mysqld as root. You should run mysqld as user

Re: help please

2001-05-03 Thread B. van Ouwerkerk
>I just want to create a webbased mailing tool using >PHP/Mysql...I've done using the fuction mail()...But if i need to have a >option 'Attachment' then in which way i can do that. This_is_a_PHP_question.. have a look at the manual at www.php.net also, checkout www.phpbuilder.com www.devshed.co

Re: Mysqld

2001-05-03 Thread B. van Ouwerkerk
At 22:00 2-5-01 -0600, Al Green wrote: >When I try to run mysqld I get the following message. How do I rebuild the >.sock >file. It is not where it should be and the one's that are there are 0 bites >Any suggestions The size is right. If the .sock can't be found point to the right location in y

Re: Mysql server grant privileges problem

2001-05-01 Thread B. van Ouwerkerk
> >So would anyone explain to me how can I setup up a good privileges of >mysql server.Thx Take a look at the manual. It's all there.. as far as I remember.. Bye, B. - Before posting, please check: http://www.mysql.com/

Re: New filter

2001-04-30 Thread B. van Ouwerkerk
>This is email. It's not a bomb on a plane. Choices exist for a digest, >or a newsgroup. Freedom has a price. I am more than willing to pay it. I don't feel our freedom has been limited by the filter used. Glad the listadmins does take some steps to prevent spam. just my 0,02 Bye, B. mysq

Re: Password security

2001-04-29 Thread B. van Ouwerkerk
>How do you keep MySQL password out of view of "visitors" when needed in >PHP to access the db. The password is in plain english in all the php >files, and can be easily downloaded by anyone. PHP is parsed so should show the password etc to the world. It's better to use an include and put tha

Re: ZipSlack 486 installation problems

2001-04-29 Thread B. van Ouwerkerk
>MY PROBLEMS SO FAR >All versions of MySQL I have tried so far have come in RPM format which I >have rpm2targz to set up. Then I have >gunzip/tar or tar xzf to unpack the archive. The archive unpacks in >different folders to those that the scripts expect and >this is a problem for a start. Also

Re: What is SSL ?

2001-04-29 Thread B. van Ouwerkerk
>I am a Java developper, I use Mysql and TOmcat, > >I want to know what SSL is? Nothing_to_do_with_mysql. ssl=secure socket layer More info? type ssl into the seach field of you favorite searchengine. Bye, B. - Before post

Re: create table

2001-04-26 Thread B. van Ouwerkerk
>I got a downloaded version of MYSQL installed. >I am not able to create tables within in a database . I think some >problem with the edit options.Any solutionbut i am able to create >a new database. manual www.mysql.com several websites: www.devshed.com and others. Book: MySQL writ

Re: mysql hosting?

2001-04-26 Thread B. van Ouwerkerk
>read of a free hosting site a while ago if you are developing mysql sites. >does anybody know about that? I can't find it anymore. Please I really need >to host my test page as the server I had it one broke. Can anybody help me >out Use your favorite searchengine. Bye, B. -

Re: Need help with 23.36

2001-04-24 Thread B. van Ouwerkerk
COuld try a mysqldump to backup and restore the tables on the new/other machine. This should get you past the problems you found earlier. Remember to add the propriate users to the new machine.. Bye, B. > > >mysql> use lum >Reading table information for completion of table and column names

Re: Debian - mySQL - php3

2001-04-24 Thread B. van Ouwerkerk
Once again.. a PHP issue.. You might want to try with PHP4.. latest release. If that doesn't help go the archives @php.net.. Bye, B. mysql, query At 15:16 24-4-01 +0200, [EMAIL PROTECTED] wrote: >I have a system built up with Debian potato and apache. I have to install >(to copy) a database

Re: mysql problem

2001-04-24 Thread B. van Ouwerkerk
Here we go again This is a PHP issue NOT MySQL.. more info: www.devshed.com www.phpnewbie.com www.phpbeginner.com www.php.net One hint.. don't forget ?> to close PHP code.. Bye, B. mysql, query At 14:46 24-4-01 +0200, J.Heegsma wrote: >Dear Sir/Madam and mysql users, > >I have a mysql

Re: accessing mysql remotely

2001-04-24 Thread B. van Ouwerkerk
>I have mysql installed on two linux boxes. >How can i access one system's mysql db from the other system grant access to the user on the other system. COnnect to the remote system just like you would on the local. Bye, B. ---

Re: [PHP-INST] tforum

2001-04-24 Thread B. van Ouwerkerk
COME ON This_is_not_a_MySQL_issue.. It has everything to do with PHP.. please keep this discussion in the PHP lists.. By the way, crossposting isn't the way to make friends.. Looking for more info on PHP and MySQL go to some URL's mentions a million times in several PHP lists. Bye,

Re: how can i make it? concat?

2001-04-23 Thread B. van Ouwerkerk
>If there is a function to sum values, why there isn't one to sum strings >i.e. concat strings. Or how should i use it? You use concat to put two strings together. How it works? Thats why people like me always have a manual or a reference guide lying around. Not much fun typing it. Bye, B.

Re: how can i make it?

2001-04-23 Thread B. van Ouwerkerk
It's a bad habbit to cc to a list. >Of course "left join". And "group by" moreover. But how? >For the "group by" i need a sum-like function, which joins the strings. Hmmm, something like concat() you mean? Bye B. mysql, query ---

Re: mysql_install_db problems

2001-04-23 Thread B. van Ouwerkerk
This sounds more like a OS problem then a MySQL problem. I don't know much about HPUX. Bye, B. >Hi folks, > >Thought I'd see if I have a common problem before I do a bug report. I am >trying to install the binary file for HP/UX 10.20 on a HP/UX 10.20 785 >series computer. As the error mess

Re: how can i make it?

2001-04-23 Thread B. van Ouwerkerk
>how can i get a recordset constains all records (or records matching a where >exp.) from the Table1 with the c values from the Table2, like this: > >uidnamecs >- >1user1'50 - twenty-three - the reason of life' >2user2'twenty-three - 303 rulz' >3user3

Re: Src distribution of MySQL takes up a lot of space

2001-04-23 Thread B. van Ouwerkerk
>I'm new to MySQL and I've recently installed MySQL >(MySQL-3.23.36-1.src.rpm) and it's running ok. But, I noticed that it >seems to be consuming so much of my hard disk space. Is this normal? I'm >wondering if anyone encountered this problem before or can advise wat I >can do abt it? I don't kn

Re: Need help with 23.36

2001-04-23 Thread B. van Ouwerkerk
>I copied my database files made with 23.29 to 23.26 and now I get this. I >chowned mysql.mysql and chmoded 660. What's wrong? Perhaps or.. the location of your database is different.. or.. you didn't copy everything.. including subdirectories. Solution: check the location and if you copie

Re: Connecting to mysql as root

2001-04-23 Thread B. van Ouwerkerk
> For connecting I have given the user as root and no password in the PERL > scipt. You NEED to provide the password otherwise you can't get any data out of the database.. If you didn't entered a password for the mysql root user you need to do it ASAP.. >Is there any way to connect

Re: Run time version of MySQL

2001-04-19 Thread B. van Ouwerkerk
>We are planning to move on to MySQL. >Could you send us your opinions about MtSQL. It will greatly help us to >make decision and to use MySQL. I love MySQL.. but there are others too. I think their are still some pros and cons.. given time I think the pros will increase.. Although other datab

Re: LIMIT

2001-04-19 Thread B. van Ouwerkerk
>seems redundant and I really hate the fact that LIMIT is not supported. >Any ideas? By the way, suggestions for SQL Server 6.5 or SQL Server 7.0 >are both appreciated. M$??.. thought this was about MySQL :-) I wouldn't know.. I do know you can find a few newsgroups somewhere at news.microso

Re: Please assist me?

2001-04-19 Thread B. van Ouwerkerk
>Are there any suitable training materials on your website? In particular, >how can I best use the GUIs in WinMySQLAdmin? Try a few of the websites already mentioned in other postings.. I think www.devshed.com is a nice place to start.. But you can find plenty others in the manual.txt found

Re: problem

2001-04-18 Thread B. van Ouwerkerk
>I'm trying to install mysql onto a uniz environment. >I've already unzipped and untarred, and I've created >the mysql - version directory, but when I type >configure, I get a grant table failed error. I cant >find anything on how to fix this. Take a look at www.devshed.com they've got a nice t

Re: install probs - socket error

2001-04-18 Thread B. van Ouwerkerk
>When I go to that directory and do a ls -al it is empty. So how do I >create this file. If it is not specific to my system can someone just >mail me one. I'm doing all this as root - do I need special permissions >to this dir and file. mysql.sock usually lives in /tmp and is created wh

Re: MySQL Problem

2001-04-18 Thread B. van Ouwerkerk
>I have done the following :- > >Login through telnet and become root. >accessed : > >mysql -h server name -u username -p >Password : password > >and tried to create database with : >mysql> create database cart; > >ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE 'CART' You s

Fwd: Re: MySQL Reports No More Connections - How to Troubleshoot?

2001-04-17 Thread B. van Ouwerkerk
Forwarded cause HH send reply to me instead of to the list.. >The connections are released... If an INSERT is trying to update a table >that is locked, won't that cause connections to stack up? > >Anyone have any insight? > >Hunter > > > From: "B. van Ouwerke

  1   2   >