Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
T Uma Shankari wrote:
>
> Hello!
>
> I am trying to run mysql on XP. I have started the net start mysql.
> This service started without any error. My.ini file was there in
> c:\windows only. But i c
Hello,
Any inputs or information on running MySQL tests under Valgrind,
http://valgrind.org .
Thanks
-Manish
On Tue, 2005-10-04 at 14:25 -0700, Manish Marathe wrote:
> Hello All,
>
> I was building mysql after checking out from the bk repository. In that
> process, while executing mysql tests
I'd hate to use Microsoft's SQL server, but I feel like i've hit a
dead end with mysql.
If anyone can offer some advice on how to get mysql running on windows
ce, or can point me to some programmers who would be willing to port
the source code for me, please contact me.
-LiquidIce
[EMAIL PROTECTED
On Tuesday 13 July 2004 08:12, A. Lanza might have typed:
> Hi list,
>
> i've installed mysql-administrator and mysqlcc graphical clients
> downloaded from mysql.com. As i read in doc from the site, i unzipped
> the downloaded files in /usr/local.
>
> It seems to be ok, but i cannot execute the app
ics.co.uk
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: 26 May 2004 14:10
To: [EMAIL PROTECTED]
Subject: RE: Running MySQL and PostgreSQL on the same hardware
Thanks Kevin,
I am comfortable with the software installs etc.. I was more concerned
with hardware bottlenec
10:53
To: Andrew Braithwaite; [EMAIL PROTECTED]
Subject: RE: Running MySQL and PostgreSQL on the same hardware
Andrew
I've done it but only in a test environment. I actually had 3 different
versions of Mysql running plus Postgres.
Each of the Mysql's and Postgress were installed to
/op
Andrew
I've done it but only in a test environment. I actually had 3 different
versions of Mysql running plus Postgres.
Each of the Mysql's and Postgress were installed to /opt/-version
and paths set accordingly.
I've had no problems and they databases have been continuously up for over a
month.
"Colin O'Connor" <[EMAIL PROTECTED]> wrote:
> I don't have much experience with MySQL server, but I am working on a
> project which consists of a Java application accessing MySQL databases. The
> program is packaged with the mysqld binary for Windows, and the Java program
> simply executes the bina
Anyone has an idea about this issue?
Thanks in advance!!!
Regards,
Stefan
Stefan Egli wrote:
Hi there,
I'm having problems running two versions of mysql simultaneously on
the same box.
The versions I'm using are:
* mysql 3.23.48
* mysql 4.0.16
What happens:
* I have the 3.23 version up and runn
On Mon, Aug 18, 2003 at 09:42:51AM -0500, mos wrote:
>
> External RAM disks that are around 8g are extremely
> expensive. Some have built in in battery protection and operate
> independently from the OS so if the OS reboots, you still have your data. A
> couple of years ago I priced t
At 10:19 AM 8/18/2003, you wrote:
Mike,
This is very helpful.
Database consists of approximately 220,000,000 records. Raw data total
(roughly) 5.5 GBytes. I don't know how large the database will be loaded
(don't know about overhead, etc.)
Running InnoDb. Probably split 90% read and 10% wri
Your MySQL installation should have a directory called "support-files".
In there are a couple of configuration files you can use with obvious
names like my-huge.cnf, my-large.cnf, ..., my-small.cnf.
There are comments in each file about what kind of system they were
designed for. You can read up
Sorry the MySQL list server seems to have bounced my attachment. I have
include the text below.
my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# skip_innodb
innodb_data_file_path=idbdata1:200M:autoextend
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_a
Mike,
This is very helpful.
Database consists of approximately 220,000,000 records. Raw data total
(roughly) 5.5 GBytes. I don't know how large the database will be loaded
(don't know about overhead, etc.)
Running InnoDb. Probably split 90% read and 10% writees.
If nothing else replication
If you can post your current my.cnf + box configuration I'm sure we can
come up with some suggestions..
On Mon, 18 Aug 2003, Creigh Shank wrote:
> How would I tune my.cnf for a larger memory box? (Running on UPS;
> production machine(s) will go into Co-Lo with UPS and generator.) I
> realize
How would I tune my.cnf for a larger memory box? (Running on UPS;
production machine(s) will go into Co-Lo with UPS and generator.) I
realize there is some risk here. I am more concerned with the system
failing and some kind of mirroring solution to protect data.
Creigh
At 10:34 AM 8/18/200
At 09:17 AM 8/18/2003, you wrote:
Have a very large database and due to performance requirements it seems
that running MySQL in RAMDisk might be a good solution. Access to the
database is through PHP. Any suggestions or experiences?
Creigh
305-541-1122
Creigh,
How large is the database
Depends on db size... kinda risky putting it in memory if it's being
updated and power goes bye-bye..
You should be able to get alot more performance just tuning my.cnf for a
larger memory box..
On Mon, 18 Aug 2003, Creigh Shank wrote:
> Have a very large database and due to performance requi
e permissions on the /var/lib/mysql directory as
well. Mike
- Original Message -
From: "Peter Bradley" <[EMAIL PROTECTED]>
To: "O'K Web Design" <[EMAIL PROTECTED]>
Sent: July 30, 2003 1:03 AM
Subject: Re: Running mysql (complete newbie)
Hi Mike,
Hmmm
Ha! Nice one Nick.
Changed the user to mysql, but there's no mysql group, so changed the
group to daemon (sounded right). Anyway mysql is now up and running.
Just out of interest, the owner of all the directories in
/usr/local/mysql is '503'. Grepping /etc/passwd for '503' returns
nothing. mys
Hi guys/gals, the problem is directory perms but not in the tmp. And yes
you should have my.cnf in your /etc (can change this location but cant
remember where), and there are sample cnf files in the support-files
directory of mysql.
As far as the directory issue goes simply run:
chown -R mysql data
Hi Sanya
Don't appear to have a file called my.cnf anywhere on my system. Should
I have? If so how should it be formatted, and what should be in it?
Peter
On Wed, 2003-07-30 at 18:42, Sanya Shaik wrote:
> You need to set the sock in usr/local/mysql/data/my.cnf to /tmp/mysql.sock
>
>
>
e
>
>
>
> - Original Message -
> From: "Peter Bradley" <[EMAIL PROTECTED]>
> To: "O'K Web Design" <[EMAIL PROTECTED]>
> Sent: July 30, 2003 1:03 AM
> Subject: Re: Running mysql (complete newbie)
>
>
> > Hi Mik
Sorry forgot to cc to the list.
Hi Mike,
Hmmm. Don't think so. /tmp is drwxrwxrwt
Cheers
Peter
On Wed, 2003-07-30 at 18:43, O'K Web Design wrote:
> Hi Peter
>
> It sounds like you have a directory permission problem. I had one just
> this week. Just make sure that mysql can write to /
On Sunday, December 15, 2002, at 10:03 PM, David T-G wrote:
% ---
% Does anyone know what NetInfo Manager means when it shows a username
% (mysql) whose passwd is "*" (an asterisk)? And how I might
incorporate
% that user into... whatever I need it for? :)
No idea here; sorry. Well, some id
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ted --
...and then [EMAIL PROTECTED] said...
%
% On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote:
%
% >...and then [EMAIL PROTECTED] said...
% >%
...
% >% Most things I've read say to establish a "mysql" user -I take it this
% >% is to ru
At 20:34 -0500 12/15/02, [EMAIL PROTECTED] wrote:
Sorry all, but I'm trying!
What is the fix for the following behavior (besides "shoot the user" ;)
Looks like the stuff under /var/mysql isn't owned by ted. For starters,
try this as the Unix root user:
chown -R ted /var/mysql
Then try runnin
On Sunday, December 15, 2002, at 08:15 AM, David T-G wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
TR --
...and then [EMAIL PROTECTED] said...
%
% I wish to attempt to clarify one of my earlier questions:
That's always helpful :-)
%
% Most things I've read say to establish a "mysql" u
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
TR --
...and then [EMAIL PROTECTED] said...
%
% I wish to attempt to clarify one of my earlier questions:
That's always helpful :-)
%
% Most things I've read say to establish a "mysql" user -I take it this
% is to run the daemon(mysqld?) under?
>>Most things I've read say to establish a "mysql" user -I take it this
>>is to run the daemon(mysqld?) under?
Correct
>>Is the above user one that will be created in the users table of the
>>mysql db? What mysql privileges does such a user need?
No, this is a unix/linux user that is used to run t
TR,
Ok first I would like to say that I have just recently started using MySQL so I
feel your pain and I hope my explination helps you out.
The mysql user your referring to is probably the user that is should be used to
run the mysql daemon. Which would b e a seperate *nix/Windows(?) user, I'm no
Kevin,
Sunday, April 21, 2002, 11:27:06 PM, you wrote:
KF> I have the standard tarbal install of mysql. I want to know how do I start
KF> the server so that I can access it from another machine. I am running on a
KF> linux 6.2 server where the local ip address of the box is 192.168.1.150 and
KF>
From: Kevin Fialkowski <[EMAIL PROTECTED]>
> ...so that I can access it from another machine.
Hi Kevin,
This isn't a matter of how you start the service, but of your user privileges. Users
are not only known by user name and password, but also by the host they are coming
from.
Start with th
[EMAIL PROTECTED] wrote:
>
> I read somewhere that mysql reads /etc/my.cnf before it does any
> command line options, is this correct? If so, how can I have a my.cnf
> file
> and then run two servers if I have to have a [mysqld] section in the
> my.cnf
> file that tells the server which port and
ECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 3:10 PM
To: Johnny Withers
Cc: [EMAIL PROTECTED]
Subject: Re: Running mysql on a certain IP
On Mon, Apr 08, 2002 at 03:04:58PM -0500, Johnny Withe
On Mon, Apr 08, 2002 at 03:04:58PM -0500, Johnny Withers wrote:
>
> I need to run two MySQL servers on one machine.
>
> One needs to use /var/lib/mysql.sock
> and the other needs to use /home/mindbender/production/db/mysql.sock
>
> One needs to run on one ip address:
> ie: 10.0.0.10:3306
> and
Hi,
I am also facing the same problem...in Win2K
When i try to run in from the service, it says some
error
so i referred to some sites...and just using the
command line as standalone
Also i acould not run apache as a service...
I could not see it under services...
Any way to start thes
I have no problem running mySQL as a service on Win2k Server.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 2:35 PM
To: [EMAIL PROTECTED]
Subject: Running MySQL as Service on 2000 Server
Hi,
Anybody running MySQL on Win 2000 ser
Hi Floyd,
> Hi.. Can anyone tell me some good places to look for sample snips,
> tutorials or other assistance specifically for making PHP and mySQL
> cooperate. Running mysql queries using php syntax. Mysql talks about
> mysql queries, etc. and php talks about php functions, etc. but I'm
> fi
www.phpbuilder.com
www.hotscripts.com
www.devshed.com
Good Luck
Mark
-Original Message-
From: Floyd Baker <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, February 26, 2002 6:03 PM
Subject: running mysql w/php..
>
>Hi.. Can anyone tell me some good places
At 10:51 19/02/2002 -0500, Martin Filteau wrote:
Hi,
>Is it possible to port MySql on a Dos Computer ?
Sorry no. You need at least a 32 bit OS.
Regards,
Miguel
>
>Computer : 486DX66
>OS : DR-DOS 7.03
>Ram : 64 Mo
>HD : 1 Go
>
>Martin
>
>-
**
**
- Original Message -
From: Joe Kaiping
To: 'Curt Kliewer' ; 'G r e g L a w r i e'
Cc: 'MySQL List'
Sent: Sunday, December 09, 2001 3:17 PM
Subject: RE: running MySQL on WinXP
Sounds like you need to add permis
ssage-
From: Curt Kliewer [mailto:[EMAIL PROTECTED]]
Sent: Monday, 10 December 2001 11:49 a.m.
To: G r e g L a w r i e
Cc: MySQL List
Subject: Re: running MySQL on WinXP
I have installed the necessary MySQL files onto the hard drive (under
the folders inetpub --> wwwroot --> mysql. Next, I s
]
> Sent: Sunday, December 09, 2001 3:49 PM
> To: G r e g L a w r i e
> Cc: MySQL List
> Subject: Re: running MySQL on WinXP
>
>
> I have installed the necessary MySQL files onto the hard
> drive (under the folders inetpub --> wwwroot --> mysql.
> Next, I set up a
te: http://www.sol-interactive.com
**
**
- Original Message -
From: G r e g L a w r i e
To: Curt Kliewer ; MySQL List
Sent: Sunday, December 09, 2001 1:04 PM
Subject: RE: running MySQL on WinXP
Haven't tried it myself, but can't see why it shouldn't.
How about you
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
>
At 20:05 19/5/2001 +0100, James Cox wrote:
Hi!
Remove the service first: mysqld-nt --remove
Create /winnt/my.ini file with the following section and keys:
[mysqld]
basedir=G:/mysql
datadir=G:/mysql/data
Install the service: g:\mysql\bin\>mysqld-nt --install
start the server: net start mysql
James Cox wrote:
>
> Hi,
>
> I have been running an old version of the mySQL-nt server on my Windows 2000 box for
>some time now. It was installed on C:\ , as suggested in the install instructions.
>
> Now, I have a new disk, and so want to put the server on a partition, G:\ . After
>removing
It could be either you haven't set up a user by that name or you didn't set
that users password correctly. Have another read of Ch 6 of the manual and
then the GRANT and REVOKE commands in chapter 7.
- Original Message -
From: "Xiaowu Gai" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent
>the script. However, after that, I could not run mysql as root or mysql.
>It gave me the same error message as it could not connect to local MySQL
>server through /var/lib/mysql/mysql.sock.
/etc/my.cnf might have a line giving the uri above. Mysql.sock normally
lives in /tmp change my.cnf ac
If the user was defined using a password, then you must use the password.
If the user was defined without a password, then you must NOT use a
password.
Since the userid is unique key in the grant tables, you can't have it both
ways. Pick one and go with it (best to use the password)
If you really
Was a password defined when you granted permissions to the user?
-Original Message-
From: Hammad Nasim [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 2:43 PM
To: [EMAIL PROTECTED]
Subject: running Mysql client
Hi
I am having some problems running mysql client. I can connect
TECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 01, 2001 7:38 AM
Subject: RE: running mysql not as a server
> Michael,
>
> IMHO, if you are looking for a desktop database, something built around a
> .dbf file would be a more suitable choice. (My personal fav is FoxPro even
>
Michael,
IMHO, if you are looking for a desktop database, something built around a
.dbf file would be a more suitable choice. (My personal fav is FoxPro even
though it's a M$ product) MySQL, while it probably can be made to do this,
is not designed to do this.
Cal
http://www.calevans.com
-
Did you log into mysql a root?
ie mysql -uroot mysql
- Original Message -
From: "Webmaster" <[EMAIL PROTECTED]>
To: "MY SQL" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 23:25
Subject: running mysql
> Hi,
>
> I am a new user of Linux and mysql and i have installed suse7.0 on m
Hi,
you need to install the perl DBI package!
> What is DBI, sounds like data base interface or something like that. Do I
> need a latter perl or a different configure for my perl???
"The DBI is a database interface module for Perl. It defines a set of
methods, variables and conventions that pr
DBI is the database interface for Perl, I assume this bench mark uses perl
so you will need to install the DBI.
- Original Message -
From: "MacDonell, Dennis" <[EMAIL PROTECTED]>
To: "'MySQL List'" <[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 5:51 PM
Subject: Running mysql tests
57 matches
Mail list logo
