Re: COLDFUSION AND MYSQL
Hi marco In the administration page of coldfusion, usually something like: http://domainName/CFIDE/administrator/index.cfm?target=/CFIDE/administrator/welcome.cfm go to your data sources and click the edit button. THen click the show advance settings button. Make sure that the Allowed sql privelages are correct (ie. select, delete, update, etc). That is, if you give your coldfusion a datasource using the user name mySource you have to make sure that your sql database has a user mySource. Make sure that the user mySource has the correct privelages. That is, if you say that the user mySource can only have select privelages then you have to make sure that the coldfusion knows about it too and thus, you can't say that the user: mySource has drop or alter privelages. Hope this helps Desmond From: marco [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: COLDFUSION AND MYSQL Date: Mon, 19 Aug 2002 10:23:19 +0200 Hello everybody I'm just getting mad with coldfusion, installed on a redhat platform running mysql 2.1.0 Well, the problem occures when I try to create a data source, because I always get this ERROR MESSAGE: []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. So I was wondering if it's a problem of drivers. for example I may not have JDBC drivers installed on that redhat server???Is it possible???If so, can I install them?? thanx marco - 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 _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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
help with syntax of left outer join
Hi there I want to do a left outer join but i also have a bunch of where conditions in my sql statment that i need. Can anyone help me out: SELECT title, authorName, journalName, journalPages, aname, tname, avg(ranking) FROM publications, area, topic, pubTopicInt, LEFT OUTER JOIN ranking publications.pubID = ranking.pubID WHERE publications.areaID = area.areaID AND publications.pubID = pubTopicInt.pubID AND topic.topicID = pubTopicInt.topicID AND publications.pubID = ranking.pubID AND publications.pubID = 3 GROUP BY (publications.pubID); I look at the mysql documentation, but i couldn't really understand their examples when they had additional where cluases. THanks Desmond _ Chat with friends online, try MSN Messenger: http://messenger.msn.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
Re: help with syntax of left outer join
Whoops... forgot the on in the join stament. I change it to include the on, but still no luck. Does anyone have any idea? SELECT title, authorName, journalName, journalPages, aname, tname, avg(ranking) FROM publications LEFT OUTER JOIN ranking ON (publications.pubID = ranking.pubID), area, topic, pubTopicInt, WHERE publications.areaID = area.areaID AND publications.pubID = pubTopicInt.pubID AND topic.topicID = pubTopicInt.topicID AND publications.pubID = ranking.pubID AND publications.pubID = 3 GROUP BY (publications.pubID); Thanks Desmond From: Desmond Lee [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: help with syntax of left outer join Date: Tue, 13 Aug 2002 14:34:06 -0700 Hi there I want to do a left outer join but i also have a bunch of where conditions in my sql statment that i need. Can anyone help me out: SELECT title, authorName, journalName, journalPages, aname, tname, avg(ranking) FROM publications, area, topic, pubTopicInt, LEFT OUTER JOIN ranking publications.pubID = ranking.pubID WHERE publications.areaID = area.areaID AND publications.pubID = pubTopicInt.pubID AND topic.topicID = pubTopicInt.topicID AND publications.pubID = ranking.pubID AND publications.pubID = 3 GROUP BY (publications.pubID); I look at the mysql documentation, but i couldn't really understand their examples when they had additional where cluases. THanks Desmond _ Chat with friends online, try MSN Messenger: http://messenger.msn.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 _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 with syntax of left outer join
Ah Never mind, i got it. I did some stupid stuff, but figured it out. Here's the working query: SELECT title, authorName, journalName, journalPages, aname, tname, avg(ranking) FROM publications LEFT OUTER JOIN ranking ON (publications.pubID = ranking.pubID), area, topic, pubTopicInt WHERE publications.areaID = area.areaID AND publications.pubID = pubTopicInt.pubID AND topic.topicID = pubTopicInt.topicID AND publications.pubID = 7 GROUP BY (publications.pubID); Thanks for your patience. Desmond From: Desmond Lee [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: help with syntax of left outer join Date: Tue, 13 Aug 2002 14:34:06 -0700 Hi there I want to do a left outer join but i also have a bunch of where conditions in my sql statment that i need. Can anyone help me out: SELECT title, authorName, journalName, journalPages, aname, tname, avg(ranking) FROM publications, area, topic, pubTopicInt, LEFT OUTER JOIN ranking publications.pubID = ranking.pubID WHERE publications.areaID = area.areaID AND publications.pubID = pubTopicInt.pubID AND topic.topicID = pubTopicInt.topicID AND publications.pubID = ranking.pubID AND publications.pubID = 3 GROUP BY (publications.pubID); I look at the mysql documentation, but i couldn't really understand their examples when they had additional where cluases. THanks Desmond _ Chat with friends online, try MSN Messenger: http://messenger.msn.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 _ Chat with friends online, try MSN Messenger: http://messenger.msn.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
exporting data
Hi guys I know that you can import data into a table by using 'load data infile' or 'mysql' import. however, is there something that allows you to export the create statemtns for the table schema and the data of a database for backup. SO that if we reinstall the whole thing from scratch all we need are the exported files that will recreate the whole database from the time we exported? Thanks Desmond _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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
Re: exporting data
Thanks Jeremy :) From: Jeremy Zawodny [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Desmond Lee [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: exporting data Date: Fri, 2 Aug 2002 15:59:01 -0700 On Fri, Aug 02, 2002 at 03:55:52PM -0700, Desmond Lee wrote: Hi guys I know that you can import data into a table by using 'load data infile' or 'mysql' import. however, is there something that allows you to export the create statemtns for the table schema and the data of a database for backup. SO that if we reinstall the whole thing from scratch all we need are the exported files that will recreate the whole database from the time we exported? mysqldump will do it. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 64 days, processed 1,352,277,811 queries (240/sec. avg) _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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
currency type
Hi there Does mysql have a currency type, or is it best to just use a varchar or a float? Thanks Desmond _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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
Re: currency type
Hi Mike Thanks for your reply Just to check the decimal(6, 2) means show 6 digits to the 2 decimals of percision. Thus you get a numbers like: 1.34 30.00 3344.92 Is that correct? Why do you not use a float and a decmial type? Thanks Desmond From: Mike(mickako)Blezien [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Desmond Lee [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: currency type Date: Tue, 30 Jul 2002 11:36:30 -0500 Desmond Lee wrote: Hi there Does mysql have a currency type, or is it best to just use a varchar or a float? Thanks Desmond I normally use the DECIMAL(6,2) data type, works very for currency values. -- Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(985)902-8484 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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 _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
do you need to define not null and unique?
Hello Just wnated to calrify something here. If you define your id in a table to be a primary key, do you also need to define it as 'NOT NULL' and 'UNIQUE'. I've notice in some examples like the following off the mysql site: CREATE TABLE animals ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, PRIMARY KEY (id) ); that they say the id col is not null, but do they have to since they've already defined it to be a primary key? Thanks Desmond sql _ Chat with friends online, try MSN Messenger: http://messenger.msn.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
graphical interface to mysql on red hat 7.3
Hi there I'm doing fine with the command line interface of mysql, no complaints from me. Howerver, another team member who knows nothign about mysql is more familiar with the windows stuff like access. Is there an graphical interface for mysql on red hat v7.3? I figured i'd ask here because this is the most direct and helpful way since there are a lot of guys (and gals) with mysql experience. Thanks Desmond _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
graphical interface to mysql on red hat 7.3
Hi there I'm doing fine with the command line interface of mysql, no complaints from me. Howerver, another team member who knows nothign about mysql is more familiar with the windows stuff like access. Is there an graphical interface for mysql on red hat v7.3? I figured i'd ask here because this is the most direct and helpful way since a lot of you guys (and gals) have way more mysql experience than I :) Thanks Desmond _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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
graphical interface to mysql on red hat 7.3
Hi there I'm doing fine with the command line interface of mysql, no complaints from me. Howerver, another team member who knows nothign about mysql is more familiar with the windows stuff like access. Is there an graphical interface for mysql on red hat v7.3? I figured i'd ask here because this is the most direct and helpful way since a lot of you guys (and gals) have way more mysql experience than I :) Thanks Desmond sql _ Chat with friends online, try MSN Messenger: http://messenger.msn.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
RE: help me out here guys... you gotta have a primary key
Hi Eric I dunno why people make 100 field tables, sounds a little harsh. I'll keep you in mind the next time i wanna make a 100 field table. Anyways, just to let you know mysql 4 will be supporting foreign key constraints. And yes thoes other db technologies like postGrep already support key constraints, but i thought (and correct me if i'm wrong) that mysql just performs a little better (maybe because of having no key constraints). But regardless of mysql not supporting foreign keys, i still put them in the defenitions of my tables because i believe it's good for documentation and also if we upgrade to mysql 4 things will be less painful when updating tables to use foreign keys. Is it such a big deal to use more than one field for a primary key? Two field keys are only a little slower than single field Primary keys for selects. Often in linking tables you want to have duplicates of the two foreign keys right? Not quite sure what you mean by having duplicates of a foreign key. I'm guessing you mean something like this in a linking table: Linking table __ authorID, bookID Author table _ authorID, firsname, lastname, ... Book table ___ bookID, name, pubDate, Thus the linking table will have a primary key of authorID and the bookID to uniquely id the row in the linking table. However, you can have this: LInking table _ 6, 1 7, 1 Author table _ 6, Puff, Daddy, ... 7, keanu, reves, ... Book table ___ 1, Bad acting and rapping cross over, 2000, Thus, the book Bad acting and rapping cross over is written by Both Puff and Keanu. Therefore you have multiple entries of the book with id 1 in the table. It appears 2 times on 2 different rows, but 2 times within the same column. (My apologies to keanu and puffy fans out there). Good luck with the 100 field tables, and thanks for your reply and all the other replies out there for this message. I'm glad to know that i'm not the only one that thinks having no primary key is NOT a good idea. I'll be sure to give my collegue a mouthful if he bitches about primary keys again. Thanks Desmond _ Chat with friends online, try MSN Messenger: http://messenger.msn.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
RE: graphical interface to mysql on red hat 7.3
Ya... i'll give it a try, thanks :) But do you know of any free graphical interfaces for linux that are not browser based? Thanks again (fast reply to ) desmond From: Shashank Tripathi [EMAIL PROTECTED] To: 'Desmond Lee' [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: RE: graphical interface to mysql on red hat 7.3 Date: Sun, 28 Jul 2002 20:14:25 +0900 Would a browser based interface do? http://phpmyadmin.sourceforge.net Cheers Shashank _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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
help me out here guys... you gotta have a primary key
k This is seems ridiculous to me,.. but i'll let you tell me if i'm just being stubborn. So, one of my associates has made a linking table (some people also call it intersection table, cross tab table, but i believe that the propper way to model a many to many relationship is via a linking table). in the linking table, there is no primary key defined. I believe that every table must have a primary key. It is absolutely essential, otherwise you'll get tons of problems including redundancy, and inconsistency. However, my associate believes that our coding will ensure that such problems will be avoided and that it's okay for a table to have no primary key defined. I totally disagree. Even if our code is perfect, a primary key must be defined. So, am i correct in being concerned, or am i just being close minded? If, i'm totally wrong, in what situations is it a good idea, okay, or benificial to not have a primary key defined for a table? Thanks Desmond (sql) _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
question about varchars
Hello there Mysql documentation says the following: values are stored using only as many characters as are needed, plus one byte to record the length. Values are not padded; instead, trailing spaces are removed when values are stored. So, then would there be anything wrong with making all my varchar's up to 255. That is defining most of my fields to be varchar(255) even when i know they may only go 100? Thanks Desmond _ Chat with friends online, try MSN Messenger: http://messenger.msn.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
question about varchars
Hello there Mysql documentation says the following: values are stored using only as many characters as are needed, plus one byte to record the length. Values are not padded; instead, trailing spaces are removed when values are stored. So, then would there be anything wrong with making all my varchar's up to 255. That is defining most of my fields to be varchar(255) even when i know they may only go 100? Thanks Desmond _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
Re: THIS IS NOT AN ADVERTISEMENT
From: [EMAIL PROTECTED] To: Desmond Lee [EMAIL PROTECTED] Subject: Re: THIS IS NOT AN ADVERTISEMENT Date: Thu, 25 Jul 2002 03:37:48 +0200 Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: { Original-Message-ID: [EMAIL PROTECTED] Original-Sender: Desmond Lee [EMAIL PROTECTED] Original-Subject: question about varchars Original-Date: Wed, 24 Jul 2002 16:42:31 -0700 } _ Chat with friends online, try MSN Messenger: http://messenger.msn.com _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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
Re: Setting up hostname
Hi Thanks for all your help, much appreciated. I edited my both the /etc/resolv.conf and /etc/hosts to include the line 'hostname 142.135.134.154' of course, that's not my real ip addy. Am i suppose to edit these files? or did you mean to edit the /etc/sysconfig/network file. THe /etc/sysconfig/network file already had the proper hostname entry in it, so i left it at that. and after that to do final check, just run : hostname ... till it shows you your real_host_name, if it doesn't just mail me :D when i type, hostname, i still just get my own ip addy shown to me. Do i have to reboot, or reinitialize some variables. THanks a bunch for you help. It's greatly apprecaited. REgards Desmond -- Let's call it an accidental feature. -- Larry Wall MySQL 3.23.51 : up 17 days, Queries : 362.846 per second (avg). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 up hostname
Hi there Thanks for your reply. check your system configuration ... just run from shell script : hostname and what does it show you ... WHen i run 'hostname' i get my ip address shown to me. and then check your /etc/hosts and /etc/resolv.conf my /etc/hosts has the following in it: # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 testbox localhost.localdomain localhost my /etc/resolv.conf has the following in it: nameserver 137.82.1.1 nameserver 137.82.22.12 after you sure your hostname has been configured properly (on OS side), then restart your mysqld ;-) should be work by then ... I'm not too too sure how to make sure that my hostname has been configured properly. I'm still in the works of getting a domain name, so no domain name has been set up to look up the ip of my box. When I do register a domain name, I know i have to modify my httpd.conf to get apache to work, but do i have to do anything for any other system, mysql, php, or apache files? Thanks Desmond _ Chat with friends online, try MSN Messenger: http://messenger.msn.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
Setting up hostname
Hi guys I just managed to install mysql... yippy But, i had to use the '--force option' when executing the /usr/local/mysql/scripts/mysql_install_db . I got a message saying that i needed to configure the hostname latter on. So, now that mysql is isntalled i need to set up the hostname stuff. My host name is just my ip address. And the message also said that it couldn't lookup my host? I've done searches on google and the mysql documentation but i didn't get any useful info about setting up the hostname. I'm just wondering if anyone out there can help me out. Thanks Desmond _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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