RE: java.sql.SQLException: Cannot connect to MySQL server onlocalhost:3306.

Hi Venu, Thanks for ur response. Ur first guess is correct ... mysqld server is not running. But whenever i tried to run it, it is showing this error: 08 13:59:01 Can't start server : Bind on unix socket: Address already in use 08 13:59:01 Do

Mysql start on RH Linux 7.1

Hello, I have the following Mysql installed on a RH 7.1 PC: mysql-server-3.23.36-1 mysql-3.23.36-1 mysql-devel-3.23.36-1 php-mysql-4.0.4pl1-9 mysqlclient9-3.23.22-4 unixODBC-mysql-2.0.7-1 If I try to start Mysql as root, as explained in: http://www.mysql.com/doc/S/t/Starting_server.html I get

Re: java.sql.SQLException: Cannot connect to MySQL server on localhost:3306.

Hi Venu ! First, u should try use : Connection con = DriverManager.getConnection(HOST + DB, ACCOUNT, PASSWORD); intead of Properties. I writer java servlet, so i placed mm.driver in lib dir of each context, what's version of yr mm.driver, i'm using 2.0.4. u can know what's port running by

FULL TEXT results

Hi Having a few weird things with the FULL text Match, it's bringing back records where there is definitely no match but the score is above 1. Using the following SQL: SELECT tblText.ID, tblText.Title, MATCH (pagetext) AGAINST ('thornham manga') AS score FROM tblText WHERE MATCH (pagetext)

Re: column maximum?

Hello Kurt! Just to expand a little on the 'whys' of ryan's post... On 17 Nov 2001 [EMAIL PROTECTED] wrote: I'm creating a table, and because i'm a fan of single-table databases, its turning out to have many colums. (It will have over 1100). Will this be possible? Will this cause

Re: Name of the Driver file ?

You should install MyODBC. Peter http://www.mysql.com http://www.unixodbc.org On Saturday 17 November 2001 23:34, Chaudhary, Prem Shankar wrote: Hi all, I want to connect through ODBC Driver Manager(libiodbc-3.0.5) to MySql Server. Can you tell me the MySql driver's Name path of

Re: Mysql start on RH Linux 7.1

(me looking down, ashamed...) Of course Usual RH style. I know it and use it for many other services, but for God knows which reason I just did not think about it this time. Maybe because I only wanted to experiment, not use it as a regular daemon to start at boot time every time.. Now it

List Info

Bill, Actually, there *is* a digest -- send mail to [EMAIL PROTECTED] the information about this and all other listserver commands is in the welcome message that you should have received as your first mysql@lists email. I have been using the digest. BUT... All of Bernie's comments are right

Re: R: Access denied for the new created user!

Hi, It still failed. But if I tried to use GRANT to create a new user without password, then this new user can access MySql; Why? How can I fix it? Please help! Thanks! wei --- Riccardi Moreno [EMAIL PROTECTED] wrote: Before login with new account you must reload server with this command:

read only message

i am using linux redhat 7.2. on my home computer.. i am logged on as root@localhost. i get a message that my table is read only. i thought the root user had all privileges and i cannot figure out how to give myself the privilege to change and alter my database and tables after i just created

Re: FULL TEXT results

Hi! On Nov 18, johnlucas-Arluna wrote: Hi Having a few weird things with the FULL text Match, it's bringing back records where there is definitely no match but the score is above 1. Using the following SQL: SELECT tblText.ID, tblText.Title, MATCH (pagetext) AGAINST ('thornham manga')

Dumb Question: Listing tables in telnet

I looked all through the documentation for this and I cannot find the command for listing tables in mysql in telnet. I get this: Mysql show tables - I have no idea what the arrow does and what I am suppose to do with it. I type in commands and it just does another - What is that? Thank you,

Re: read only message

The message means that the databse files themselves have incorrect permissions for the user mysql is running as. ps -ef | grep mysql will show who mysqld is running as. Then check the owership/permissions of the files to see if they are owned by that user. I think you'll find they are not

Re: Dumb Question: Listing tables in telnet

- is a continuatin line for your sql stamement. Remember yo conclude your statement with a semi=colon... Denis Todd Williamsen wrote: I looked all through the documentation for this and I cannot find the command for listing tables in mysql in telnet. I get this: Mysql show tables - I

Recursive select to produce hierarchical listing

I am trying to display a hierarchically related list of folders via a recursive SQL statement (each row in a table represents a folder). What is needed is a select that will sort the folders and associate the parent folder with their child, sub-folders. The kicker is that the items in the

