On Mon, Nov 04, 2002 at 12:54:17AM -0500, Bob Lockie wrote:
> >
> That fixed it, thanks.
> What did it use since I didn't specify an @'localhost'?
It used '%' which matches everyhing *except* localhost. The manual
explains this.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazin
Jeremy Zawodny wrote:
On Mon, Nov 04, 2002 at 12:37:12AM -0500, Bob Lockie wrote:
Does anyone know why?
create database visitor;
grant all on visitor.* to visitor_user identified by 'visitor';
use visitor;
mysql -u visitor_user -p
I get "ERROR 1045: Access denied for user: 'visitor_user@loc
On Mon, Nov 04, 2002 at 12:37:12AM -0500, Bob Lockie wrote:
> Does anyone know why?
>
> create database visitor;
> grant all on visitor.* to visitor_user identified by 'visitor';
> use visitor;
>
> mysql -u visitor_user -p
>
> I get "ERROR 1045: Access denied for user: 'visitor_user@localhost'
Does anyone know why?
create database visitor;
grant all on visitor.* to visitor_user identified by 'visitor';
use visitor;
mysql -u visitor_user -p
I get "ERROR 1045: Access denied for user: 'visitor_user@localhost'
(Using password: YES)"
From Mozilla
Ken,
Don't you want ...
...
INNER JOIN table_2 as b ...
...
PB
-
> I'm having some real problems figuring out a seemingly simple join
> statement. I've looked through some of the mailing list posts, but I
can't
> seem to find what I'm looking for. Here's what I have - 2 tables
Hi,
I'm having some real problems figuring out a seemingly simple join
statement. I've looked through some of the mailing list posts, but I can't
seem to find what I'm looking for. Here's what I have - 2 tables:
table1 (id, stimulus_number, stimulus_type)
table 2 (id, stimulus_number, stimulus_
Hi,
I'm having some real problems figuring out a seemingly simple join
statement. I've looked through some of the mailing list posts, but I can't
seem to find what I'm looking for. Here's what I have - 2 tables:
table1 (id, stimulus_number, stimulus_type)
table 2 (id, stimulus_number, stimulus_
Hi,
I'll soon run in a probaply pretty common problem with 2 site replication.
We currently hold our customer and buisiness data in one mysql server.
Soon we'll get another site which basically will work on a regional
separate project. While the set of potential costomers that overlap will
be
Helllo
Im trying to run a select from 5 different tables, depending on the key
in the main one like this:
select JOB_ASS.JOB_ASS_ID, JOB_ASS.START_DATE, JOB_ASS.STOP_DATE,
JOB_ASS.JOB_NAME, JOB_ASS.LOCATION, JOB_ASS.NOTE, JOB_ASS.ORDER_ID,
JOB_ASS.CONTRACT_VALUE, USER.SURNAME, USER.FIRSTNAME,
PR
Hi,
I've tried an EXPLAIN of the SELECT below.
Please can anyone tell me why it's
"Impossible WHERE noticed after reading const tables"
?
I've droped and created the table - but the error/message occurs.
When I leave '(chetPosition = 1)' away, it works!
A bug or ???
The statement works without
Hi!
> "Chung" == Chung Ha-nyung <[EMAIL PROTECTED]> writes:
Chung> Dear,
Chung> By default, binary log file uses 3-digit number suffix as its counter.
Chung> Then, without reseting master logs suffix number may reach 999. If so,
Chung> what happens?
Chung> next suffix number is 1000 o
j.random.programmer wrote:
Hi:
Thought I'd mention this (using the latest dev
J/connect):
A)
DatabaseMetaData.getColumns() does not return the last
4 columns (SCOPE_*) but it should according to the
API spec
I'll look into fixing this right away. You should write Sun as well, as
their JDBC c
Hello!
I am working on an analysis that is very much dependent on calculating
time differences in seconds. The most simple example:
I have 3 variables: time_begin (DATETIME) time_end (DATETIME) and elapsed_
seconds (INT). The data in these DATETIMES looks fine -MM-DD HH:MM:SS
as expected
>Description:
Hi there, I downloaded and installed the 4.0.3 linux version of MySQL
(see elsewhere in this document for full product info). I untarred, installed,
and configured without any problems. However, when I attempted to start the
server, it failed. When I looked in the 'data/daphne
Hi:
Thought I'd mention this (using the latest dev
J/connect):
A)
DatabaseMetaData.getColumns() does not return the last
4 columns (SCOPE_*) but it should according to the
API spec
B)
InnoDB, on their benchmark page, say that inserting
100,000 rows into the DB is about 5 seconds.
http://www.i
if you have a windows box that you can use as a
front end, get a copy of corereader.
i recommend it to you because, among other
things, it's a teaching tool. it allows you to
do (genuine) point and click queries. you can do
complex queries simply by clicking on selections.
furthermore, yo
David Lloyd wrote:
How do you mean not able to "see it"? Under the control panel there
should be an "ODBC Data Source Administrator"...
(mysql, query)
DSL
The driver is not listed in the driver. I cannot select
it from the list of drivers as it is not there.
Jerry
Jerry,
> I have some questions on using ODBC with My SQL.
:-)
> I have a MySQL on on an ISPs database server. I'd like to
> pull data from it into Excel. It appears that I need to
> use ODBC to do this. Do the server need to have ODBC
> installed or do I just need it installed on the PC I wa
David Garamond wrote:
mysql> select 1/29;
+--+
| 0.03 |
+--+
mysql> select 100.0*1/29;
++
| 3.448 |
++
mysql> select 1/29*100.0;
++
| 3.45 |
++
sorry for the previous post, misleading problem statement. the exact
problem for m
hi,
mysql> select 1/29;
+--+
| 1/29 |
+--+
| 0.03 |
+--+
1 row in set (0.00 sec)
mysql> select 100.0*1/29;
++
| 100.0*1/29 |
++
| 3.448 |
++
1 row in set (0.00 sec)
mysql> select 1/29*100.0;
++
| 1/29*100.0 |
++
|
20 matches
Mail list logo
