How to connect Windows client to a MySQL server in Linux

Hi, I really frustrated because I could not connect my WIN98 client to the MySql server installed on a Linux Server. The MySQL is of version 4.0.1 in a RedHat Linux 7.2, also I install a MyODBC version 3.5 in the client machine. In fact, I am using PowerBuilder on Windows platform as a

mysqldump : help needed very urgent

Hi! Chetan == Chetan Lavti [EMAIL PROTECTED] writes: Chetan Hi, Chetan I am using Mysql version 3.23.47-Max client and server and using Innodb Chetan table type. Chetan I am doing my database backup using the mysqldump utility. Chetan Once I have done with database backup, I am deleting all

a tough(?) query problem

hi I need to select the ten latest entries from a diary-database, but i don't want to get any duplicate users, so if i want to select the ten latest entries and someone has written five entries of these latest ones, i only want to get the latest entries from each user. So far no problem, my

The table 'SQL746e7_0' is full

What are the various reasons that could explain the following error message. It happens as a result of an equi-join. The table 'SQL746e7_0' is full How can I get additional information such as where is that table being written to disk (I could check the amt of free disk space). Thomas S.

RE: How to connect Windows client to a MySQL server in Linux

The full error is probably access for Host denied. Look at http://www.mysql.com/doc/A/c/Access_denied.html for the answerer and search the new's group archives on how to GRANT the HOST access to the database. -Original Message- From: TH Leung [mailto:[EMAIL PROTECTED]] Sent: Sunday,

pattern matching (in text field)

Hi all, I currently have $result = mysql_query (SELECT title_id, title FROM documents_tbl, url_tbl WHERE (documents_tbl.title_id = url_tbl.url_id) AND keywords LIKE '%$temp%' AND title_id != '$myrow[title_id]'); this works to an extent, but 'keywords' is a text field and if $temp is for

table name including current date

Hello, I am trying to write a script that creates tables via a cronjob but I want to name these tables including the current date as a suffix -like transections_20020324- . Does anybody know the SQL statement that entegrates the table name with the current date? I tried to do it by storing the

Table created on script Err

After creating a script to create customer table for Meet_a_Geek with an editor and named it 032302.sql. It was saved in the folder called. c:\my download files\. Then at at the mysql\bin prompt I typed mysql c:\my download files\032302.sql. hoping that this table would be readed and created

Re: pattern matching (in text field)

At 17:02 + 3/24/02, julian haffegee wrote: Hi all, I currently have $result = mysql_query (SELECT title_id, title FROM documents_tbl, url_tbl WHERE (documents_tbl.title_id = url_tbl.url_id) AND keywords LIKE '%$temp%' AND title_id != '$myrow[title_id]'); this works to an extent, but

Re: table name including current date

At 19:00 +0200 3/24/02, Okan CIMEN wrote: Hello, I am trying to write a script that creates tables via a cronjob but I want to name these tables including the current date as a suffix -like transections_20020324- . Does anybody know the SQL statement that entegrates the table name with the

Warnings after LOAD DATA statement

Hi all, I'm new to the list and new to MySQL. I've been working on creating my first db and I've encountered a problem I'm hoping someone here can help me with. I have a text file with the following three lines: V-AIG001|AIGLON'S MUSIC VIDEOS|http://www.aiglon.prv.pl/|\N| V-AIG002|AIGLON'S

Re: The table 'SQL746e7_0' is full

On Sun, Mar 24, 2002 at 08:22:59AM -0700, Tom Brettin wrote: What are the various reasons that could explain the following error message. It happens as a result of an equi-join. The table 'SQL746e7_0' is full How can I get additional information such as where is that table being

RE: Warnings after LOAD DATA statement

