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# .

Help Please OpenBSD & Mysql

Has anyone ever seen this error. I have loaded mysql on a sparc running openbsd. I have asked on the opebsd list and searched for days on google and deja. But it seems as if mysql has a problem running on the sparc platform because others have ran in to this eact same problem but have not been pro

Help with myODBC

Hello people, I've a mysql database which is quite large and I needed to create a backup for it, which I can use offline in MS Access or such. I've tried using MyODBC, but one strange problem has come up. Certain fields (defined as TEXT) in my databast have multiple lines in them, separated by CR

Can't stop msqld

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 shut it down. Then I created a password for root. Mysql still starts but I can't stop it as root or any other user. It runs as user mysql which also requires password.

access dbs to mysql dbs

Hi How can u take profit of my already done access dbs to create a new one in mysql ? Thanks _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ---

Re: Mysql Security (fwd)

> The fact that he has logged on should not require him to specify > password again. This fact means: when a user is logged in, he is allowed to use the mysql-server: use this one:( every logged -on -user on localhost has all rights to every base and table without pw) GRANT USAGE ON *.* TO "

mysql authentication via /etc/passwd

Hi I have written an app to extract data from the mysql database which would be run by around 3000 users.But I would like to use the login/passwd in the /etc/passwd file for authentication. Is it possible to use /etc/passwd for 'mere' authentication and then let the table permissions in the use

Re: DISSERTATION2 [VIRUSES STRIPPED]

You have a virus on your system sending email with virus attachments. As a respected Individual or company in business, it is imperative that you fix your system by deleting the virus infection. Below are some simple steps you can take so it won't be sent to anyone else. WHY YOU NEED TO DO SOMETH

Correct DISTINCT syntax for MYSQL version 3.22.32

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 following fields: IP_address web_date web_time

Unix passwd file and mysql authentication table

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).If there is a module that handles this during connection of the mysql client to the server, then it saves the risk

Re: FW: encrypt

So sprach »Christian Grimm« am 2001-07-25 um 22:16:04 +0200 : > sa must be a 2-char long Salt-String... Which is completely optional :) sql,database,filter Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.

The old interfering with the young

Here's my problem: 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 everything seems to be working smo

Re: Mysql Security (fwd)

-- Forwarded message -- Date: Thu, 26 Jul 2001 13:15:06 -0400 (EDT) From: sachin shetty <[EMAIL PROTECTED]> To: Christian Grimm <[EMAIL PROTECTED]> Subject: Re: Mysql Security Thanks Christian But when a user connects to the server isnt it mandatory to specify the password?. I

Building MySQL on HPUX with InnoBase support

I have had problems building the MySQL database server when I include support of InnoBase DB files. During the build process I must use the HP/ANSI compilers. This causes an error while building the mach0data.c file in the mach directory in the InnoBase directory structure. Has anyone on HP-UX 11

CREATE SEQUENCE

Hello, Does anybody know what the SQL statement: CREATE SEQUENCE do? I cannot find any info on this in the http://www.mysql.com/docs section. Thanks, Bryan Capitano - Before posting, please check: http://www.mysql.com/ma

Mysql Security

