I can't find file mysqld.sym.gz!

hello~ When I try to Using a stack trace there's no mysqld.sym.gz on our server . Can we always find mysqld.sym.gz on any operating system? Our operating system is Linux 7.0 . I would like to mail you our error log to see if you can tell us what's wrong with our MySQL which always crash

Re: The table 'SQLb73d_0' is full

On Tue, Feb 19, 2002 at 09:50:57AM +0200, Mohamed Abd El-Samei Mohamed wrote: mysql insert into table1 select distinct field1 , MIN(field2) from table2 where field2 =2001-12-01 00:00:00 group by field2 ; ERROR 1114: The table 'SQLb73d_0' is full mysql I've seen this when MySQL uses an

While executing a query, Got error 22275 from table handler

Description: When i execute the following query on my database: SELECT retaillastdone_.* FROM retaillastdone_ WHERE (retaillastdone_.source_=mercury AND retaillastdone_.timestamp_ BETWEEN 97864920 AND 978735599099) ORDER BY retaillastdone_.owner_,retaillastdone_.timestamp_ ASC ;

I cannot start my server.

guo, Tuesday, February 19, 2002, 1:49:50 AM, you wrote: gl Dear Sir/Madam, gl I install mysql on my computer but it did not work. after installing the gl rpms, I use gnorpm to verify the installtion, and it's OK. but I couldn't gl start my server, after I ran mysql_install_db and safe_mysqld

consistency of NOW() function, and summary caching

I'm curious about what guarantees MySQL (and the SQL standard) provide with regard to multiple calls to NOW() within the same statement. If the statement takes a long time to execute, will NOW() be consistent across all invocations? The trivial example of this is if you're updating a large set of

Re: consistency of NOW() function, and summary caching

I'd also love any suggestions/criticisms of the above architecture. I'm trying to address what is a potentially significant performance issue for us (we hope to allow the main table to grow to tens to hundreds of millions of rows before pruning it down), but there might be a much simpler

Table overhead --

Mark, Tuesday, February 19, 2002, 5:34:34 AM, you wrote: MS Anyone know what causes overhead on a MySQL table? MS I wrote a JSP application using MySQL that uses updates and Inserts and have MS found that a lot of overhead exists. MS Of course if the table is optimized - the overhead is

How can i acheive 'Triggers' in MySQL

sreedhar, Saturday, February 16, 2002, 7:03:31 AM, you wrote: s Hi all, s How can i acheive 'Triggers' in MySQL. or equivalent to 'Triggers'. MySQL doesn't currently support triggers, look at: http://www.mysql.com/doc/T/O/TODO_sometime.html

The table 'SQLb73d_0' is full

Mohamed, Tuesday, February 19, 2002, 9:50:57 AM, you wrote: MAESM mysql insert into table1 select distinct field1 , MIN(field2) from table2 MAESM where field2 =2001-12-01 00:00:00 group by field2 ; MAESM mysql ERROR 1114: The table 'SQLb73d_0' is full MAESM please help to fix this error You

Re: Am I asking the wrong question?

Søren Neigaard wrote: HS To see if there are correct permissions check the db table ind Database HS MySQL - there you find Database specififc persmissions for each user. Yes in db the homebrew user did not have any permissions, so I change them manually, and now it all works. But why?

Re: Fulltext problems 4.0.1 part two

Hi! On Feb 02, Alexander Belyaev wrote: Hello, I have found a bug( or bad feature? :) ) in 4.0.1 boolean fulltext search Please help... -- select id,txt from test.logo_text where match(txt) against ('+desig* +service' in boolean mode) -- 2 rows in set (0.03

Any limit of the Query Buffer ???

Anyone here know if there is a limit of the number of query I can do in a Do While of a VB program ? --- Pascal Richer [EMAIL PROTECTED] Étudiant en Informatique et Génie Logiciel Université du Québec à Montréal

Mysql performance question

Hi people, May be anybody can advice from the personal experience tweeking which options both in the mysql configuration and server hardware can help in increasing mysql performance speed? As it is now, mysql is configured to occupy about 600M RAM, and queries per second avg goes up to about

RE: Mysql performance question

What disk drive have you got? We have found that this can help. Simon -Original Message- From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]] Sent: 19 February 2002 13:14 To: [EMAIL PROTECTED] Subject: Mysql performance question Hi people, May be anybody can advice from the

