Re: database problem

2005-09-01 Thread SGreen
dEeZAcK SweETtY <[EMAIL PROTECTED]> wrote on 09/01/2005 10:27:28 AM: > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: cannot

Re: database problem

2005-09-01 Thread gerald_clark
dEeZAcK SweETtY wrote: __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]

database problem

2005-09-01 Thread dEeZAcK SweETtY
__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: cannot create database Description: I have already set the path to c:\mysql\bin

Re: Safe Database Problem

2004-02-13 Thread Mike Miller
Y Lock_tables_priv: Y Cheers; -M From: Victoria Reznichenko <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: Safe Database Problem Date: Fri, 13 Feb 2004 13:38:50 +0200 "Mike Miller" <[EMAIL PROTECTED]> wrote: > Hi, > > I believe I've done everything

Re: Safe Database Problem

2004-02-13 Thread Victoria Reznichenko
"Mike Miller" <[EMAIL PROTECTED]> wrote: > Hi, > > I believe I've done everything from the book and have been fighting with > the same problem for about 6 hours thus far. > > I just upgraded from MySQL 3.23.56 to 4.0.17. In the old system, I > prevented show databases from ordinary users us

Safe Database Problem

2004-02-12 Thread Mike Miller
Hi, I believe I've done everything from the book and have been fighting with the same problem for about 6 hours thus far. I just upgraded from MySQL 3.23.56 to 4.0.17. In the old system, I prevented show databases from ordinary users using skip-show-databases. In order to upgrade I used t

Re: Database problem.

2004-02-05 Thread Vinay
try to use the "myisamchk" to check/repair MyISAM tables Pablo Pragana wrote: > I hope you can help me with this: > > Incorrect information in file: './sarara/searchindex.frm' > > Error > > consulta SQL : > > SHOW KEYS FROM `searchindex` > > MySQL ha dicho: > > #1033 - Incorrect information in

Database problem.

2004-02-02 Thread Pablo Pragana
I hope you can help me with this: Incorrect information in file: './sarara/searchindex.frm' Error consulta SQL : SHOW KEYS FROM `searchindex` MySQL ha dicho: #1033 - Incorrect information in file: './sarara/searchindex.frm' How can I fix this??? Thanks ___

Re: Show database problem

2003-09-03 Thread Victoria Reznichenko
"Joris Beckers" <[EMAIL PROTECTED]> wrote: > > I used the flush privileges command > > There are in total 6 databases > > But only mysql and cehdb are visible. > > The MySQL version is 4.1.0-max-nt > > There are no other hosts configured for that user other then % > > Because it's mysql 4, th

Re: Show database problem

2003-09-02 Thread Albert
Message - From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Albert" <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 9:36 AM Subject: Re: Show database problem > * Albert > > When I enter : > > > > mysql\bin

Re: Show database problem

2003-09-02 Thread Antony Dovgal
On Tue, 2 Sep 2003 08:45:42 -0400 "Albert" <[EMAIL PROTECTED]> wrote: > When I enter : > > mysql\bin>SHOW GRANTS FOR uma; > > I get a response that show is not a command etc.. > > This is on Win32 version 4.x > > The same happens when I try it from mysql> > and also after I run mysqld > > An

Re: Show database problem

2003-09-02 Thread Albert
o: "'Albert'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 9:38 AM Subject: RE: Show database problem .com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Show database problem

2003-09-02 Thread Albert
ortuno, Adam" <[EMAIL PROTECTED]> To: "'Albert'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 9:38 AM Subject: RE: Show database problem > Albert, > > This may sound minuscule. You're certain that 'uma'

Re: Show database problem

2003-09-02 Thread Roger Baklund
* Albert > When I enter : > > mysql\bin>SHOW GRANTS FOR uma; > > I get a response that show is not a command etc.. > > This is on Win32 version 4.x > > The same happens when I try it from mysql> > and also after I run mysqld > > Any ideas what is wrong here? When you say you "try it from mysql>" d

RE: Show database problem

2003-09-02 Thread Fortuno, Adam
;%' Albert, one suggestion. Next time provide the exact error message. It makes it easier to assist. Regards, Adam -Original Message- From: Albert [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 8:46 AM To: [EMAIL PROTECTED] Subject: Re: Show database problem When I enter :

Re: Show database problem

2003-09-02 Thread Albert
"Joris Beckers" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 01, 2003 11:19 AM Subject: Show database problem > I've got a user, admFrederic > He got the grants shown below. > Those are correct and I configured them that wa

RE: Show database problem

2003-09-01 Thread Joris Beckers
I used the flush privileges command There are in total 6 databases But only mysql and cehdb are visible. The MySQL version is 4.1.0-max-nt There are no other hosts configured for that user other then % Because it's mysql 4, the safe-show-database option is not usefull All the users that exist

Re: Show database problem

2003-09-01 Thread Yves Goergen
On Monday, September 01, 2003 5:19 PM CEST, Joris Beckers wrote: > But, when I log in using that username. That user can access the main > database... > > > > Does anyone know how to fix this? > Only cehdb should be accessable. Did you try to set the safe-show-database flag? Hm, let me see where

Re: Show database problem

2003-09-01 Thread Antony Dovgal
On Mon, 1 Sep 2003 17:19:52 +0200 "Joris Beckers" <[EMAIL PROTECTED]> wrote: > I've got a user, admFrederic > He got the grants shown below. > Those are correct and I configured them that way. don't forget about FLUSH PRIVILEGES; --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL G