Hello my friend, shure its possible! additional you can insert into the user table of mysql the encryptet Password-Hash of your local etc.shadow-Phile to verify the correct Password and authenticate the the user. Hope it helps Christian sachin shetty wrote: > Hello > > Is it possible to auth

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

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 +0200 (CEST) Subject: Returned mail: Host unknown (Name server: mailserv: host not f

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

In message <[EMAIL PROTECTED]>, tj marlin <[EMAIL PROTECTED]> writes >I think it is time for you to learn about regular expressions; page 520 >ff of Dubois. >(sql, mysql, database - to get past the filter) > any chance of an example or full syntax? M. -- Work:- postmasterAThinwick.demon.co

Re: Uploading files using PHP to database.

> Could anyone shed some light on how to go about uploading a text file > with a web interface using php into a mysql database. wow, that was a > mouthfull. I would much appreciate it. Well, that depends. Do you want to store the native text file fully intact say like you might store an image

Re: mysql and credit cards

So sprach »Alexander 'Digital Projects' Skwar« am 2001-07-26 um 18:48:15 +0200 : > MySQL's builtin ENCRYPT() function is good enough. No need to worry Uhm, is ENCRYPT decryptable? Anyhow, I was rather thinking about ENCODE()/DECODE(). > PS: filter sql Alexander Skwar -- How to quote: http:

[fwd] Re: mysql and credit cards (from: ASkwar@DigitalProjects.com)

So sprach »William R. Mussatto« am 2001-07-25 um 23:01:49 -0700 : > But what happens when the customer returns the product? You no longer > have the cC to do a chargeback Have him enter it again. Explain that this is done to increase the security and he may be fine. If not - well he's already

[fwd] Re: Re: mysql and credit cards (from: mysql@lists.mysql.com)

database,sql,query,table So sprach =BBPeter van Dijk=AB am 2001-07-25 um 23:59:48 +0200 : > That is only true for a parallel cipher. A non-parallel cipher (like Yep, that's why I said symetrical encryption. Asymetrical enc.'s work like you explained. Alexander Skwar -- How to quote: http://

Mysql Security

Hello Is it possible to authenticate a user running mysql client by comparing the unix username($LOGNAME) with the user table in mysql.It seems more secure than specifying the authenticaton parameters in a configuation file or along with the client. Thanks Sachin ---

Re: mysql and credit cards

So sprach »Fletcher Sandbeck« am 2001-07-25 um 15:08:48 -0700 : > I would counter that symmetric encryption is reasonably easy to > implement and provides a modicum of security, so why not go ahead and > do it. Just don't be fooled that a determined individual won't be > able to defeat your encr

Re: Moved MySQL to new machine.

13 is access denied. Your /var/lib/mysql ( Or whatever ) is owned by root, and mysql can not create a new directory. Jeremy wrote: > I recently moved my MySQL databases from one RedHat Linux 6.x machine to a new >RedHat 7.0 machine. Now, I can't seem to add databases. I get the following err

help on connection mysql

hello everybody: When I deal with my database log_db using mysql on linux, I meet with a problem like this: 1.the command is: #mysqlimport --local log_db http_tb --fields-terminated-by "," but mysql run wrong .There are what mysql print out : Error: lost connection to

Re: stability of freebsd 4.3, gcc 2.95.3

Allen, Sorry to take so long to reply I have been away, and will be away again in a few hours. Try this is a shell script: rm config.cache CC=gcc CFLAGS=-O3 CXX=gcc \ CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \ ./configure $DEBUG --enable-large-files --with-berkeley-db -

Re: Compiling MySQL 3.23.39 on FreeBSD 4.3

Hi Juraj, I don't see an anwser to your request, so I will tell you that I have no problems compiling 3.23.39 or .40 or FBSD 4.3-release or stable. Here is my compile script rm config.cache CC=gcc CFLAGS=-O3 CXX=gcc \ CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \ ./con

Re: mysql and credit cards

On Wednesday 25 July 2001 17:53, Elvis wrote: > You can always degrade the credit card. > > 1) verify AUTH ONLY (not capture) with your CC provider. (if you want to verify they have funds available and the CC is valid) > 2) store the CC # in the database > 3) ..do your order processing thing or

Mysql Version 3.23.37

Hello, I downloaded the Mysql application from your site and installed it. While trying to start for the first time the MySQL with winmysqladmin.exe. I encountered some problems using your Readme file . I chose the mysqld-nt and then you say "Choose 'create my.ini' file I couldn't find it,

MFC

Hi, I’m new two this list as well, and I was wondering if anyone know how to connect an MFC application to a remote database? It works fine with my local database but when I come to create a file DSN for the remote one using MyODBC, it wouldn’t connect. Any ideas? Thanks.

joining two databases

> HIi, > i'm new to the list, i have a problem and i hope you have the answer. > 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? > Motasem. - Before