RE: Mysql performance question

Here is the hardware: 8x U160 SCA IBM UltraStar 36LZX Discovery 4MB cache 1 rpm 18.2GB, Adaptec 3200S 64MB Cache 32/64 bit PCI RAID U160 SCSI, FreeBSD says when booting: ADAPTEC RAID-50 370F Fixed Direct Access SCSI-2 device Tell me please if any other info is needed. Alexander

Error 1058 Win2K Server with MySQL

We are trying to install MySQL on a Windows 2000 Server, but are getting 'error 1058' when we try to start the service. The MySQL version is 3.23.47-nt. The MySQL drive is F:, and c:\my.cnf is: [mysqld] port=3306 big-tables skip-locking set-variable =

Boolean Fulltext problems part III

Hello, Sergey, thanks for the patch, I applied it for 4.0.1 and seems like mentioned bug closed. But I found new bug :) Strange, but the query WORKS AS EXPECTED without fulltext index! The results for 4.0.1 with latest fulltext patch applied: If you need full testcase, please conteact me.

Re: About Regular Backup on MySQL

Dear Sir/Madam: I'd like to know how I can have regular backup in mysql database that is carried out by the system itself, instead of typing in the backup command in the DOS mode everytime. Thanks for your attention looking forwards to your reply. Regards, Polly

help on installation

Hello, I am trying to install MySQL in Solaris 7. I download this version of Mysql (mysql-3.23.48-sun-solaris2.7-sparc.tar.gz). After I ran the gunzip and these instruction shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar

Re: MySQL TEXT datatypes and multiple tables

At 04:08 2/19/02 +0100, you wrote: 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

RE: About Regular Backup on MySQL

If you are on a Windows box, you can create a batch job for it. If you are on Linux/Unix run a cron job -Original Message- From: Che WaiSam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 8:19 AM To: [EMAIL PROTECTED] Subject: Re: About Regular Backup on MySQL Dear

Please have a look on this group by

Hi Folks, now sitting here for 5 hours trying to get these stupid sql-request running, I decide to ask the list. structual information of the database: database.preis = decimal(12,2), database.lfd=int(11), database.typ=varchar(30), database.marke=varchar(50) The following requests works select

Re: Mysql performance question

Hi Simon, A couple of things, unless you have compiled WITH_LINUX_THREADS from the /usr/ports/databases then adding more processors will be unlikely to help. The native threads lib on FreeBSD runs a threaded app on 1 processor currently, use the LINUX_THREADS option in the ports to get

Re: Please have a look on this group by

On Tuesday 19 February 2002 10:07, Oliver Heinisch wrote: What would you expect the database to return You asked it to GROUP all the records with the same preis, that means it has to choose a value for each column of the record that is the result of each grouping, correct? So which of the

Re: Please have a look on this group by

Oliver, select min(preis),lfd from database where marke='marke' and typ not like 'R%' and typ not like 'X%' and typ not like 'C%' group by preis this doesnt bring the expected pair preis / lfd but all available preis/lfd grouped ascending. you're grouping by the same column you're

[SECURITY] How do these blank passwords get into mysql.user?

One thing's been bothering me for a while: When I create a user and database in MySQL, the user always ends up with an extra entry with host='%' and password=''. How is this happening? This is how I create a new database and user: mysql create database xxx; Query OK, 1 row affected (0.01 sec)

Re: double outer joins in mysql?

On Tuesday 19 February 2002 00:48, Todd Goldenbaum wrote: hi, I'm wondering if anyone knows if it's possible to do a double-outer join in mysql. by that I mean outer-joining on two tables instead of one (both from the same original table). in other words, whereas a normal outer join might

Re: [SECURITY] How do these blank passwords get into mysql.user?

