kalin mintchev wrote:
system freebsd 4.10
mysql is binary: mysql-standard-5.0.15-freebsd4.7-i386
after mysql installation and root password set up i can type:
/usr/local/mysql/bin/mysql -u no_matter_what_user_here
and i get right in. even if i type -p. i do get the password prompt
This message was cancelled from within Mozilla.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
kalin mintchev wrote:
system freebsd 4.10
mysql is binary: mysql-standard-5.0.15-freebsd4.7-i386
after mysql installation and root password set up i can type:
/usr/local/mysql/bin/mysql -u no_matter_what_user_here
and i get right in. even if i type -p. i do get the password prompt
Sorry I first misread yor question (I hope I cancelled prev. post on
time). I thought you have problems connecting to mysql while actual
problem is: Why it is so easy for everyone (even from outside) to
connect?
Yes this is normal: default user is root *without password*
if you wan't to secure
Hello.
According to the output of configure shared libraries are enabled by
default:
--enable-shared[=PKGS] build shared libraries [default=yes]
Have you tried to just configure and make without any options?
Daryn wrote:
hi there.
1st time posting to this list (and
Did you try doing a find for the lib? Perhaps it needs to be in the ld.conf or
ldlibpath?
-
Sent from my NYPL BlackBerry Handheld.
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
Sent: 12/06/2005 05:51 PM
To: mysql@lists.mysql.com
Subject: Re: question
On 12/4/05, Luiz Rafael Culik Guimaraes [EMAIL PROTECTED] wrote:
Dear Friends
Is their an Page with data of how much bandwidth mysql consume when using
remote servers?
mysql show status like 'Bytes_%';
+++
| Variable_name | Value |
Yes you're right! you can safely delete those - but first make some
changes... as it seems you've set up root password only for :
[EMAIL PROTECTED] - right? that's why you can't login using
localhost (mysql without -h host option assumes -h localhost and if you
only changed password for
Hi,
For any reason, current_date doens't look to behave normally since a few
days.
I run reports in a MySQL DB through sql queries and I use a statement like
... invd between current_date - 7 and current_date - 1 ... It always
worked.
I just noticed that this week's report was wrong. Indeed :
In current_date - 7 the date is converted to a string and than to an Integer.
Use adddate function:
adddate(CURRENT_DATE(),interval -1 day)
Santino
At 11:37 +0100 7-12-2005, christophe nauwelaers wrote:
Hi,
For any reason, current_date doens't look to behave normally since a few
days.
I run
Hello,
I'm using mysql-standard-4.1.14 and mysql-client-4.1.14 on a RH9 machine,
I have utf-8 tables with hebrew data. When using the client I see the
hebrew as question marks.
I would like to view and edit the data via the client.
I've tried using a terminal that is surely able to view
Hi,
I have a berkeley db table containing about 5 rows where I do this
transaction (pseudocode follows):
begin work
delete from mytable where myfield='boo' /*delete about 100 rows*/
for (i=0; i=100; i++){
insert into mytable values(...);
}
commit
During the insert command i get the following
Hi,
Is it possible to wrap an a href tag around a column in a resultset? For
example:
SELECT Firstname FROM Users;
Matthew
Mark
Luke
John
Becomes:
a href=index.php?action=view_userfirstname=MatthewMatthew/a
a href=index.php?action=view_userfirstname=MarkMark/a
a
On Wednesday 07 December 2005 15:29, Shaun wrote:
SELECT Firstname FROM Users;
Matthew
a href=index.php?action=view_userfirstname=MatthewMatthew/a
I need to do this with pure SQL - no server side scripting...
http://dev.mysql.com/doc/refman/4.1/en/string-functions.html
CONCAT() perhaps.
select CONCAT('a
href=index.php?action=view_userfirstname=',Firstname,'',Firstname,'/a')
from Users;
Shaun wrote:
Hi,
Is it possible to wrap an a href tag around a column in a resultset? For
example:
SELECT Firstname FROM Users;
Matthew
Mark
Luke
John
Becomes:
a
Hello.
Please, check that you can see hebrew data in your
terminal (you have appropriative fonts installed).
Send to the list a CREATE statement for you table and
output of the following statement:
show variables like '%char%';
Yair Zohar wrote:
Hello,
I'm using
Description:
mysql will not create /tmp/mysql.sock
at first it would not create /var/run/mysql/mysqld.pid - I manually created
the /var/run/mysql and set permissions, and it works. now i have problems
with the socket file - it wont create it
How-To-Repeat:
bin/mysqld_safe --user=mysql
Since I didn't get a response from the perl list, and since Daryn received
some responses to his similar question I thought I might see if you guys had
any ideas on why I can't make test for DBD::mysql on Solaris.
TIA,
F
-- Forwarded message --
From: Jake Peavy [EMAIL PROTECTED]
What is the MySQL equivalent to Sybase's @@error and @@rowcount? I'm
writing stored procedures where I want to log database error codes.
Please let me know.
Thanks,
Brandon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Yep, the objects appear to be ok including the offending libmtmalloc.so.1...
# ldd /export/home/root/.cpan/build/DBD-mysql-3.0002
/blib/arch/auto/DBD/mysql/mysql.so
librt.so.1 =/lib/librt.so.1
libcrypt_i.so.1 = /usr/lib/libcrypt_i.so.1
libgen.so.1 =
Hello.
seems to put the socket file in the wrong place- (should be in /tmp)
Your running copy of mysqld has --socket==/var/lib/mysql/mysql.sock
argument. Perhaps mysqld_safe puts it by default or reads from
[mysqld_safe] or [mysqld] sections of configuration file. Specify
the value of
Hello.
But anyway, the source *IS* latin1, so maybe this shouldn't be a
problem anyway?
In theory if the source contains only characters from latin1 set
there shouldn't be any problems, but are you sure that you're inserting
latin1 characters? What is your locale settings? If you
Hello.
I'm not a Solaris or DBD guru, so I could be wrong, but ldd output
doesn't show that mysql.so loads libmysqlclient (however, it can be
statically linked). There could be some problems with compiling
MySQL clients which described more in detail at:
i´m using mysqldump to dump some tables and then load it into another mysql
server with mysql command.
but can i specify what columns in the tables to dump?
i´m using something like this now
mysqldump -h localhost -u root db tbl | mysql -h xxx.xxx.xxx -u login -pass -w
db
kbforge.com is pleased to announce the first public release of kbforge,
a new free desktop search application specifically designed for software
developers.
What differentiates kbforge from other desktop search programs, is its
ability to assist the user in categorising the information before it
25 matches
Mail list logo