Hi
That's a problem about privileges. Try mysql -uroot.
Please have a look at http://dev.mysql.com/doc/mysql/en/privilege-system.html
and http://dev.mysql.com/doc/mysql/en/user-account-management.html
regards
On 2005年08月20日 14时46分26秒, tai huijia wrote:
Greetings,
I'm a new user for MYSQL
Thanks so there is no operator that tells mysql that both words must match?
one|two is equal to one OR two
I want an operator that is equal to one AND two but i guess i will have to
use match in boolean mode for that?
Quoting Enrique Sanchez Vela [EMAIL PROTECTED]:
John,
using
John thegimper wrote:
Thanks so there is no operator that tells mysql that both words must match?
one|two is equal to one OR two
I want an operator that is equal to one AND two but i guess i will have to
use match in boolean mode for that?
Why not use full-text searching instead of regexp?
HI,
If you want i can send you the help file so you dont need to browse anytime
you need a command in mysql.
Thank you,
ehrwin
At 03:13 PM 8/22/2005, Gu Lei wrote:
Hi
That's a problem about privileges. Try mysql -uroot.
Please have a look at
Martin,
Have you defined a user? Because Windows automatically uses
'ODBC'@'localhost' as a standard account, when there is no username
submitted. According to
http://www.php.net/manual/en/function.mysql-errno.php the mysql-errno
function should still work. But it might be interesting to know
Hi,
I asked this question in in the mysql-cluster list, but I think this is not
really related to clustering. So I am asking it here. Please bear with the
cross posting.
I need to run a particular 'select' on multiple machines, and then reorder
them. The query is: 'select * from table
On Mon, Aug 22, 2005 at 01:46:23PM +0530, George Cherian wrote:
I need to run a particular 'select' on multiple machines, and then reorder
them. The query is: 'select * from table where parent_name = 'parent' order
by name limit 10. This query has to be sent to 10 servers - in series,
my host dont want to change the ft_min_word_len it´s now at 4 chars and i need
to do searches with only 2 chars.
Quoting Jasper Bryant-Greene [EMAIL PROTECTED]:
John thegimper wrote:
Thanks so there is no operator that tells mysql that both words must
match?
one|two is equal to one OR
Is there still no solution for this? Every large searchengine works like this.
Quoting:
Hi that works fine only now if a user puts + in front of a word that
word
becomes optional = OR?
What i would like is the search to work exactly like before only that it
defaults to AND instead of
Le samedi 20 août 2005 à 13:53 -0700, Devananda a écrit :
Hi Devananda,
In short, it sounds like you should be able to simply copy the
auto_increment field data from your old DBMS into MySQL, and continue to
use it as such, without problem. Have you tried this in a test
environment yet?
Hi,
2005/8/22, Kane Wilson [EMAIL PROTECTED]:
Thanx , as i understood , i have to keet the raw data in folders and has to
be stored that relavent file path's into mysql database,
so can u kindly tel me , how it is possible to get the file path ( absolute
ot realtive ) of that certain
This is what i need:
Posted by gogman on Monday May 5 2003, @10:42am on the mysql website:
MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext
search engines default to an 'AND'. These include: AltaVista, Fast Search,
Google, Hotbot, Lycos,
Hello.
One possible solution is to create a new database, and then RENAME TABLE
each table from the original database into the new database. Then
drop the original database.
Octavian Rasnita [EMAIL PROTECTED] wrote:
Hi,
Please tell me how to rename a database. I couldn't find this
Hello.
So it seems everything is ok. But changes in the original database
rtest on the masterserver aren't replicated to _rtest on the slave.
You have _rtest in the Replicate_do_db column of SHOW SLAVE STATUS, that
tells the slave to restrict replication to statements where the default
So it seems everything is ok. But changes in the original database
rtest on the masterserver aren't replicated to _rtest on the slave.
You have _rtest in the Replicate_do_db column of SHOW SLAVE STATUS, that
tells the slave to restrict replication to statements where the default
database
Hello.
Have anyone an hind for, why this trigger Lock the Table Customer ??
I was unable to reproduce this problem on my ALT Linux system, but
I've noticed one server crash during my tests. Please, could you
send a reproducible test case. Use the output of SHOW CREATE TABLE
to provide
hi all,
how can we have a select satement in an SP?(i want to return a result set from
the SP). i want to migrate from SQL Server to MySQL and i don't know what to do
with these SPs.
it can be done in MySQL client, but it gives the error:procedure foo can't
return a result set in the given
I am trying to adjust sql_mode but with no success. I use MySQL Query
Browser from a remote mashine, login as root and I run set global
sql_mode='ansi';
Then I run MySQLCommand line client from the MySQL server and the sql_mode
is unchanged.
I also tried to set the sql_mode in the My.ini
Hello,
I am running mysql 4.0.15 on a Win2000 operating system. I would like to be
able to back up the system with a perl script. I have a mix of InnoDB and
MyISAM table types. Upon investigating this, I found this web site, with an
article about backing up mysql databases:
Also mysql complaints when I use the *= syntax:
select a.userID from USers a, UserGroups b where
a.UserGroupID*=b.UserGroupID;
Any ideas? What is the equivalent syntax for MySQL.
Thank you
John C
From: John c [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: FW: RE: MSSQL to MySQL
Hi everyone,
I have a freeform string field in one of my tables that is xml encoded.
Basically, i can create xml tags on the fly as and when i want, and just
store the entire xml string in the field.
This eliminates the need to create a new column everytime i have a new
datatype. I can just
Hello.
I've setup a replication between two instances of MySQL 4.0.25,
and replicate-* rules work fine. Check your replication setup one
more time, and if you able to make a reproducible test case you
may want to report a bug. Sometimes it is possible to find a clue
to the problem in the
User % instead of *
-Original Message-
From: John c [mailto:[EMAIL PROTECTED]
Sent: Monday, August 22, 2005 9:48 AM
To: mysql@lists.mysql.com
Subject: FW: RE: MSSQL to MySQL mapping
Also mysql complaints when I use the *= syntax:
select a.userID from USers a, UserGroups b where
George Cherian [EMAIL PROTECTED] wrote on 08/22/2005 04:46:02 AM:
On Mon, Aug 22, 2005 at 01:46:23PM +0530, George Cherian wrote:
I need to run a particular 'select' on multiple machines, and
then reorder them. The query is: 'select * from table where
parent_name = 'parent' order by
This is the old syntax for OUTER JOIN. Not very ANSI...
select a.userID
from USers a
left join UserGroups b on b.UserGroupID=a.UserGroupID;
-Original Message-
From: Rajesh Mehrotra [mailto:[EMAIL PROTECTED]
Sent: Monday, August 22, 2005 7:50 AM
To: John c;
Has anyone run into this issue before? Does anyone have any idea where
to go for more info?
I'm running Red Hat Enterprise v4 and I have installed OpenSSL-0.9.8 and
am trying to install MySQL-4.1.13 but am receiving an error during
configuration. The actual error is as follows:
checking for
John thegimper [EMAIL PROTECTED] wrote on 08/22/2005 04:55:46 AM:
my host dont want to change the ft_min_word_len it´s now at 4 chars
and i need
to do searches with only 2 chars.
Quoting Jasper Bryant-Greene [EMAIL PROTECTED]:
John thegimper wrote:
Thanks so there is no operator
On Mon, Aug 22, 2005 at 09:57:44AM -0400, [EMAIL PROTECTED] wrote:
You are correct in your analysis that you would get better performance if
you ran the queries asynchronously. Just remember that each query thread
will need its *own* connection. Even if you are querying two databases on
On Mon, Aug 22, 2005 at 08:03:08PM +0530, George Cherian wrote:
So I am surprised that no one has done this before. I am very new to
database - (about last week, is when I started getting into the intricacies),
so at present I am confused why there isn't such a solution. I had created a
Hi,
I'm not sure of what you are looking for, and what do you know.
Did you read this ?
http://dev.mysql.com/doc/mysql/en/c.html
It could give you some clues on how to do your queries from your
library. I've never seen any library able to query several servers at
the same time. Usually people
--- RedRed!com IT Department [EMAIL PROTECTED]
wrote:
Has anyone run into this issue before? Does anyone
have any idea where
to go for more info?
I'm running Red Hat Enterprise v4 and I have
installed OpenSSL-0.9.8 and
am trying to install MySQL-4.1.13 but am receiving
an error
Enrique Sanchez Vela wrote:
John,
using 'one.*two|two.*one' would do it. :)
regards,
esv.
That will work, but doesn't generalize very well. Imagine how that will
look with 4 or 5 search terms.
LIKE and REGEXP are meant to match strings, not find words. They are
ill-suited to finding
Hello.
Information from this thread might be helpful:
http://lists.mysql.com/mysql/187580
Shaghayegh Sahebie [EMAIL PROTECTED] wrote:
[-- text/plain, encoding 8bit, charset: iso-8859-1, 18 lines --]
hi all,
how can we have a select satement in an SP?(i want to return a
Hello.
Use 4.1.13. Logging for prepared statements works as of that version.
See:
http://bugs.mysql.com/bug.php?id=8367
050822 17:28:13 122 Connect [EMAIL PROTECTED] on test
122 Prepare [1] select product from lth where
Hello.
It looks like there is something called a InnoDB Hot Backup that is a =
perl script. Is this something that Mysql offers, or is it something one =
needs to purchase.
InnoDB Hot Backup is a good tool. Have a look here:
http://www.innodb.com/order.php
But mysqldump is very
Ok how can i mix boolean and regexp searches?
SELECT * FROM tbl WHERE MATCH (name) AGAINST ('TEST' IN BOOLEAN MODE) OR name
REGEXP 'TEST';
That dont work :(
Quoting [EMAIL PROTECTED]:
John thegimper [EMAIL PROTECTED] wrote on 08/22/2005 04:55:46 AM:
my host dont want to change the
** I am reposting. **
I am looking for some general rule to determine the innodb_buffer_pool_size and
innodb_log_file_size based on number of innodb tables, transactions, etc.
Setting these values based on how much of the server resources I am allotted is
not adequate.
Thanks
ORIGINAL POST
Thank you for your e-mail, but it did not work. In any case it does not make
a lot of sense to go back to a 1000 page application and identify every
single T-SQL syntax and convert it to a MySQL syntax especially without an
MSSQL to MySQL mapping. Isn't there a mode to support T-SQL
On Monday 22 August 2005 09:31, Gleb Paharenko wrote:
Hello.
Use 4.1.13. Logging for prepared statements works as of that version.
See:
http://bugs.mysql.com/bug.php?id=8367
SNIP
Yes, thank you again. I had just upgraded and tested it about the time I got
this message. The loggin is
To answer your questions:
a) does MySQL have a T-SQL parser: no
b) is there a compatibility mode that MySQL can run so that valid ANSI SQL
statements will perform on MySQL the same way as they should perform on MS
SQL Server: yes.
c) How do you set the compatibility mode discussed in b):
On Monday 22 August 2005 15:30, Darrell Cormier wrote:
SNIP
Yes, thank you again. I had just upgraded and tested it about the time I
got this message. The loggin is working fine now.
Now I get this for the log output:
/usr/sbin/mysqld-max, Version: 5.0.11-beta-Max-log. started with:
Tcp
Hi,
Linux 2.4.21-32.0.1.EL #1 Tue May 17 18:01:37 EDT 2005 i686 i686 i386
GNU/Linux
I rebooted the mysql server. After the OS came back, I was not able to
find mysqld, safe_mysqld and mysqladmin any more (their respective man
pages are still there). But the mysql client command and other mysql
Fábio Emilio Costa wrote:
I'm working in a project in C++ using MySQL C API (Win98/Dev-C++
4.9.9.8/MySQL DevPak/MySQL 4.1.13) and I want to know if it's possible
to setup the server environment language (--language) via
mysql_options() function.
It seems that you are actually asking whether
Greetings,
I'm a new user for MYSQL and I face problem adding
mysql database.
After typing:
SHOW DATABASES;
I got this:
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.02 sec)
which does not contain mysql and tmp as shown:
+--+
| Database |
+--+
tai huijia wrote:
I'm a new user for MYSQL and I face problem adding
mysql database.
After typing:
SHOW DATABASES;
I got this:
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.02 sec)
which does not contain mysql and tmp as shown:
+--+
| Database |
Try
mysql -uroot
On 2005年08月23日 12时09分25秒, tai huijia wrote:
Greetings,
I'm a new user for MYSQL and I face problem adding
mysql database.
After typing:
SHOW DATABASES;
I got this:
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.02 sec)
46 matches
Mail list logo