Philip, you should explicitly specify host/password in the GRANT statement, like this: GRANT ALL ON xxx.* TO user@'localhost' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; This way the user will only granted access from the specified host, you don't need to manually INSERT into the user table.

Re: [SECURITY] How do these blank passwords get into mysql.user?

On Tue, Feb 19, 2002 at 04:39:10PM +0100, Peter Banik wrote: you should explicitly specify host/password in the GRANT statement, like this: GRANT ALL ON xxx.* TO user@'localhost' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; This way the user will only granted access from the specified

Re: another xml thread

On Monday, February 18, 2002, at 11:26 PM, Benjamin Pflugmann wrote: So, if you want to use data from a MySQL database and transfer it via XML and the other way around (i.e. XML as an transport layer for relational data), I see no particular problem for you to write a client that

Running MySQL on Dos System?

Is it possible to port MySql on a Dos Computer ? Computer : 486DX66 OS : DR-DOS 7.03 Ram : 64 Mo HD : 1 Go Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Running MySQL on DOS?

Is it possible to port MySql on a Dos Computer ? Computer : 486DX66 OS : DR-DOS 7.03 Ram : 64 Mo HD : 1 Go Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: get instance variable

Hi Robert - The only way I have found to get this sort of stuff (as well as security info) out is to use mysql_query (or mysql_real_query) and issue the query just like you would at the mysql client. Then you can interpret the results that are returned. I am having to do that with column

Re: Please have a look on this group by

At 19.02.2002 10:20, you wrote: What would you expect the database to return Thanks to all so far, The query should give the smallest price MIN(preis) and the according lfd number of this record. so the answer should only be one pair f.e.: 15200,00 | 41 . I think this should work, as this

Editing system vars

I am relatively new to MySQL I need to edit my db variables. How is this done ? From the command line or by editing a file? My OS is Windows. Thanks Mark - Before posting, please check: http://www.mysql.com/manual.php

appropriate datatype - blob/text?

Hi, I wonder if someone could offer me some advice. One of the requirements for my database is that it must store (in one field) the contents of a text file (never exceeding 1MB). The data is obviously plain text format, and is in the following format: .010 .1083649E+03

Re: Please have a look on this group by

In this case you have to omit GROUP BY from your query. Peter On Tue, 19 Feb 2002, CreaCtion wrote: At 19.02.2002 10:20, you wrote: What would you expect the database to return Thanks to all so far, The query should give the smallest price MIN(preis) and the according lfd number of

Re: Mysql performance question

Thanks a lot for the advices. The value for table_cache is 8572, and I'm indeed accessing a lot of tables. So as I gather it the main effect should be expected from transfering to MySQL 4.0.1 compiled with LINUX_THREADS and using innodb tables, true? Now what can you say about reliability issue,

HTML dumping into browser...

I am having trouble convincing my SQL admin at the hosting company that something is wrong with the server / speed. It is really odd, but in myPhpAdmin for example, on the left hand side the list of databases comes out properly for about 95% of the list, then it starts dumping HTML into the

Generating SQL code?

I am going to be copying some tables from one DB to another and was wondering if it is possible to have MySQL output the SQL Create Table syntax? I know there are products that will do that (ie. MyPHPAdmin) but can MySQL do it? I'd rather not put anything extra on my server. Thanks.

Re: Generating SQL code?

