So is there a place where MySQL stores all warning messages which occured
during LOAD DATA ?
-Arnis
Hi
This is not a response to Malcolm, but rather a query.. if the CSV file
to be imported into a MySQL table using LOAD DATA command had ASCII
char(13) and/or ASCII char(10) in it, would
Hi!
"David" == David Mechner [EMAIL PROTECTED] writes:
David Hi,
David My license number is 7697. I don't know what the expiration date is. I'm
running 3.23.28-gamma msqld-opt under w2k.
David I'm trying to use a HEAP table to speed up data access, but every select I do
which references an
hi, i have a query that i hope someone can help me with.
i have a monitoring system that tracks the number of times that person clicks on a
particular adbanner on our site or in one of our newsletters. i member can choose
have a maximum of 16 interests selected.
so for example, i can say
3 times in the last few days I've had tables that have become
corrupted and needed isamchk -r to repair them. I'm becoming concerned:
what can cause such errors? (and what can I do to avoid them?)
I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have processes
updating the
I would suggest you issue an ALTER TABLE command to change your
AUTO_INCREMENT to unsigned. The concept of AUTO_INCREMENT negates the use
of negative numbers. If you are using the change from positive to negative
to flag for deletion or some other process, try adding a column for this
purpose
Hello,
I have just deleted thousands of records but the file
is still the same size as before. How do I make the
file compact? i.e. how do I get rid of all the "empty
spaces" in the table?
Tim Samshuijzen
-
Before
On Mon, Jan 29, 2001 at 01:30:57PM +0100, Tim Samshuijzen wrote:
Hello,
I have just deleted thousands of records but the file
is still the same size as before. How do I make the
file compact? i.e. how do I get rid of all the "empty
spaces" in the table?
Look at the MySQL manual.
Patrick Vogel writes:
HI
I am trying to install mysql++.
I did automake, autoconf ./configure, make and make install.
When I add this row in kdevelopp / C++
#include sqlplus.hh
this message appears:
"In file inclued from /usr/local/include/sqlplus.hh:9,
from main.cpp:24:
Arnis Shinka Jr writes:
So is there a place where MySQL stores all warning messages which occured
during LOAD DATA ?
-Arnis
No , there is not.
There is an item on our TODO for 4.* to optionally produce a table
with description of warnings. It is however not very high on TODO
list.
Try copying your databasefiles (mysqlhome/data), tar'ed or untar'ed,
to the mysql/data location.
According to specs this should do it
regards
- Original Message -
From: "Sam Wong" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 29, 2001 1:47 PM
Subject: Copying Database
There is an apache module called mod_auth_mysql that will allow you to do
this. You can download it from the mysql site at
http://www.mysql.com/downloads/contrib.html
I'm not sure if it's still maintained or anything because I can no longer to
the site at
It's quite fast for tar, just around 10-20 minutes. But it's unacceptable
slow when untar, more than 3 hours! I just want to know if there's any
efficient way to do that...
- Original Message -
From: "Lars Schioler" [EMAIL PROTECTED]
To: "Sam Wong" [EMAIL PROTECTED]; [EMAIL PROTECTED]
1) It's on a RAID, the seq test (just using a perl script to write files
coninuously) reach 50MBytes/sec
2) Sorry I don't understand
3) I've no idea. I've tried on UFS (on FreeBSD 3.2 3.4 3.5 4.1.1 and 4.2)
and ext2 (on newest Debian release)
4) It's on Dual xeon P2 400 1MB Cache, with 1G ram on
Hi there!
Macromedia Generator needs a cloumn as query result to create a chart
from given data (e.g. temperature lows).
My data is stored in records (rows).
Does anybody know a SQL syntax to return one column as query result
containing the information from one row.
Any help is greatly
I don't know if any of you people have ever had this trouble, but it's
been a messy one here.
Whenever a website of ours get lots of traffic, MySQL gets too slow to
connect. Whenever it connects, the queries are fast. Since lots of our
scripts relies on database connections, it has become a big
increase the number of connections allowed, that might be it
On Mon, 29 Jan 2001, Leonardo Dias wrote:
I don't know if any of you people have ever had this trouble, but it's
been a messy one here.
Whenever a website of ours get lots of traffic, MySQL gets too slow to
connect. Whenever it
Hi, everybody,
I have trouble, installing mysql on a Linux-machine running SuSE-Linux 6.3.
I managed to compile it from source (3.23.32) and I managed to install
everything, but I am unable to create the initial databases and to start the
mysqld. Here is, what I did, and what happened:
I
Aha! Many files you say. Well, the try:
-noatime, -async options for filesystem
(it quadrupled perfomance for me) or
use SoftUpdates (when on FreeBSD 4.2-stable only,
before than SoftUpdates were unstable).
- Original Message -
From: "Sam Wong" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Is this perhaps related to the 'slow thread creation' 'feature' of some
linux kernels?
http://lists.mysql.com/php/search.php?ps=10q=fast+thread+creation+ps=20m=
and
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Leonardo Dias
Sent: 29 January 2001
Marcelo wrote:
Can someone tell me how i can get(or
can someone send me) the strip command
for SCO Open Server 5.0.5?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
There's been some problems with the list. Testing if it works...
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
I bet your webserver and database server are seperate machine.
Make sure the hostname of web and db are in the /etc/hosts on both machine,
it's very slow to use DNS to resolve everything
That doesn't matter. We use IP to connect, not hostnames.
It might be a problem with the slow
Hi,
Does anyone have an idea of the date when the developments of Gemini project
will be integrated into MySQL ?
Will it be integrated in the MySQL 4.0 version ?
Will it be integrated in the standard MySQL sources without changing the
license agreement ?
I read that this project resulted in the
Leonardo Dias wrote:
I bet your webserver and database server are seperate machine.
Make sure the hostname of web and db are in the /etc/hosts on both machine,
it's very slow to use DNS to resolve everything
That doesn't matter. We use IP to connect, not hostnames.
But if you use IP
"jds" == j d stumbles [EMAIL PROTECTED] writes:
jds I'm running 3.22.32 on Solaris 5.6 on a sparc ultra-1, and have processes
jds updating the tables concerned continuously, via REPLACE INTO, INSERT INTO
jds or UPDATE statements.
I've never had table corruption on a Solaris box, even with
I'm seeing this error when installing mysql-server-3.23.32 on FreeBSD4.2.
I understand the name resolution issue, however I don't believe this has
anything to do with the grant tables failing. This is a binary install
from ftp.freebsd.org. Should I consider "rolling my own" from a
tar-ball?
Hi , im having a strange problem with the update in mysql
i have a table named "notices" with the following fields:
id :prymary, int, auto_increment.
title :varchar (255).
priority:int.
inside this table i have 5 registers like this :
id title priority
1 a 1
2
"JN" == Jeff Neuffer [EMAIL PROTECTED] writes:
JN I'm seeing this error when installing mysql-server-3.23.32 on FreeBSD4.2.
Use /usr/ports on FreeBSD, and make sure you have the C++ compiler fixes
from mid-january (ie, update FreeBSD to 4.2-STABLE).
--
[1 text/plain; us-ascii (7bit)]
I don't know if any of you people have ever had this trouble, but it's
been a messy one here.
Whenever a website of ours get lots of traffic, MySQL gets too slow to
connect. Whenever it connects, the queries are fast. Since lots of our
scripts relies
"Guridi, Tomas" wrote:
Hi , im having a strange problem with the update in mysql
i have a table named "notices" with the following fields:
id :prymary, int, auto_increment.
title :varchar (255).
priority:int.
inside this table i have 5 registers like this :
id
Trying to build mysql-3.23.32 under solaris 7 with gcc version 2.95.2
19991024 (release) got error message :
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local\" -DDATADIR=\"/usr/local/var\"
-DSHAREDIR=\"/usr/local/share/mysql\" -DUNDEF_THREADS_HACK
-I./../include -I../include -I ./.. -I.. -I.. -O6
-Mensaje original-
De: Gerald L. Clark [mailto:[EMAIL PROTECTED]]
Enviado el: lunes 29 de enero de 2001 12:53
Para: Guridi, Tomas
Cc: '[EMAIL PROTECTED]'
Asunto: Re: Problem with the UPDATE
"Guridi, Tomas" wrote:
Hi , im having a strange problem with the update in mysql
i have a
[1 text/plain; us-ascii (7bit)]
I don't know if any of you people have ever had this trouble, but it's
been a messy one here.
Whenever a website of ours get lots of traffic, MySQL gets too slow to
connect. Whenever it connects, the queries are fast. Since lots of our
"GLC" == Gerald L Clark [EMAIL PROTECTED] writes:
GLC You do not say what version you are running.
GLC Older versions did not allow updating the primary key field in that
GLC manner.
he's not updating the primary key field.
-
Concurrent updates and mysql aren't the best of friends, yet. (Perhaps DBD
and/or that new geminii stuff can fix some of your problems? Although
geminii will probably cost you...)
A lot of the slow queries can be solved by making better tables, sometimes
even de-normalizing them if that
From: NELSON, GLEN
Sent: Monday, January 29, 2001 11:15 AM
To: Mysql (E-mail)
Subject: Install of mysql on AIX fails due to missing module libz.a
-Original Message-
From: NELSON, GLEN
Sent: Monday, January 29, 2001 10:28 AM
To: '[EMAIL
You don't seem to have mentioned how much memory you have.
On 29 Jan 2001, at 14:52, Leonardo Dias wrote:
[1 text/plain; us-ascii (7bit)]
I don't know if any of you people have ever had this trouble, but
it's been a messy one here.
Whenever a website of ours get lots of traffic,
The manual section on BACKUP does not state what locking behavior the command
has. Does it lock all the tables at once that you backup in one statement or
does it lock them one at a time?
I.e. if I run:
BACKUP foo.bar, foo.baz, foo.blah TO '/tmp/mysqlbackups/'
Will it lock all three tables
I'm running mysql v3.22.32 and encountered a corrupt key file for a table. I
searched the documentation on the site, but it doesn't seem to pertain to this
version of mysql any longer. I'm hesitant to upgrade to 3.23.32 until I can
figure out what it might break. Does anyone have the steps
Hi All,
Summary: sockets opened by mysql-clients are not closed properly after
the client process has been terminated.
I'm using mysql-3.23.8-alpha (server running on irix 6.5), the clients
run on RadHat Linux 7.
When I establish a connection from the client (linux) to the server via
the
I have tried that with no avail. The GUI asks for my password when I
connect, and I am able to run select queries from the GUI, but all of the
things on the Commands menu that involve changing data don't work. Thanks,
Dave W.
-Original Message-
From: Sinisa Milivojevic
[1 text/plain; us-ascii (7bit)]
I don't know if any of you people have ever had this trouble, but
it's been a messy one here.
Whenever a website of ours get lots of traffic, MySQL gets too
slow to connect. Whenever it connects, the queries are fast. Since
lots of our
Nevermind. I see that the manual online has this information. Sigh. It
doesn't do what I want unfortunately.
Best,
Kyle
On Monday 29 January 2001 09:32, Kyle Hayes wrote:
The manual section on BACKUP does not state what locking behavior the
command has. Does it lock all the tables at
I'm running mysql v3.22.32 and encountered a corrupt key file for a table. I
searched the documentation on the site, but it doesn't seem to pertain to this
version of mysql any longer. I'm hesitant to upgrade to 3.23.32 until I can
figure out what it might break. Does anyone have the
Hello All:
I have developed a MySQL/PHP web application that is hosted on a shared
server. I have noticed that when the server is re-started, mysqld is not
automatically re-started.
I have been informed that I need to write a program to be executed by cron
when the server is re-started that
Hi,
Depending on your platform, there will be a set of directories somewhere
that contain a number of scripts that are run at various times during
reboot.
On Solaris, the main repository for the scripts is /etc/init.d, and scripts
in /etc/rc1.d are run when entering run level 1, /etc/rc2.d for
Hello,
We're installing Mysql source mysql-3.23.8-alpha on AIX 4.3.3.0. We were
able to run configure without a problem but have problem once make is run,
we receive the following errors:
"net.c", line 109.9: 1506-045 (S) Undeclared Identifier net.
"net.c", line 114.18: 1506-045 (S)
I am trying to bring up my third mysql server. This one is
MySQL-3.23.32-1.i386.rpm..rpm on a redhat 6.2 base. I was successful in
installing both the server and the host. Look around and every thing
looked cool! Piece of Cake! Then I decided to set up the mysqladmin user
and setup
From: NELSON, GLEN
Sent: Monday, January 29, 2001 11:19 AM
To: Mysql2 (E-mail)
Subject: Install of mysql on AIX fails due to missing module libz.a
From: t199k01
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
Install of
From: Subba Reddy M
Date: Fri, 26 Jan 2001 14:52:29 +0530
Hello MySQL guru,
Please advise me,
on creating new table with existing table structure.
I have tried, how MySQL documentation referred, but unable to get success.
create table newtable select * from oldtable;
This works on 3.23.x
Hello,
I'm student in Thailand. I learning about MySQL.
I have questions to ask to you.
I use MySQL version 3.22 have not SHOW TABLE
STATUS Syntax . How I know when table was created
(date and time).
Please contract to me, Thank you.
Very nice. Recommend to go there, could come a awfull lot of tricks things
to know there, in a entertaining way.
- Original Message -
From: "Jeff Cordova" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 29, 2001 6:54 PM
Subject: New way to learn Mysql?
I've spent the
Dear all,
i m running mysql on freebsd webserver and using our own DNS server.
Everything run fine with database and web serving. However, i m trying to
change the DNS ip addresses to our isp's DNS server instead of ours on this
webserver. Then i got the following error:
Does Mysql can be used in client server envorinment.
Hammad Nasim
New Core Networks
1032 Castro Street
Mountain View, CA 94040
P 650-691-1400
F 650-938-1730
http://www.newcorenet.com
-
Before posting, please check:
From: Liu Danyu
Date: Thu, 18 Jan 2001 18:08:37 +0800
I would do the query as
select maker, pc.id
from table1
where pc.id 2
order by maker;
dear all:
I need some help from you.
The dataset is as
did you edit /etc/resolv.conf?
dyu wrote:
Dear all,
i m running mysql on freebsd webserver and using our own DNS server.
Everything run fine with database and web serving. However, i m trying to
change the DNS ip addresses to our isp's DNS server instead of ours on this
webserver. Then
create table newtable select * from oldtable where 10;
This will solve your problem.
Best regards,
Fábio Ottolini
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 29, 2001 7:06 PM
Subject: How can I create one more table with existing table
hi
i am trying to use mysql database for my application , which is being
developed in java. where can i find jdbc drivers for mysql , and how to
install them, i am using win nt as developement platform. Its not for any
commercial application.
thanks
Vijay
Hi,
I managed to install the database but where can i find "mysql" in which directory. I
am not being able to find this executable. Did I mess on the installation process.
An early reply will highly appreciated.
Thanks.
Sanjeev Kabra.
I have a 6000user DB that has just moved to a new machine. The database
starts up and runs fine for about 2 minutes.
mysqld starts to hit heavy on the CPU bringing IDLE CPU usage down to 0.0
continuesly.
Is there any way to find out what exactly is dragging the database down. I
am sure there
DELETE FROM news WHERE newsdate=DATE_ADD(CURRENT_DATE, INTERVAL -14 DAY)
Above is the code that I would use to do that job. Hope this helps.
-Angela
Thomas Katsampes wrote:
Hello,
I'm trying to figure out the correct syntax for requesting
the database to
remove all records older than
In pawing though the source for mysql-3.22.32 (our current version
in production), I noticed in acconfig.h, a macro 'USE_RAID', which
in term seems to set up the use of include/raid.h.
But, I can't find any documentation for this, and the configure
program doesn't seem to set it one way or
On Sat, Jan 27, 2001 at 09:32:56PM +0300, Artem Koutchine wrote:
Hmm.. So ID is not PRIMARY KEY (not UNIQUE index).. That makes it
harder. A lot harder. A lot depends now on how many records per ID
you have there on average. If you you have only, say, 50 ids then
you'll be slower.
In the create table documenttation, it explains the USE_RAID, and a few
other options pertaining to it.
Gregg
- Original Message -
From: Brian Reichert [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 29, 2001 4:22 PM
Subject: 'USE_RAID' in mysql-3.22.32?
In pawing though
I'm wondering if anyone has any experience in setting up MySQL as a backend
to a website with multi-lingual support?
What I'm trying to do is have a web site with a main "gateway" page that
allows a user to choose their language. This will bring them to the actual
content, but in the language of
On Mon, 29 Jan 2001, Brian Reichert wrote:
In pawing though the source for mysql-3.22.32 (our current version
in production), I noticed in acconfig.h, a macro 'USE_RAID', which
in term seems to set up the use of include/raid.h.
But, I can't find any documentation for this, and the
Sorry if this is a little late- but at Abriasoft we are currently developing a tool
that can be used for automated backup of your MySQL databases from one or more servers
with the ability to restore from the backups in the event that you need to.
Our tool uses a C daemon and a php web
Hello,
I just want to make sure that I can do this but would this scenario work
properly.
I build an sql database and perl interface at site www.siteX.com.
A person on www.siteY.com is going to utilize this tool
The perl interface running on www.siteY.com makes a call to the database
from
hi:
Do you know where to get the class and their methods documentation of
Mysql++ API,
Regards
Hensen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Where can we find more information about gemini and when it will be done
exactly (date)?
--
-Spinlock
EmpireQuest Creator
http://www.empirequest.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the
maybe root password is not set...
check root password or login as root without password..
From: "Artem Koutchine" [EMAIL PROTECTED]
To: "Velamarthy Murthy" [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: How to avoid ERROR :1045
Date: Sun, 28 Jan 2001 15:13:23 +0300
i don't know exactly,
I'm going to have to answer Yes, and No.
Yes, they can access it.
No, it won't be the best situation. The internet is not very trustworthy,
and having DB's seperated over such large distances accessing instantly is
probably not the best choice. Not to mention that if you have large record
On Sun, Jan 28, 2001 at 11:26:29AM -0500, Lee Jenkins wrote:
Very, very cool. What will happen to the licensing and/or price for
this version?
According to the Press Release, Spring 2001.
And I believe it will be GPL'd. But I could be mistaken.
Jeremy
--
Jeremy D. Zawodny, [EMAIL
I am an independent web developer working on a web based application that I
plan on giving to companies to use to track certain activities. I am
currently developing this application using ASP and VB and integrating it
into an MS SQL server. I have some companies using MS SQL, some using
Hi everyone,
I have twice posted a problem with replication and have since seen 2 or 3
others post with similar replication questions and problems.
However I have yet to see ANYONE respond to any of those posts.
I dont understand, it feels like we're being totally ignored. Can no one
offer
This site provide the JDBC driver and all the tutorial :
http://www.worldserver.com/mm.mysql/
--Andy--
-Original Message-
From: Vijay Chandra [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 4:55 AM
To: '[EMAIL PROTECTED]'
Subject: mysql jdbc drivers
hi
i am trying to use
nope sorry
On Mon, 29 Jan 2001, Ricardo Kleemann wrote:
Hi everyone,
I have twice posted a problem with replication and have since seen 2 or 3
others post with similar replication questions and problems.
However I have yet to see ANYONE respond to any of those posts.
I dont
I have followed the instructions at
http://www.symbolstone.org/cgi/dbi/moduledump?module=Msql-Mysql-modules
to install MySQL Perl DBI/DBD which are:
First of all you need to fetch the
archives from any CPAN mirror, for
example
Hi all. I'm having a little trouble with this query.
**Table 1 (Orders) **
OrderID SmallInt
OrderStatus VarChar(20)
CustomerPhone VarChar(10)
SalesRepIDSmallInt(11)
**Table 2 (Customers)**
CustomerFirst VarChar(20)
CustomerLast
Hmmm... Looks like you over did the query to me. This should work.
SELECT o.OrderID, c.CustomerFirst, c.CustomerLast, s.SalesRepFirst,
s.SalesRepLast
FROM Orders as o, Customers as C, SalesReps as s
WHERE O.CustomerPhone=c.CustomerPhone AND o.SalesRepID=s.SalesRepID
of course you don't need
This is hopefully a simple problem.
I have just upgraded my server from RH 6.2 to RH 7.0 and have upgraded the
MySql as well. Having sorted out the missing Perl modules I have finally
arrived at the point where the following error is returned by Perl to the
browser:
Can't connect to local
Aftab Rashid wrote:
Hi,
A friend has told me that there is port on which mysql allows anyone to
access mysql without authentication, is that right?
If yes, what is the port number ?
Regards,
--
Aftab Rashid
Manager Systems
Beaconet
164 P, Gulberg II,
Lahore, Pakistan
Hi,
A friend has told me that there is port on which mysql allows anyone to
access mysql without authentication, is that right?
If yes, what is the port number ?
Regards,
--
Aftab Rashid
Manager Systems
Beaconet
164 P, Gulberg II,
Lahore, Pakistan
+92-42-11122
http://www.beaconet.net
On Mon, Jan 29, 2001 at 04:40:53PM -0800, Ricardo Kleemann wrote:
Hi everyone,
I have twice posted a problem with replication and have since seen 2
or 3 others post with similar replication questions and problems.
You've certainly been on the list long enough to witness the volume of
mail
Hi,
How do I Create a Database with Userid and Passwords. Eg. CREATE DATABASE
USER. Such that I am able to login and access the database using this userid and
password.
Thanks
Richard
I have no idea what this error is trying to tell me...
I have a table called "Headlines" which contains a VARCHAR(255) field
called "Url". I need to store larger values in the "Url" column, so I
want to convert it to TINYTEXT.
---snip---
mysql alter table Headlines modify Url TINYTEXT NOT
from the MySQL site is MySQLGUI.
will this run on OS X pb?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
On Mon, Jan 29, 2001 at 10:07:55PM -0800, Jeremy D. Zawodny wrote:
---snip---
mysql alter table Headlines modify Url TINYTEXT NOT NULL;
ERROR 1170: BLOB column 'Url' used in key specification without a key length
Oh, okay. Now I understand.
The max key length is 256, so I'd need to
Personally speaking, if the index 256, it will lost the meaning of
indexing...
- Original Message -
From: "Jeremy D. Zawodny" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 30, 2001 3:06 PM
Subject: Re: ERROR 1170: BLOB column 'Url' used in key specification without
a
On Sun, Jan 28, 2001 at 10:47:21PM -0800, Bob Cottrell wrote:
Hello there,
We have a number of Sun sparcs connected to 2 NetApp file servers,
and are currently using 1 sparc running mysql with the databases
residing on one of the NetApps. I would like to run a 2nd sparc
mysql server,
On Tue, Jan 30, 2001 at 01:09:14AM +0100, [EMAIL PROTECTED] wrote:
Description:
Can't start mysqld. In /var/mysql/hostname.err, there is
a line saying "getpwnam: Undefined error: 0"
How-To-Repeat:
/usr/local/bin/safe_mysqld
Hm.
What user have you configured MySQL to run
Hi, we are testing out MySQL, too se if it might meet our needs.
We are currently having problems returning Text fields from the database through ODBC.
System:
Win NT 4.0
Visual Basic 6.0 Ent.
RDO (Remote data objekts, must use!)
MySQL servers both on W32 and Linux
The first record in the
How do I Create a Database with Userid and Passwords. Eg.
CREATE DATABASE USER. Such that I am able to login and access the
database using this userid and password.
Check out the manual. Search for MYSQLADMIN and GRANT.
Much other info can be found at www.devshed.com
Bye,
B.
93 matches
Mail list logo