Sorry I found a mistake in my text. $pass pwd, like it is used in the php.
One more thing: I guess it's the php.ini. there are a few differences
with the two versions. if you want to compare i'll send you the two
phpinfo-files to compare.
The script doesn't work when the username is compared
Dear Mr. Jeremy D. Zawodny,
I am subscriber of the mysql.com MailingList and have received some of your
mails.
From the mails I get the idea that you have quite some experience with mysql.
We are planning to migrate our database (currently oracle) to mysql.
Our database consists of about 150
* [EMAIL PROTECTED]
1. Is it a good idea to have all the columns in one big table ?
This will depend on the nature of your data. You say you have many varchar
columns. If many of them contains the same value, you could get substantial
speed/space improvements by splitting (normalizing) the
Tony,
Friday, April 26, 2002, 12:15:00 AM, you wrote:
TWDescription:
TW When dumping the 'mysql' database, the dump file contains syntax errors,
TW and I can't find where this has been rectified in later releases.
TW Example dump using 'mysqldump -cl mysql':
TW [snip]#
TW # Table structure
Description:
When dumping the 'mysql' database, the dump file contains syntax errors,
and I can't find where this has been rectified in later releases.
Example dump using 'mysqldump -cl mysql':
[snip]#
# Table structure for table 'db'
#
CREATE TABLE db (
Host char(60) NOT NULL default
Roger,
Wednesday, April 17, 2002, 6:54:29 PM, you wrote:
RB * Egor Egorov
RB 1) does this apply to InnoDb tables?
Not quite, InnoDB stores tables in the tablespace, that may consists of
several files..
RB Yes... but rarely one file per table...
RB But what about the .frm files...? Are they
* Egor Egorov
RB Are you saying that the mysql server will need to open all
the tables in a
RB database at the same time? When does this happen? When I issue the USE
RB command?
Roger, number of opened files is not the same as number of files in
the directory. When table is created, MySQL
Does the same scenario apply to MySQL database on a Linux server?
Yvon
Bill Easton wrote:
On the grounds that someone else may have this problem, and in response to
John's post, below, I am providing a cookbook of how to do what I asked.
The problem: I have a bunch of users, all
On Saturday, April 06, 2002 at 5:32 PM,
Aravind NagaVenkata Gorthy asked:
Could any one tell me what all the chages I have to make in order
to make my existing (english version) of MySQL database compatable
to the Japanese language.
It's a little hard to read your mind. Have you read section
Hi !!
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 1:39 PM
To: Guy-Maurice Lepoutre; [EMAIL PROTECTED]
Subject: Re: Creating a mysql database usinc VC++
On Tuesday 09 April 2002 2:30 pm, Guy-Maurice Lepoutre wrote:
Hello
On Sat, 6 Apr 2002 18:54:14 -0800 (PST)
Kip Kramer [EMAIL PROTECTED] wrote:
Hi All,
After working happily for months, my MySQL (v. 3.23.48-1) database has begun
displaying
the following problem:
Whenever I log in as mysql root and try to change privileges for my database as
follows:
Dear All
Could any one tell me what all the chages I have to make in order
to make my existing (english version) of MySQL database compatable
to the Japanese language.
Thanks and Regards
Aravind
-
Before posting, please check
Hi All,
After working happily for months, my MySQL (v. 3.23.48-1) database has begun displaying
the following problem:
Whenever I log in as mysql root and try to change privileges for my database as
follows:
grant insert, select
on MyDB_Name
to MyExistingUserName;
I get the error that the
database--but they need to be able to work offline.) They mostly have and
know Microsoft Access, and we have a requirement to support letting them get
to their data in Access. Turns out you can bring up the MySQL database in
Access just fine.
BTW, we did consider just using Access locally
Hello,
I would like to create a MySQL database using DAO and
Visual C++ 6.0 (CDaoDatabase and CDaoRecordset). I
know there is a Create() method on CDaoDatabase but I
cannot figure out how to use it to create a mysql
database. Does anyone know how to do this?
Moreover, do you know which files
On Thursday 04 April 2002 2:21 pm, Guy-Maurice Lepoutre wrote:
Hello,
I would like to create a MySQL database using DAO and
Visual C++ 6.0 (CDaoDatabase and CDaoRecordset). I
know there is a Create() method on CDaoDatabase but I
cannot figure out how to use it to create a mysql
database
I have a bunch of users with a MySQL database on their local machines.
Life would be simpler if they were able to access the MySQL database (read
only) from Microsoft Access.
Can this be done through an ODBC connection? Can somebody tell me how to
set it up
In the last episode (Apr 04), Bill Easton said:
I have a bunch of users with a MySQL database on their local
machines.
Life would be simpler if they were able to access the MySQL database
(read only) from Microsoft Access.
Can this be done through an ODBC connection? Can somebody tell
hii all,
I want to knowledge about blob.
how can write or read image(jpeg,gif or tiff) to/from MYSQL database by
using Visual C++. MySQL++ seems too confused.
Can any body say me more basic and understandable way to do this..
Thanks...
Ibrahim Kivanc Cihan
Anadolu University
,
for example, an image, to the mysql database, while I use EJB.
Another words, I have a object , which has a blob column, I wanna to
save and retrive this object from mysql database via
CMP or BMP...how to make that?
--
Borland Japan / Consulting Group
TAKAHASHI, "KEN"
Does anyone know of a good place to start looking at how to mirror a MySQL
database on two different computers?
Any help would be great, Thanks
Scott
-
Before posting, please check:
http://www.mysql.com/manual.php
Scott,
Try the following perl script to copy the contents of one mysql table from a
mysql database and insert it's contents into another mysql database on a
different host/server/computer under the same table name. Essentially a
mirrored copy. Can be useful in a cron or a shedule as it wont
a
mysql database and insert it's contents into another mysql database on a
different host/server/computer under the same table name. Essentially a
mirrored copy. Can be useful in a cron or a shedule as it wont output any
information or anything. Fill in your database details and let it run.
Ensure
On Tue, Apr 02, 2002 at 11:07:43PM -0800, Scott Broderick wrote:
Does anyone know of a good place to start looking at how to mirror a
MySQL database on two different computers?
Lookup REPLICATION in the on-line manual:
http://www.mysql.com/doc/
Jeremy
--
Jeremy D. Zawodny, [EMAIL
Hi,
After following the procedure on the web site for installing the MySQL
database on Solaris machine we encountered Segmentation fault (during the
Configuring mySQL for your machine step).
Please help me with this.
Regards,
Prachi
but would mean a second
copy of MySQL
but you would only need a low spec system..
I hope this helps...
Simon
-Original Message-
From: Kathy Reyes [mailto:[EMAIL PROTECTED]]
Sent: 19 March 2002 21:37
To: mysql
Subject: MYSQL DATABASE BACKUP
I am trying to backup a table in mysql without
I am trying to backup a table in mysql without locking my tables it this
posible
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
PROTECTED]]
Sent: Tuesday, March 19, 2002 1:37 PM
To: mysql
Subject: MYSQL DATABASE BACKUP
I am trying to backup a table in mysql without locking my tables it this
posible
-
Before posting, please check:
http://www.mysql.com
not quite sure what you mean by locking.
each table will be locked during readout for the dump automaticly for the
time the select runs and delivers data to the dumping program.
it is not needed to lock the tables (more than one) in advance for a dump, but
that, might better for dataintegrety.
Hello all.
I am running mysql 3.x on Redhat Linux, and Solaris 2.6 and 8
Most of the development work is done on these servers.
I do have a couple of windows developers using tools like mysqlfront
Is there way with mysql to print out table structure in a useable text format or maybe
even a
Hi,
I'm using php form to update mysql database, the form has several drop down
menus to choose from. What would the best way of updating information in the
database, update, as a function? Any help will be greatly appericated.
Thanks
Hi,
didn't really understand what you are asking.. Can you please be more
specific? What exactly you are asking?
Gurhan
-Original Message-
From: Valerie Brooks [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 5:28 PM
To: [EMAIL PROTECTED]
Subject: update mysql database via php
Hi there,
I have a problem with MySQL and the connection to it.
What I want is to connect a Visual Basic application with a MySQL database
with ADO. The only problem (and maybe more) is that there isn't a ODBC
driver available to connect to the database. For company security it is not
possible
is to connect a Visual Basic application with a MySQL database
with ADO. The only problem (and maybe more) is that there isn't a ODBC
driver available to connect to the database. For company security it is not
possible to install or modify system configuration. So the problem must be
solved server sided
Ashraf KAzmi writes:
Hi Jani,
That variable is already set to max_allowed_packet=16M in my.cnf file?
Any more clue..!
Ashraf
Hi,
First of all,
Please turn off HTML mode in your email client and use plain text mode
instead. HTML mode only increases the size of emails without
All,
How can I notify an application running on the slave server that the slave
database has just updated itself by means of replication. The reason I ask
is that I know MySql currently doesn't support triggers, but my application
needs to be notified when an update on the slave has just taken
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote:
All,
How can I notify an application running on the slave server that the
slave database has just updated itself by means of replication. The
reason I ask is that I know MySql currently doesn't support
triggers, but my application
PROTECTED]]
Sent: Thursday, March 07, 2002 10:42 AM
To: Thi Cao
Cc: MySQL
Subject: Re: MySql Database Replication Question
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote:
All,
How can I notify an application running on the slave server that the
slave database has just updated itself
privileges. For example, to create a user named repl
which can access your master from any host, you might use this command:
GRANT FILE ON *.* TO repl@% IDENTIFIED BY 'password';
Thi Cao wrote:
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get
ds,
If I understand you correctly, that also means that the user repl can access
the mysql database where all the privilege info is stored and see the
permissions, passwords, and such. Yes/No?
Thi
-Original Message-
From: ds [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002
-Original Message-
From: Thi Cao [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 12:04 PM
To: Thi Cao
Cc: MySQL
Subject: RE: MySQL Database Replication
ds,
If I understand you correctly, that also means that the user repl can access
the mysql database where all the privilege info
Yes, I did flush the privileges when nothing else worked but that didn't do
the trick either. Thanks for trying.
-Original Message-
From: James Housley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 6:00 PM
To: Thi Cao
Cc: MySQL
Subject: Re: MySQL Database Replication
Thi
-Original Message-
From: James Housley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 05, 2002 6:00 PM
To: Thi Cao
Cc: MySQL
Subject: Re: MySQL Database Replication
Thi Cao wrote:
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get
it to work
Hi
What is the number max of fields in a table in mysql database ?
Samuel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get
it to work yet. The problem reported in the error log of the slave server
is as follows:
Error reading packet from server: Access denied for user 'repl@slave_host'
(Using password: YES) (read_errno 0
Thi Cao wrote:
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get
it to work yet. The problem reported in the error log of the slave server
is as follows:
Error reading packet from server: Access denied for user 'repl@slave_host'
(Using
I just reinstalled the latest version of php on my system and after doing
so the pages that existed within the site no longer allow records to be
updated in MySQL, records that updated fine before. Any ideas why or how
to fix?
Thanks
]]
Sent: 28 February 2002 19:30
To: php-list; MySQL-list
Subject: After php udate, php pages no longer update MySQL database
I just reinstalled the latest version of php on my system and after doing
so the pages that existed within the site no longer allow records to be
updated in MySQL, records
Which PHP version did you update to? I have noticed in PHP 4.1.1 is
more anal about syntax
-Original Message-
From: Vernon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 28, 2002 1:30 PM
To: php-list; MySQL-list
Subject: After php udate, php pages no longer update MySQL database
Hi.
That's too few information to say anything concrete. Do you get any
error message? If not, please look how to enable error messages in PHP
(or change your script to log them). Then post the error message you
get.
Bye,
Benjamin.
On Thu, Feb 28, 2002 at 02:30:20PM -0500, [EMAIL
If you compiled it did you use --with-mysql?
On February 28, 2002 01:30 pm, you wrote:
I just reinstalled the latest version of php on my system and after doing
so the pages that existed within the site no longer allow records to be
updated in MySQL, records that updated fine before. Any
Hello group! I am a newbe to this listing.
What I am attempting to do is pass a number like 0123456 to a field in the
mysql database which is setup as int(11) but for some reason, the zero is
not
written into the database but instead all that is written into that field is
123456
What am I doing
On Tuesday 26 February 2002 4:00 pm, Scott Broderick wrote:
Hello group! I am a newbe to this listing.
What I am attempting to do is pass a number like 0123456 to a field in
the mysql database which is setup as int(11) but for some reason, the zero
is not
written into the database
At 15:00 -0800 2/26/02, Scott Broderick wrote:
Hello group! I am a newbe to this listing.
What I am attempting to do is pass a number like 0123456 to a field in the
mysql database which is setup as int(11) but for some reason, the zero is
not
written into the database but instead all
Douglass,
Saturday, February 23, 2002, 9:02:05 AM, you wrote:
DP I am brand new to MySQL, and trying to get up to speed as fast as possible.
DP I have successfully installed both MySQL 3.23.47 and MyODBC 2.50.39. I am
DP using VB6 and ADO in combination with MyODBC to connect to a database
properties:
Windows DSN Name: FECDatabase
MySQL host(name or IP): localhost
MySQL database name:FECData
User: IDSIUser
Password: excalibur
The following options have been turned on for the DSN:
Return matching rows
Don't prompt on connect
Change BIGINT columns
properties:
Windows DSN Name: FECDatabase
MySQL host(name or IP): localhost
MySQL database name:FECData
User: IDSIUser
Password: excalibur
The following options have been turned on for the DSN:
Return matching rows
Don't prompt on connect
Change BIGINT columns
properties:
Windows DSN Name: FECDatabase
MySQL host(name or IP): localhost
MySQL database name:FECData
User: IDSIUser
Password: excalibur
The following options have been turned on for the DSN:
Return matching rows
Don't prompt on connect
Change BIGINT columns
]
- Original Message -
From: Alexander Shaw [EMAIL PROTECTED]
To: MySQL Win 32 List [EMAIL PROTECTED]
Sent: Monday, February 18, 2002 6:56 AM
Subject: Create Tables in MySQL Database from Access
Hi all,
Seem to be hitting another annoying problem and can't find an answer -
which
no doubt
Oh. OK. Didn't know that. Thanks.
j- k-
On Saturday 16 February 2002 22:26, Jeremy Zawodny wrote:
On Sat, Feb 16, 2002 at 03:56:42PM -0900, Joshua J.Kugler wrote:
In that case, i would highly recommend using mysqldump to backup
your databases. Simply compressing the actual DB's
Hi list,
How compressible is a typical MySQL database? Is this more dependent on
the type of columns used i.e. a lot of text columns as opposed to a lot
of columns containing integer values?
The uncompressed size of the database is in the region of about 800-MB.
Also will it suffice to only
or bzip2 if you're looking for
more compression. test it out.
-tcl.
On Sun, 17 Feb 2002, George Labuschagne wrote:
Hi list,
How compressible is a typical MySQL database? Is this more dependent on
the type of columns used i.e. a lot of text columns as opposed to a lot
of columns containing integer
...
tar your mysql dir and gzip it, or gzip -9 or bzip2 if you're looking
for
more compression. test it out.
-tcl.
On Sun, 17 Feb 2002, George Labuschagne wrote:
Hi list,
How compressible is a typical MySQL database? Is this more dependent
on
the type of columns used i.e. a lot of text
(images or something),
then
probably not as much...
tar your mysql dir and gzip it, or gzip -9 or bzip2 if you're looking
for
more compression. test it out.
-tcl.
On Sun, 17 Feb 2002, George Labuschagne wrote:
Hi list,
How compressible is a typical MySQL database? Is this more
On Sat, Feb 16, 2002 at 03:56:42PM -0900, Joshua J.Kugler wrote:
In that case, i would highly recommend using mysqldump to backup
your databases. Simply compressing the actual DB's could give you
tables in inconsistent states, UNLESS you first shut down your DB
server, then run the backup.
Jason,
Friday, February 15, 2002, 9:33:14 PM, you wrote:
JGE what affects the rows in the host table of database mysql? is it when a
JGE particular host logs in the server's mysql console? or is it when a user
JGE browses a web file that launches a script to access a database? or both?
Table
what affects the rows in the host table of database mysql? is it when a
particular host logs in the server's mysql console? or is it when a user
browses a web file that launches a script to access a database? or both?
thanks
jembo
/retrieve data. For this I have thought of using the file based
database ie some file(s) will be bundled that are MySQL database. The
configuration to tell where the MySQL is running that will operate on
the
file system database bundle will be done before running the program. How
to
create such database
12.02.02 05:56:48, D Bamud [EMAIL PROTECTED] wrote:
I need to create a database in MySQL that I need to bundle with my program
for distribution. The user will have its own copy of MySQL running. User
[...]
file system database bundle will be done before running the program. How to
create such
/retrieve data. For this I have thought of using the file based
database ie some file(s) will be bundled that are MySQL database. The
configuration to tell where the MySQL is running that will operate on the
file system database bundle will be done before running the program. How to
create such database
On Thu, Jan 31, 2002 at 10:46:39PM +0100, m.korse wrote:
I know abouts MySQL's Replication, but i don't think this will help me
This is the situation:
I'm working for a (small) company with 4 offices in different parts
of the country. I've constructed a database in mysql and made an
Hi,
Can someone please tell me how this query can be better??
I need the clubrecords from atlethics database for onderdeel,categorie,inoutdoor.
select onderdeel,categorie,MIN(prestatie) as
prestatie,inoutdoor,naam,datum,wedstrijd,plaats FROM runtijden
GROUP BY onderdeel,categorie,inoutdoor
I know abouts MySQL's Replication, but i don't think this will help me
This is the situation:
I'm working for a (small) company with 4 offices in different parts of the
country. I've constructed a database in mysql and made an interface in PHP
that should be accessible for all 4 offices. I
Greeting all
Is there a way to put images like jpgs, tifs, gifs, bmp files into a mysql
database? I have done this with OLE objects using MS Access... can this be
done using the blob data type some how?
Thanks in advance
Dean-O
, January 22, 2002 8:27 AM
To: Rochester, Dean
Cc: mysql
Subject: RE: How does one put images into a MySql database
You can put images in the DB, but the easiest way is to put the path to
the
images in a text field, and rely on the disk to send the images.
hope that helps,
Brian
-Original Message
Message-
From: Brian P. Austin [mailto:[EMAIL PROTECTED]]
Sent: 22 January 2002 14:27
To: Rochester, Dean
Cc: mysql
Subject: RE: How does one put images into a MySql database
You can put images in the DB, but the easiest way is to put the path to the
images in a text field, and rely on the disk
Rochester,
Tuesday, January 22, 2002, 3:49:40 PM, you wrote:
Reoen Is there a way to put images like jpgs, tifs, gifs, bmp files into a mysql
Reoen database? I have done this with OLE objects using MS Access... can this be
Reoen done using the blob data type some how?
Yes, but don't forget
It seems like you have hit a file size limit.
Soalris has a 2 Gig ( or is it 4Gig) file size limit which is
restricting your database.
You could get past this by breaking up your data into different
segments, eg. group the data by month and store it in monthly tables,
reducing the size of the
I have added some extra fields to the mysql.user table, namely:
full_name VARCHAR(255)
job VARCHAR(255)
location VARCHAR(255)
phone VARCHAR(255)
reminder VARCHAR(255) NOT NULL
ip_addr VARCHAR(255) NOT NULL
I want to store these values for each person that creates a new account on my database.
Hamlin Nicholas-qa568 writes:
I have added some extra fields to the mysql.user table, namely:
full_name VARCHAR(255)
job VARCHAR(255)
location VARCHAR(255)
phone VARCHAR(255)
reminder VARCHAR(255) NOT NULL
ip_addr VARCHAR(255) NOT NULL
I want to store these values for each person that
Sinisa Milivojevic writes:
ALTERing will completely break security and permission systems and
will even prevent MySQL from proper functioning.
Can you give me an example? I'm having no problems with security even after adding
these columns. Users only have access to the dbs and tables that
a new
account on my database.
Yes, one might think that is a good idea, but it isn't... :)
The mysql database is an internal system database, you are probably better
of considering it read only... The GRANT and REVOKE commands modify these
tables.
cut
Any ideas would be appreciated so that I
Hello,
I am new to MYSQL
platform: Sun Solaris 2.6
mysql version: 3.22.32
I upgrade the hard drive from 4G to 18G as database
was increasing and causing problem now space problem
is solved and got in to another problem.
Database is not getting updated through
C programs and perl scripts(
On Sun, Dec 16, 2001 at 09:49:29AM -0600, Philip Molter wrote:
On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote:
: On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote:
:
: So, could you give me some advice that if it is feasible ? Or show
: me your successful cases of
: Re: MYSQL Database - DBI::db
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 include
one of the following words in your message:
database,sql,query,table
If you just reply to this message, and include
Hello,
I am interested in knowing :-
1) The maximum number of tables possible in MYSQL Database
2) The maximum number of columns that are in a table.
-
Before posting, please check:
http://www.mysql.com/manual.php
Hello,
I am interested in knowing :-
1) The maximum number of tables possible in MYSQL Database
2) The maximum number of columns that are in a table.
http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http
On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote:
So, could you give me some advice that if it is feasible ? Or show
me your successful cases of using mySQL which is supporting very
large DB or tables with details ?
How about a table with 260 million rows? We've got one that is
On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote:
: On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote:
:
: So, could you give me some advice that if it is feasible ? Or show
: me your successful cases of using mySQL which is supporting very
: large DB or tables with
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 locking
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
seconds of querying normal
COLUMNs. I want to know query speed in larger table.
Regards
Ares
- Original Message -
From: [EMAIL PROTECTED]
To: Ares Liu [EMAIL PROTECTED]
Sent: Monday, December 10, 2001 1:28 PM
Subject: Re: How Huge of your mySQL database or table in your former
Instance
Hi Tony,
- Original Message -
From: Tony Buckley [EMAIL PROTECTED]
Coming from an Oracle background, I started off hating mySQL. So far, I
have only 'played' with it, but now have enough confidence to start using it
for real. It is super fast and my test loads (as much as I can
Hi,
I need to store a string variable which is more than 255 character that
varchar field in mysql can contain. I have check the available docs with me
I can see anything referring to this.
Any support will be highly appreciated.
Thanks
Kamal.
TEXT and BLOB types.
http://www.mysql.com/doc/B/L/BLOB.html
-Ursprungligt meddelande-
Fran: Hamzat kamal [mailto:[EMAIL PROTECTED]]
Skickat: den 23 november 2001 09:56
Till: [EMAIL PROTECTED]
Amne: Is there any alternative to MEMO field in MYSQL database?
Hi,
I need
Did you *start* mysqld? :
Sounds to me like mysqld hasn't been launched. Check to make sure the server software
is actually running.
HTH
/Rob
Hi:
I telnet to the server. But I can not get into MySql
database. What's the problem?
% mysql
ERROR 2002: Can't connect to local MySQL server
Hi:
I telnet to the server. But I can not get into MySql
database. What's the problem?
% mysql
ERROR 2002: Can't connect to local MySQL server
through socket '/tmp/mysql.sock'
(2)
% mysql -p linksdb
Enter password:
Then I type in password, and got the following:
ERROR 2002
: Thursday, November 15, 2001 10:14 PM
To: [EMAIL PROTECTED]
Subject: How to Access MySql Database?
Hi:
I telnet to the server. But I can not get into MySql
database. What's the problem?
% mysql
ERROR 2002: Can't connect to local MySQL server
through socket '/tmp/mysql.sock'
(2
I can't access mysql databases from servlets, using mmjdbc.
When a servlet tries to execute:
Connection conn = DriverManager.getConnection(
jdbc:mysql://archive.infn.it/work?user=...password=...);
it always gets this exception:
java.sql.SQLException: Cannot connect to MySQL server on
: Accessing mysql database from a servlet
It is exactly what I do. But in a normal java application it works,
while in a servlet it doesn't.
Luigi Fonti
Nguyen Trong Phuc wrote:
this is the way to connect to MySQL from JDBC:
Class.forName(driverName).newInstance();
Connection con
501 - 600 of 726 matches
Mail list logo