See mysqldump utility, it does exactly what you ask. Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Tue, 19 Feb 2002, Sterling J. Anderson wrote: Date: Tue, 19 Feb 2002 11:14:11 -0600 From: Sterling J. Anderson [EMAIL PROTECTED] To: [EMAIL

basic query question

I'm fairly new to MySQL, so if anyone could help me I'd really appreciate it! What I'm trying to do is join two pictures in a database to each other. My database holds info about people with variables: id, lname, fname, engagedto, pic The engagedto field contains the id of the person they are

SOLVED ..Please have a look on this group by..,not really

Again, thanks to all, who helped. None of your advices gave the desired pair combination single row preis/ lfd, but just looking at the first row, gave the correct answer as I grouped by preis, lfd. I was irritated by the results, the command-line gave me. Even as I wanted the quantity of

!------ MySQL C API ----------!

I have a written a Windows client that accesses a MySQL server (Linux) via the MySQL C API. Stored in the MySQL database are large files (larger than a Mbyte). The C API makes it very easy for the client to query and alter the database. However, I have some special needs that don't appear to

Re: [SECURITY] How do these blank passwords get into mysql.user?

»Philip Mak« sagte am 2002-02-19 um 10:25:38 -0500 : One thing's been bothering me for a while: When I create a user and database in MySQL, the user always ends up with an extra entry with host='%' and password=''. How is this happening? This is how I create a new database and user: mysql

Re: Generating SQL code?

Take a look at mysqldump John On Tuesday 19 February 2002 12:14, Sterling J. Anderson wrote: I am going to be copying some tables from one DB to another and was wondering if it is possible to have MySQL output the SQL Create Table syntax? I know there are products that will do that (ie.

Re: Running MySQL on Dos System?

At 10:51 19/02/2002 -0500, Martin Filteau wrote: Hi, Is it possible to port MySql on a Dos Computer ? Sorry no. You need at least a 32 bit OS. Regards, Miguel Computer : 486DX66 OS : DR-DOS 7.03 Ram : 64 Mo HD : 1 Go Martin

Editing system vars

Mark, Tuesday, February 19, 2002, 6:31:26 PM, you wrote: MS I am relatively new to MySQL I need to edit my db variables. MS How is this done ? From the command line or by editing a file? MS My OS is Windows. If you mean mysql options you can set variables by editing my.cnf(my.ini) file or by

gross database lockup

I've upgraded a database server from: 2 x pIII 700MHZ 784Mb to 2 x pIII 1ghz 2gig ecc reg and have been having some sick database lockups since. 9:10pm up 6:11, 3 users, load average: 167.29, 108.42, 49.33 - unbelieveable load average. top shows 137 mysql 'threads?' CPU0

Re: Error 1058 Win2K Server with MySQL

At 07:49 19/02/2002 -0600, Gerald Jensen wrote: Hi! Did you tried to put the datadir variable too in the my.cnf file ? Anyway, when the service is failing try to start it as console: mysqld-nt --standalone --console In this way you should see the messages errors, also you can see them in the

v3.22.32 and temp tables

Hi, I want to build a temp table which I can query to sum values. If I try create temporary table tbl_name select some_query_here, then I get an error that tells me that I have an error with my sql syntax near 'temporary table tbl_name select some_query_here'. Am I correct in thinking that this

Re: basic query question

At 19.02.2002 10:22, you wrote: I'm fairly new to MySQL, so if anyone could help me I'd really appreciate it! What I'm trying to do is join two pictures in a database to each other. My database holds info about people with variables: id, lname, fname, engagedto, pic Try this, even if I´m

Re: Generating SQL code?

At 11:14 -0600 2/19/02, Sterling J. Anderson wrote: I am going to be copying some tables from one DB to another and was wondering if it is possible to have MySQL output the SQL Create Table syntax? I know there are products that will do that (ie. MyPHPAdmin) but can MySQL do it? I'd rather not

RE: basic query question

assuming that engaedto refers to an id, your query might be: SELECT a.lname,a.fname,b.engagedto FROM mydata a LEFT JOIN mydata b ON(a.id=b.engagedto); -Original Message- From: Dean Householder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 11:22 AM To: [EMAIL PROTECTED]

RE: appropriate datatype - blob/text?

do you need to search on it? If not, perhaps storing these files separately with a pointer storedd in the database. This will improve searching speed I understand. -Original Message- From: Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 10:29 AM To: MySQL Subject:

Re: Error 1058 Win2K Server with MySQL

Problem is solved ... customer had his server configured so any new services being installed were automatically disabled! That is why the service would not start. We have installed MySQL on about a dozen Win2K Advanced servers ... this is the first time we have encountered this issue. Thank you

MOD_AUTH_MYSQL and apache

HAS anyone every used this Module to access mysql before , i have it working with clear text passwords just fine but when i took the encrypted ones from my old .htpasswd file and put them in my mysql table apache cant read them John Lord([EMAIL PROTECTED]) Network Administrator Studio for

RE: basic query question

select id, lname, fname, pic from database where engagedto=id; Sorry, mate, that won't work. That will find folks who are engaged to themselves, i.e., narcissists -Original Message- From: Oliver Heinisch [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 11:30 AM To: [EMAIL

RE: v3.22.32 and temp tables

From the manual: In MySQL Version 3.23, you can use the TEMPORARY keyword... Sorry, mate, you are SOL until you upgrade -Original Message- From: Brian Warn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 12:09 PM To: 'MySQL List' Subject: v3.22.32 and temp tables Hi, I

MySQL-3.23.49-1.src.rpm does not build on RedHat 6.2

I'm running MySQL on a RedHat 6.2 linux box (kernel 2.2.20). The MySQL-shared-3.23.49-1.i386.rpm package does not install since it's compiled using GLIBC 2.2. I've tried to build binary packages from MySQL-3.23.49-1.src.rpm as suggested. The compilation fails: creating libmysqlclient.la (cd

Re: MOD_AUTH_MYSQL and apache

On Tue, 19 Feb 2002 13:10:01 -0500, John Lord [EMAIL PROTECTED] wrote: HAS anyone every used this Module to access mysql before , i have it working with clear text passwords just fine but when i took the encrypted ones from my old .htpasswd file and put them in my mysql table apache cant read

innodb table status : Why is Max_data_length NULL?

I have two InnoDB tables using a pool of space (the combined size of the data files may change). I want to limit each to using half the amount of space (or split it in some manner .. 60%/40%, etc). So far I've done this with a daemon that runs all the time deleting appropriate rows when the

RE: basic query question

you will have to join the table with itself and reference it as if it is two tables. this might be slow however so you might want to make some specific indexes to speed it up. This Query will return all the people who are engaged and a picture of their fiancé: select p1.lname, p1.fname,

Re: basic query question

Okay, so I do this and all I end up with is +-+---+-+---+ | id | lname | fname | engagedto | +-+---+-+---+ | 131 | Hallows | Samuel | 131 | | 273 | Simmons | Maria | 273 | | 221 | Papa |

Error 2013: Lost connection to MySQL server during query

Hopefully someone out there can help me as I haven't been able to find any documentation on this that applies. I am running MySQL version 3.22.32 on a FreeBSD v4.4 machine. I am getting Error 2013: Lost connection to MySQL server during query when I run the following query: select distinct

RE: basic query question

You're very close: mysql select p1.lname, p1.fname, p2.lname as engaged_lname, p2.fname as engaged_fname from members p1, members p2 where p1.id = p2.engagedto; but the REAL question is What do you want out of the query? -Original Message- From: Dean Householder [mailto:[EMAIL

RE: MOD_AUTH_MYSQL and apache

i compiled it right into apache , it is working but using clear text passwords. Its 2.20, i found a 3.20 also but it wont compile at all, ive looked all over the web and noone else seems to have a problem , im at a loss here is my .htaccess that works AuthName Your Login is Required AuthType

Re: Mysql performance question

Your welcome Alexander! OK the value for table_cache is 8572 * 3 = 25716 file descriptors, how big is kern.maxfiles and kern.maxfilesproc? These need to be set above 26000 to allow all those tables to be opened! I know I have missed this sometime, or not reset them after a kernel compile.

Time bug with MySQL 3.23.49

After MySQL 3.23.49 was release the other day, I upgraded my server as usual. After a while I noticed something odd. All datetimes that were entered into the database after I upgraded the server to 3.23.49 were 5 hours ahead. I am located in Upstate NY, which I think is -5 hours from GMT.

Re: basic query question

Thank you all so much for helping me with this query. It works! Best of all, now I understand how to join tables and such! Thanks again! - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'Dean Householder' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002

Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!

Description: Followed steps to install binary distribution, including adding mysql user to group mysql. The user exists. When you run bin/safe_mysqld --user=mysql or if you run bin/mysqld --user=mysql or if you run bin/mysqld --user=#UID then it gives this error. No error if you

Flushing via JDBC

I am having problems flushing via jdbc. I have already granted the administrator reload permissions, but maybe I need to do something else. I am using MySQL version 3.23.47 and I am using JDBC 3.0. Has anyone ever had this type of problem?

Flushing via JDBC

I am having problems flushing via jdbc. I have already granted the administrator reload permissions, and I am passing the query flush tables;, which seems to work in the command line. I am using MySQL version 3.23.47, mm.mysql-2.0.9, and JDBC 3.0. Has anyone ever had this type of problem?

Re: row level privilages - thoughts on how to do

Hi Noel, On Tue, 2002-02-19 at 13:40, [EMAIL PROTECTED] wrote: I'm wondering about row level privilages - being able to restrict what people see and can update etc on a row level as well as a column/table level. As others mentioned, having VIEWs wouldn't necessarily be of any help, since

MySQL and ASP.Net

Has anyone connected to a mysql database using ASP.NET If so can you point me in the right direction. I can't find anything on that query, Table, SQL Roger Karnouk - Before posting, please check:

MySQL off-the-shelf product

Hello everyone, Would someone know of off-the-self MySQL product that will contain latest MySQL server in it? Something like 3.23.46a max-nt and above. I don't care what it's bundled with, PHP or perl. I just need to use the features of MySQL only. The reason I need it, is for FDA (Food

Question about locking reads

Hi Guys According to documentation from MYSQL the query Select * from test where test=5 FOR UPDATE Should lock the row which satisfies the above condition. But this is not working for me. I tried this query with InnoDB table. Does anybody knows what could be a possible cause for this. Rajneesh

-fno-implicit-templates, -fno-exceptions,-fno-rtti problems

Can somebody tell me why these 3 flags must be added when I compile mysql from source code? I am trying to use another compiler instead gcc to compile mysql. But it doesnot accept these three flags. From the readme, it seems to me that these flags (especially -fno-exceptions must be

Re: -fno-implicit-templates, -fno-exceptions,-fno-rtti problems

On Tuesday 19 February 2002 4:31 pm, Peng Zhao wrote: Can somebody tell me why these 3 flags must be added when I compile mysql from source code? I am trying to use another compiler I see no reason that these should be required. -fno-implicit-templates simply requires all templates to be

Re: -fno-implicit-templates, -fno-exceptions,-fno-rtti problems

Thanks for your reply. But You can find something from http://www.mysql.com/doc/I/B/IBM-AIX.html : If you are using gcc or egcs to compile MySQL, you must use the -fno-exceptions flag, as the exception handling in gcc/egcs is not thread safe! (This is tested with egcs 1.1.) And it also says

Re: -fno-implicit-templates, -fno-exceptions,-fno-rtti problems

On Tuesday 19 February 2002 4:56 pm, Peng Zhao wrote: Thanks for your reply. But You can find something from http://www.mysql.com/doc/I/B/IBM-AIX.html : Thanks, I hadn't noticed that. If you are using gcc or egcs to compile MySQL, you must use the -fno-exceptions flag, as the exception

RE: **Backing Up A Database**

Hi Felix (or anyone), I'm giving this a go but as a Linux newbie running Red hat 7.2 I have a question to ask Do I need to alter anything in Cron for it to run the logrotate script? What would I need to put into the hourly cron folder to make things happen more often to check they are

Re: -fno-implicit-templates, -fno-exceptions,-fno-rtti problems

somewhat that exceptions aren't thread-safe in egcs. Still, it would be worth trying out with gcc 2.95.x or gcc 3.x. I used 2.95.3 to compile mysql, it is fine, just because it accepts those flags. I didnot try to switch those flags off and compile. I am using orcc to compile mysql.

Installation Problem mysql-3.23.49

Description: When I run a ./configure --prefix=/usr/local/mysql --with-libwrap the configure completes but the make fails. Making all in sql make[2]: Entering directory `/usr/local/src/mysql-3.23.49/sql' Making all in share make[3]: Entering directory `/usr/local/src/mysql-3.23.49/sql/share'

security concerns and 1044 access denied problem

Hi gurus, Here's my problem: After installing binary version of mysql on sun, I try to add a new user and a new database, namely `dbuser' and `mydb', such that dbuser can access mydb but nothing else. However I found that if I do not grant dbuser 'select' privilege in mysql.user, dbuser

using MySQL

I seem to have forgotten how to get into MySQL and work. (It's been a while but I'm starting up again. I get these errors: bob@sfpetard:~ mysqladmin create library mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'library'' and: bob@sfpetard:~ mysql

Fw: would you send me the mysql distribution which can support big5

- Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: Tony Wu [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 8:38 PM Subject: Re: would you send me the mysql distribution which can support big5 On Tue, 19 Feb 2002 12:43:04 +0800 Tony Wu [EMAIL

MySQL with SSL support

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All, Need: Communicate securely using PKI from a DBI perl script to MySQL where dozens of clients connect from multiple sites around the country (stunnel is not an option :( If I issue a grant command like such GRANT ALL PRIVILEGES ON test.*

Re: using MySQL

You did not setting privilege for yourself to use MySQL access. See something about Security issue in MySQL manual (online or donwload). If you need the tools to setup MySQL instead of MySQL command prompt try PHPMyAdmin (web based) or MySQLFront (windows based). SF At 16:01 19/2/2002

Re: MySQL with SSL support

Hi JC I know you said stunnel is not an option but how about SSLwrap? http://www.quiltaholic.com/rickk/sslwrap/ james At 18:49 19/02/2002 -0800, JC wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All, Need: Communicate securely using PKI from a DBI perl script to MySQL where dozens

Question on maximum record input frequency and table lengths.

Hello, We are considering using MySQL in an application involving recording and processing analog signal inputs from various electric powerplant instrumentation. Some (but not a majority) of these signals will take and need to record and discrete measurements at a frequency from 360 to 1000 or

I can't find file mysqld.sym.gz!

hello~ When I try to Using a stack trace there's no mysqld.sym.gz on our server . Can we always find mysqld.sym.gz on any operating system? Our operating system is Linux 7.0 . I would like to mail you our error log to see if you can tell us what's wrong with our MySQL which always crash

Re: Question on maximum record input frequency and table lengths.

Hi Michael, On Wed, 2002-02-20 at 13:29, Michael Mitchell wrote: We are considering using MySQL in an application involving recording and processing analog signal inputs from various electric powerplant instrumentation. Interesting application! It is always nice to hear where MySQL is being

Please, need help urgently

I need some help, this is a mission critical server and it has CRASHED! Details:FreeBSD on INTEL, MySQL v3.23.36 (FreeBSD Port) The server had to be rebooted, and when it came back up, my MySQL server died. It's been working flawlessly for months (5 or 6), but all the sudden mysqld will not

I can't find file mysqld.sym.gz!

hello~ When I try to Using a stack trace there's no mysqld.sym.gz on our server . Can we always find mysqld.sym.gz on any operating system? Our operating system is Linux 7.0 . I would like to mail you our error log to see if you can tell us what's wrong with our MySQL which always crash

Re: Please, need help urgently

Hi, It would be time consuming to understand why the server crashed and then repair the server, as u say it is a mission crtical one , the quickest way to get it up and running would be to back up the database (copy the ur database directory completely under the data directory) reinstall MySQL

Re: MySQL off-the-shelf product

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Demirchyan Oganes-AOD098 declared Would someone know of off-the-self MySQL product that will contain latest MySQL server in it? Something like 3.23.46a max-nt and above. I don't care what it's bundled with, PHP or perl. I just need

Re: MySQL off-the-shelf product

Hi! I believe NuSphere does not distribute MySQL-Max-3.23. Tergat MySQL Studio contains MySQL-Max-3.23.47. Do you literally need an 'off-the-shelf' product? Tergat is available as a downloadable version for $66. The physical boxset version is not available yet, I think. ...