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/mysql or

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:

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]

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 Ouwerkerk [mailto:[EMAIL

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: 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,

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

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

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
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

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

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

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 PROTECTED]

Re: images with mysql

2003-03-21 Thread B. van Ouwerkerk
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: You can use other ways to protect your images from linking by others. Like

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

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

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 (not MySQL) getting corrupted because

Re: images with mysql

2003-03-20 Thread B. van Ouwerkerk
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 wrote: I assume it is, have

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:

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

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: 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:

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: 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

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

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.

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]

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

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

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

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. - Before

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. -

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: 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 need

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: 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 messages

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 archive.

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 it's

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

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

2001-08-20 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:

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

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

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 himself

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: 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.7

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: 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

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 forming

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

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

Re: which the best

2001-06-06 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 choose

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: 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:

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: == Warning: MySQL

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

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

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 your

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 and

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 that I

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:

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.

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

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 some

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 that

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: 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 written

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: 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: 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: 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 You

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 to

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 copied

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 know

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'' I

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 message

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: 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: 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

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

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

2001-04-18 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 Ouwerkerk" [EMAIL PROTECTED] Date: Tue, 1

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 say root..

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 when

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

Re: how is this done

2001-04-17 Thread B. van Ouwerkerk
I am using php for this project. Right now it is related to mysql. What I want is to display the names of the countries and cities from the Special table instead of the ids. What would be the correct syntax for the select statement? Take a look at websites like www.devshed.com

Re: Simple question

2001-04-17 Thread B. van Ouwerkerk
Why it display other version of client api than I install. It would be nice that You answer me. Did you compile PHP with --with-mysql=/path/to/mysql Bye, B. - Before posting, please check:

Re: Simple question

2001-04-17 Thread B. van Ouwerkerk
At 19:31 17-4-01 +0100, John Dean wrote: Hi Did you leave an old version of the shared libs lying around? The old version is packed with PHP.. Bye, B. query sql - Before posting, please check:

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

2001-04-17 Thread B. van Ouwerkerk
What's the best way to figure this out if I can't get into the server at all when it locks up? Few thoughts: - release the connection in your code.. - use pconnect instead of connect.. Check the logs.. if you have any.. Bye, B. query sql

Re: No Subject

2001-04-13 Thread B. van Ouwerkerk
At 20:31 13-4-01 +, [EMAIL PROTECTED] wrote: Hi, Can i make a user friendly interface for Sales people to make a contact to my data base on mysql running on my linux server. PHP, Perl also seen message from people who use VB and ODBC to connect to MySQL. Take a look at this lists

Re: mail to mysql database recepient

2001-04-13 Thread B. van Ouwerkerk
I will like to mail all the users in Mysql database having valid email record, their data with user name and password. How to go about this? does anyone have a free script to share? I also want a column to be updated with random password for each user. This is an application issue. You can do

  1   2   >