Re: Coldfusion?
ColdFusion server on Unix/Linux platform, then yes. The ColdFusion server for Linux/Unix comes complete with the MySQL drivers necessary. I have successfully created CF-MySQL pages without any problem. When I have installed ColdFusion on Windows platforms, it has NOT come with the MySQL drivers. I'm not sure if there's a place to get MySQL drivers for ColdFusion? I haven't tried. The My-ODBC drivers might work. I don't know. Bryan Capitano MSL wrote: Quick Newbie question: Can I use MySQL with Coldfusion server? If yes, are there any limitations or provisos I should know about? Thanks as always Mark - 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 -- CAPITANO WEb CONSULTING http://www.capitanoweb.com Bryan R. Capitano cell (541)760.6288 home (541)929.5060 - 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: setting root psswd on Win2K ??
Yes, thank you, everybody's comments have been helpful.
It seems, as Roel has noted, that the user where user='' and host='localhost'
has all kinds of
privileges. Which explains why when I log in as simply 'mysql' without
specifying a particular
user, than I have omnipotent powers.
delete from user
where user=''
and host='localhost'
now this does the trick!
(I will note however, that this is NOT plainly described in the MySQL
installation and setup. I only found it after searching in about 5 different
locations. Even then, the significance of this 'empty' user was not well
impressed upon me. The documentation could be more clear on this VERY
important fact.)
Thanks everyone!
Roel Van den Bergh wrote:
The problem is you only changed the password for the user 'root'
and didn't provide a password for 'anonymous' login or dissabled it
therefore any login can alter anything
be sure to fully read the section on security and you'll find an answer to
your securityleak
btw after dopping table 'user' I think you might have to reinstall MySQL
: -)
Also NB, Roel
-Oorspronkelijk bericht-
Van: Bryan Capitano [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 10 januari 2002 8:51
Aan: [EMAIL PROTECTED]
Onderwerp: setting root psswd on Win2K ??
Having some problems setting root password on MySQL. Can anybody help
me?
I've just installed MySQL 3.23.38 on a Windows 2000 server.
I'm following the directions in the documenation for setting the root
password:
mysql -u root mysql
mysqlUPDATE user
mysqlSET password=password('mynewpass')
mysqlWHERE user='root';
mysqlFLUSH PRIVILEGES;
okay, all seemed fine. now if I log out and log back as pain old nobody:
mysql
mysqluse mysql;
mysqldrop table user;
okay 1 table affected.
How come just anybody can log into my MySQL server and start dropping
tables
in the mysql database?? This shouldn't be right. What have I done wrong?
Either I have a serious mis-understanding or something is seriously not
right here.
Thanks for any help!
-
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
--
CAPITANO WEb CONSULTING
http://www.capitanoweb.com
Bryan R. Capitano
cell (541)760.6288
home (541)929.5060
-
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
setting root psswd on Win2K ??
Having some problems setting root password on MySQL. Can anybody help
me?
I've just installed MySQL 3.23.38 on a Windows 2000 server.
I'm following the directions in the documenation for setting the root
password:
mysql -u root mysql
mysqlUPDATE user
mysqlSET password=password('mynewpass')
mysqlWHERE user='root';
mysqlFLUSH PRIVILEGES;
okay, all seemed fine. now if I log out and log back as pain old nobody:
mysql
mysqluse mysql;
mysqldrop table user;
okay 1 table affected.
How come just anybody can log into my MySQL server and start dropping
tables
in the mysql database?? This shouldn't be right. What have I done wrong?
Either I have a serious mis-understanding or something is seriously not
right here.
Thanks for any help!
-
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
Need help with mysqldump
I'm running MySQL ver 3.23.38 on Win98 platform and am trying to learn to do backups. I'm trying the mysqldump command but I'm getting the error: Access denied for user '@localhost' How do I specify a user for mysqldump? Thanks, Bryan - 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
Consequtive, Sequential auto-increment?
When I delete items from a table where I've got an auto-incremented primary key/index, call it table_id, I'd like to keep this column consequtive and sequential. In other words, when I delete items from the middle, then the column is no longer sequential because there is a number missing. Is there a function to re-index the column? -- CAPITANO WEB CONSULTING Bryan R. Capitano CELL: 541-760-6288 HOME: 541-929-5060 - 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: Need A book for dynamic website
PHP and MySQL Web Development by Luke Welling and Laura Thomson (Sams Publishing, Copyright 2001) is the best book on the market I think. But it depends on your skill level. This book has a section on basic PHP language, another section on setting up MySQL databases, and a third section with practical examples of PHP/MySQL projects, including source code etc. This book covers 90% of everything you'd need to REALLY know. For the other 10%, I like to use the WROX series Professional PHP Programming by Castagnetto, Rawat, Schumann et. al. It has more fine details of the PHP language which Welling and Thomson just couldn't cover. But the WROX book only has one chapter on interfacing with MySQL. It does have a nice library of MySQL functions in the glossary, however, which Welling and Thomson would have been really wise to incorporate. The two of these books make a SLAMMING dynamic duo. You just can't fail with them. Bryan -- CAPITANO WEB CONSULTING http://www.capitanoweb.com Webmaster wrote: Hi, I need a book to teach me how to make a database driven website, I think php mySql is the way to go and have seen some on amazon and fat brain but don't know if any are any good, any ideas? Thanx in advance DavidJaymz Here are the books I'm thinking of: PHP and MySQL Web Development Luke Welling, Laura Thomson Database Driven Web Sites By Joline Morrison,Joline Morrison Sams Teach Yourself Active Web Database Programming in 21 Days By Dina Fleet,Matt Warren (Editor) Building Database Applications on the Web Using Php3 By Craig Hilton,Bjorn Borud,Jeff Willis Create Dynamic Webpages Using PHP and MySQL David Tansley PHP: Fast and Easy Web Development J. Meloni Thanx again: DavidJaymz - 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 - 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: Need A book for dynamic website
My experience with DuBois's book is that it's GREAT for MySQL, especially when you want to interface with MySQL at the server level -- with C or C++ for example. But for PHP/MySQL or using MySQL at any level of web interfacing, this book just doesn't do it. Erik Price wrote: When I was just starting to consider my database-driven web site, I checked mysql.com and found this: http://www.mysql.com/portal/books/html/index.html The best-rated book is the one I chose to get: MySQL by Paul DuBois New Riders I think it's awesome. (Although neither it nor the web site documentation can help me with my problem in shutting down the mysql daemon with mysqladmin.. !) I originally had purchased MySQL/PHP Database Applications by Jay Greenspan and Brad (forget last name) And found its example code was ridden with typos and errors, to the point that I was having a great deal of trouble following the text. I took it back to the store to get the DuBois book. Erik --- Webmaster [EMAIL PROTECTED] wrote: Hi, I need a book to teach me how to make a database driven website, I think php mySql is the way to go and have seen some on amazon and fat brain but don't know if any are any good, any ideas? Thanx in advance DavidJaymz Here are the books I'm thinking of: PHP and MySQL Web Development Luke Welling, Laura Thomson Database Driven Web Sites By Joline Morrison,Joline Morrison Sams Teach Yourself Active Web Database Programming in 21 Days By Dina Fleet,Matt Warren (Editor) Building Database Applications on the Web Using Php3 By Craig Hilton,Bjorn Borud,Jeff Willis Create Dynamic Webpages Using PHP and MySQL David Tansley PHP: Fast and Easy Web Development J. Meloni Thanx again: DavidJaymz - 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 = Microsoft e[X]tra [P]roprietary -- Is this where you really wanted to go today ? -- http://www.redhat.com/about/opinions/xp.html __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com - 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 -- CAPITANO WEB CONSULTING Bryan R. Capitano CELL: 541-760-6288 HOME: 541-929-5060 - 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: Need A book for dynamic website
Todd Are you familiar with either of the books I recommended? Each of
them does a fine job explaining (1) how to use PHP -- as a beginner (2) how
to use MySQL -- as a beginner. The language is simple. If you've never come
across a for{} loop, it explains it clearly. If you've never seen an RDBMS,
or any of it's terminology, you will get a fine introduction. AND, what I
liked about these books (as a beginner) was that they had plenty of room to
grow -- chapters on more advanced topics, practical projects with source
code. You certainly don't have to read those chapters first. I like to get
books which have a few more miles that just the basics.
Nevertheless, if you need something more basic, with more elementary
language, I would suggest a book like Introductory Web Development, which
doesn't dive into topics like PHP and MySQL--because these are already
advanced topics relative to web development.
If you can't run with the big dogs, then stay on the porch.
Todd Williamsen wrote:
Brian... You can SLAM yourself into a wall of confusion if you do not
pick the right books that doesn't explain things to you like a two year
old. I like books that explain things that way when I learn a new
technology. It keeps the frustration away
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Bryan Capitano [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 14, 2001 10:29 AM
To: Webmaster; mysql
Subject: Re: Need A book for dynamic website
PHP and MySQL Web Development by Luke Welling and Laura Thomson (Sams
Publishing, Copyright 2001) is the best book on the market I think. But
it depends on your skill level. This book has a section on basic PHP
language, another section on setting up MySQL databases, and a third
section with practical examples of PHP/MySQL projects, including source
code etc.
This book covers 90% of everything you'd need to REALLY know. For the
other 10%, I like to use the WROX series Professional PHP Programming
by Castagnetto, Rawat, Schumann et. al. It has more fine details of the
PHP language which Welling and Thomson just couldn't cover. But the WROX
book only has one chapter on interfacing with MySQL. It does have a nice
library of MySQL functions in the glossary, however, which Welling and
Thomson would have been really wise to incorporate.
The two of these books make a SLAMMING dynamic duo. You just can't fail
with them.
Bryan
--
CAPITANO WEB CONSULTING
http://www.capitanoweb.com
Webmaster wrote:
Hi,
I need a book to teach me how to make a database driven website, I
think php mySql is the way to go and have seen some on amazon and fat
brain but don't know if any are any good, any ideas?
Thanx in advance
DavidJaymz
Here are the books I'm thinking of:
PHP and MySQL Web Development
Luke Welling, Laura Thomson
Database Driven Web Sites
By Joline Morrison,Joline Morrison
Sams Teach Yourself Active Web Database Programming in 21 Days By Dina
Fleet,Matt Warren (Editor)
Building Database Applications on the Web Using Php3
By Craig Hilton,Bjorn Borud,Jeff Willis
Create Dynamic Webpages Using PHP and MySQL
David Tansley
PHP: Fast and Easy Web Development
J. Meloni
Thanx again: DavidJaymz
-
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
-
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
--
CAPITANO WEB CONSULTING
Bryan R. Capitano
CELL: 541-760-6288
HOME: 541-929-5060
-
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 through socket using PHP script
Usually this means your MySQL daemon, mysqld, is not started. Which OS are you using? Under RedHat Linux, you can get your mysqld running on init runlevels 3 and 5 (network services with and without X-windows) this way: % chkconfig --level 35 mysqld on % /etc/init.d/mysqld start check to make sure it's working: % chkconfig --list mysqld now your mysqld daemon will be running--and will start on runlevels 3 and 5 every time the system boots. now try connecting to MySQL server via php script. On Thu, 26 Jul 2001, cjackson wrote: Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) What does this error mean? I am trying to authenticate from a php script using the following code... $db=mysql_pconnect(localhost,username,password); The user username is able to login to mysql ata command prompt. Thanks, Jackson - 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 - 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
subqueries?
Do any of the newer versions of MySQL support sub-queries yet? - 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
CREATE SEQUENCE
Hello, Does anybody know what the SQL statement: CREATE SEQUENCE do? I cannot find any info on this in the http://www.mysql.com/docs section. Thanks, Bryan Capitano - 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