Show database problem

2003-09-01 Thread Joris Beckers
I've got a user, admFrederic He got the grants shown below. Those are correct and I configured them that way. mysql> SHOW GRANTS FOR admFrederic; +--- + | Grants for [EMAIL PROTECTED] | +---

DATABASE PROBLEM

2002-09-26 Thread Thomas Edison Jr.
HI! there is a problem in mysql database.there r two tables.one table is named as transactions and the other is named as the code.the transactions table has got the 12 fields which r the following 1.clientid int 2.date date 3.isinno text 4.debit int 5.credit int 6.desc text 7.dpid1 text

Re: database problem

2002-04-09 Thread Dicky Wahyu Purnomo
On Wed, 10 Apr 2002 03:59:22 + "saraswathy saras" <[EMAIL PROTECTED]> wrote: > hi everybody, > > i have problem with storing chinese word to databaseall the chinese > automatic change to code like this 算盘。 its not only > waste the space, also i have problem to display it...sometime, some

database problem

2002-04-09 Thread saraswathy saras
hi everybody, i have problem with storing chinese word to databaseall the chinese automatic change to code like this 算盘。 its not only waste the space, also i have problem to display it...sometime, some of the word not complete and also display symbols.is there anybody can help me? Please

RE: Symbolically linked database, "unknown database" problem.

2001-12-06 Thread Quentin Bennett
, "unknown database" problem. I've created databases on a partition without problems, now I come to create a new database on a different partition and I can't access the database at all. At this stage I have the following in the mysql data directory (among others): lrwxrwxrwx

Symbolically linked database, "unknown database" problem.

2001-12-06 Thread Peter Campbell
I've created databases on a partition without problems, now I come to create a new database on a different partition and I can't access the database at all. At this stage I have the following in the mysql data directory (among others): lrwxrwxrwx1 mysqlmysql 17 Sep 3 11:56

RE: create database problem

2001-09-06 Thread Emiliano Carlesi
you > cannot do somethings that you mentioned in ur mail. > > Sheena. > > -Original Message- > From: emiliano [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 06, 2001 12:55 PM > To: [EMAIL PROTECTED] > Subject: Re: create database problem > > >

Re: create database problem

2001-09-06 Thread emiliano
Hi !!! Scuse me if before I insert few data to analize the problem :-) Now at the shell I insert the command 'mysql' then at the prompt of mysql if I insert the command 'connect test' this work and I can use sql command to work on the database. If I else insert 'connect mysql' (the other db

Re: create database problem

2001-09-06 Thread Gerald Clark
Show us what you type, and what error message you get. Emiliano Carlesi wrote: > Hi !!! > I'm new in this ml. > I've installed MySQL on my linux box follow the > instruction ... I have : > > create user mysql > create group mysql > compiled mysql > exec the script install_db > changed permissio

create database problem

2001-09-06 Thread Emiliano Carlesi
Hi !!! I'm new in this ml. I've installed MySQL on my linux box follow the instruction ... I have : create user mysql create group mysql compiled mysql exec the script install_db changed permission etc ... all this operation are doing by root user. I can connect to the db 'test' without problem

Unknown database problem

2001-08-31 Thread Artem Koutchine
Hi! I having a very weird unpredictable problem. A script run from cron at 2:00am every day must conect to database 'ubex' and do some stuff with it. The script is in perl and uses DBI. It works fine pretty much all the time but sometimes (1 or 2 time per month) it gives an error: Unknown databa

Re: create database problem

2001-06-19 Thread Rolf Hopkins
"mysqladmin --help" will provide you with a list of switches you can use. If you add "-u root" to the shell command , perhaps you'll have more success. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 19

create database problem

2001-06-19 Thread mhafizm
shell>mysqladmin create trial mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'trial'' why this happened i only can use test database by default - Before posting, please check: ht

Database problem with Autonumeric(s) after crash

2001-06-11 Thread Cesar Cabrera
Hello, I had a problem with my server: it was shut down by a sudden energy cut, after that I ran a 'myisamchk -o' for recover the tables but the autonumerics fields insert -1 and nothing else. What should I do to resolve that problem (I have 5 tables with autonumeric in

upgrade / database problem?

2001-04-27 Thread Marc Bragg
Am running Redhat 7.0, and had installed. 3.23.22. with php4.0. Would like to upgrade to 3.23.32. No existing tables or data. Any major problems anyone having with .32 version on 7.0 redhat? Also, any special steps to upgrade rpm and keep php4.0 intact? What add'l libraries are needed? What about

Re: Strange database-problem: deletion of rows

2001-02-25 Thread Fred van Engen
On Sun, Feb 25, 2001 at 12:16:39AM +0100, Katja Ide wrote: > Hi everyone, > We've got a database with 46 tables running on the server of Schlund for > four months now. During these four months we've been inserting data into > the database by PHP-scripts without any problem whatsoever - until two >

Strange database-problem: deletion of rows

2001-02-24 Thread Katja Ide
Hi everyone, I've got a problem with my MySQL-Database that I've been dealing with for nearly two weeks now and I don't seem to get a clue of what it's about. My webspace-provider (Schlund & Partner in Germany: http://www.schlund.de) doesn't have a solution either, nor have some of my expert-frien