Direct connection to mysql database

. is there anyway to do that ? Thanks. Regards, Alice /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee

Re: Direct connection to mysql database

, and then use the SQL command USE databasename to switch to other databases on the same server (if you have the right). alice [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Hi, all I would like to know is there anyway where i can connect to the mysql database without add the odbc dsn

newbie question: subareas

Just been using mysql for a couple of days, so this is possibly old ground, but i have searched and can't find any solution. i'm sure it must have come up before. The project is to allow resources to be shared amongst community groups throughout uk. there are a number of attributes that can be

Error encountered when Connect remotely in mySQL 4.0.15

, alice /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery

Need some explainations on mysql.err

of unusual entries in mysql.err, Can anybody tell me what's problem may causing the following abort in connection ? 030315 0:43:05 Aborted connection 2 to db: 'unconnected' user: 'ODBC' host: `localhost' (Unknown error) 030319 12:01:26 Aborted connection 4457 to db: 'employee' user: 'alice' host

stuck with converting a query from a sub query

portlet_fk FROM UserTabAssignment WHERE user_fk = 'guest' AND portal_FK = 'mysqlPortal' AND tabNumber = 0 AND subtabName = 'firstSubtab') thanks Alice Farbles - Before posting, please check: http://www.mysql.com

Re: MySQL secure access

. customer only access their own database only. - Original Message - From: Pae Choi [EMAIL PROTECTED] To: Alice Tan [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Thursday, November 28, 2002 8:33 PM Subject: Re: MySQL secure access If I am your customer and the data related to my web

MySQL secure access

server. But our customer requested to have their own access on their databases, which i don't want them to see those databases that not belongs to them. Can i do that ? Thanx in advance for anyhelp. regards, alice

Re: MySQL secure access

. can u specify more detail on that ?? - Original Message - From: Bhavin Vyas [EMAIL PROTECTED] To: Alice Tan [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Thursday, November 28, 2002 12:07 PM Subject: Re: MySQL secure access You can create separate databases (database directories

MySQL Installation

Hi, i am doing a setup program that eventually install mySQL, myODBC, and my system. during my system installation, it require mySQL is installed and already run the WinMySQLAdmin.exe, where by from there i will be able to do some record insertion on the db. but now, since for the first time we

how to shut down the mySQL service ?

Message - From: Amish K. Munshi [EMAIL PROTECTED] To: Alice Tan [EMAIL PROTECTED] Sent: Monday, October 28, 2002 3:57 PM Subject: Re: how to stop the mySQL service ? On Monday 28 October 2002 01:26 pm, you wrote: run in the DOS, i got this error .. am i doing wrongly ? C

Re: how to shut down the mySQL service ?

: Friday, November 08, 2002 11:15 AM Subject: Re: how to shut down the mySQL service ? Pada Fri, 8 Nov 2002 11:16:16 +0800 Alice Tan [EMAIL PROTECTED] menulis: Hi, i got the stop mysqladmin service done. but this time is how to shutdown the mysqladmin service ? this is due to when ppl

how to stop the mySQL service ?

How to stop the mySQL service instead of right click the traffic light and stop it ? is there any exe can stop the mySQL service ? i tried the mySQLShutDown.exe, but it didn't actually stop the service. i want to stop the mySQL service so that the mysqld-nt.exe wouldn't hold my database, which

Re: how to stop the mySQL service ?

: Monday, October 28, 2002 2:32 PM Subject: Re: how to stop the mySQL service ? mysqladmin shutdown On Mon, 28 Oct 2002, Alice Tan wrote: How to stop the mySQL service instead of right click the traffic light and stop it ? is there any exe can stop the mySQL service ? i tried

Using Install shield, how to do ODBC DSN setting ?

programs/script to make it work ? hope can get reply ASAP. thanx regards, alice /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you

Is mySQL support replication ??

Hi, all, May i know is mySQL support replication regards, alice /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you

Commit Trans

I want to used the begin trans and commit trans in my ASP program on top of mysql db. do anyone know how to do that ? thanx /---\ Confidential and/ or privileged information may be contained in this e-mail and any

mysqlhotcopy ..

but i still got no idea how to run mysqlhotcopy ? run in where ? how ? Original Message- On Fri, Jun 01, 2001 at 03:35:57PM +0800, Alice wrote: i have no idea on how to run mysqlhotcopy in the query tool or it is not suppose to run in query tool. is this correct

mysqldump

i saw % myswldump samp_db /usr/archieves.mysql.samp_db.1999-10-02 syntax in the Paul Dubois mySQL book, but this is command for unix, how abt windows syntax ?? /---\ Confidential and/ or privileged information may be

Re: RE: mysqldump

- Hello It's simple, if you installed mysql in folder c:\mysql just type this string in command promt (or START-RUN): c:\mysql\bin\mysqldump samp_db c:\archieves.mysql -Original Message- From: Alice [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 12:51 PM To: MySQL

mysqlhotcopy ..

i have no idea on how to run mysqlhotcopy in the query tool or it is not suppose to run in query tool. is this correct ? mysqlhotcopy db_name '/downloads/backupDB/' if i want it to backup in my c:\downloads\backupDB folder ??

password assign for localhost

at the moment, i am still connect to local host without a password. i did try to using query to update the MySQL db and update the user table on it for the user where it is 'root' my asp prog did connected to my db which have the connection string that the password is blank. but with the

Re: password assign for localhost

ahh .. help, after i follow what u said, and do the update in my password then flush privileges, now i can't even access my database with the password .. . so, how now ??? - Original Message - From: David Lidström [EMAIL PROTECTED] To: Alice [EMAIL PROTECTED] Sent: Thursday, May 31, 2001

how to convert my sql server data into mysql ??

i would like to convert my sql server data into mysql, how can i do ?? /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not

help ... db connection to asp prog !

hi .. i am a new user to mysql, i did install myODBC, but fail to create the db connection in the ODBC ... why it fail ??? /---\ Confidential and/ or privileged information may be contained in this e-mail and any

help .. db connection to asp prog !

hi .. i am a new user to mysql, i did install myODBC, but fail to create the db connection in the ODBC ... why it fail ??? /---\ Confidential and/ or privileged information may be contained in this e-mail and any

MySQL front end tool

Hi, i am a win2k professional user, and i would like to get a mySQL front end tools which can make mySQL to be work more user friendly. currently i am using MySQL-Front, for those who had tried out others this kind of tools, pls recommend any others tools that u think is more powerful,

how to creat stored procedure ??

Hi, i am a new userof mySQL, however i have experience inMSSQL server. ihave difficulties on creating stored procedure, triggers and views in mySQL. /---\ Confidential and/ or privileged information may be contained in