Re: MySQL Tests

> I installed MySQL 3.23.40 on Linux 6.2 and am having trouble > running the tests: > Can't locate DBI.pm in @INC (@INC contains:/usr/lib/perl5/5.00503/i386-linux > /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux > /usr/lib/perl/5.005 .) at ./run-all-tests line 36. > BEGIN faile

Re: innodb unrecognized option

Ryan, I think it is a long line problem. Monty recently increased the my.cnf option text length to 256 or 512 characters, but obviously your line is exceeding the limit. I am sending a copy of this email to Monty, so that he can consider increasing the maximum to 1 kB. Regards, Heikki http://w

Re: MySQL Tests

On Thu, 26 Jul 2001 09:32:47 -0400, Cavo Vincent Civ AFRL/SNRT <[EMAIL PROTECTED]> wrote: >>I installed MySQL 3.23.40 on Linux 6.2 and am having trouble >>running the tests: >>Can't locate DBI.pm in @INC (@INC >>contains:/usr/lib/perl5/5.00503/i386-linusr/lib/perl5/5.00503 >>/usr/lib/perl5/sit

MySQL Tests

Sir/Madam: I installed MySQL 3.23.40 on Linux 6.2 and am having trouble running the tests: Can't locate DBI.pm in @INC (@INC contains:/usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl/5.005 .) at ./run-all-tests line 36. BEGIN failed

MySQL Tests

Sir/Madam: I installed MySQL 3.23.40 on Linux 6.2 and am having trouble running the tests: Can't locate DBI.pm in @INC (@INC contains:/usr/lib/perl5/5.00503/i386-linusr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perlte_perl/5.005 .) at ./run-all-tests line 36. Line 36

Re: Multiple Tables

> > I want to associate John Doe with system1. How do I get mysql to extract the sysid >from the system table and then update the user table with the sysid and the username? > > > > Thanks, > > > > Phil > > > > > > This feature is scheduled to come up in 4.0, which will be released > this Autumn

RE: MySql Server creating problem

hi, I am working on linux. my mysql server is creating problems. when i do ./mysqld start, i get server started ok. But i am not abel to login the message i get is ERROR 2002: Can't connect to local MySQL server through socket' /var/lib/mysq

Re: Multiple Tables

Philip Montgomery writes: > I am overlooking something as for the code to update the user table. Maybe it would >help to make it more concrete. > > Assume that I create two tables with the following statements: > > CREATE TABLE system ( > sysid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, > sysname

Re: Multiple Tables

I am overlooking something as for the code to update the user table. Maybe it would help to make it more concrete. Assume that I create two tables with the following statements: CREATE TABLE system ( sysid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, sysname VARCHAR(12), os VARCHAR(10), cpumhz INT

Re: Procedures

=?iso-8859-2?Q?Michal_Proke=B9?= writes: > I need to use procedures in mysql. > Does somebody know, what is the easiest way? > > I hear, that it is possible to compile new procedures to mysql, but I don't > know how! > > Thanks Michal > Check our manual on UDF's. -- Regards,

localisation error - please, please help me

Hi, I have configured MySQL with charset latin2 on a Linux box. I made a big table with a mediumtext filed and a search engine using MySQL match-against. On the Linux box everything looked fine. Now we replaced our server to FreeBSD. I compiled the same source with the same configuration settings

Re: Compile Error Tru64 __cxa_pure_virtual

Kundiger, Rick writes: > When compiling with gcc3.0 mysql 3.23.4 I get the following error trying to > link the mysqlbinlog (I think) any idaes? > > Rick > > lmach -lexc > mkdir .libs > gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti > -fno-implicit-templates -fno-exception

Re: Record ID

On Thu, Jul 26, 2001 at 10:17:56AM +0200, Peter Wiherkoski wrote: > >Hello, what is the best way to handle record id in MySQL? Has MySQL > >some kind of automatic record id? > > > >if you need a record id which increments automatically, then you can use the > >int types( tiny, medium or int) wit

Urgent help needed, is this a version bug?

Hello John, are you sure, that the user "test" with password "test1" exist in your Grant-Tables and has rights to INSERT ??? [;-)] Gruß Christian john zie wrote: > > > > Mysql: > > We have installed mysql 3.23.26 beta version to a BSD 4.2 server. It > works fine, however when we test a

Problem in linking MySQL 4.0

I'm getting this when I'm trying to compile MySQL 4.0. Is it something wrong with my thread library? Red Hat 6.1, glibc 2.1.2-11 ../pstack/libpstack.a(linuxthreads.o): In function `linuxthreads_notify_others': linuxthreads.o(.text+0x16): undefined reference to `__pthread_handles_num' linuxthreads

Re: java & mysql

In your Java app on Linux, change the db connection string to point to the old MySQL db server in Windows. For Linux, you can download MM JDBC driver from MySQL Contribution. Install and set-up by following the instruction. Set your dbURL = "jdbc:mysql://YOUR_WINDOWS_HOST_NAME/IP:3306/YOUR_DB_NA

RE: java & mysql

Hi Sibel, on linux, you just d/l the mmmysql jdbc driver and place the mysql_uncomp.jar in the classpath. and then do a 1. GRANT ALL ON db_name.* TO "user_name"@"host_name" IDENTIFIED BY "your_password". 2. set your path for your jdk/bin 3. u are up and running! u don't need to make any modifica

MySql Server creating problem

Hello Selva, the best way to start the server is: 1. change to your mySQL-directory and then: 2. ./bin/safe_mysqld & starts the damon via script in the background (&) Alles wird gut! [;-)] Christian

