unable to access mysql as anyone besideslinux user= root

whenever I try to connect to mysql logged on as anyone besides root I get teh error below. This isnt' making sence to me. The ps-ef output and the permissions info is also included. mysql 2524 2500 0 15:41 pts/100:00:00 /usr/sbin/mysqld-max --basedir=/usr --datadir=/var/lib/mysql

Customized auto-increment serial number

Hi, I've a unique requirement where the transaction number should be automatically generated (increment). I can't use AUTO_INCREMENT column. The TRAN_NO is supposed to be in MF format, where: Field: TRAN_NO CHAR(10) M = Encoded current month (A: January, B: February, C: March . L:

mySQL character set problem

Hi, I have just found a major problem with my site. This is my problem: My server has been running on a redhat 7.3 distro without any problems for some time now. I then purchased a new server, which is running Redhat Linux ES 3.0 with the same basic settings and same install options. When

Multiple Order By

I want to order my articles in descending order on date, and for articles on the same date I want to order by ID in ASC. I've tried the following: ORDER BY EntryDate DESC, ID ASC But it does the EntryDate Order but nothing else. The problem I have is I don't want to record the time (the user

Re: Multiple Order By

Ian ORourke said: I want to order my articles in descending order on date, and for articles on the same date I want to order by ID in ASC. I've tried the following: ORDER BY EntryDate DESC, ID ASC But it does the EntryDate Order but nothing else.

netstat

I'm running a web server with Apache Tomcat and mySQL for the first time and I've been following various recommendations to make the server more secure (it's Linux Debian). One of these recommendations is to keep the number of open ports to a minimum. I'm looking at netstat (see the output

Re: Fulltext search

Is it possible to create a InnoDB table and a MyIsam table with fulltext indexes and use a join to search in fulltext indexes? Santino At 18:43 -0600 23-01-2004, Paul DuBois wrote: At 18:34 -0600 1/23/04, Sidar LC. wrote: How can I implement fulltext search engine on InnoDB and MySQL 5. You

mySQL character set problem

The first things you should check: 1. Do \s from the mysql client to be sure its using the character set you told it to use with default-character-set=latin1. Be sure its the same one you used on your old server. 2. Since you have the Norwegian keyboard set up try typing Norwegian characters

RE: [Mysql-discussions] netstat

Hi adam, you can tell mysql to listen on 127.0.0.1, the loopback interface, --bind-address=IP , add that to the startup parameters of MySQL if you require access from othermachines to your db but want to restrict every other host, you can , or you should use a firewall.. iptables is a good

Query was empty -- any ideas

Hi, This script keeps returning the error Query was empty via php's mysql_error() function. I think this is just a run-of-the-mill query, of which I have hundreds on this site. I just can't figure this out... any ideas? I'm probably missing something small. I have tested the variables and

Websphere and mysql

Hello: I have been trying to configure websphere 5 to use mysql. I have set up the datasource using the mysql driver and whenever I test the connection from the websphere admin console, I get the following: Test Connection failed for datasource Securance Datasource on server server1 at node linux

Re: Query was empty -- any ideas

Okay, I feel dumb. After seeing my message appear on the list, in a different font, I can see that here: $result = mysql_query($sq12,$connection) or die (mysql_error()); I typed $sq12 instead of $sql2 -- sorry! Works now. Sam Sam Folk-Williams wrote: Hi, This script keeps returning the

RE: [Mysql-discussions] Websphere and mysql

if you can normally connect with plain settings to the mysql server, then it might be the drivers from websphere, which then tell me, ask them :) in addition you can dump traffic from the websphere thingy to your db server in order to see WHAT the packages are carry-ing so that you can see for

Re: Customized auto-increment serial number

On 25-Jan-2004 Hassan Shaikh wrote: Hi, I've a unique requirement where the transaction number should be automatically generated (increment). I can't use AUTO_INCREMENT column. The TRAN_NO is supposed to be in MF format, where: Field: TRAN_NO CHAR(10) M = Encoded current

MySQL and dates before 1000-01-01

Reading the details of the Date and Datetime datatype at: http://www.mysql.com/doc/en/DATETIME.html I see that 1000-01-01 is the earliest date that MySQL supports in this datatype. We have an application that needs to store a lot of historical data, the majority of which will fit nicely above

Re: MySQL and dates before 1000-01-01

Roland Corbet said: However, although there are relatively few pieces of history we need to store before the year 1000 they are equally important. We are likely to have dates such as 0005-04-10 or even BC dates (-)3000-00-00. Alternatively, is there a better method which I could use? For

Re: Bug in Boolean mode fulltext searching.

Joe Rhett wrote: mysql select Notice_ID from Notices where match (Text) against ('+pollution +control' in boolean mode); Empty set (0.00 sec) mysql select Notice_ID from Notices where match (Text) against ('pollution control' in boolean mode); Empty set (0.02 sec) mysql select Notice_ID from

libcrypto.so.0.9.6 is needed by MySQL

I have a new box that I am trying to install 4.1.1 on, and whenever I try to use rpm to install either MySQL-shared-4.1.1-0.i386.rpm or MySQL-shared-compat-4.1.1-0.i386.rpm. I get the dreaded messages below: [EMAIL PROTECTED] src]# rpm -i MySQL-shared-compat-4.1.1-0.i386.rpm warning:

Re: optimizer: GROUP BY unnessesary slow using ANSI notation for redundant group by's.

Hi! On Jan 24, Stefan Traby wrote: Hi ! For my forum system, I use the following query to generate the main-overview: (using 4.0.16-log) select f1.id as BoardId, f1.name as Board, f1.more as BoardDesc, f2.id as AreaId, f2.name as Area, f2.more as

Initial running of MySql on OS X 10.3

I installed mysql on my Mac Powerbook 10.3 and cannot access the server even though it seems to be running. I get the socket error as seen below. I used the disk img package from the mysql website. Kevins-Computer:~ kevinbarry$ sudo /Library/StartupItems/MySql/MySql start Password: Starting

How to write such query?

I want to get distinct title from table titles. But there are two differnt titles (new and used).So I need somehow join all three tables where user_tiles status='true' and titles are distinctive. Thanks titles

Re: Initial running of MySql on OS X 10.3

Kev wrote: I installed mysql on my Mac Powerbook 10.3 and cannot access the server even though it seems to be running. I get the socket error as seen below. I used the disk img package from the mysql website. Kevins-Computer:~ kevinbarry$ sudo /Library/StartupItems/MySql/MySql start Password:

Re: Fulltext search

Santino [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Is it possible to create a InnoDB table and a MyIsam table with fulltext indexes and use a join to search in fulltext indexes? Santino Yup.. you can.. create the tables on the same DB and make a JOIN.. -- MySQL General

auto sorting

Hello All, I got a table with a VARCHAR(255) field as a primary key, but when I insert a new row it inserts it ordered by the key. Then, when I select rows without doing any order, it returns the rows ordered by the primary key. How can I insert a new row to the end of the table, and select

re: auto sorting

Why don't you want to use an ORDER BY? I think its the _only_ way to get a stable order. It sounds like you want to retrieve your rows in the order in which they were entered. If you don't want an auto_increment field you could order by a timestamp.

start / end dates for each week of year?

Does anyone know of a way to get the start and end dates of each week of the year (preferably starting on Mondays) using v3.23? Here's why: I am trying to extract the sum of a column for each week. No problem, I use group by yearweek() to get it. So my query looks like this: select

Re: auto sorting

Am Sunday 25 January 2004 23:17 schrieb Lorderon: Hello All, I got a table with a VARCHAR(255) field as a primary key, but when I insert a new row it inserts it ordered by the key. Then, when I select rows without doing any order, it returns the rows ordered by the primary key. That's by

Japanese in version 4.0

Hi, I need to implement a search in japanese (and also in english). Can 4.0 accept japanese characters and sort them From the documentation I see that it supports: EUC-JP Japanese or Shift-JIS Japanese a. What are the differences btw the two. b. How do i get the mysql to implement the sort.

RE: Initial running of MySql on OS X 10.3

I've run all of the installation procedures and database initialization steps in entropy.ch and still get a number of errors such as no access to the /data directory in order to view the error log. I get this error on attempting to initialize the database: Kevins-Computer:/usr/local/mysql

Weird bug in MySQL and Mac OS X 10.3

I've had some very weird issues that I've posted about here in the past, but no one was able to help. I posted a bug report on mysql.com and have received some advice on how to suppress the problems I was having. The problem seems to be exploited when running a slave server on OSX 10.3.x;

key constraint error on replace

Hi there, i am trying to use a replace, when mysql throws an error of Cannot delete or update a parent row: a foreign key constraint fails , is there any way to get more information like which key is having the issue, is there more detailed information i can extract ? -- MySQL General Mailing

Database design

Can someone explain a 1:n non identifying relation? Brian Duke

Re: netstat

Adam Hardy wrote: I'm running a web server with Apache Tomcat and mySQL for the first time and I've been following various recommendations to make the server more secure (it's Linux Debian). One of these recommendations is to keep the number of open ports to a minimum. I'm looking at netstat

Re: key constraint error on replace

Hi there, i am trying to use a replace, when mysql throws an error of Cannot delete or update a parent row: a foreign key constraint fails , is there any way to get more information like which key is having the issue, is there more detailed information i can extract ? -- It seems to work

Re: Database design

Duke, Brian wrote: Can someone explain a 1:n non identifying relation? Brian Duke Yes. I'm Dan, and I'm unique; there's only one of me. However if I like a store after an initial purchase from them, I may go back and another purchase. 1:n User:Purchase Dan -- MySQL General Mailing List

Re: Initial running of MySql on OS X 10.3

Kev wrote: I've run all of the installation procedures and database initialization steps in entropy.ch and still get a number of errors such as no access to the /data directory in order to view the error log. I get this error on attempting to initialize the database:

subqurey syntax error

I am getting the error message: mysql SELECT s1 FROM t1 WHERE s1 IN(SELECT s1 FROM t2); ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near 'SELECT s1 FR OM t2)' at line 1 mysql I am using