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: 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

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 create

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 using

Re: Safe Database Problem

2004-02-13 Thread Mike Miller
; -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 from the book and have been fighting with the same problem for about 6 hours

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

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 file:

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, the

Re: Show database problem

2003-09-02 Thread Albert
[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 way. mysql SHOW GRANTS FOR admFrederic

RE: Show database problem

2003-09-02 Thread Fortuno, 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 : mysql\binSHOW GRANTS FOR uma; I get a response that show is not a command etc.. This is on Win32 version 4.x

Re: Show database problem

2003-09-02 Thread Roger Baklund
* Albert When I enter : mysql\binSHOW 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 do you mean

Re: Show database problem

2003-09-02 Thread Albert
] 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' is a user account and not a database or table? Normally, you use SHOW GRANTS FOR user_account. See

Re: Show database problem

2003-09-02 Thread Albert
]; [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 Antony Dovgal
On Tue, 2 Sep 2003 08:45:42 -0400 Albert [EMAIL PROTECTED] wrote: When I enter : mysql\binSHOW 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

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\binSHOW GRANTS FOR uma; I get a response that show is not a command etc

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] |

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 General

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... snip 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 I

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

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

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 #31639;#30424;#12290; 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

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 #31639;#30424;#12290; its not only waste the space, also i have problem to display

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: 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): lrwxrwxrwx1 mysqlmysql

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

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 permission etc

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 Emiliano Carlesi
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 Hi !!! Scuse me if before I insert few data to analize the problem :-) Now at the shell

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

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, 2001 16:37 Subject: create database problem

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

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