VeeJay wrote:
I am a novice with Unix and user of MySQL on windows…..
I have a problem, i.e.
I want to install MySQL5.0 at my FreeBSD 6.1 box with following
configurations:
--prefix=/usr/local/mysql
--with-mysqld-user=mysql
--with-unix-socket-path=/tmp/mysql.sock
--with-mysqld-ldflags
Hi,
A replication slave needs some of its temporary files to survive a machine
restart so that it can replicate temporary tables or LOAD DATA INFILE
operations. If files in the temporary file directory are lost when the
server restarts, replication fails. MySQL creates temporary files as hidde
Brent Anderson wrote:
> Hello.
>
> I'm developing a client application for several platforms that will
> need to connect to a remote MySQL database. Unfortunately, MySQL
> refuses connections from external IP's that aren't allowed and since
> the clients using this will be on unknown IP addresses
GRANT (ALL|SELECT|INSERT|UPDATE|DELETE|etc) ON DATABASE.* TO
'user'@'%' IDENTIFIED BY 'password'
See http://dev.mysql.com/doc/refman/5.0/en/grant.html for details.
Note that localhost is considered as a special case, not included in
the wildcard %
HTH,
Dan
On 12/13/06, Brent Anderson <[EMAIL P
Hello.
I'm developing a client application for several platforms that will
need to connect to a remote MySQL database. Unfortunately, MySQL
refuses connections from external IP's that aren't allowed and since
the clients using this will be on unknown IP addresses (their home
computers), I
In the last episode (Dec 13), Jacek Becla said:
> Is there a way to find which index was used to sort
> MyISAM table (suppose someone run
> "myisamchk --sort-index --sort-records=2" in the past,
> how to find that sorting was done based on index #2?)
You can run a "select * from mytable" and see w
Hi,
Is there a way to find which index was used to sort
MyISAM table (suppose someone run
"myisamchk --sort-index --sort-records=2" in the past,
how to find that sorting was done based on index #2?)
And a related question: how to determine which is
the index "#2"? I guess if I look at the order
> On 12/13/06, Bing Du <[EMAIL PROTECTED]> wrote:
>> Hi,
>>
>> I want to create a MySQL user account that can only do database backup
>> but
>> nothing else. What privileges does such an account need?
>>
>> I'm having trouble with connecting to mysql.com to look at the
>> documents.
>> It's just s
It turns out that I have a binlog-ignore-db option configured for
another database. If you have even one of these you must make all
updates in the default database if you want them to be replicated. This
is a change in behavior from 4.0 to 4.1. We upgraded from 4.0 to 4.1 to
5.0 the same day wh
I am a novice with Unix and user of MySQL on windows…..
I have a problem, i.e.
I want to install MySQL5.0 at my FreeBSD 6.1 box with following
configurations:
--prefix=/usr/local/mysql
--with-mysqld-user=mysql
--with-unix-socket-path=/tmp/mysql.sock
--with-mysqld-ldflags=-all-static
H
I am a novice with Unix and user of MySQL on windows…..
I have a problem, i.e.
I want to install MySQL5.0 at my FreeBSD 6.1 box with following
configurations:
--prefix=/usr/local/mysql
--with-mysqld-user=mysql
--with-unix-socket-path=/tmp/mysql.sock
--with-mysqld-ldflags=-all-static
H
It turns out that I have a binlog-ignore-db option configured for
another database. If you have even one of these you must make all
updates in the default database if you want them to be replicated. This
is a change in behavior from 4.0 to 4.1. We upgraded from 4.0 to 4.1 to
5.0 the same day wh
On 12/13/06, Bing Du <[EMAIL PROTECTED]> wrote:
Hi,
I want to create a MySQL user account that can only do database backup but
nothing else. What privileges does such an account need?
I'm having trouble with connecting to mysql.com to look at the documents.
It's just spinning forever. Actuall
According to the mysql reference manual, the definition of this field is:
"How many temporary files mysqld has created. "
Can someone elaborate on this? What causes mysql to create a temporary file? I
see something indicating it may be associated with replication. In our
environment (which has
Hello, I'm using MySQL version 5.0.27 under Windows XP professional. I
have a text file with some SQL commands (I create a few tables and
insert some rows into them). I noticed that all columns where I tried to
insert a swedish character, that character got corrupted. But it works
if I type the
Well,
Maybe 70 pairs of "select into outfile" - "load data infile". At least,
this way you can select only columns you want to be in your new
database.
Best,
Mikhail Berman
-Original Message-
From: Russell Horn [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 13, 2006 12:41 PM
To: m
Hi,
I want to create a MySQL user account that can only do database backup but
nothing else. What privileges does such an account need?
I'm having trouble with connecting to mysql.com to look at the documents.
It's just spinning forever. Actually, the connection to mysql.com has
become extreme
We have a moderately sized database, more than 5GB in size, several
million rows and 70 tables.
We're running MySQL 5.22 and the database uses innodb throughout with
multiple foreign keys in use.
During development the structure of several tables has been changed many
times, such that we now
Hello,
I use Debian Linux, and I could install (with apt-get install) fine
the Mysql-4.1+apache+php4.
I tried fine Mysql 5. on the same debian machine.
Now I want to use mysql 5. through web/php4
Then I run into problem, like :
Warning: mysql_connect(): Can't connect to local MySQL server thro
Make sure that all joined fields are of identical types, otherwise the
query executor must cast each and every join value, which may be
affecting the query time...
Can you even define fields having foreign keys to be of a different type?
Anyway, taking a look at my JOIN
INNER JOIN users ON use
well the problem was olved when i used the follwoing command
scripts/mysql_install_db --user=root
bin/mysqld_safe --user=root
Gues by default it was not creating the mysql user. Now on prompt mysql is
running fine...
But...
As I am trying to port my MySQL code on HP-UX, and am unable to link my
Make sure that all joined fields are of identical types, otherwise the
query executor must cast each and every join value, which may be
affecting the query time...
Jay
Chris Boget wrote:
> Here is a query I'm trying to run. It doesn't look like it is overly
> complex and, granted, it's joining o
Hi,
Nishant Gupta wrote:
[/usr/local/mysql-5.1.12-beta-hpux11.11-hppa2.0w]scripts/mysql_install_db
--user=mysql
chown: unknown user id mysql
Installing all prepared tables
061212 19:39:30 [ERROR] Fatal error: Can't change to run as user
'mysql' ;
Please check that the user exists!
Did you do
Here is a query I'm trying to run. It doesn't look like it is overly
complex and, granted, it's joining on a few tables, I wouldn't imagine it
would take 6.5s to execute.
SELECT
TRIM( users.username ) AS username,
TRIM( games.game_name ) AS game_name,
CASE
WHEN 0 != UNIX_TIMESTAMP( MAX(
Hi All
I am trying to port my MySQL code on HP-UX, and am anuable to link my code
as I am getting the standard functions like mysql_query(),
mysql_store_result() etc as undefined. I am currently linking my code with
libmysqlclient_r.a. Do I need any other library to be linked as well??
--
25 matches
Mail list logo
