setting root password in mysql

Never am able to gain access to enter in a password for root? It's driving me crazy... Any help Michael Collins thanks for trying! [localhost:/Users/nezi] root# kill -9 1354 [localhost:/Users/nezi] root# kill -9 1371 [localhost:/Users/nezi] root# cd /usr/local [localhost:/usr/local] root#

RE: Help with myODBC

Hi Nikhil Is there any chance for you to provide the ODBC trace generated by ODBC DM / MyODBC ? Thanks in advance Venu -Original Message- From: Nikhil Goyal [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 11:33 AM To: [EMAIL PROTECTED] Subject: Help with myODBC Hello

RE: access dbs to mysql dbs

Export all the tables with data from access to MySQL using MyODBC. Please visit the following link for more details about MyODBC. If you have any questions on this, please send it to [EMAIL PROTECTED] http://www.mysql.com/documentation/mysql/bychapter/manual_ODBC.html#ODBC Thank you Venu

REGEXP syntax

Hi, Trying to get to grips with regexp but really want to 1st get a simple expression working with mysql. SELECT Sequence, Message, id FROM $sqlTable WHERE Sequence REGEXP(\^$filterValue;\) The above works for finding matched values, where the number = to $filterValue is in in the 1st part.

Problems with lock in share mode

I have a table customer like a example, and 2 user making change in this. The firts user make select * from customer where a = 1 lock in share mode; and the second try to update the record where a = 1. In theory the second user can't make any change, but the update is true and change the data.

RE: MFC

Hi You need to specify the ip address/host name of the remote system in the DSN creation. In MyODBC Setup screen, 'MySQL host(name or ip) provide the IP ADDRESS or HOST NAME of the remote system. Also, please use [EMAIL PROTECTED], for any MyODBC related queries. Thank you :-Venu

disable the mysql port

Hi, Does anyone know how to disable mysql listening port? Thanks, Michael Lin _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -

Mysql Error

Hi, I am trying to use the precompiled version of mysql-3.23.37-ibm-4.3.3.0-rs6000. ANd when trying to start the mysqld i get the following error: exec(): 0509-036 Cannot load program ./mysqld because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be

Re: The old interfering with the young

In the last episode (Jul 27), Anatole said: I had some pre-installed version of MySQL on a Linux machine that I didn't want to use or know how to dispose of properly and then installed a source distribution on the same machine. I've gotten the source distribution installed all right and

Re: [fwd] Returned mail: Host unknown (Name server: mailserv: host not found) (from: MAILER-DAEMON@host2.webprovider.net)

Hi, I have removed '[EMAIL PROTECTED]'. Matt Alexander Skwar writes: Hi! Could someone please do anything about this? - Forwarded message from Mail Delivery Subsystem [EMAIL PROTECTED] - From: [EMAIL PROTECTED] (Mail Delivery Subsystem) Date: Thu, 26 Jul 2001 19:06:21

RE: Unix passwd file and mysql authentication table

On 26-Jul-2001 sachin shetty wrote: Hi Is it possible to authenticate a logged on user by comparing the unix passwd file entry with the mysql user table entry(after copying passwords from the password file to the table). The password_crypt routine used in MySQL is incompatible with the

Unix - Windows migration

Hello, On the project I am working on is a MySQL database generated on Sun/Solaris. If memory serves the MySQL version was 3.2.xx on the Sun. On Windows98 the MySQL version is 3.23.39.1 The Sun datafile cannot be read. The file extension in the tables is .ISD and .ISM for Sun, and .MYD and .MYI

Cobalt raq4 and mysql

Hi all, I'm looking for a beginners resource for working with Mysql on a raq4 linuxbox. Any suggestions? Bye, Patje... Behandel mij met zachtheid, ik ben een overlevende van het vorige millennium! Handle with care, I'm a survivor of the previous millennium!

Re: Date Format in MySQL

On Thursday 26 July 2001 11:03, Claudemir F. Martins wrote: Hello Friends Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- I suppose, by changing the source code, and reompiling, which would break several other things. Before posting, please check:

Re: installing mysql

Hi Stefan, Thank You very much for this message to Maggie regarding installation to a Windows 2000 system. I am a neophite and have been lost. I am now partially found!!! My question: Do I need to do anything to the ini file, or is that now done? Am I now good to go? Thanks, Susan -

RE: Correct DISTINCT syntax for MYSQL version 3.22.32

On 26-Jul-2001 Graham Nichols wrote: Hi, I'm using MYSQL version 3.22.32. I have read that from version 3.23.xx COUNT can be used in combination with DISTINCT. However, I have a project deadline which does not give me time to upgrade. I have a small table 'web-stats' consisting of the

timestamp problem

I'm using PHP to add records into a mysql database. The records write successfully to the database except for the timestamp field which I have defined as Field Type Null Key Default Extra TheDatetimestamp(14) YES NULL

conversion

Ok , Granted I'm really new at this but, I'm starting to feel as though I'm missing something very obvious here. If I have a tect file , say a excell spredsheet saved as a CSV tab delimited, can i import that into MYsql and have it create th eneccesary feild names? if so, how?

I need help constructing a regexp

In message [EMAIL PROTECTED], Mark Worsdall [EMAIL PROTECTED] writes Hi all, I have a problem, I have some VARCHAR data in a column called Sequence looking like this:- 5;6 12;6 120;6 5;6;1 12;6;12 120;6;105 So there could be anything from 2 to n numbers seperated by ; Each number could be 1

Re: CREATE SEQUENCE

Date |Thu, 26 Jul 2001 10:12:03 -0700 (PDT) From |Bryan Capitano [EMAIL PROTECTED] Hello! BC Hello, BC Does anybody know what the SQL statement: CREATE SEQUENCE do? BC I cannot find any info on this in the http://www.mysql.com/docs section. BC Thanks, BC Bryan Capitano AFAIK MySQL doesn't

[Compiler error for MySQL 3.23.40 - Forte C++ and Solaris X86]

Description: I'm comiling with GNU make and tar, and Forte C++ v6 r2. The compiler is current, as is the Solaris. My configuration line looks like: ./configure --prefix=/usr/local/mysql --with-innodb I'm getting the following errors when running the make command: cc

Re: The old interfering with the young

Date |Fri, 27 Jul 2001 02:21:17 +0900 From |Anatole [EMAIL PROTECTED] Hello! A Here's my problem: A I had some pre-installed version of MySQL on a Linux machine that I didn't A want to use or know how to dispose of properly and then installed a source A distribution on the same machine. I've

Re: Correct DISTINCT syntax

What I'm trying to achieve is is a srfer visits the site each page visited will be inserted into the database. So, if the surfer visits 5 pages there will be 5 records inserted. Initially, I need to know that this is just ONE hit (one IP), with the next surfer to vist being the second IP. That

ADO + show columns

I'm experiencing some unexpected and undesired behavior attempting to run SHOW COLUMNS FROM TABLE using Delphi via ADO. MDAC: 2.6 RTM MyODBC: 2.50.37 O/S:Windows 98 MySQL: 2.23.24 (Linux) I can run most queries just fine (ie SHOW TABLES, selects, etc.). However any SHOW COLUMNS queries

Paycheck database Design

I want to log my paychecks in my own database for my own personal use. I am in the design phase: Do I need a table for year to date since this can be calculated automatically? I don't want to have to enter a lot of information when entering the data for each pay period. How many tables are

mysql keeps restarting

Hello Everyone.. I just upgraded from MySQL-3.22 (FreeBSD package) to 3.23.40 FBSD binary release. Now everything appears to be running correctly, but the error log tells a different story. Every few seconds MySQL is restarting, and I don't know what to do... But here is what the logs say:

SUSAN

Warning Could not process message with given Content-Type: multipart/mixed; boundary=7EFA5077_Outlook_Express_message_boundary

Replication without using replication?

In MySQL 3.23.40 there are no more warnings about aborted connections (yay!) and I can see what is actually in the error log. I found a binlog error message even though we do not use replication or the binlog (though this got me thinking that we should use it as it will be replacing the

window me support

Can I use MySQL with Window ME. If so which one?? Thank you, Mary

myvbql dll, help please!

I've got the myvbql DLL for accessing a mySQL database directly from Visual Basic (6), however, after reading the documentation I'm still at a loss as to how to use this file since I've not had much experience with API. If anyone can help me learn how to run a simple mySQL query, displaying

installing mysql

I'm relatively new to web development and basically don't have a clue on all the intricacies of establishing a localhost development environment. I'm running a Win 98 platform and want to develop using PHP4, Apache, MySql that will support transaction processing. I've found a ton of great

Re: Teen Hobos having sex? ..no.. but MAYBE

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: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply,

Re: Cannot create text fields

If you are trying to create a text field (memo field) then drop the (30). If you are trying to create a 30 chr text field then use varchar(30) Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Geoff Martin [EMAIL PROTECTED] To: mysql list

Re: Moved MySQL to new machine.

try to see more detail in INSTALL, it tell us about file and directory permission. If you have more problem with /var/any dir why did not use /statedir=/usr/mysql/data while configure to relocate MySQL data directory insteady use in /var/... Sommai Fongnamthip At 11:47 26/7/2001 -0500,

Re: Can't stop msqld

$ ps -ax | grep mysqld get the pid of mysql $ kill -9 pid_of_mysql that'll do it. :) Tyler On Thu, 26 Jul 2001 13:24:41 -0500 cjackson [EMAIL PROTECTED] wrote: Hello all, I just installed mysql 3.23.32-1.7 with an rpm on redhat7.0 server running apache and php. I could start msqld and

Re: Date Format in MySQL

Date |Thu, 26 Jul 2001 15:03:59 -0400 From |Claudemir F. Martins [EMAIL PROTECTED] Hello! CFM Hello Friends CFM Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- ? CFM Thanks CFM Claudemir F. Martins You can use DATE_FORMAT function for change output date format.

possible bug in sum() function

We keep a timecard database and I was just asked how much time had been charged to a particular project code. No problem says I and did the following: select sum(worktime) from timecard where tcacct=project; The answer came back 182. Then I was asked who had spent time on the project. the

RE: Date Format in MySQL

On 26-Jul-2001 Claudemir F. Martins wrote: Hello Friends Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- ? Check for DATE_FORMAT() in the manual. Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the

RE: joining two databases

i have 2 mysql servers, i need to run a query that joins two tables from two databases on the two servers, how can i do this? You can't. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Date Format in MySQL

Hello Friends Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- ? Thanks Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Can't stop msqld

Date |Thu, 26 Jul 2001 13:24:41 -0500 From |cjackson [EMAIL PROTECTED] Hello! C Hello all, C I just installed mysql 3.23.32-1.7 with an rpm on redhat7.0 C server running apache and php. I could start msqld and shut it down. C Then I created a password for root. Mysql still starts but I C can't

RE: Uploading files using PHP to database.

yup, i have this same question...it seems to me, unless i'm missing something obvious that you have to create the table and feild names first, then upload the txt file? Is this correct? - Before posting, please check:

Re: Help with myODBC

Date |Thu, 26 Jul 2001 14:32:48 -0400 From |Nikhil Goyal [EMAIL PROTECTED] Hello! NG Hello people, NG I've a mysql database which is quite large and I needed to create a backup NG for it, which I can use offline in MS Access or such. I've tried using NG MyODBC, but one strange problem has come

Re: I need help constructing a search thingy using % _ in LIKE

yes, but then you wouldn't learn. if you don't want to buy Dubois' book, try appendix J of the mySql reference manual, available for free from the mysql site. At 06:06 PM 7/26/01 +0100, you wrote: In message [EMAIL PROTECTED], tj marlin [EMAIL PROTECTED] writes I think it is time for you to

Re: Building MySQL on HPUX with InnoBase support

Jeff, I think some people have built on HP-UX, but I do not remember if they used GCC. What kind of errors do you get from the HP compiler? Regard, Heikki http://www.innodb.com Copied message: .. I have had problems building the MySQL database server when I include

Re: Can't stop msqld

Jackson, Check under what process ID mysqld is running, than kill it, like doing: -- # killall mysqld -- On Thu, 26 Jul 2001 13:24:41 -0500 cjackson [EMAIL PROTECTED] wrote: | I just installed mysql 3.23.32-1.7 with an rpm on redhat7.0 server | running apache and

not null

I am having trouble setting a column attribute to not null. Below is the statement I am using: create table table_name ( Column_Name not null ); If this is not the correct way to do it, can someone please help me...this is my first mysql database. Thank you.

Unable to use shortcut keys

Hi, I am currently using mySQL 3.23.39, under windows 98 SE environment. When i am running mySQL using MSDOS-prompt, there is no shortcut key available (all the arrows keys, ctrl+p, etc, don't work, even though doskey was enabled). Thanks in advance. JH

mysql unable to connect

I'm trying to connect to the mysql database and get the error (computer r3holt24en.eng.agilent.com not allowed to connect). Any ideas? mysql is loaded on an HP-UX box at /usr/local/mysql. Where should I look/do? tia (very novice: knows other sql dbms, but not mysql yet) Suu Quan Agilent

Bug in GRANT in 3.23.40

Found a bug in 3.23.40 with GRANT: Statement: grant file on db.* to peeps@% identified by password; emits no error message, however when one does a select for that user from the user table, one will find that the user peeps which was dutifully created has NOT been given File_priv - in fact,

Re: up arrow using mysql client on windows

Dear Alan, new Windows distributions of MySQL do have the up arrow (history list), although it is only for the current session (that's better on Linux). If you have an older version, simply start c:/mysql/bin/mysqlc.exe instead of mysql.exe. This one has the history list. Regards, -- Stefan

Re: Moved MySQL to new machine.

Dear Jeremy, have you checked the rights already? Try CHMOD 777 for a test, if you can create databases then, it's only a file rights problem. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee

Re: MySql Server creating problem

Dear Selva, ERROR 2002: Can't connect to local MySQL server through socket' /var/lib/mysql/mysql.sock' (2) Wrong file rights. Change /var/lib/mysql/ to 777 for a test, and everything will work. Run the MySQL daemon (server) with user mysql, and change the /var/lib/mysql/ rights to 700 (7 for

Moving database from windoze to Linux

Good day, I have created a database using MySQL under Windoze and am trying to move the data to MySQL running on Linux. I have exported the data to a res file - can't see how to do a mysqldump in Windoze. I then try and import the file on the Linux machine using LOAD DATA, but end up with

Re: Can't stop msqld

Dear Jackson, do not mix up Unix users and MySQL users! Only a MySQL user who has been granted the right SHUTDOWN can shut down the server! (As Unix root, you can as well kill MySQL. But this might harm open tables.) Check for privilege system in the manual. Regards, -- Stefan Hinz

I can kill it but Can't stop mysqld

Thanks everyone for immediate response to this problem. I can kill the mysql process but I cannot stop it using /etc/rc.d/init.d/mysqld stop. I can start it like this using start but not stop it using stop. All of this is done as system root. So runlevel 3 starts it OK, but runlevel 5 won't

Re: Correct DISTINCT syntax for MYSQL version 3.22.32

Date |Thu, 26 Jul 2001 21:11:20 +0100 From |Graham Nichols [EMAIL PROTECTED] Hello! GN Hi Grigory, GN your query below only runs without error if I leave out the word DISTINCT. SELECT web_date, dayofmonth(web_date) AS d, COUNT(DISTINCT IP_address) AS c FROM web_stats GROUP BY d ORDER BY

DISTINCT problem

Hi, Distinct can only be used with count count(distinct field_name) --- OK for 3.23 NOT for 3.22 from MYSQL version 3.23. I have only version 3.22. How can I get around this please? kind regards, Graham Nichols -

Delete

Hi, im trying to delete a record from a table where the value of a field must be equal to the value of a field of another table.I know this is wrong but I need to show you what I mean. I think I'm missing a very important select statement to join them...can

Mysql Database

Hi, i have a question. I have a Mysql Database with about 50 tables, How many rows could be support this database using mysql Thanks, Dairo _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

long query: when to give up

To sum it all up, I am trying to import data from text files into an innobase table (about 12m rows of data that is stored in text files created by doing a select into outfile). First I tried dropping the indexes before doing load data infile, but I found that I didnt have enough table space to

RE: CREATE SEQUENCE

It's a command used for creating the equvalent of AUTO_INCREMENT columns in other dialects of SQL. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq -Original Message- From: Bryan Capitano [mailto:[EMAIL PROTECTED]]

Re: setting root password in mysql

Why not try sql to update it: mysql -u root mysql use mysql; mysql update user set password = password('new password') where user = 'root'; mysql flush privileges; mysql exit - Original Message - From: Michael Nezi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 26, 2001

can't connect through socket using PHP script

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) What does this error mean? I am trying to authenticate from a php script using the following code... $db=mysql_pconnect(localhost,username,password); The user username is able to login to mysql ata command

Re: access dbs to mysql dbs

Have a look at AccessToMysql tools at http://mysql.com kaab kaoutar schrieb am Donnerstag, 26. Juli 2001, 20:18:54: Hi How can u take profit of my already done access dbs to create a new one in mysql ? Thanks _ Get your

Re: FW: encrypt

Wouldn't that be a problem of your program? MySQL will sotre anything and not care about what it is. You encrypt first, then insert, next retrieve and decrypt. Jason Whitlow schrieb am Mittwoch, 25. Juli 2001, 17:34:05: I hope this is not to stupid. I have looked at how to encrypt strings in

Re: Date Format in MySQL

Claudemir F. Martins schrieb am Donnerstag, 26. Juli 2001, 21:03:59: Is possible to change the MysQL Date fromat from -mm-dd to dd-mm- ? No. This is the standard format. You can, however, reformat the result sets according to your needs. This format allows easy manipulation of

Re: How to ROUND numbers

Your code doesn't make much sense to me, and especially not with respect to the question. I give you some comments below. Arnab (WebMaster) schrieb am Mittwoch, 25. Juli 2001, 09:23:39: How to round the result number after the multiplication, below are the PHP codes, any help greatly

Re: setting root password in mysql

What version have you installed? I would think on Mac OS X you have 3.23.36? I will give it one last shot. First kill -9 the mysql processes (mysqladmin shutdown does not work on Mac OS), killing safe_mysql first. Add a -p when assigning the password, and I think that the password needs to be

excell text file to mysql table using php admin?

Hi, I'm using PHP Admin 2.2.0pre5 (unofficial stable-branch)and MySql 3.22.32 I have created the following table: Field Type Attributes Null Default Extra Action agent_id smallint(6)No 0Change Drop Primary Index Unique first_name tinytextNo Change Drop Primary Index Unique

Re: Help Please OpenBSD Mysql

/usr/libexec/ld.so loads the dynamic libraries, It goes down a path set by LD_LIBRARY_PATH, get the location where the libary is in and put it in the path, should be that simply. find / -name libpthread.so.14* -print , might help. BTW that was a solaris answer but should be the same on openbsd

Re: Unix - Windows migration

Date |Thu, 26 Jul 2001 17:21:05 -0500 From |Dick Davis [EMAIL PROTECTED] Hello! DD Hello, DD On the project I am working on is a MySQL database generated on Sun/Solaris. DD If memory serves the MySQL version was 3.2.xx on the Sun. DD On Windows98 the MySQL version is 3.23.39.1 DD The Sun

Problem with MyODBC

Hi , I'm trying to access database on MySQL server which is on a Unix box from a windows system through odbc. I'm using MyODBC for this purpose. When ever i connect i get the error message access denied for the user. I have inserted the user in the db, user and host tables in mysql database

Re: The old interfering with the young

You might have had a 'distribution' that was installed via the 'RPM' method. You can see if the RPM packages are installed by typing: rpm -q -a | grep -i mysql If some package appear (as 'mysql-something), remove each one by typing: rpm --erase 'mysql-something' Otherwise, if

RE: Cobalt raq4 and mysql

Hi Well there is not a problem running Mysql on most flavours of Unix/Linx. So there are three thing that you can do to learn more about MySQL... One. MySQL.com: this is very good and covers most things and probmes that you would do with MySQL. Two. MySQL by Paul DuBois. Very good book. Three.

Re: Unix - Windows migration

Hi, I think datafile-compatibilty was introduced in 3.23.xx . To get these old files imported, I would set up a tiny solaris or linux machine ( I think there is a free solaris version for PC) then install the (exactly!) same version (download from mysql.com) as on your old machine. Then run

Re: installing mysql

I dunt know MySQL's ini file. However, you have to copy a file my-example.cnf from your MySQL root directory to C:\ and then rename it as my.cnf. Then edit the file C:\my.cnf . You modify paths in it by the Escape format like E:\\MySQL\\ . save it. open a new command prompt and change to your

iso-8859-2 to UTF-8

Hi I really like mysql feature when I can create conversion table for client and server. Does anyone have made such patch for iso-8859-2 (latin2) and UTF-8? I need this and don't have too much time (my project deadline) to develop it myself. Regards Daniel a

Re: timestamp problem

Kory, Since your fieldtype for TheDate is timestamp(14), you don't need a function to insert a timestamp there. In fact, what you're doing now is inserting the text TIMESTAMP into a date field, which results in '' Instead of 'TIMESTAMP', use NULL -- and don't put quotation marks

Re: possible bug in sum() function

- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 27, 2001 5:31 AM Subject: possible bug in sum() function select sum(worktime) from timecard where tcacct=project; The answer came back 182. Then I was asked who had spent time on the project. the

Re: not null

create table table_name ( Column_Name not null ); If this is not the correct way to do it, can someone please help me...this is my first mysql database. You have to give the type of the column after the name first (int, varchar etc..) -- Sebastiaan Smit

mysqlBUG

Dear I did install MySQL on win95 which is simple. But got stuck when installing on SunSolaris (On PentiumII) at shellmake install given page 56 chapter 4 of MySQL manual. Please advise me what to do next. Waiting for your reply. With Best Regards Sohail Aziz Quidwai

Re: timestamp problem

Omit the value for timestamp. mysql will do all by itself. Kory Wheatley schrieb am Freitag, 27. Juli 2001, 01:17:22: I'm using PHP to add records into a mysql database. The records write successfully to the database except for the timestamp field which I have defined as Field Type

Re: not null

Hm you need to define what kind of column you want... like integer, text, varchar, enum etc etc something like: create table tablename (ID int not null auto_increment, something varchar(255) not null, ...) I would strongly recommend to read the manual! You find it at www.mysql.com There are

Re: MySQLGUI 1.7.x crashes on Windows

[EMAIL PROTECTED] writes: Hi, I'm a little bit new here, so I don't know this has been asked before. Anyway..MySQLGUI 1.7.4 and 1.7.5 (Win32) both crash if you select Administration-Set Password: The statement in 0x77f74d8a points to memory in 0x1fe1 ... This shouldn't happen.

RE: excell text file to mysql table using php admin?

Heres the text file i'm trying to upload, btw... Hi, I'm using PHP Admin 2.2.0pre5 (unofficial stable-branch)and MySql 3.22.32 I have created the following table: Field Type Attributes Null Default Extra Action agent_id smallint(6)No 0Change Drop Primary Index Unique first_name

Re: Multiple Tables

Rafal Jank writes: So in release 4.0 there will be multitable updates, not only deletes? -- _/_/ _/_/_/ - Rafa³ Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk,

RE: not null

You must specify a datatype: create table table_name ( Column_Name integer not null ); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Fri, 27 July 2001 06:48 To: [EMAIL PROTECTED] Subject: not null I am having trouble setting a column attribute to not

Re: Unix passwd file and mysql authentication table

Don Read wrote: On 26-Jul-2001 sachin shetty wrote: Hi Is it possible to authenticate a logged on user by comparing the unix passwd file entry with the mysql user table entry(after copying passwords from the password file to the table). The password_crypt routine used in MySQL is

Re: possible bug in sum() function

[EMAIL PROTECTED] wrote: We keep a timecard database and I was just asked how much time had been charged to a particular project code. No problem says I and did the following: select sum(worktime) from timecard where tcacct=project; The answer came back 182. Then I was asked who had

Re: not null

[EMAIL PROTECTED] wrote: I am having trouble setting a column attribute to not null. Below is the statement I am using: create table table_name ( Column_Name not null ); If this is not the correct way to do it, can someone please help me...this is my first mysql database.

Re: possible bug in sum() function

On Thu, 26 Jul 2001 [EMAIL PROTECTED] wrote: We keep a timecard database and I was just asked how much time had been charged to a particular project code. No problem says I and did the following: select sum(worktime) from timecard where tcacct=project; The answer came back 182. Then I was

Re: disable the mysql port

You can add : skip-networking : to your my.cnf file. You will only be able to connect to the database server from localhost then. -- Jason On 7/26/01 5:21 PM, Michael Lin was heard saying: Hi, Does anyone know how to disable mysql listening port? Thanks, Michael Lin

Re: I can kill it but Can't stop mysqld

On Thu, 26 Jul 2001, cjackson wrote: Thanks everyone for immediate response to this problem. I can kill the mysql process but I cannot stop it using /etc/rc.d/init.d/mysqld stop. I can start it like this using start but not stop it using stop. All of this is done as system root. So runlevel

Re: installing mysql

Hi! You are obviously running a 3.23.38 binary. Sorry, the executable mysqld.exe was in that version accidentally compiled with __NT__ defined, which means that mysqld.exe does not work on Win 98. Use mysqld-max.exe from the same distribution, or download 3.23.39 from www.mysql.com. InnoDB does

Re: Unable to use shortcut keys

You mean within mysql? That's a program, doskey won't do anything inside that program. Oh junhui schrieb am Freitag, 27. Juli 2001, 06:49:05: Hi, I am currently using mySQL 3.23.39, under windows 98 SE environment. When i am running mySQL using MSDOS-prompt, there is no shortcut key

Re: not null

Example: CREATE TABLE rassen ( id smallint(5) unsigned NOT NULL auto_increment, bezeichnung varchar(50) NOT NULL, kurz varchar(25) NOT NULL, total smallint(5) unsigned DEFAULT '0' NOT NULL, totalDeck tinyint(4) DEFAULT '0' NOT NULL, PRIMARY KEY (id), KEY id (id,

Re: Moving database from windoze to Linux

try to use mysqlfront ( http://www.mysqlfront.de ), a windows GUI for mysql i've tried it and it works like a charm you can export table structure in a .sql format and then dump data into a csv file and use the same utlity to import the files into your linux machine; regards; At 08:00

Re: Lost connection

Date |Thu, 26 Jul 2001 19:11:21 -0700 From |Hannes Niedner [EMAIL PROTECTED] Hello! HN I just checked upon the following query which was already running for 3+ HN hours. The sequence field is a non-indexed text field (is for once only HN join). mysql create table genpept_sequence_protein HN -

Re: not null

Date |Fri, 27 Jul 2001 00:47:50 EDT From |[EMAIL PROTECTED] Hello! C I am having trouble setting a column attribute to not null. Below is the C statement I am using: C create table table_name ( C Column_Name not null C ); C If this is not the correct way to do it, can someone please help

  1   2   >