Curlys wrote:
hi ,
mysql databse server is in Red Hat Linux 8 box. I have an application
which is developed from Visual Basic . So that application included a
reqiurement to connect mysql data base.
Can somebody help me how to connect mysql database via VB ?
thanx in advance
curlys
First
Curt Zirzow wrote:
i'm trying to use the following configure
./configure --with-apxs2=/usr/sbin/apxs --with-config-file-path=/etc --with
-mysql=/usr/include/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config -
-with-ldap --with-pgsql
If you read the installation at http://php.net/mysqli, you
Title:
Madame,
mademoiselle, monsieur,
Bouygues
Telecom vous informe que votre correspondant(e) a chang
hello people..
i have a curious problem with mysql.
i configure root user acount to enable access from other machines but i cant
connect..
my user table is:
mysql select * from user;
Hello! I'm new to MySQl and I have sevral problems to get the Mysql-server
going.
First of all, when trying to connect (in mysqlcc) I get the following error
message:
[MySQL] ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
Hoe can I get this
Take a look at this
http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator Web Developer
http://www.dalar.net
- Original Message -
From: Laurent [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 19, 2004
Victor Pendleton wrote:
What error messages are you receiving?
-Original Message-
From: Peter Bruggink
To: [EMAIL PROTECTED]
Sent: 7/16/04 3:19 AM
Subject: [CONNECTION PROBLEMS]
To have a better performence I have installed a new server running
solaris8 and mysql version 3.23.53. The
Wesley Furgiuele [EMAIL PROTECTED] wrote:
I think one way to solve it would be to move your data to a new copy of
your table. Assuming record_ref and keyword are separate fields...
CREATE TABLE newtable SELECT * FROM oldtable GROUP BY CONCAT(
record_ref, keyword );
Or, more simply and
On Monday 19 July 2004 12:12, charitha wrote:
Hi, You just check the entry in your /etc/my.cnf file where your .sock
file is configured
my.conf says for server and client configuration:
socket = /var/lib/mysql/mysql.sock
So the path is correct
if it is not this path then change it and
Hi!
I've upgraded from 3.23.51 to 4.0.20 .
The query: SELECT e.id, sum(c.quantity) FROM Execution e left join
Couple c on c.executionRef=e.id GROUP BY e.id;
If there's no Couple for an Execution the value of the sum(c.quantity)
is 0 in 3.23.51 and NULL in 4.0.20.
Was it a bug, or is it a
User mysqladmin has not the rights to access mysql? How can that be?
Laurent
--
Linux is like an Indian tent: no Windows, no Gates, and an Apache inside!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin is an executable. Did you set up an user named mysqladmin that
can connect from the localhost?
-Original Message-
From: Laurent
To: [EMAIL PROTECTED]
Sent: 7/19/04 6:55 AM
Subject: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
password: YES)
User mysqladmin
This is the way the SUM() operator works. If there are not any rows it will
return NULL.
http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
-Original Message-
From: Róth Zoltán
To: mysql lista
Sent: 7/19/04 7:12 AM
Subject: 0 or null?
Hi!
I've upgraded from 3.23.51 to 4.0.20 .
Can you telnet port 3306 on linuxready from the remote machine?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 7/19/04 4:27 AM
Subject: i cant connect to mysql from other machine
hello people..
i have a curious problem with mysql.
i configure root user acount to
The INTERSECT keyword is not available in MySQL. You will have to compare
the columns in your join syntax (or get creative?).
-Original Message-
From: L a n a
To: [EMAIL PROTECTED]
Sent: 7/18/04 8:20 PM
Subject: how to intersect resulting sets form sql query
Hello,
I'm trying to find a
I believe you shoul comment out the bind_address option on config
file...
Hope this helps,
Giulio
Il giorno 19/lug/04, alle 11:27, [EMAIL PROTECTED] ha scritto:
hello people..
i have a curious problem with mysql.
i configure root user acount to enable access from other machines but
i
On Monday 19 July 2004 14:59, Victor Pendleton wrote:
mysqladmin is an executable. Did you set up an user named mysqladmin that
can connect from the localhost?
Exactly, it should be able to connect, but it doesn't. Should I change the
name from mysqladmin to mysql or something similar? I'll
Hi David,
In your database on the countries of the world think you were able to
mostly avoid using numeric keys however in this case, they will save you a
world of headaches.
My suggestion to you: Create one table per taxonomic level, starting at
Kingdom and working all of the way down to
Trying to setup a new user for replication purpose, here what i got :
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2566 to server version: 4.0.20-standard
grant REPLICATION SLAVE on forum.* to repl@'%' IDENTIFIED BY 'replforum';
ERROR 1221: Wrong usage
On Mon, 19 Jul 2004, Laurent wrote:
On Monday 19 July 2004 14:59, Victor Pendleton wrote:
mysqladmin is an executable. Did you set up an user named mysqladmin that
can connect from the localhost?
Exactly, it should be able to connect, but it doesn't. Should I change the
name from
INTERSECT is not a MySQL keyword. If I read your logic correctly, you
seem to want:
SELECT *
FROM table
WHERE (field_a like '%keyword1%' OR field_b like '%keyword1%')
AND (field_a like '%keyword2%' OR field_b like '%keyword2%')
This statements tests that both keyword1 and keyword2
Is linuxready an address visible from your other machine? Could you need
a hosts file entry? Could you need to add that address to your internal
DNS server?
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote on
07/19/2004
Victor Pendleton wrote:
This is the way the SUM() operator works. If there are not any rows it will
return NULL.
http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
Thanks! But I found , that it returns null only from version 3.23, in
the earlier versions it was 0.
The query: SELECT
You were attempting to grant replication rights to all of the TABLES in
the database forum. Try it again like:
grant REPLICATION SLAVE on forum to repl@'%' IDENTIFIED BY 'replforum';
and see if it works better ;-)
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Have you tried another user.
-Original Message-
From: Laurent
To: [EMAIL PROTECTED]
Sent: 7/19/04 8:07 AM
Subject: Re: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (U
sing password: YES)
On Monday 19 July 2004 14:59, Victor Pendleton wrote:
mysqladmin is an executable. Did
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Acces rights in 4.1.2
Description:
Hi , i've installed the packages and created one db user called pm_user.
the host is called pm-spa280. I created GRANTS for [EMAIL PROTECTED] and [EMAIL
PROTECTED]
both grants are with password. accessing
Sorry,
grant REPLICATION SLAVE on forum to repltest2@'%' IDENTIFIED BY
'replforum';
ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual which
privileges can be used.
(using 4.20)
Regard's
Vincent
You were attempting to
What are you asking?
Hausmann Johannes IT5624 wrote:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Acces rights in 4.1.2
Description:
Hi , i've installed the packages and created one db user called pm_user.
the host is called pm-spa280. I created GRANTS for [EMAIL PROTECTED] and
I should have looked before I answered. I apologize to you and the rest of
the list for having my head up my a**..
I RTFM (http://dev.mysql.com/doc/mysql/en/GRANT.html) and find:
The EXECUTION, FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION
SLAVE, SHOW DATABASES, SHUTDOWN, and SUPER
hi...
saw your post with your remote mysql issues...
a number of issues/question need to be answered... to begin, are your
machines (client/server) linux/windows boxes? is iptables/firewall app
running on either or both boxes? what version of linux/windows/mysql are you
running? how are you
Description:
Multi-delete stops working in all forms when used along with table
aliases, it gives an error saying
ERROR 1109 (42S02): Unknown table 'test_base' in MULTI DELETE
Which definately is NOT the case. After trying all kinds of
combinations I reliased that the
OS: Win2k Server
MySQL: 4.1.1 alpha / 4.1.3 beta
Table type: INNO DB
In my production environment, running the query:
select * from main where id in
(select main_id from receipt group by main_id having COUNT(*) 5)
will hang the server - sometimes for over a day, thugh it seems it will
Laurent [EMAIL PROTECTED] wrote:
User mysqladmin has not the rights to access mysql? How can that be?
Have you created the mysqladmin user? By default there is no such user and
it's not supposed to be there. There is no special meaning for it - mysqladmin
usually logs in as root user.
--
Loic Minier [EMAIL PROTECTED] wrote:
Did other MySQL users experience this?
Yep.
I could not find MySQL's bugtracker, should it be reported there as
well?
You can post the report at http://bugs.mysql.com/
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
Michaell Taylor [EMAIL PROTECTED] wrote:
Lost connection to MySQL server during query
details:
myssql 4.0.20
linux: fedora core 2
file system : ext3
There should be a clue of what's happening with MySQL at the end of .err file
in the datadir. Take a look into it.
--
For technical
Brad Waddell [EMAIL PROTECTED] wrote:
does anyone have a stress test for mysql? i want to give my box a
workout before deploying on the web. Maybe a PHP page which runs
forever, creating, finding and deleting thousands of records? Maybe I
can run it in several browsers at the same time?
Daniel Cummings [EMAIL PROTECTED] wrote:
Is there a way of getting the number of updated rows without using the API
calls?
No.
But if you connect to MySQL from your software then you are already using the API.
--
For technical support contracts, goto
Sergio Ilarri [EMAIL PROTECTED] wrote:
P.S. I also get sometimes an error: General error, message from server:
Can't lock file (errno: 116).
...which is:
[EMAIL PROTECTED] egor]$ perror 116
Error code 116: Stale NFS file handle
See the end of .err files in datadir of your servers, there
It looks like your IN statement is forcing your inner SELECT to execute
once PER ROW of your main table. It is asking the engine to make sure that
_each and every_ id value in main meets the condition in the inner
select. So, for each and every value in the table main, it has to
re-computing
Sergei Skarupo [EMAIL PROTECTED] wrote:
I see some files in the data dir with names like #sql-85d_4.MYI. Some of =
these are pretty old. Are these the temp tables that didn't get deleted =
properly? Is it OK to shut down the server and delete them?
The answer is yes to both questions. :)
Hello,
I wonder if someone could shed some light on a problem that's been bothering
me for months. Please bear with me as I explain it..
I have two tables in question:
CREATE TABLE `News` (
`FileID` int(8) unsigned NOT NULL auto_increment,
`Subject` char(200) NOT NULL default '',
Dear Friends
i was using ,mysql 4.0.15 for production with no problem
now i just instaled the 4.1.3-beta for an test
and relink my app that use mysql api
every time i execute i got an segmentation fault on the call to
mysql_num_fields
Can any one help
Regards
Luiz
--
MySQL General Mailing
Hi,
We are currently using a 4.0.16-replication-setup (debian-linux, kernel
2.4.21, xfs) of two 2.4ghz Intel-Pentium4 systems with 3gig RAM each
and SCSI-Hardware-Raid, connected via gigabit-ethernet. We are reaching
the limit of those systems and are going to buy new hardware as well as
Hi
I have a hockey pool database and I want to be able to add each weeks
totals (goals, assists, etc.) for the players on each team.
Example:
Team 1 may have Hossa, Redden, and Forsberg. If each of them scored 2 goals
and 2 assists for week one, I want to be able to get the total of 12. Team
I have a HUGE table, with hundreds of millions of records.
mytab.MYD 78GB
mytab.MYI 16GB
I decided to get rid of some old data because I can't INSERT into this
table anymore, since the MAX for index file is reached.
Following is what I did and what I got.
mysql DELETE FROM mytab WHERE
(first: excuse for my english)
On Monday 19 July 2004 15:03, Victor Pendleton wrote:
Can you telnet port 3306 on linuxready from the remote machine?
nop.. :/ .. i cant do telnet to linuxready 3306 ¡
-
[EMAIL PROTECTED] $ telnet linuxready 3306
On Monday 19 July 2004 15:17, Giulio wrote:
I believe you shoul comment out the bind_address option on config
file...
:)
ok¡
all is right now¡
a lot of thanks
Hope this helps,
Giulio
d2clon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I?ve developed an Oracle PL/SQL stored procedure that takes information
from an Oracle 9.2.0.5 database and inserts this information into a MySQL
4.0.17 MyISAM table. The insert takes over 3 minutes to insert
approximately 90 records based on an Oracle SQL Trace. A few things that
may be
Check back and make sure linuxready is running MySQL on the expected port.
-Original Message-
From: [EMAIL PROTECTED]
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '; '[EMAIL PROTECTED] '
Sent: 7/19/04 11:18 AM
Subject: Re: i cant connect to mysql from other machine
(first: excuse for my
This is expected behavior for MySQL post version 4.1. Check out:
http://dev.mysql.com/doc/mysql/en/DELETE.html
particularly the 'Note:' section just before the user comments. If you
use table aliases you must use those aliases to refer to the tables you
want to delete, not the table names
Guten Tag,
die untere Anweisung löscht richtig, sobald kein INDEX in der Tabelle
angelegt ist, und bei einem Index löscht er FALSCH (In meiner Tabelle habe
ich die Spalten A von Typ Char und B Typ Char und C Typ INT, für die Spalte
A und B habe ich einen Index angelegt und die Spalte C enthält
Hi,
I have a table with a column that has the Unique key constraint on it.
In the table definition that column has a default NULL specification
too.
So, when I ran the query select * from table where col is NULL;
I get only 1 row returned, when I have 23 such rows with NULL values.
ok...
here's what this issue appears to be narrowing down to... i'm guessing that
it has something to do with using the same libs for both mysql/mysqli. i've
been able to get a running app for only mysqli, but adding the mysql
function to the ./configure gives the multiple define issues that i've
Try
SELECT * FROM table ORDER BY col LIMIT 23 ;
If the col type is numeric, trying to match the string NULL might be the
problem. And, if it is numeric, the NULL values will be listed first in
'ORDER BY col'.
This doesn't really solve the problem of not being able to select 'where
col is
When you delete records, space is freed up within the table, not from
the disk. Just like when you delete a file, it's not deleted, the space
is just marked as available. So technically you do now have space in
your table and you may be able to do inserts. I'm pretty sure the
documentation
It might help if you say what version of MySQL you're using, give the
table schema, etc. I couldn't reproduce the behavior you describe
here.
--Pete
On Mon, Jul 19, 2004 at 12:13:47PM -0500, Deepak Vishwanathan wrote:
Hi,
I have a table with a column that has the Unique key constraint
Hello,
I recently installed MySQL on Mandrake 10, not the
distro version, but the standard version from
mysql.com.
Version 4.x.
The install went very well, I set up Webmin and am
able to access it from there.
My question (finally) is about the network skip
setting...
Is this set to not listen
There are permissions that are set for users and have to be set for access
over the network.
By default localhost can access it for specified users and you GRANT
access to users, hosts, db combinations.
Check mysql's documentation, for GRANT syntax
Ex., GRANT SELECT ON dbnam.* TO [EMAIL
Have you tried moving the GroupID not IN () into your JOIN clause?
SELECT *
FROM News
JOIN FileGroup
ON News.FileID = FileGroup.FileID
AND FileGroup.GroupID NOT IN (638)
WHERE News.Category = 7
GROUP BY News.FileID
ORDER BY News.Date DESC
LIMIT 100
I think, though, that
You will need to create another table. In it you will need a columns
identifying what week it is, what team you are documenting, and the
statistics you want to store.
For individual player statistics, you will need yet another table. This
one would have columns identifying the player, what
Olá,
qual o significado da seguinte menssagem de erro do MySQL:
Got error 28 from table handler?
Obrigado,
Paulo.
---
Inscreva-se na Maratona iBest para concorrer a prêmios!
São 2 casas, 11 Ford EcoSport e 60 computadores.
Participe já: http://maratona.ibest.com.br
--
MySQL General
Use the command perror
Here's yours
$ perror 28
Error code 28: No space left on device
So get some disk !
Aman Raheja
http://www.techquotes.com
On Mon, 19 Jul 2004 16:30:05 -0300, [EMAIL PROTECTED] wrote :
Olá,
qual o significado da seguinte menssagem de erro do MySQL:
Got error
Hello
I executed a query on my server
mysql select count(*) from mytab where change 2004070100
And another
mysql select count(*) from mytab where change 2004070100
Would like to mention, the table is 240 million records and 78GB (MYD)
I've been waiting forever to get any output.
Gerard Gilliland wrote:
Michael:
Thank you for your excellent suggestion and quick response.
You're welcome.
I now have an operable DATE_ADD.
The solution to break nPeriod into n and Period would not work directly.
That is, in the SELECT statement in the form of ...
$qry = SELECT PlantName,
Thanks!
In that case, what can I do about the #sql-frm files? Those must be related to the
temp InnoDB tables. If I delete the .frm file, will InnoDB release the respective part
of its tablespace when I start MySQL? If not, is the only choice to backup / restore
the database?
hi...
in regards to the php5/mysql/mysqli/apache2 issue...
the following should be helpful... i've managed to get it working, so that i
have mysql and mysqli both being displayed using phpinfo()...
for a linux rh8.0
use mysql-4.1.3-beta.tar.gz
copy it to whatever
I am trying to figure out the best innodb paramaters in the my.cnf
file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with
2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am
running on default params.
Does anyone out there have a suggested innodb parameters or
On Mon, Jul 19, 2004 at 07:52:01PM -, Aman Raheja wrote:
Hello
I executed a query on my server
mysql select count(*) from mytab where change 2004070100
And another
mysql select count(*) from mytab where change 2004070100
Would like to mention, the table is 240
Kieran Kelleher wrote:
Does anyone out there have a suggested innodb parameters or even a
working set of params that I could start with.
The InnoDB manual gives good suggestion. Some minor comments (none
particularly OS X specific, but InnoDB works fine on it)
innodb_buffer_pool_size is very
This is how the redhat 9.0 mysql.spec file adds the mysql user:
' useradd -M -o -r -d /var/lib/mysql -s /bin/bash -c MySQL Server -u 27 mysql '
Anybody know why the shell is '/bin/bash' instead of '/sbin/nologin' like other daemon
users? Is this simply an oversite?
--
MySQL General Mailing
I need so general guidance on relational integrity.
I'm setting up a reasonably small DB with 30 or so
tables for a machine control application. Several of
the tables will have referential links to each other
(e.g. a finished part table will link to a master
part type table via the product ID
MyISAM tables are sometimes faster than InnoDB, but for most
applications the difference is going to be negligible. MyISAM tables
also use less disk space (more compressed row format). These are the
only 2 advantages I'm aware of. InnoDB on the other hand offers you
foreign keys and transaction
After installing mysql,
mysql-standard-4.1.3-beta-apple-darwin6.8-powerpc
php http://www.entropy.ch/software/macosx/php/
http://www2.entropy.ch/download/Entropy-PHP-4.3.4-2.dmg
and phpMyAdmin 2.5.7-pl1
(following http://www.macservers.org/feature-2.html )
Mac OS 10.2.8, MySQL4.1
the tests
Not a problem!
Do look into the database mysql after you log in. There are different
privileges that you assign to different users and hosts on databases.
GRANT and REVOKE are used for access control on databases / tables /
columns.
Regards
Aman Raheja
http://www.techquotes.com
On Mon,
Roy,
MyISAM tables also support the FULLTEXT index type, which may be useful,
whereas InnoDB doesn't.
Lachlan
-Original Message-
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 20 July 2004 7:50 AM
To: Roy Harrell; [EMAIL PROTECTED]
Subject: RE: Relational Integrity
Kieran,
The InnoDB tablespace may span multiple files and may even be configured to
use raw devices, thus, the filesystem really doesn't limit the maximum
InnoDB tablespace size. The maximum InnoDB tablespace size is 64TB.
Eg. of multiple files/devices
Oh I forgot to say, a full list of InnoDB restrictions is here:
http://mysql.megalink.com/doc/mysql/en/InnoDB_restrictions.html
-Original Message-
From: Lachlan Mulcahy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 20 July 2004 9:36 AM
To: [EMAIL PROTECTED]
Subject: RE: Relational
Aman,
I agree with Jeremy, it sounds like you don't have an index, but the chances
are with a table that large and only 1GB or RAM there could be some heavy
disk action happening.
Could you post the CREATE TABLE and your my.cnf..
Lachlan
-Original Message-
From: Aman Raheja
Chris,
Have you checked your following server configurables:
sort_buffer_size:
- This is the size of the cache created by _each_ thread that requires
ORDER BY or GROUP BY in a query.
If you are doing a lot of large ordered queries you will need to increase
this value otherwise MySQL will use
d2,
By the looks of it the client machine you are trying to connect from can
resolve the hostname of your 'linuxready' machine perfecetly fine... and
your host (according to nmap) is running the MySQL server daemon listening
on TCP port 3306. I would suggest the problem lies at the network level.
Hi all,
I'm in the planning phase of a hosted web application where all
instances of the app (a sort-of website CMS) will be running off a
single code source. I've got a clear picture about everything except
for the database design.
a) I could have a separate database table structure for
Michael:
Again, Thank you for your excellent suggestions and quick response !!
I agree that Two types of data means you should use two columns.
There is no excuse for bad design.
(I inherited the database and moved it to MySQL -- I should have converted
then.)
I will split the Source
Hi All,
Is there any equivalent of empty_blob() in mysql. Kindly guide us in this regard.
Thanks in advance.
regards
msjeyabalan
**
CONFIDENTIAL INFORMATION
**
This e-mail transmission and any attachments may
In the last episode (Jul 20), Jeyabalan Murugesan Sankarasubramanian said:
Is there any equivalent of empty_blob() in mysql. Kindly guide us in
this regard. Thanks in advance.
You didn't tell us what empty_blob() is supposed to do. If
empty_blob() checks to see whether a blob is empty:
84 matches
Mail list logo
