Re: mysql and php3
On Wed, 13 Jun 2001, Saisab Pradhan wrote: > > Hi, > > Can somebody tell me why I cannot use php3 with mysql? I have just > installed mysql (3.23.38) on a linux 6.2 machine. It is working fine. > PHP3 was already installed when I installed mysql. Does it have to be the > other way round? that is php first and then mysql? I also configured > php3.ini with mysql settings but it doesn't work. By the way php3 itself > works fine. Did you use the --with-mysql option when you compiled php? -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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: startup help
On Tue, 12 Jun 2001, Neil Zanella wrote: > > On Tue, 12 Jun 2001, Martin Scherer wrote: > > > I am told that mysqladmin is not an understood command. > > Looks like you need to update your PATH variable. > Or one of the following: $ /var/lib/mysql/bin/mysqladmin $ cd /var/lib/mysql/bin $ ./mysqladmin -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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.sock not created
On Wed, 13 Jun 2001, Brian Walker wrote: > mysqladmin: connect to server at 'localhost' failed error: 'Can't > connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' > (111)' Check that mysqld is running and that the socket: > '/var/lib/mysql/mysql.sock' exists! When this happened to me, it was because mysql didn't exist as a subdir under /var/lib. I created the mysql dir, and it worked fine. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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: Advice needed....
On Sat, 19 May 2001, Dave Carter wrote: > I'm converting an Access db to mySQL, and Access allows users to Insert > Records into a table AND call them as well in the FROM clause. This is > illeagal in ANSI SQL however and therefore illeagal in mySQL, but I don't > know really how to get around it. How can I insert only new records that > aren't already in a table, without calling the table first? Can this be done > in SQL? But you're not working only with SQL, are you? Like transactions or foreign keys, you can easily do this in your middleware, whatever that might be (PHP, Perl, Coldfusion, whatever). Select first, then check to see if it's there, and if it isn't, insert it. A simple if-statement will do the job, so what's the problem? -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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: mail all users in MySQL database
On Fri, 27 Apr 2001, Prasad Mhatre wrote: > Dear All, > > Can anyone suggest a link where I can find a script in PHP3 to mal all users > in MySQL database? That's pretty simple, isn't it? Pull the usernames from the table, then put mailto:$email>link ?> or something like that in a while loop ... -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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: No Subject
On Fri, 13 Apr 2001 [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. Sure. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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: several problems
On Fri, 16 Mar 2001, Daniel Soto Armijo wrote: > ¿Why the user interface of MySQL is very difficult? ¿Why is not more > friendly like MS SQL Server user interface? I tried to use and configure > MySQL and I get nothing. H. I'll probably get flamed for this, but you wouldn't be using either if you weren't at least trying to be a DBA, and if you need a cute little point-and-click interface before you can figure something out, you have no business being near a db server. IMHO, of course. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS
Re: MAX number of connections
On Wed, 28 Feb 2001, Decasto David wrote: > can u tell us how to configure mysql , to support more > connections. safe_mysqld --set-variable=max_connections=n -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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: [PHP] Re: Creative solution with XML,PHP,MYSQL
On Sat, 17 Feb 2001, Artem Koutchine wrote: > Aha, java is even better :) Absolutely. I can't think of anything I'd rather do than sit and wait for the browser to load the JVM. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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: is it possible to store images in mysql db?
On Sat, 17 Feb 2001, Nikhilesh Haval wrote: > I want to store different file formats in a database like images (*.jpg) > or audio files (*.mp3). Is it possible to do so in mysql? > Yeah, that's what BLOB is for--but why would you want to do that? Why not just store the path in the table, and the binary somewhere else? -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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 please?
On Tue, 13 Feb 2001, Crystal D. Silver wrote: > in the documentation about how to just plain DELETE everything in the > database (i don't want to delete the installed database itself, just go back > down to where there's nothing in it, so I can start over)...could somebody > tell me what to do? drop -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS
Re: special characters messing me up
On Tue, 13 Feb 2001, Irmund Thum wrote: > Rolf Hopkins schrieb: > > > > "^M"??? You sure it is that? Anyway, it is most likely to do with carriage > > returns. Windows uses CR and LF to indicate a new line, while Linux and > > Macs only use LF. Hopefully this will help. Don't know what you can do > > about it though. > > > this is a very old well-known Windows issue; > you should use a text editor what can save your files in UNIX format: > I guess every professinal editor has this option, see Textpad or > Dreamweaver... Or if you ftp it to your server, you can set your ftp client to strip the newline chars. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS
Re: Shell Shocking
On Tue, 13 Feb 2001, Donald Korth wrote: > The hosting company has given me a user name and passwd . When i log into my own >site thro' a telnet session i 'm able to view all the databases created in the server >that includes DBs not created by me . I also did a "USE DB" command to connect to a >DB that wasn't mine . Also "Show tables" faithfully listed all the tables in the DB . >I even was able to run a "SELECT " on a login table table to list all the user names >and passeords listed with the company . > What do i make of it An admin lapse or a inherent limitation of MySQL as the >support guy makes it out . But the latter is hard to believe. > Any suggestions on how to make my DB invisible on other Logins ? > Any help will be deeply appreciated . If your db is anywhere near critical, I would change to an ISP with a competent DBA, if I were you. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS
Re: Installation error Linux RedHat 7.0
On Sat, 10 Feb 2001, Larry Marshall wrote: > On issuing the command: > > rpm -i MySQL-32.23.32.-1.i386.rpm > > the following error listed: I understand that mysql rpm that comes with RH7 is buggy. I dowloaded the tarball and compiled it. Runs like a dream. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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!!!
On Sat, 10 Feb 2001, Mailing List Address wrote: > Yes I tried that too... Same stupid stuff happening Then have you tried creating the mysql db and tables? -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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!!!
On Fri, 9 Feb 2001, Mailing List Address wrote: > Help! > [ ... ] > 6 rows in set (0.00 sec) > (The output should be mysql and test.) Looks to me like you didn't run mysql_install_db -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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: Problems with mySQL and DBTools
On Thu, 8 Feb 2001, Curtis, Lorenzo wrote: > 2. Is there a detailed outline to use to compile Apache with PHP and mySQL > effectively? www.devshed.com/Server_Side/PHP/Soothingly_Seamless/print.html -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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: Connect problem
On Wed, 7 Feb 2001, Carsten H. Pedersen wrote: > ...but in this case, it means that PHP is trying > to connect not through TCP/IP as other remote > machines, but rather through a UNIX socket located > on the machine as you have described above. > > It probably means that > 1) PHP expects to find the socket file as it says > 2) your new version of MySQL creates the socket file >somewhere else. > > Alternatively, try connecting from PHP specifying > the host name rather than localhost. This will > force PHP to use TCP/IP rather than the socket > file (at the cost of some performance loss) Ah, many thanks. That worked. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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
and ...
I just tried connecting to the db from kmysql on the same box--no way, no how. Same can't connect error message, though I can connect remotely. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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
Connect problem
I just installed mysql 3.23.32 on my server and it went without a hitch. I ran mysql_install_db, changed the root password, started the server. I used GRANT statements to create another user, then connected as that user to the mysql client--no problem at all, ran queries, etc. But I wrote a PHP test script to test the connection, also on the same machine (so this is a localhost connection), used the same username and password that worked just fine with the client, and I get: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) This usually means that the server isn't started, but it's running. I use dbtools on my wintel to connect to the departmental mysql server, so I set up a connection in it to this one, and it connects just fine, no problem. I looked at the PHP code and saw no problems there, but to test it, I changed the dbhost, user, and password to connect over the network to the departmental server, and it works just fine, so it's not the code. It just won't connect to localhost--though the connection works from the command line and dbtools. Anybody have any idea what's going on here? -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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
