I am following or trying to follow this document:
http://www.howtoforge.com/mysql5_master_master_replication_debian_etch
I think it is running in a good state because when i query the show
slave state, I get awaiting connection from host, like :
on server1:
mysql SHOW MASTER STATUS;
Joey, please consult your mysql error log. Something has gone wrong on your
server where innodb is not started.
On Tue, Jun 5, 2012 at 3:53 PM, Joey L mjh2...@gmail.com wrote:
I am following or trying to follow this document:
thanks - i had to reset the whole db and the error went away - do not
know what i did wrong.
thanks
On Tue, Jun 5, 2012 at 3:35 PM, Andrew Moore eroomy...@gmail.com wrote:
Joey, please consult your mysql error log. Something has gone wrong on your
server where innodb is not started.
On Tue,
I am brand new to MySQL
Running MYSQL 4.0.16 on FreeBSD.
When I try to add a user, with the following code I
get an error.
INSERT INTO user
VALUES
('localhost','username',password('Secret'),
'Y','Y',...);
I have used inwhere from 6 'Y's (Friends
Recommendation) to 14 'y's MYSQL manual.
I get the
(
data
, more data
, even more
);
Peter
-Original Message-
From: Leon Ellis [mailto:[EMAIL PROTECTED]
Sent: 26 June 2004 10:14
To: MYSQL
Subject: MYSQL Setup Question
I am brand new to MySQL
Running MYSQL 4.0.16 on FreeBSD
[mailto:[EMAIL PROTECTED]
Sent: 26 June 2004 10:14
To: MYSQL
Subject: MYSQL Setup Question
I am brand new to MySQL
Running MYSQL 4.0.16 on FreeBSD.
When I try to add a user, with the following code
I
get an error.
INSERT INTO user
VALUES
('localhost','username',password
PROTECTED]
Cc: MYSQL [EMAIL PROTECTED]
Sent: Saturday, June 26, 2004 11:32 AM
Subject: RE: MYSQL Setup Question
Thanx Peter,
But I have no tables set up yet.
I just installed MySQL
I'm try to set remote access (for using Dreamweaver)
on a local network.
I thought I had to set permission
Has anyone try to setup ECperf benchmark using MySQL?
Am having problem on the mysql setup files for ECperf.
Anyone can provide information on this?
Thank you: meileng
__
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
hi...
i'm running rh 8.0 with mysql on a test system. i'm relatively new to the
admin functions of mysql. another person setup the mysql on the system.
in reviewing the setup, it appears that mysql was setup with using root, and
the root password. when i look at phpMyAdmin, it is also setup
/where a change
should be made..
You should look at using the Cookie auth type in phpmyadmin. Your mysql
setup is fine, you need a root user, you just don't want phpmyadmin logging
in as that user all the time.
http://www.phpmyadmin.net/documentation/
That link will tell you how to change your
..???
and what the h*^* are you doing up at this time of night!!
thanks...
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 16, 2004 12:51 AM
To: MySql
Subject: Re: basic mysql setup
on 05/16/2004 12:52 AM, bruce at [EMAIL PROTECTED] wrote:
i'm running rh 8.0
on 05/16/2004 01:15 AM, bruce at [EMAIL PROTECTED] wrote:
but this brings to mind a question. is it possible to have multiple users
accessing the phpMyAdmin app, with each having different access rights for
different databases/tables...??
Yes, that's exactly what it does, you basically assign
Estoy tomando el sol
.
q
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
§A̦n! §Ú¨Ï¥Îlinux rehat 7.2 ¦w¸Ëmysql-3.23.43-1.scr.rpm®ÉÔ,¹B¦æ¥X²{¦pªþ¥óªº¿ù»~«H®§,
¤£ª¾§A̯à§_À°À°§Ú,ÁÂÁÂ!
P
§
jackliu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: mysql setup compared to oracle
Hi,
I'm new to mysql. Coming from the oracle database a couple of questions
came up. Perhaps somebody, who has also experience in oracle, can set me
on the tracks.
Questions:
1. is mysql simular organized as oracle: instance/users/tables
I'm fairly new to mysql myself, but I'll have a go.
The mysql manual is at http://www.mysql.com/doc/.
I've only dipped into it, but it seems to be pretty good.
Questions:
1. is mysql simular organized as oracle: instance/users/tables,
so that I have to connect to chossen instance and
1. No, especially not MyISAM. In MyISAM, a database (you can compare
that to instance) is just a directory on disk. Every table in this DB
(instance) again is file (well actually 3 files, one for data, one for
metadata, one for index information).
Actually the server is equivalent to an
'; [EMAIL PROTECTED]
Subject: RE: mysql setup compared to oracle
1. No, especially not MyISAM. In MyISAM, a database (you can compare
that to instance) is just a directory on disk. Every table in this DB
(instance) again is file (well actually 3 files, one for data, one for
metadata, one
Hi,
I'm new to mysql. Coming from the oracle database a couple of questions
came up. Perhaps somebody, who has also experience in oracle, can set me
on the tracks.
Questions:
1. is mysql simular organized as oracle: instance/users/tables,
so that I have to connect to chossen instance
Balazs,
Wednesday, October 16, 2002, 8:27:56 AM, you wrote:
BL I installed the full version of Mandrake 8.2.
BL The problem is that i can't setup the mysql server.
BL When i tried: mysql -u root mysql; the server
BL responded: acces denied for root@localhost !!
Have you installed MySQL
Hi!
I installed the full version of Mandrake 8.2.
The problem is that i can't setup the mysql server.
When i tried: mysql -u root mysql; the server
responded: acces denied for root@localhost !!
Then tried the command mysql_install_db. But when i
wanted to sign in: still acces denied.
Then
Well try mysql -u root -p
it will prompt asking for the password I really don't remember if
the derault password is mysql but you could try empty too.
-jose
Hi!
I installed the full version of Mandrake 8.2.
The problem is that i can't setup the mysql server.
When i tried: mysql -u root
Dear All,
My web host provider says that he cannot allow me to have a MySQL account
on the server. However, he asks me to set up my tables offline and ftp them
across and asses them using Php.
Can this be done?
Thank you.
Kindest regards,
Kenneth Gomez,
Engineering Analyst,
Compumod Sdn
/description file).
Regards,
Bhavin.
- Original Message -
From: Kenneth Gomez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 7:41 PM
Subject: Basic MySQL setup question
Dear All,
My web host provider says that he cannot allow me to have a MySQL account
On Fri, Aug 02, 2002 at 10:41:12AM +0800, Kenneth Gomez wrote:
Dear All,
My web host provider says that he cannot allow me to have a MySQL account
on the server. However, he asks me to set up my tables offline and ftp them
across and asses them using Php.
Can this be done?
Yes.
--
Hi,
Would like to know if there is a preferred way of setting up the data
directory for mySQL. The default for a database would be in C:\mysql\data.
Is this the preferred way or should this be set up in another directory
outside of the mysql directory? Does moving the data directory affect
At 16:50 08/01/2002 +, Los Morales wrote:
Hi!
Hi,
Would like to know if there is a preferred way of setting up the data
directory for mySQL. The default for a database would be in C:\mysql\data.
Is this the preferred way or should this be set up in another directory
outside of the mysql
Hi,
Here is what I understand:
your queries are already very optimized, you have already played
with database scheme and application optimisations so there is little
chance to find any gain there.
Your setup seems to be right according to disc I/O and RAM since
all indexes fit in RAM and you
Aaron Williams wrote :
Joseph Bueno wrote:
Hi,
If you run a single query, MySQL will use only one processor.
MySQL multithreading allows you to run multiple queries in parallel,
one query per thread.
Right, that I understand. Even while running up to 30 queries it pegs the
first
Hello again list. I sent this message yesterday and wasn't able to
get an answer. Just curious to see if any of the gurus out there care
to share some insight on a mid-level MySQL setup, and can offer some
starting points for learning how to troubleshoot the same.
| Begin message:
I have
Aaron Williams wrote:
Hello again list. I sent this message yesterday and wasn't able to
get an answer. Just curious to see if any of the gurus out there care
to share some insight on a mid-level MySQL setup, and can offer some
starting points for learning how to troubleshoot the same
Aaron Williams wrote:
The tables run upwards of around 13-15 gigs each. The nature of the
data forces me to search the entire contents (looking for unique
values) around 3000 times a day. The server is running Solaris 2.8,
Do you have an index on the columns you are querying for unique
Joseph Bueno wrote:
Hi,
If you run a single query, MySQL will use only one processor.
MySQL multithreading allows you to run multiple queries in parallel,
one query per thread.
Right, that I understand. Even while running up to 30 queries it pegs the
first CPU at max, and no other CPUs are
]
To: [EMAIL PROTECTED]
Sent: Monday, May 07, 2001 18:32
Subject: RE: mySQL setup
Hi
Thanks, I tried, but it still didn't work.
Can somebody point me to an idiot proof installation site, I've tried a
few
from the web, some seam to help slightly, others seam to hinder more
Cheers, Alud
I have a problem getting the mysql started. I am running
slackware linux version 7.xx. Apparently mysql is installed.
I downloaded the linux binary package of mysql and installed it.
the mysql is installed in /usr/local/mysql. The problem is that
mysql ** immediately ends **. Here is one of the
Dear All,
I am trying to build up a web based email setup on RedHat linux platform.
And for that purpose I am using a solution comprising of
IMP2.2/Horde1.2/PHP4/Sendmail/Apache Server and MySql. The problem is that
although the MySql server is running, the PHP script cant connect to the
36 matches
Mail list logo
