Could not start mysql daemon

2001-03-29 Thread Denis Mettler
Hi, I had a running system (suse Linux 7.1, php 4, mysql 3.22.32 and apache 1.3.12). but the mysql daemon is running in root. 10 minutes before i tried to add a new user in the table user of the db mysql. but i got no results. so, i tried again. -nothing! then i killed the mysql daemon. and no

Could not start mysql daemon

2001-03-29 Thread Denis Mettler
Hi, I had a running system (suse Linux 7.1, php 4, mysql 3.22.32 and apache 1.3.12). but the mysql daemon is running in root. 10 minutes before i tried to add a new user in the table user of the db mysql. but i got no results. so, i tried again. -nothing! then i killed the mysql daemon. and no

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

2001-03-21 Thread denis mettler
Hi, I'm really tired of this problem... Here's the error message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /usr/local/httpd/htdocs/dbopen.php3 on line 5 I have Suse 7.1 Standard installation with apache1.3.14 and php3.0.17 Apache is running Sim

Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler
March 2001 18:25, you wrote: > It is more likely /tmp/mysql.sock > > tmp has no 'e'. > > denis mettler wrote: > > Hi, > > > > I did. but the problem is the same. > > > > regards > > denis > > > > On Tuesday 20 March 2001 17:4

Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler
ilar, then make "chmod g+rx > /var/lib/mysql", this should work. if not try to make a "chmod o+rx > /var/lib/mysql", this should always work, but I think it isn´t a good idea > to leave it that way. > > Egon > > --- > URL: http://www.snb.at > mailto:[EM

Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler
Hi, I did. but the problem is the same. regards denis On Tuesday 20 March 2001 17:45, you wrote: > try: > [mysql] > mysql.default_socket = /temp/mysql.sock > > > Cal > http://www.calevans.com > > > -Original Message- > From: denis mettler [mailto:[

Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler
Egon > > --- > URL: http://www.snb.at > mailto:[EMAIL PROTECTED] > --- > http://www.grusskarte.at > > > > > > denis mettler <[EMAIL PROTECTED]> > 20.03.01 15:02 > > > An: [EMAIL PROTECTED] > Kopie: > Thema: Can't con

Re: Problem Setting up MyODBC Driver

2001-03-20 Thread denis mettler
Hi Nick, I think u have to make the following. go to mysql prompt: use mysql; then select * from user; is there an entry for the mysql client and the user on it? i don't think so. so u have to make a new entry. then: grant all on *.* to username@clienthostname username (username u are conne

Can't connect throug socket

2001-03-20 Thread denis mettler
Hi Thanks for the help, I checked again. but i don't have an entry in php.ini [mysql] mysql.default_socket    = So, i did execute the tip from egon. But now, i don't get the content from .php files but i think i'll get it to work today. thanks regards denis ---

Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler
Hi, I get the following message if i try to connect to server: Can't connect server through socket /var/lib/mysql/mysql.sock(111) Cal said, i should modify my php.ini and should give the exact definition for the mysql socket. but i don't have an entry in the php.ini for mysql socket. any idea

ODBC

2001-03-18 Thread denis mettler
Hi there, I have the following problem which i can not solve. i try to connect access with odbc to mysql. i have a table: name age id (primary key, auto_increment) misc (timestamp) i can connect but the entries are shown as #deleted- Why? i have installed the new MDAC! i have no float fields

ODBC // #gelöscht

2001-03-18 Thread denis mettler
Hi, Habe folgendes Problem: Ich verbinde über ODBC (MDAC 2.5 ist installiert) Access mit einer MySQL Datenbank. Ich kann mit der MySQL Datenbank verbinden, aber die Einträge in der Tabelle werden als #gelöscht angezeigt. Ich habe aber auch kein float Feld. Habe ein auto_increment, Primary K

MYSQL Connection failed

2001-03-18 Thread denis mettler
Hallo, Kann mir irgend jemand helfen? Ich kann mit der folgenden Meldung nichts anfangen: Anbei die Datei zum verbinden zur Datenbank: _ Yes, we're open! Handle: $conn"; } else { echo "Oops, something goes wrong"; exit; } $select = mysql_select_db("cust

MYSQL Connection failed

2001-03-18 Thread denis mettler
Hallo, Kann mir irgend jemand helfen? Ich kann mit der folgenden Meldung nichts anfangen: Anbei die Datei zum verbinden zur Datenbank: _ Yes, we're open! Handle: $conn"; } else { echo "Oops, something goes wrong"; exit; } $select = mysql_select_db("cust

Persistent connection with php to mysql

2001-03-18 Thread Denis Mettler
Hi, some of you work with php and mysql to connect a website with a mysql database. do u prefer an simple connection or a persistent connection? and if u prefer the last one. how can u make this connection in the index.php3? do u make this with an "./include"? thanks regards denis

ODBC

2001-03-17 Thread Denis Mettler
The Problem was that i didn't have a primary key in addition to a timestamp field. that's all. regards denis .' '.' `. _.-| o | o |-._ .~ `.__.'.__.'^ ~. .~ ^ / \ ^ ~. \-._^ ^| |^_.-/

2 Tables

2001-03-17 Thread Denis Mettler
Hi there, Another problem. i have the following tables: table 1: id, primary key, auto increment name varchar(50) city varchar(50) phone varchar(25) table 2: categorie_id, primary key, auto_increment kategorie varchar(50) in table one i have the contacts and in table two the categories (Busi

MySQl // Access // ODBC

2001-03-16 Thread Denis Mettler
Hi, i read the manual. but i don't know what to do. I have a table. only 2 columns without a primary key. so i made the following: alter table 'tablename' add id auto_increment primary key; and alter table 'tablename' add Misc timestamp; But all fields are filled with #deleted. i don't hav

Access & MySQL --> a new feature

2001-03-16 Thread denis mettler
Hi, i have a mysql db on suse linux 7.1 only one table without primary key. then i inserted data via load data local infile everything was fine. then i altered table and added a primary key everythings fine, too. i'm searching for results: select * from 'tablename' where ID<10; got th

Error: MYSQL Connection failed

2001-03-16 Thread denis mettler
Hi there, First i have the mysql db on linux in /usr/local/ then i installed new on /var now i get the message: Warning: MYSQL Connection failed: Can't connect to local MYSQL Server through Socket '/var/lib/mysql/mysql.sock' (111) in /usr/local/httpd/htdocs/dbopen.php3 on line 8. This is the

Primary Key

2001-03-16 Thread denis mettler
Hi, Can i add the Primary key for a table after i created a table? and if this column is not null and auto_increment will there occur an error? t.i.a. regards denis - Before posting, please check: http://www.mysql.com/manua

MySQL over ODBC

2001-03-15 Thread denis mettler
Hi there, i received the following message: [TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server (#1130) any ideas regards denis - Before posting, please check: http://www.mysql.com/manual.php (the man

Hi,AW: LOOKING FOR A FRONTEND FOR MYSQL

2001-02-26 Thread Denis Mettler
Hi, Check out MysqlGUI at www.mysql.com I think it's the best. But there are a lot of other GUI's. -- Best Regards / Beste Gru?e Denis Mettler http://www.denis-mettler.de -- Unix is an operating system, OS/2 is half an operating system, Windows is a shell, and DOS is a boot parti

AW: Exporting data from MySQL to Oracle

2001-02-13 Thread Denis Mettler
Hi there, please check the oracle migration bench at the oracle technet. http://technet.oracle.com kind regards denis mettler -Urspr?ngliche Nachricht- Von: Noor Dawod [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 13. Februar 2001 17:23 An: Cal Evans; MySQL List Betreff: RE