On Thu, 19 Apr 2001, feldekis wrote:
> ./bin/mysql -p -user=root
> Enter password: password
> ERROR 1045: Access denied for user: 'ser=root@localhost' (Using password: YES)
^
mysql -p -u root, not mysql -p -user=root
pz
--
Bartosz Sienkiewicz
---
take a look at /var/mysql :)
- Original Message -
From: "Philip Mak" <[EMAIL PROTECTED]>
To: "feldekis" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 11:59 PM
Subject: Re: there is no mysql/var directory
> On Wed, 18 Apr 2001, feldekis wrote:
>
> > Hi every
Ive come up with a curly problem and im wondering if anyone can shed some
lights on it. I looked under the SELECT part of Mysql but it didnt seem to
cover this and I didnt know how to phrase it.
What I have is a displayed list on the site. This data that makes up the
list comes from 2 tables.
If anyone has successfully gotten MySQL to work on Mac OS X, could you
please share your tips/solutions? There are at least 3 other people who
are not able to get it to work and are showing a variety of problems
(can't shut msqld down (hangs), fails to complete the install tests
(mysql-test-ru
Hi.
On Wed, Apr 18, 2001 at 04:17:45PM +0800, [EMAIL PROTECTED] wrote:
> Siggy...
>
> thanks for the past reply...
>
> but i i dont want to SORT the record in ASCENDING or DESCENDING order
> just a plain invert...
That doesn't make really sense. According to the SQL specification,
without ORDE
I don't know if you have fixed this probelm, but I had the same problem on Red Hat
7.0. I had installed the rpm files from MySQL.com and RedHat.com. The problem was
solved by doing the following.
chmod 755 the "mysql" directory that contains the "mysql.sock" file.
I am currently running the l
>Subject: inverse function (database,sql,query)
>
>
>hello anybody knows how to invert selected records?
>
>example :
>
>i have selected records :
>
> apple
> mangoe
> cherry
> avocado
>
>if i invert it :
>
> avocado
> cherry
> mangoe
> apple
Records do not have order unless you use ORDER
Ch 7 of the manual contains a list of date functions that allows you to do
everything, short of boiling an egg.
- Original Message -
From: "Kevin Xin Lin" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 22:10
Subject: Date,time,datetime type
> Hi ther
Here's my 2cents worth. Speed, reliability, ease of use.
- Original Message -
From: "Dilkushan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 23:10
Subject: Help for the Final year project..
> Hi,
> I'm a final year student in a private Campus in Sri Lank
- Original Message -
From: <[EMAIL PROTECTED]>
To: Brandon Davis <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 7:17 PM
Subject: Re: timeGetTime
> 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 i
Hi There,
Please remove me from the mysql mailing list.
Leslie
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
Hi again...
I'm going to be crazy soon, it's 2h20 in the morning and i'm dead!
Anyway:
i've tried to make a new user, and i launch safe_mysqld from him.
Everything is ok. (i checked)
I've write: ./bin/mysqladmin -u root password password (exactly!!)
ok
and so:
./bin/mysql -p -user=root
Enter p
On Wed, 18 Apr 2001, ryc wrote:
> The subject field is a bit more tricky. You COULD change it to
> Char(255) but that would waste a lot of space seeing that most
> subjects are a lot shorter. You can move the subject into the table
> that holds the varchar bodies. This wont hurt anything because
How much difficulty is there in turning a MySQL replication server into a master?
You could also do something like:
select field1, field2 from table order by rand() limit 1;
HTH
Ben
- Original Message -
From: "Philip Mak" <[EMAIL PROTECTED]>
To: "Alec Smith" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 11:50 PM
Subject: Re: How to stru
Excuse me, i've solve my pb:
i just wrote: mysql -p -user=root
and nothing for the password, and it works... don't ask me why...
Phelles
Anyway thanks for your help Phillip!!!
-
Before posting, please check:
http://www.mysql.
On Wed, 18 Apr 2001, Alec Smith wrote:
> I've got a table of X rows, each with a unique ID as determined by
> auto_increment when the row is inserted into the database. How would I go
> about doing a SELECT on a row of the database and have MySQL return a row
> at random?
Maybe you can do someth
Can any one help me install Mysql on my Freebsd 4.2 box..
the first thing I did was:
got a copy of Mysql for mysql.com
placed in in the /usr/local
then:
>gzip -dc mysql-3_23_36-unknown-freebsdelf4_2-i386_tar.gz | tar -vxf -
created a mysql directory.
/usr/local/mysql
then
./configure --prefi
Hi again...
mysql daemon is running...
i've wrote 1 time: /my/path/mysql/bin/mysqladmin -u root password 'new-password'
nothing happened...
after that, i've tried: mysql -p user=root mysql
here it answers: ERROR 1045: Access denied for user: 'ser=root@localhost' (Using
password: YES)
If someone
I'm just starting to learn SQL and MySQL, and am curious as to how the
following query might be built.
I've got a table of X rows, each with a unique ID as determined by
auto_increment when the row is inserted into the database. How would I go
about doing a SELECT on a row of the database and hav
http://www.mysql.com/doc/M/a/Mathematical_functions.html
describes how to do this using the RAND() function.
-Original Message-
From: Alec Smith [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 6:27 PM
To: [EMAIL PROTECTED]
Subject: How to structure a random query
I'm just
Hi!
3.23.37 is now released.
This release mainly fixes some minor bugs, so we assume that most
users doesn't have to upgrade from 3.23.36.
The main change is that Innobase tables changed name to InnoDB to not
conflict with the German INNOBASE company. If you are using Innobase,
you need to ch
I thought I read that was in the plan for 4.0. I can't find where that's
stated in the docs though - all I see is the stuff about boolean operators.
Does anyone have experience with using the AOL PLS package for text
searching? I am thinking of using it.
Braxton
-Original Message-
Fro
> I have some VARCHAR columns (name, e-mail address and subject) that are
> used in every query, though. Should I change them to CHAR(255) so that I
> can do this? (On a related note, does anyone know whether the RFC for
> e-mail messages limit the subject length/name length/e-mail address length
On Wed, 18 Apr 2001, feldekis wrote:
> Hi everybody!!
> I've got a pb during the installation of the binary of mysql-3.22.32 (the same
> for 3.23.36 version):
> there is no mysql/var directory, so when i write: chown -R mysql
> /usr/local/mysql/var
> that doesn't work. And it's exactly the same f
That's weird - my Server will only let me have 210 connections if I set
max_connections to 300, it sets at 210. If I set it to 500, it still stays
at 210. Any ideas on how to increase this?
-Original Message-
From: Philip Mak [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 3:
Hi everybody!!
I've got a pb during the installation of the binary of mysql-3.22.32 (the same
for 3.23.36 version):
there is no mysql/var directory, so when i write: chown -R mysql /usr/local/mysql/var
that doesn't work. And it's exactly the same for mysql/bin.
So PLEASE!!! if someone can help me!
I read through the MySQL documentation on full text indexing, and there
does not seem to be a way to search for a *phrase*, e.g. searching for
a document that contains "Sailor Moon", as opposed to one that contains
the word "Sailor" and the word "Moon", not necessarily together. (Unless I
use LIKE
On Wed, 18 Apr 2001, Jesse E. Stay II wrote:
> I'm having a problem, which has occured before, in which I keep getting "Too
> Many Connections" Errors in my logs on the web server for MySQL. I am using
> Apache::DBI to connect. I fixed the problem before by just increasing the
> max_connections
I'm having a problem, which has occured before, in which I keep getting "Too
Many Connections" Errors in my logs on the web server for MySQL. I am using
Apache::DBI to connect. I fixed the problem before by just increasing the
max_connections. Unfortunately, I am at the max amount of max_connec
Simon,
Take a look at www.sunfreeware.com. Go to their Downloading/Installation
section (left panel) and grab the pkg-get script. Use pkgadd to install
it. (as root: pkgadd -d BOLTpget.pkg ). Then add /usr/local/bin to your
path. (PATH=$PATH:/usr/local/bin; export PATH)
Use pkg-get to get
On Wed, 18 Apr 2001, ryc wrote:
> A few tips for you... Store all the varchar/text columns for each message in
> a seperate table so that the primary message table only has fixed length
> fields (ie messageid, size, #of replies, userid, bodyid, ...).
I have some VARCHAR columns (name, e-mail add
Hello,
I am trying to find some information on MySQL. Could you folks help me
out. I need:
Max Database Size
Max Table Size
Max Size for a row
Max Number of rows
Max Number of Columns
Max number of indexes per table
Thanks!
Joshua Drake
-
Yeah, it does require one insert command per table, thats why some people
like transaction capability in tables. If we all could insert data into
multiple tables with one insert command then we wouldn't need transaction
support would we? H, that would be nice though! :o)
Patrick
-Origina
> Is it possible to use ASP with MySQL? I found a link
> in the documentation to
> www.amedea.cz/mysqlx/index.html which was supposed to
> have a downloadable MySQL COM extension but the
> website was not found.
Yes, it's possible to use ASP with MySQL. In a nutshell, you need to make
sure that
- Original Message -
From: "Pat Sherrill" <[EMAIL PROTECTED]>
Sent: Saturday, April 14, 2001 7:34 AM
Subject: Re: ADO RS.Update problem
> Just a quick note about RecordCount. RecordCount only returns the number
of
> records or rows from the recordset that have been 'seen'. Therefore it
NOTE: I have cross-posted this to the plusplus mailing list as well.
I am using sql_create_basic_N to generate structures that mirror my database
tables. The problem I have is that some of the fields in my database are
"blobs" that need to be escaped before insertion.
Questions:
1. I am u
After posting yesterday about mysql_install_db haning when it says
"Installing all prepared tables" I've tried the rpm version, and it hangs in
the exact same place.
How do I get it to work? The other posts suggest that it's a permissions
problem. If that's the case, what do my permissions need
Hi,
I am facing the following problem with MySQL3.2.3:
OS:Windows NT 4.0
When ever I try to DROP A TABLE it gives the following
"Error on delete of '.\dbhub\data_source_type.MYI'
(Errcode: 13)"
Can someone let me know the reason.It works fine
sometimes.But the behaviour is not consistent.
Rega
At 18:50 18/04/2001 +0300, Yusuf Incekara wrote:
>You said :
>Only those who don't read English too good.
What I meant was a clarification of your problem since English is not your
native language. This has nothing to do with racism whatsoever. For you
information I have lived and worked in the
Is it possible to use ASP with MySQL? I found a link
in the documentation to
www.amedea.cz/mysqlx/index.html which was supposed to
have a downloadable MySQL COM extension but the
website was not found.
Thanks!
__
Do You Yahoo!?
Yahoo! Auctions - b
mySQL requires one insert command per
table. Stop being lazy, *grin*
P
On Wed, 18 Apr 2001, Fates wrote:
> How do I insert data into multiple tables without having to use multiple
>
>insert statements? Can I just do Insert into table1 (data) table2
> (data)
>table3 (data) or do I h
Hi all
I need a Help
I installed mysql 3.23 ( mysql-3.23.33-hp-hpux11.00-hppa2.0w.tar.gz ) in HP-UX 11.00
and now I try install PHP4 ( 4.0.4pl1 ), but I have some problem's
# cd /opt/php4
# ./configure --with-mysql=/opt/mysql
# make
after make command occur the follow error message
You've got a long way to go. "tar" is short for tape archive. It is an
ancient unix utility that takes directory and file data and builds it into a
contiguous data base file. This is for portability and manageability. You should
have to get past "gzip" before you get to "tar". gzip is a gnu co
I just got done figuring out how to --100%-- normalize a database to
make it very flexible. Methinks that Oracle has done this in some
fashion, as they claim to be able to make an intersection from any row
in any table to any other.
A note: Objects, Actors, and Attributes use the names of the ta
I'm looking for Outlook Express API's, I want to import data from a .dbx
file (archive outlook) into a MySql table.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Luis ([EMAIL PROTECTED]) writes:
> 1. I would love to move my database in access (ms) to mysql running on my
> linux box (rh7.0)
> How would I do this?
We use the ExportSQL script - you can get it from the MySQL.com web site.
> 2. Then I would like to connect threw my windows machine into t
Will Seitz wrote:
>
> Hi,
> I am probably missing something obvious in the documentation, but how do I
> convert a string to an integer in mysql. I am sorting on a substring
> (String-Number) and want the substring sorted as an integer and not a string.
>
> database, sql, query
>
> Thanks,
> -W
How do I insert data into multiple tables without having to use multiple
insert statements? Can I just do Insert into table1 (data) table2
(data)
table3 (data) or do I have to use seperate INSERT statements for each
table? I would like to add all at once from web page form
$query = "I
On Wed, Apr 18, 2001 at 01:22:21PM -0400, Will Seitz wrote:
> Hi,
> I am probably missing something obvious in the documentation, but how do I
> convert a string to an integer in mysql. I am sorting on a substring
> (String-Number) and want the substring sorted as an integer and not a string.
Add
Hello all, Just have a simple question I hope.
1. I would love to move my database in access (ms) to mysql running on my
linux box (rh7.0)
How would I do this?
2. Then I would like to connect threw my windows machine into the database
running on the linux box.
I download the MyODBS file fr
Hi,
I am probably missing something obvious in the documentation, but how do I
convert a string to an integer in mysql. I am sorting on a substring
(String-Number) and want the substring sorted as an integer and not a string.
database, sql, query
Thanks,
-Will Seitz
--
hi.
"GNU `tar' saves many files together into a single tape or disk archive, and
can restore individual files from the archive."
gnu tar differs from the sun version of tar that comes with solaris.
type tar --help to see which tar you have.
if you need the gnu version, you can get it from www.su
you need to login into MySQL with rights to create databases. Your being
root under linux has got nothing to do with root under mysql.
Mani. M
>and tried to create database with :
>mysql> create database cart;
>ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE
>'CART'
-
Hi all,
Has anyone experienced anything like the following ?
I have several queries which, admittedly, are quite complex and operate on
several million rows of indexed data. The tables are naturally locked
while the query occurs, which is fine, but what is *not* fine is that
occasionally, comple
Here's the situation. I have two application servers, each running
their own mysql databases. If one goes down, the other takes over for
it. But when it comes back up, whatever user preferences were stored on
the other server during the downtime are lost. I need a way to
syncronize the databas
Hi Everybody!
Just starting to teach myself MySql and databases.
I have the O'Reilly books on Perl DBI and Mysql, msql.
My question is this:
I am trying to install mysql on sparc sun solaris 2.7
machine. I found a binary version in the downloads
page of mysql.com (is is called Sun Solaris
(Spa
lol. guess yusuf gots some point here.
Obviously, for one reason or another m$ decided to place some files in the
%windir%, and some in the %windir%\system32 dir. Although it never became
totally clear to me what structure they had in mind (if there is any).
Roughly said: %windir% is for executa
Messages that are around 10k should be just fine, as long as they are the
majority.
A few tips for you... Store all the varchar/text columns for each message in
a seperate table so that the primary message table only has fixed length
fields (ie messageid, size, #of replies, userid, bodyid, ...).
You said :
Only those who don't read English too good. Being a native English speaker
it is very clear to me.
Could you please be more open and honest?
It is obviously seen that i can easily read and write in English.
But if you disturbed that one Turk found your bug please let me know
and quit
Hi,
I'm a final year student in a private Campus in Sri Lanka (Collaboration
with Manchester Metropolitan University). My final year project is a Web
Interface to a DBA in a Heterogeneous Databases environment.
I'm basically developing my prototype for two databases Oracle and MySql.
What I wan
Is it efficient to store things in MEDIUMTEXT columns?
I am developing a web based system (using perl and MySQL) for viewing an
archive of mailing list messages. In my database, I have one row per
message. The column called "message" is of type MEDIUMTEXT. My perl code
retrieves it using $sth->fe
Hi,
I'm using MySQL 3.22.32 on OpenBSD 2.7. Does there exist a maximum table
size? How big (4G)? Can I avoid this in any way?
--
Aigars
> I'm using MySQL on OpenBSD 2.7 and I'm accessing it throhgh DBI/DBD. While
> filling a large table with data I finally get the error :
>
> "Got error 22
Hi,
It seems like you are not "joining" the tables in any way. Say you have:
Table1 --- record1_id = 1 --- record2_id = 2
Table2 --- record1_id = 3 --- record2_id = 4
Table3 --- record1_id = 5 --- record2_id = 6
If you do a select all, you get all permutations:
1, 3, 5
1, 3, 6
1, 4, 5
1, 4, 6
>I'm trying to install mysql onto a uniz environment.
>I've already unzipped and untarred, and I've created
>the mysql - version directory, but when I type
>configure, I get a grant table failed error. I cant
>find anything on how to fix this.
Take a look at www.devshed.com they've got a nice t
hi.
a join across 3 tables with 2 records each will return 8 rows...2*2*2 = 8.
hth.
-ravi.
-Original Message-
From: Fates [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 9:38 AM
To: [EMAIL PROTECTED]
Subject: Output from select is not what expected
I have three tables in
Is it efficient to store things in MEDIUMTEXT columns?
I am developing a web based system (using perl and MySQL) for viewing an
archive of mailing list messages. In my database, I have one row per
message. The column called "message" is of type MEDIUMTEXT. My perl code
retrieves it using $sth->fe
Unzipped What?
Sounds like you downloaded a binary tar file.
Stephen Henry wrote:
>
> I'm trying to install mysql onto a uniz environment.
> I've already unzipped and untarred, and I've created
> the mysql - version directory, but when I type
> configure, I get a grant table failed error. I ca
Because 2*2*2=8.
You need to put joining information in the where clause.
I suggest you get a book on SQL.
You might try "MuSQL" by Paul DuBois ( New Riders).
Fates wrote:
>
> I have three tables in a database called menus and I have added 2 records
> to each table so 2*3=6 records. Why is
Hi all,
Has anyone experienced anything like the following ?
I have several queries which, admittedly, are quite complex and operate on
several million rows of indexed data. The tables are naturally locked
while the query occurs, which is fine, but what is *not* fine is that
occasionally, comple
Hi there,
If I need compare 2 fields of DATE and TIME to a field of
TIMESTAMP/DATETIME in my query,
what am I supposed to do? Is there a function to get DATE/TIME part from
a DATETIME field, or combine DATE and TIME to a DATETIME type?
thanks.
You are correct.
Mike Cermak wrote:
>
> This is probably a silly question, but I've read the one reference to
>skip_networking in the documentation and searched the archive (first rule of MySQL:
>RTFM, second rule of MySQL: read it again, third rule of MySQL: do an archive search
>on the term
I'm trying to install mysql onto a uniz environment.
I've already unzipped and untarred, and I've created
the mysql - version directory, but when I type
configure, I get a grant table failed error. I cant
find anything on how to fix this.
Stephen Henry
I have three tables in a database called menus and I have added 2 records
to each table so 2*3=6 records. Why is it when I do a "select * from
table1, table2, table3" I get 8 records back when there are only 2 records
in each table? What am I doing wrong? Some of the fields are references
if th
1. Make sure the execute bit is set ( Mode should be 755 ).
2. The shell will only execute executable files in the default path,
unless specifically
overridden with a valid search path.
Try ./safe_mysqld
Kevin J Edwards wrote:
>
> Hi
> Thanx for your response. Umm I have read the manual. As
This is probably a silly question, but I've read the one reference to skip_networking
in the documentation and searched the archive (first rule of MySQL: RTFM, second rule
of MySQL: read it again, third rule of MySQL: do an archive search on the term or
concept you're looking for and read all r
That is correct.
Web programmers must supply their own login and security measures.
MySQL is a tool used by the web server. THe web server does the login in
the
manner the web programmer provides. The host will be the host the CGI is
executing
from. THe user will be the user the CGI script provid
The actualy tool I find that works the best is a sheet of paper.. or a white
board. I write down all the fields that are required. Then find out what I
can break out (normalize). After that I try to figure out what I can slice
away and still get the required data. For instance, say the book price
What do you mean by "better" ?
Next time it hangs, check your disk freespace.
When MySQL runs out of tmp workspace, it waits until some becomes
available.
[EMAIL PROTECTED] wrote:
>
> Help!
> I have set up a web server with PHP4, RH7 and MySQL 3.23.32.
> After surfing for sometime, the browse
Hi
Thanx for your response. Umm I have read the manual. As far as I know probs running
as root are basically security. This is a test box which isn't on the net.
I've tried running safe_sqld from the /support-files directory which is the only place
it appears. Same thing "command not found
[EMAIL PROTECTED] writes:
> hi,
>
> i have a problem with mysql 2.23.36.
> so far it everything works fine but since today, i get wrong resultsets
> from my sql-selects - even if i try them direct over the mysql sql-editor.
> one minute it works fine and the next minute an empty or incomplete
> r
Information thank you !!
It is very glad.
Is connection possible in other software?
I can also connect with MySQL of Linux Server.
Since my environment has only the Japanese environment of Windows, it cannot
experiment in other environment. As much as possible, it tries to be able to
solve early
Katelyn Sweet writes:
> Are there c libraries that for mySQL (connecting, query and sort) that the
> Cygwin compiler is compatible with?
> Kate
>
Hi!
Somewhere on Contrib or Link pages on our site there is a link to the
site devoted to building MySQL with Cygwin.
Also, after 3.23.37, there
I have a database project, historic building materials...
I've designed 4 Tables like this (there are more fields which I didn't
listed here):
table products
- primary key(productid)
- product description
...
table category
- primary key(categoryid)
- category description
table subcategory
- prima
hi,
i have a problem with mysql 2.23.36.
so far it everything works fine but since today, i get wrong resultsets
from my sql-selects - even if i try them direct over the mysql sql-editor.
one minute it works fine and the next minute an empty or incomplete
recordset is returned.
can somebody help
>When I go to that directory and do a ls -al it is empty. So how do I
>create this file. If it is not specific to my system can someone just
>mail me one. I'm doing all this as root - do I need special permissions
>to this dir and file.
mysql.sock usually lives in /tmp and is created wh
Hi
(Re: mysql 3.23.33 )
I have got mysql running fine with the only problem that every connections
made to it through a web browser (using cgi scripts) are considered as
coming from localhost. In this way, I cannot limit the machines that
should be allowed access. I read the manual pages, cleane
DAN LYDIARD writes:
> I have a program that creates C-ISAM files and I want to access the data via
> mysql.
>
> I have a question about integrating a C-ISAM library into the mysql source.
> I noticed that mysql uses myisam files, but I'm wondering what steps would
> be involved to have it support
Hi
I tried a rh7 automatic install and it died when I tried to run it.
Then I tried installing rh7 without mysql and doing a source install. It ran:
configure
make
make install
mysql_install_db
all fine. Although I'm a little doubtful about the last one cause it didn't seem to
take much tim
Are there c libraries that for mySQL (connecting, query and sort) that the
Cygwin compiler is compatible with?
Kate
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Ide, Jim writes:
>
> Pentium III 667 mhz, 256mb ram, 20 gb hd
> OpenBSD 2.7
> MySQL 3.22.32 (installed with pkg_add mysql-3.22.32.tgz)
> started with:
> safe_mysqld --user=mysql > /dev/null &
>
> I have several text files that look like this:
> use mydb;
> create table mytable
Help!
I have set up a web server with PHP4, RH7 and MySQL 3.23.32.
After surfing for sometime, the browser will be in a forever loading
mode.
I use mysqladmin processlist to take a look and I saw processes
with the command "sleep" (it could be just 1 "sleep" process).
Everytime I encounter this,
"It does exactly what it says in the tin"
> ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE
'CART'
You'll have to get permission to create the database.
If you are the MySQL admin, lookup "grant" in order to give user "ABHI"
access. Something like:
grant all on cart.* to [
>I have done the following :-
>
>Login through telnet and become root.
>accessed :
>
>mysql -h server name -u username -p
>Password : password
>
>and tried to create database with :
>mysql> create database cart;
>
>ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE 'CART'
You s
Hi Everybody,
I need your help.
Thanks ..
I was trying to create database on MySQL
but it is giving error.
I have done the following :-
Login through telnet and become root.
accessed :
mysql -h server name -u username -p
Password : password
and tried to create database with :
mysql
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html
here says that mysql does not support sub-selects thus you see errors.
also here shows you that how to rewrite sub-selects.
- Original Message -
From: "Nicolas Villatte" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
S
I'm using MySQL on OpenBSD 2.7 and I'm accessing it throhgh DBI/DBD. While
filling a large table with data I finally get the error :
"Got error 22 from table handler"
while trying to do an insert statment. The table file is about 4G so I
assume the file is 'full'. Can anyone confirm that the
On 18-Apr-01 Nicolas Villatte wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Query syyntax error, help needed
>
> SELECT descpays.libelle FROM descpays WHERE descpays.pays_id IN
> (SELECT pays.pays_id FROM pays where pays.pays_ref IS NULL)
>
> I cannot find the error.
> pleas
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Query syyntax error, help needed
SELECT descpays.libelle FROM descpays WHERE descpays.pays_id IN
(SELECT pays.pays_id FROM pays where pays.pays_ref IS NULL)
I cannot find the error.
please could someone help me ?
-BEGIN PGP SIGNATURE-
Ver
As Far as I can remember it is explicitly said in the Manual that inserting
a negative value in an autoincrement field is a Bad Thing
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 6:14 AM
Subject: Possible bug in 3.23.32 or later
1 - 100 of 102 matches
Mail list logo