Error in linking MySQL 4.0

I'm getting this when I'm trying to compile MySQL 4.0. Is it something wrong with my thread library? Red Hat 6.1, glibc 2.1.2-11 ../pstack/libpstack.a(linuxthreads.o): In function `linuxthreads_notify_others': linuxthreads.o(.text+0x16): undefined reference to `__pthread_handles_num' linuxthreads

Procedures

I need to use procedures in mysql. Does somebody know, what is the easiest way? I hear, that it is possible to compile new procedures to mysql, but I don't know how! Thanks Michal - Before posting, please check

java & mysql

Hi, I have a Java program, from which I'm accessing the data in a mysql database via jdbc. I want to run the program on linux and on windows, without changing the code. I was using the jdbc-odbc driver on Windows, but on linux I can't use this. I would be glad, if someone knows, how to manage thi

Various Issues the Mysql Community seems to be raising

I have been a member of this list for a week now and have read with interest the issues that are raised. I have tools that will resolve some of these issues especially for new users of MySQL. I know this list probably should not be used as a sales forum but I do believe I have a tool that will hel

RE: Record ID

>Hello, what is the best way to handle record id in MySQL? Has MySQL >some kind of automatic record id? >if you need a record id which increments automatically, then you can use the >int types( tiny, medium or int) with the attribute that it be unsigned and >auto_increment like this: >record_id

MySql Server creating problem

hi, I am working on linux. my mysql server is creating problems. when i do ./mysqld start, i get server started ok. But i am not abel to login the message i get is ERROR 2002: Can't connect to local MySQL server through socket' /var/lib

3.23.40 Win32 version

Hi all, I couldn't find the latest 3.23.40 Version available under Win32. Does anybody know when it would be released? Thanks. Regards, Michael

RE: Record ID

if you need a record id which increments automatically, then you can use the int types( tiny, medium or int) with the attribute that it be unsigned and auto_increment like this: record_id mediumint unsigned not null auto_increment regards shane -Original Message- From: Peter Wiherkoski [

charsets on win32 mysql

Hi, File 'c:\mysql\\share\charsets\?.conf' not found (Errcode: 2) Character set '#26' is not a compiled character set and is not specified in the 'c:\mysql\\share\charsets\Inde What this error means ??? i have these settings: [mysqld] basedir=C:/Program Files/MySQL datadir=C:/Program Files/My