-Original Message- From: Maribel Piloto [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 24, 2002 10:24 AM [snip] The data is loading fine and the NULL values are in fact correctly entered as NULLs but I'm getting this warning after the LOAD statement: Records: 3 Deleted: 0

rpm rebuild failure

Hello. I would value your help in resolving a problem I had which makes it impossible for me to install MySQL on my system. I would like to report that : rpm --rebuild MySQL-3.23.49-1.src.rpm FAILED on my system - Redhat 6.2 on an i686 box. I had to do this as I had glibc devel 2.1.3-15,

Full Text Multicolumn search bug

Description: It appears that adding a full text field to multiple columns can cause the database to crash. How-To-Repeat: Set ft_min_word_len=2. Create a database and run the SQL script at http://gear.moregadgets.com/~nickkral/newscrash.sql Fix:

Re: Warnings after LOAD DATA statement

At 13:23 -0500 3/24/02, Maribel Piloto wrote: Hi all, I'm new to the list and new to MySQL. I've been working on creating my first db and I've encountered a problem I'm hoping someone here can help me with. I have a text file with the following three lines: V-AIG001|AIGLON'S MUSIC

RE: Warnings after LOAD DATA statement

At 10:50 -0800 3/24/02, Nick Arnett wrote: -Original Message- From: Maribel Piloto [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 24, 2002 10:24 AM [snip] The data is loading fine and the NULL values are in fact correctly entered as NULLs but I'm getting this warning after

InnoDB monitor

Hi, Can anyone tell me how to use the InnoDB monitor please. After creating the table with the following command: CREATE TABLE innodb_monitor(a int) type = innodb; I don't know where to watch the output from the InnoDB monitor. Can anyone help? Balteo. (sql,query)

Problem building DLL library, undefined references (mysql) - macros?

I am buiding an extension to tcl which involves linking to the mysql library. I have done this before on Microsoft VC5.0 but nolonger have access to that and so am using Cygwin Mingw. Trying to build my extension I get the following output, any ideas or help would be greatly appreciated.

Re: StartTransaction

At 17:20 -0300 3/24/02, Edilson Vasconcelos de Melo Junior wrote: Hi, Is there anyway to start transaction, do rollback and/or commit changes using mysql c api? Same way you issue any other statement. Use mysql_query() or mysql_real_query() to issue statements like BEGIN, COMMIT, ROLLBACK, SET

Re: Table created on script Err

At 12:20 -0500 3/24/02, alan4100 wrote: After creating a script to create customer table for Meet_a_Geek with an editor and named it 032302.sql. It was saved in the folder called. c:\my download files\. Then at at the mysql\bin prompt I typed mysql c:\my download files\032302.sql. hoping that

Grant all on my mysql.*

mysql mysql Grant all on mysql.* to 'root''localhost' identified by password; Query OK, 0 rows affected (0.00 sec) == At this point the priveleges are granted to root@localhost. mysql \q Bye I had to type \q to quit and type in the following: But .

Re: Grant all on my mysql.*

You set a password for root, so you must use it to connect as root. That is, you must use -p, like this: C:\mysql\binmysql -u root -h localhost -p You'll then be prompted for the password. This is covered in the manual. Michael On Sun, 24 Mar 2002, alan4100 wrote: mysql mysql Grant

Re: Grant all on my mysql.*

mysql Michael, This time it went through fine only when I typed in mysql -u alan -h localhost -p It went through fine because I already set up alan for username as well as the pasword for (alan). You said I could only use mysql -u root -p to go through! Perhaps, it will go through even

Re: Table created on script Err

mysql Paul, I was afraid to hear that. It had said about line 2 in the error message. This line #2 looks normal. May I ask you to check this script below, but I am afraid it may be annoying. I will eventually put this on posting. Remember I use Windows XP. I would like to know if there is

Connect Mysql on Linux from Windows

Dear Miliser I am new member here, and I would like to ask about connection at Mysql. I have MySQL on linux server and I want to connect that MySQL engine from windows, how can I connect to that mysql now I've been install Mysql-ODBC and MySQLFront on windows, but there is still an error

Re: Grant all on my mysql.*

mysql Michael, You can look at the results after the dash lines. You will notice mysql -u root -h localhost -p does not help at all. I clicked enter to by pass the password;it is acceptable for the root, but look at the results. C:\mysql\binmysql -u alan -h localhost -p Enter password:

Regarding Licence

Hai, I have one doubt regarding Licence of MySql. I want to develop one software based on MySql. And i want to distribute it in the market. To do this shall i need Licence for MySql. Why i am asking is MySql is available on InterNet at free. So, i am thinking i can distribute my software without

Re: Grant all on my mysql.*

mysql Michael, It is clear now after typing in p-a-s-s-w-o-r-d into the password for the user root. It then went through fine, but I never set up the password for the root user. Hope it will be clear later how the password had been stored for the user root. It had to occur before or during

RE: Regarding Licence

http://www.mysql.com/support/arrangements.html is pretty clear on what you need... M;) -Original Message- From: nagendra [mailto:nagendra%bartronicsindia.com] Sent: Sunday, March 24, 2002 7:05 PM To: [EMAIL PROTECTED] Subject: Regarding Licence Hai, I have one doubt regarding

re MySQLGUI

I have installed MySQLGUI ( Win32 static binary of MySQLGUI 1.7.5-2 ../Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip ) and have been able to connect the the server successfully. platform used: Win95 The Help function is not available. Is configuration required to access Help? your

slow search on INDEX?

Hi, I have this table: mysql describe eventlog; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(10)

Re: Grant all on my mysql.*

At 18:09 -0500 3/24/02, alan4100 wrote: mysql mysql Grant all on mysql.* to 'root'@'localhost' identified by password; Query OK, 0 rows affected (0.00 sec) == At this point the priveleges are granted to root@localhost. mysql \q Bye I had to type \q to

Wildcard and users...

Hi, I am wondering is there a way to set up user that can log in from anyplace? I know I need to set this user up with the %(I hope this is the wildcard for) mysql. Thanks, Chuck Payne - Before posting, please check:

Re: Grant all on my mysql.*

At 21:32 -0500 3/24/02, alan4100 wrote: mysql Michael, It is clear now after typing in p-a-s-s-w-o-r-d into the password for the user root. It then went through fine, but I never set up the password for the root user. Sure you did: At 18:09 -0500 3/24/02, alan4100 wrote: mysql Grant all on

RE: mysqldump : help needed very urgent

thank u very much... but I am planning for one approach is it right .. as by mysqldump we can take back up of Table structure and Insert values separately.. As my database will remain constant through out for the application I can insert the foreign key lines in the dumped file once and as the

Urgently required

Dear Arjen and Iko Rein, As I had been contacting you relating the MySQL related queries, I nned some more clarifications on that. 1. Can you please send me a write up on how to back up and restore in MySQL database. 2.Also I had got a mail from one of our customers could you please answer to

MySQL 3.23.46 corrupts MYD and MYI files frequently

Dear All, I having issues with MySQL on Linux corrupting our MYD and MYI files frequently. We get errors such as Can't open file: 'TABLE.MYD' which tells me the table data is corrupt/damaged. I can rebuild the index and recover the data correctly but this is the 2nd time in 2 weeks that this

myisamchk and table corrupt

Hello list, There's an corruption in my mysql table. I tried to use myisamchk -o to recovery, but still exists when I use myisamchk -s. What is the possible reason of the problem? linux95:/var/lib/mysql# myisamchk -s stocks/TimelyDeals.MYI myisamchk: ISAM file stocks/TimelyDeals.MYI

Dumb Newbie Keyword Search Question

I have been looking through the mailing list archives but I can seem to find a straight forward answer anywhere. I have a MySQL table with a variety of text columns I would like to search. Pretty basic... A web search form returning the users input $keywords. Some type of relevance system would

user group

hi, pls tell me how to create user group in mysql? thanks felik __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ - Before