Re: Dumb Question: Listing tables in telnet

On Monday 19 November 2001 01:25, Todd Williamsen wrote: I looked all through the documentation for this and I cannot find the command for listing tables in mysql in telnet. I get this: Mysql show tables - I have no idea what the arrow does and what I am suppose to do with it. I type

Re: DBMS that integrates well with object-oriented programming

BH After converting the data in my project from text files to MySQL BH tables, things are certainly working more smoothly than they were BH before, but since I use objects (in Perl, which barely supports BH objects, but that's another story) I have to write a lot of annoyingly BH repetitive code

Re: read only message

Have you tried checking the permissions on the .frm files? --Russell - Original Message - From: Barbara Ferrell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 18, 2001 9:08 AM Subject: read only message i am using linux redhat 7.2. on my home computer.. i am logged

RE: java.sql.SQLException: Cannot connect to MySQL serveronlocalhost:3306.

Hi, -Original Message- From: Prasad Valmeti [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 18, 2001 12:42 AM To: [EMAIL PROTECTED]; Nguyen Trong Phuc; [EMAIL PROTECTED] Subject: RE: java.sql.SQLException: Cannot connect to MySQL server onlocalhost:3306. Hi Venu, Thanks

Can not create a new user @% under windows98?

Hi, I found that if I set it as user1@localhost, other than @%, it worked. Anyone knows how to create users who can access MySql from anywhere under windows OS? Thanks! --- wei song [EMAIL PROTECTED] wrote: Hi, It still failed. But if I tried to use GRANT to create a new user without

pdf and html-split manuals

I'm looking for the pdf and the html-split manuals for MySQL-3.23.44 The one page manual is included in the source distribution, but all I can find on the website for split and pdf versions are for MySQL-4.0 alpha, which I'm not ready to run yet (not that I don't trust them, just that 3.23

Update using 2 tables

When will MySql support the UPDATE statement with more then one table. E.g. UPDATE table1, table2 SET table1.col1=table2.col1 WHERE ... Or ist there a work around? Many regards, Michael - Before posting, please check:

error while connecting to mysql

hello I'm running a server mysql 3.23.44 on a debian potato I start my server with : mysqld -u mysql mysqld: ready for connections I configure my pass for root. when I connect to it with mysql -p it works but mysql -h p204.mde.emn.fr -p Enter password: ERROR 2013: Lost connection to MySQL

Re: truncates

Richard Clarke wrote: I thought truncates were supposed to be really fast. I don't really notice any difference in speed between a truncate query and a delete query. What is actually involved in a truncate. The docs says its faster because a drop and recreate occurs but how is this actually

Re: pdf and html-split manuals

Hi Michael, - Original Message - From: Michael A. Peters [EMAIL PROTECTED] I'm looking for the pdf and the html-split manuals for MySQL-3.23.44 The one page manual is included in the source distribution, but all I can find on the website for split and pdf versions are for MySQL-4.0

Re: how do you find out which table fields are foreign keys?

Hi Bennett, - Original Message - From: Bennett Haselton [EMAIL PROTECTED] Just wondering if anyone who knew the answer to this might have missed it before -- sorry to keep nagging but I really need to find out how, or whether, you can determine which fields in a table are foreign

Re: how to handle circular references if DB enforces ref. integrity

Hi Bennett, - Original Message - From: Bennett Haselton [EMAIL PROTECTED] In a database that enforced referential integrity, if you say that a field in one table is a foreign key referencing another table, then any value in the foreign key field in the first table must reference an

Treating multiple records as a single-multiple value

mysql create database colors; Query OK, 1 row affected (0.01 sec) mysql use colors Database changed mysql CREATE TABLE Colors( - - cid INT UNSIGNED NOT NULL, - data VARCHAR(10) NOT NULL - ); Query OK, 0 rows affected (0.06 sec) mysql insert into Colors

DB Access problem

Hi, I just installed MYSQL verion 3.23.44-max version. I verified the default database tables under tool WinMySQLAdmin and I could see all tables and fields of default databases. As per security advice, I removed the default user with command DELETE FROM USER WHERE HOST=localhost and

Re: Dumb Question: Listing tables in telnet

Todd, The arrow is like the PS2 prompt from your shell in Unix. That is, the first line of your command says Mysql and every line thereafter is just a greater-than. This is because the mysql client is waiting for more commands. You can enter more than one command at a time this way, and not

Release 3.23.44 Binary Distribution

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [The Script safe_mysqld terminates with an errcode: 13] Description:

Table1 [CROSS] JOIN Table2 means what??

The current Reference Manual does not explain certain types of JOIN. Specifically: table_reference [CROSS] JOIN table_reference is nowhere explained. - Before posting, please check: http://www.mysql.com/manual.php

Column headers using SELECT * INTO OUTFILE...?

Hello Is there a way to include table column names as headers using 'SELECT * INTO OUTFILE...'? Cheers James A Robertson - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Column headers using SELECT * INTO OUTFILE...?

On Mon, Nov 19, 2001 at 03:19:41PM +1300, James Robertson - Composite Design wrote: Hello Is there a way to include table column names as headers using 'SELECT * INTO OUTFILE...'? Cheers James A Robertson No. SELECT selects data from the table. The column names are not table data.

nested select queries

hi everybody, i have a simple problem, but somehow i couldn't solve it i hope someone overthere can help me. i have a select query as below: select no,subject,ndate from cat1 where news like '%+search+%' limit +page_no+,5 i also want to find out how many rows are there in the result set. what is

HANDLER strange behaviour

If you open a table using HANDLER, e.g, HANDLER MYTABLE OPEN; then during the course of your application truncate that table, e.g, TRUNCATE TABLE MYTABLE; then you get some really wierd behaviour (my wierd behaviour was the application rolling on a free in a completely different part of

Re: Problem compiling MySQL 4.0.0 on FreeBSD 4.0-RELEASE

In the last episode (Nov 18), Ovanes Manucharyan said: Hi, I have a problem compiling MySQL on FreeBSD 4.0-RELEASE. ./configure --with-libwrap --enable-shared gcc -DHAVE_CONFIG_H -I. -I../.././innobase/pars -I.. -I../.././innobase/pars/../ include -I../.././innobase/pars/../../include

database slow down

This is a followup to my previous messages indicating database slow down. After noticing the queries start to slow down earlier i decided to try and get some debug info. a show table status had one interesting thing. | raw| InnoDB | Fixed | 169681 | 1030 | 174817280 |

Re: many similar requests - 1 request

Hi Boris, Try this: Select ifnull(position1,0)+ifnull(position2,0) As slno, title from book where ifnull(position1,0)+ifnull(position2,0) = 200 order by slno Anvar. At 09:49 PM 17/11/2001 +0100, you wrote: hi fellow mysql users :) i'm programming a little application, and i do the following

Re: Problem compiling MySQL 4.0.0 on FreeBSD 4.0-RELEASE

Thanks, I tried it again and it worked. (at least it seemst to have created some seemingly working binaries.) (I had tried 5 times to no avail before I sent a message to the list.. so go figger.) Now to my real problem. I'm trying to make udmsearch work and it needs libmysqlclient.so.10. I

mysql+myodbc+coldfusion

Hi I am currently trying to get coldfusion, mysql, and myodbc to live happily together on a windows 2000 machine. However i keep getting a [TCX][Myodbc]Transactions are not enabled error. In the setup for the system dsn I have NOT disabled transactions. So whats up? any help would be really

Re: Here's a good one

On Thu, Nov 08, 2001 at 03:26:55PM +1300, Quentin Bennett wrote: Excuse the poor formatting Please use '\G' next time. Any comments on the 'Time' column for Connection 115 anyone? It's a bit insane. The queries are running fine, just wondered why the value is screwed. 3.23.40 Solaris 8

Re: Problem compiling MySQL 4.0.0 on FreeBSD 4.0-RELEASE

In the last episode (Nov 18), Ovanes Manucharyan said: Thanks, I tried it again and it worked. (at least it seemst to have created some seemingly working binaries.) (I had tried 5 times to no avail before I sent a message to the list.. so go figger.) Now to my real problem. I'm trying to

RE: mysql+myodbc+coldfusion

Hi, -Original Message- From: berndt [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 18, 2001 8:49 PM To: [EMAIL PROTECTED] Subject: mysql+myodbc+coldfusion Hi I am currently trying to get coldfusion, mysql, and myodbc to live happily together on a windows 2000 machine.

Benchmarking

Dear all, I've been trying benchmark MySQL, SQL Server 7, and M$ Access 97. But, SQL Server 7 and M$ Access is won when connected and opening recordset using ADO, Even i'm using MyODBC with TCP/IP connections. If i'm use cursorlocation=serverside with adOpenDynamic, and adLockOptimistic, still

Getting the length of a field

Hi, can you count the number of characters in a field with MySQL? The length(str) function seemed like a choice tool but can it be used to get the length of data in a field or is there some other way? Jari Mäkelä - Before