> Hi,
>
> I am a newbie at this. I am running mysql 3.23.41 on my RedHat 7.2
> linux box. I installed it using rpm.
>
> I can start mysql but everytime I try to create a database, I keep
> getting this error:
>
> mysql> create database guessbook;
> ERROR 1044: Access denied for user: '@loca
On Saturday, December 08, 2001 at 21:46:52, Bojan IVANCIC wrote:
BI> Hi:
BI> Just a short Q:
BI> - if I install MySQL through rpm is it possible with any sort of
BI> postintallation to change the code page e.g. from Latin-1 to Latin-2.
BI> Thanx and bye.
BI> Bojan
Hi,
Try to add to my.cnf f
Rory> I want to write an efficient query that will delete all records
Rory> from one table when they show up in another table (pending
Rory> shipments --> shipped shipments). I can't do it with this:
mysql> DELETE from pending_2 WHERE pending_2.ordno = ordersearch_2.ordno;
Rory> becau
Thanks very much Paul,
Could you like to tell me what time spent in your querying ten thousands of
records from tables one time? In my test, when I query 10,000 records from a
table which contains 17 millions records total, it will cost less than 1
second of querying INDEX, or cost more than 30
I spent some time to do it w/ one query, but I couldn't figure out. So
I am throwing an example in Perl (the best way I could think of)
my $pending = $dbh->selectrow_arrayref(qq/
SELECT pending_2.ordno
FROM pending_2, ordersearch_2
WHERE pending_2.ordno=ordersearch_2.ordn
I want to write an efficient query that will delete all records from one
table when they show up in another table (pending shipments --> shipped
shipments). I can't do it with this:
mysql> DELETE from pending_2 WHERE pending_2.ordno = ordersearch_2.ordno;
because you can only refer to columns
All,
Now I want to design a database which contains more than 10G data to use. I
think the largest table in my db will contains more than 30 million records
and the amount of this kind of table will be up to 7 or 10. In my instance
there won't be so many clients connecting. normally, there are le
Hi,
I am a newbie at this. I am running mysql 3.23.41 on my RedHat 7.2
linux box. I installed it using rpm.
I can start mysql but everytime I try to create a database, I keep
getting this error:
mysql> create database guessbook;
ERROR 1044: Access denied for user: '@localhost' to database '
Hi,
I am a newbie at this. I am running mysql 3.23.41 on my RedHat 7.2
linux box. I installed it using rpm.
I can start mysql but everytime I try to create a database, I keep
getting this error:
mysql> create database guessbook;
ERROR 1044: Access denied for user: '@localhost' to database '
If I understand your core problem: it seems as if you can't start your
mysql daemon (mysqld) using the safe_mysqld wrapper.
Is it possible that you ran your "mysql_install_db" script as root? If
so then mysqld will have problems accessing the admin db files that
the script creates. (You can veri
Hi,
I compiled mysql 3.23.42 in SCO 5.05, sometimes in log file there'are
frequently mesaages: "mysqld restarted", I don't know why.
Thank you for your any useful response !
Dick
_
Get your FREE download of MSN Explorer at http:/
Hi!
> "Sergei" == Sergei Golubchik <[EMAIL PROTECTED]> writes:
Sergei> Ok, mysqlimport uses LOAD DATA INFILE.
>> > Yes, but they are simply convenient shortcuts to
>> > myisamchk --keys-used=0 -rq
>> > You can enable/disable keys from command line in 3.23.
>>
>> Ok, what is the suggest
Ok, thanks for the help, people. I finally got it to work. Was really quite simple.
(wish it were like this all the time heh). I just had to run the *clears throat*
winmysqladmin.exe and then everything went smooth as glass.
Again, thank you all for your help. :)
--
Best regards,
Curt Kli
Hi;
I have logging server (redundant) and I will store these logs on database (2
disks: one local and another remote using NFS).
When I receice the logs from my server I sent these logs to MySQL server
running on Linux. Normaly the database is on /var/lib/mysql/logging. can I
have another data
Hi,
> Do I need to create users for the database, or does every user on the
system
> have the right to create a table?
You need to create users within MySQL's authentication database. The manual
explains this beautifully.
> Also, is it possible to connect to a MySQL
> database using Access as a
Hi,
You need to be running the server (mysqld.exe) before you can connect to it
from the command line. 10061 means that the TCP/IP service cannot be
contacted, either because the IP address isn't correct or that there is no
service on the requested port.
HTH
Quentin
-Original Message-
Sounds like you need to add permission to connect from localhost.
You might want to check out:
http://www.mysql.com/doc/S/e/Secure_GRANT.html
or you might need to use the "-u root" option to mysql
> -Original Message-
> From: Curt Kliewer [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, Decem
I have installed the necessary MySQL files onto the hard drive (under the folders
inetpub --> wwwroot --> mysql. Next, I set up a cnf file and called it my.cnf with
the path "C:\Inetpub\wwwroot\mysql" in it.
Then, using the command prompt, I keyed in the path to the mysql directory and keyed
Thanks for reading this. I'm new to the whole world of linux, and MySql, but
I decided to get my hands dirty, and learn the whole thing.
I have just installed corel linux, and I'm quite happy that the whole thing
is working, and is visable on my network. Next I'm trying to get apache up
and runni
hi,
I am new to PHP/mySQL.
When i connect to phpMyAdmin to work with my database I do not have any
problem of connection, but when I try to connect to my mySQL DB using this
script (http://www.utpala.net/query1.php), then I get the following error
message,
Does anyone see something wrong in
Hi,
http://www.mysql.com/doc/m/y/mysqladmin.html
and
http://www.mysql.com/doc/C/o/Connecting.html
are a good start. If SSHing into a Unix box, you can also use "man
mysqladmin" and "man mysql", and "man mysqldump" for more info.
-Joe
> -Original Message-
> From: Scott Johnson [mail
> Hello,
>
> Does anyone know where I should look on the http://www.mysql.com web site
> or anywhere else I can find documentation for being able to SSH
> to the box
> and setup additional databases as necessary using the MySQL command
> line tools?
http://www.mysql.com/doc/S/e/Secure_connections
Try MySQLFront from www.mysqlfront.de, it has its limitations, but I
find it does 90% of what I need to do on a day-to-day basis.
Regards,
DOD.
Scott Johnson wrote:
>
> Hello,
>
> Does anyone know where I should look on the http://www.mysql.com web site
> or anywhere else I can find documenta
Try MySQLFront from www.mysqlfront.de, it has its limitations, but I
find it does 90% of what I need to do on a day-to-day basis.
Regards,
DOD.
Scott Johnson wrote:
>
> Hello,
>
> Does anyone know where I should look on the http://www.mysql.com web site
> or anywhere else I can find documenta
> Hello,
>
> i have a question.
Don't we all :-)
> I will have to set up a MySQL Database which will have a hughe amount of
> entries in a table. I did some tests and my select statements
> would need lot
> of time.
>
> I just wanna ask if there are some generally ways to speed up
> perfo
Hello,
Does anyone know where I should look on the http://www.mysql.com web site
or anywhere else I can find documentation for being able to SSH to the box
and setup additional databases as necessary using the MySQL command
line tools?
Scott
Scott
=
--
Hello,
Depending on what types of values are in your table, and the types of
selects that you are going to perform, you will most likely notice a speed
change if you were to INDEX some of your attributes...Just look up INDEX in
the mysql manual...
I notice the largest improvement when I INDEX on
Hello,
i have a question.
I will have to set up a MySQL Database which will have a hughe amount of
entries in a table. I did some tests and my select statements would need lot
of time.
I just wanna ask if there are some generally ways to speed up performance of
mysql statements?
thanx in adv
Haven't tried it myself, but can't see why it shouldn't.
How about you try telling us the process you have been through so far and
any messages / errors that you may be getting.
> -Original Message-
> From: Curt Kliewer [mailto:[EMAIL PROTECTED]]
> Sent: Monday, 10 December 2001 5:16
>
> Hello,
> them, will the command line over ride the settings in the my.cnf,
Manual sec. 4.1.2: "Options specified on the command
line take precedence over options specified in any
option file. "
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://ww
Hi,
> -Original Message-
> From: Stefano Vaccari [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 09, 2001 3:10 AM
> To: [EMAIL PROTECTED]
> Subject: VB6 ADO and UPDATE method
>
>
> Hello to everybody.
> I have a problem with the "Update" method in the following simple VB6 code:
>
Hi,
I've downloaded mysql 3.23.46 version and currenlty runnig
solaris 2.8 relase 10/00 on intel platform.
I'm getting the following error during the ./configure stage in
creating
my makefile.
checking size of char... 0
configure: error: No size for char type.
A likely cause for this co
Hello,
We currently have two separate MySQL version running, one w/innodb and bdb
tables and the other w/o transaction table handlers. We normally
shutdown/restart the servers using the --defaults-file=/path/to/my.cnf
Now if I want to restart the server w/innodb and bdb tables, and do not want
Hi. I am new to PHP/MySQL and this list.
Can I run MySQL on WinXP? I haven't been able to get it to work so far. Any help
would be appreciated.
--
Best regards,
Curt Kliewer
**
How about a 2 dimensional array? If I understand you correctly wouldn't this
work:
$result = mysql_query("SELECT id, word, count FROM table", $db);
while ($return = mysql_fetch_array($result)) {
$id = $return['id'];
$row[$id]['word'] = $return['word'];
$row[$id]['count'] = $return['count
On Sunday 09 December 2001 12:26, Paul DuBois wrote:
> At 3:19 PM -0800 12/8/01, Rob@TH wrote:
> >Hmm still nothing :/
> >Any other possibilities?
>
> The suggestion offered below is a workaround that seems logical given
> the lack of ORDER BY RAND() prior to MySQL 3.23. Unfortunately, it
> doesn
On Monday 10 December 2001 00:36, you wrote:
> I have a MySQL query that I want to draw an associative array from -
> but I want the 'key' to the array to be the identifying element of
> the row, and I'm stuck on how to get what I want.
>
> For instance:
>
> Each row in the result set contains an
> Hi,Sir:
>
> I found the message shows that:
> ---
> 04 01:13:40 mysqld started
> ^G/usr/local/mysql/libexec/mysqld: File './host-bin.1'
> not found (Errcode: 13)
> 04 1:13:40 Could not use host-bin for logging
> (error 13)
> InnoDB: Warning
Hi there,
Is it possible to have MySQLd create multiple unix sockets? Over and above
/var/run/mysql.sock. I'd like to have a socket in each of my chrooted file
systems.
Thanks,
Aragon
-
Before posting, please check:
http
Hi there,
Is it possible to have MySQLd create multiple unix sockets? Over and above
/var/run/mysql.sock. I'd like to have a socket in each of my chrooted file
systems.
Thanks,
Aragon
-
Before posting, please check:
http:
Hi,Sir:
I found the message shows that:
---
04 01:13:40 mysqld started
^G/usr/local/mysql/libexec/mysqld: File './host-bin.1'
not found (Errcode: 13)
04 1:13:40 Could not use host-bin for logging
(error 13)
InnoDB: Warning: operating system e
Hi,
how can I check how much of the InnoDB data files are already taken?
Jens
(MySQL...)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
I have a MySQL query that I want to draw an associative array from -
but I want the 'key' to the array to be the identifying element of
the row, and I'm stuck on how to get what I want.
For instance:
Each row in the result set contains an id number, a keyword and a
count related to that keywo
Under Win98 (and NT for that matter), I've found it convenient to just
run WinMySQLAdmin. It starts the server (or service) automatically.
> After installing mysql specifying nothing but defaults, I started
> mysql without any parameters and then ran "MYSQL TEST" and received
> the following erro
On RedHat 7.1 I have installed MySQL-3.23.46-1.i386.rpm and the client, but
mysqladmin does not install. Is there a fix for this?
Raymond
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
htt
Hi Bennett,
- Original Message -
From: "Bennett Haselton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 09, 2001 12:31 PM
Subject: "IN" keyword supported?
> I'm trying to use the "IN" operator as described in my databases textbook
> from college. This query:
>
> se
> I'm trying to use the "IN" operator as described in my databases textbook
> from college. This query:
>
> select count(*) from user where user.ID in (select ID from user);
>
> is supposed to evaluate to "count the number of rows in the 'user' table
> where the ID field is in the set of all ID f
I'm trying to use the "IN" operator as described in my databases textbook
from college. This query:
select count(*) from user where user.ID in (select ID from user);
is supposed to evaluate to "count the number of rows in the 'user' table
where the ID field is in the set of all ID field value
Hello to everybody.
I have a problem with the "Update" method in the following simple VB6 code:
Dim MyConn as New ADODB.Connection
Dim MyRs As New ADODB.Recordset
MyConn.ConnectionString = "DSN=test;uid=sa;pwd=;database=test"
MyConn.Open
MyRs.CursorLocation = adUseClient
MyRs.Open "lines", MyConn
> I would like to know how to create mysql.sock I destructed...
Restart mysqld
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
-
Before posting, please che
Hi Arjen,
- Original Message -
From: "Arjen G. Lentz" <[EMAIL PROTECTED]>
To: "Tony Buckley" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, December 09, 2001 1:40 AM
Subject: Re: From Oracle to the MySQL Database Server
>
> But eh, what are those gripes about transactions and lo
I would like to know how to create mysql.sock I destructed...
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:MySQL Server
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
52 matches
Mail list logo
