I figured it out. Actualy silly me forgot to add the password() function
how embarising. :)
--
Jerry M. Howell II
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> now allowing clients to login but I'm not sure what would cuse it not to
> allow root to change the password, I dubble and triple checked my entry
> but still nothing happens. Once I login to root I do the following
>
> mysql> use mysql
> mysql> UPDATE user SET Password= ('x')
> -> WHERE
Hi Steven,
Just one UNLOCK TABLES. :-) From
http://www.mysql.com/doc/en/LOCK_TABLES.html
"LOCK TABLES locks tables for the current thread. UNLOCK TABLES releases
any locks held by the current thread. All tables that are locked by the
current thread are implicitly unlocked when the thread issues a
On Fri, Sep 05, 2003 at 01:34:01PM -0400, Fortuno, Adam wrote:
> Jerry,
>
> Don't forget that MySQL authenticates an entity, which is based on the user
> name and host. For example, on my MySQL boxes root can only login from the
> localhost. If I attempt to login with root from another host, I am
On 9/5/03 7:47 AM, "Fortuno, Adam" <[EMAIL PROTECTED]> wrote:
> All:
>
> (1) I've got "/user/local/mysql/data" in my path, but when I attempt to run
> "mysqld_safe" I get a message reading:
>
> "Please do a cd to the mysql installation directory and restart this script
> from there as follows: .
OSX - OSX
Here's some new OSX AppleScript application...
This script that I wrote allows you to launch and shutdown the mysql server
on osx...
If you are using Explorer 5.2 or better, or Netscape 7.1 or thereabouts
http://mac-specialist.com/r/
Chris Nolan wrote:
Hi all!
Is anyone running MySQL on Linux kernel 2.6 or the kernel shipped with
RedHat 9.0? I am curious as to the impact of the new thread
implementation on MySQL's stellar performance (I like picking on the
Oracle, MS SQL Server and Foxpro admins that I have to work with. What
Thank you Mike.
I would like to continue development on this version, so I will try out the
BK. I got the linking errors fixed. Those were from the definitions missing
in the export file.
Is there a release date planned for 4.1.1?
Thanks!
AMit
> -Original Message-
> From: Mark Matthews
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Amit Jindal wrote:
> Hi, I am trying to use mysql 4.1.0 C client (libmysql.lib) and I am
getting
> link errors.
> I checked the libmysql.lib and it doesn't seems to have these symbols.
>
>
> Linking...
> SimpleInsertSelect.obj : error LNK2001: unresol
Sorry for the waste of bandwidth. I need to make sure my autoreply doesn't
send to the list.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Testing my autoreply.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Need some help here:
if I have two tables, alertLog, videoLog needed to lock during some
processing as:
mysql> LOCK TABLE alertLog READ, videoLog READ
after two tables are lock and do some INSERT,
mysql> INSERT INTO alertLog(alert);
mysql> INSERT INTO videoLog(video)
Hi,
I'm trying to compile MySQL 4.0.14 on a server which was previously
using RPMs, and although the ./configure (with no arguments) and make
steps went fine, make test does not want to work. The error I am getting
is :
"/home/programs/mysql/4.0.14/mysql-4.0.14/mysql-test/var/run/master.pid
w
Here is another strange question:
When I use "show databases", it shows me that I only have one database
called "test", and no database called "mysql" show up.
However, I go back to the shell, under the "/usr/local/mysql/data/", it shows
me that I Do have a database called "mysql" including h
If the ceil function won't do it you can truncate it and add 1.
Ty...
-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 2:12 PM
To: Fabio Bernardo; Mysql (E-mail)
Subject: RE: Round Question
what I've done is
select ceil(value)
(not sure
This may be a weird question, but we were wondering if there was some sort
of way to encrypt or protect the database just in case of someone hacking
into the server it resides on. Since there might be some sensitive info in
the database, we'd like to go to as great a lengths as possible (only
usern
Hi,
I tried:
Select ceiling(1.2)
It worked and returned "2".
HTH
Allen
> -Original Message-
> From: Dan Greene [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 05, 2003 12:12 PM
> To: Fabio Bernardo; Mysql (E-mail)
> Subject: RE: Round Question
>
>
>
> what I've done is
Michael Johnson <[EMAIL PROTECTED]> wrote:
> I hope someone can help me on this. I've searched the mailing list
> archives and the manual and can't find anything, except for user comments
> in the manual that confirm what I'm finding.
>
> I'm using derived tables users with restricted privileges
On Friday, Sep 5, 2003, at 15:02 US/Eastern, hongbin liu wrote:
Thank you so much. I changed the profile according to what you guys
told me,
and add "/usr/local/mysql/bin" to the profile. Guess what? It works
great!
But I am not sure if I did the right thing: my computer uses bash, I
could
not
what I've done is
select ceil(value)
(not sure if ceil is the function on MySQL, but there is a ceiling function, I'm
sure...)
> -Original Message-
> From: Fabio Bernardo [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 05, 2003 2:59 PM
> To: Mysql (E-mail)
> Subject: Round Question
Hi, I am trying to use mysql 4.1.0 C client (libmysql.lib) and I am getting
link errors.
I checked the libmysql.lib and it doesn't seems to have these symbols.
Linking...
SimpleInsertSelect.obj : error LNK2001: unresolved external symbol
[EMAIL PROTECTED]
SimpleInsertSelect.obj : error LNK2001: u
Hi!
On Sep 05, Gustavo Castro wrote:
> Hello, i?m running the Mysql 3.23.57 version in Suse 7.1 and i can?t
> add new functions to it. I?ve tried with native functions but just
> in the first step, as it appears in the tutorial,
> when addding my line in the lex.h file, like this
>
> {"GET_UPDAT
At 10:09 PM 9/5/2003, Chris Nolan wrote:
Mike,
What a brilliant idea! Seriously, setting up a community fund to sponsor
this (and perhaps in future other things) might be something to
consider.
The only questions that come to mind are:
1. Which would be more effective, setting up a fund for this
Shawn McGinn <[EMAIL PROTECTED]> wrote:
> I am trying to install a sourceforge application and in one of the
> tables in the db, there is a column whose name is 'default'. When
> installed on MySql version 4.1.0-alpha-standard, this works fine, but I
> really need it to run on version 3.22.27. Is
I write this command:
Select round(1.1)
and obtain 1 as answer
Is there a round command to obtain 2 as answer. I mean, in Excel this
command is knwon as RoundUp!
thanks a lot
Does anyone know how to set up a function to automatically generate reports
from a MySQL database? For example, I have a table that gets populated with
users when they register. I want to be able to have it automaticaly create a
report every 12 hours (or however long) that will generate specific
in
Parker & Mike:
Thank you so much. I changed the profile according to what you guys told me,
and add "/usr/local/mysql/bin" to the profile. Guess what? It works great!
But I am not sure if I did the right thing: my computer uses bash, I could
not find either .bash_profile. There is only one file n
Andreas Schwarz <[EMAIL PROTECTED]> wrote:
>
> is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2)
> fields in 4.1?
>
Nope. Fulltext search doesn't work with multi-byte character sets.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is s
Hello, i´m running the Mysql 3.23.57 version in Suse 7.1 and i can´t
add new functions to it. I´ve tried with native functions but just
in the first step, as it appears in the tutorial,
when addding my line in the lex.h file, like this
{"GET_UPDATE", SYM(FUN_ARG1),0,CREATE_FUNC(create_func_get_u
Hello, i´m running the Mysql 3.23.57 version with Suse 7.1, and i´m
getting problems trying to add UDFs to my MySQL
- In /mysql/sql/tipo.h i´ve declared this data type:
typedef struct st_del {
int empty;
char *table;
List keys;
}BUFFER_DEL;
where List is included from the sql_list.h, a
http://www.serverlogistics.com/mysql.php has a link to a Preference Pane
item that can be used to start and stop MySQL. You will need to modify the
/Library/StartupItems/MySQL/MySQL file to point to the correct location.
--
Jim Dickenson
mailto:[EMAIL PROTECTED]
Computers for Marketing Corporatio
Hello,
is it possible to use Fulltext indexes on unicode (UTF-8 or UCS-2)
fields in 4.1?
Andreas
--
AVR-Tutorial, über 350 Links
Forum für AVRGCC und MSPGCC
-> http://www.mikrocontroller.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
On Friday, Sep 5, 2003, at 13:41 US/Eastern, Thierno Cissé wrote:
Finally you seem to say that you 've setting max_connections with a
limit.
Can you tell how many 100 or 200 ?
No. It turns out that setting max_connections to 0 is the same as
setting no limit at all. This was my initial misundersta
Thanks, that helped me find the solution.
-Original Message-
From: Diana Soares [mailto:[EMAIL PROTECTED]
Sent: Friday, September 05, 2003 12:27 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: How to correct error code 1006
# perror 13
Error code 13: Permission denied
Che
On Friday, September 05, 2003 6:22 PM CET, Cory Lamle wrote:
> Your best bet is to grab 4.3.1 or greater
>
> Windows version even has gui installer...
> http://us2.php.net/get/php-4.3.3-installer.exe/from/a/mirror
actually it's all the same which version you take (from 4.1 on).
but for win32, you'
Hi,
Finally you seem to say that you 've setting max_connections with a
limit.
Can you tell how many 100 or 200 ?
Also you say :
> Here's the configuration:
> MySQL Ver 12.21 Distrib 4.0.14, for pc-linux (i686)
> PHP 4.3.2
> Red Hat 9.0
Have you enable QUERY CACHE feature with MySQL 4.0.14 ?
Re
Jerry,
Don't forget that MySQL authenticates an entity, which is based on the user
name and host. For example, on my MySQL boxes root can only login from the
localhost. If I attempt to login with root from another host, I am denied
access.
Regards,
Adam
-Original Message-
From: Jerry M.
# perror 13
Error code 13: Permission denied
Check the ownership (and permissions) of your .
Maybe your is owned by user "mysql" and not "mysqladmin" and
then "mysqladmin" can't write to .
You may find what your datadir is with:
# mysqladmin var | grep datadir
Hope this helps,
On Fri, 2003
Hi, I am trying to use mysql 4.1.0 C client (libmysql.lib) and I am getting
link errors.
I checked the libmysql.lib and it doesn't seems to have these symbols.
Linking...
SimpleInsertSelect.obj : error LNK2001: unresolved external symbol
[EMAIL PROTECTED]
SimpleInsertSelect.obj : error LNK2001: u
You have to make a script and put it in a folder (sorry I don't
remember the name but it is on /System/startup) Try to locate a shell
script like cron in a cron directory and modify it creating a script
mysql in a mysql directory.
To start:
cd /user/local/mysql/data
./bin/mysqld_safe &
To stop
Hey there all,
Here is the problem I am haveing and was wondering if anyone can help
me here. I was getting the following error when loging into mysql
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
After searching for an answer I found the answer was to r
Hi,
This problem is specific to the WAN connexion, not to the LAN connexion.
I've a Sun Fire 880, 8 Go RAM, Solaris 8 and MySQL 4.0.13 64 bits. The first
connexion to the database is about 15s to 30s (too slow). Is there a known
problem about MySQL connexion (paramaters, bugs ;-) ) or is it a net
Mike,
What a brilliant idea! Seriously, setting up a community fund to sponsor
this (and perhaps in future other things) might be something to
consider.
The only questions that come to mind are:
1. Which would be more effective, setting up a fund for this sort of
thing or just going out and buyi
Matt,
Hey. I use www.powweb.com they have a plan for $7.77 a month, 650MB storage,
blah blah blah give them a look... The important thing is that they have PHP
and I believe command line access, you'll have to use a MySQL client to connect
(seperate MySQL server). I hate to sound like I'm promotin
Hi,
>SELECT TD.project_id, P.project_manager
>FROM time_daily TD
>INNER JOIN projects P ON P.project_id = TD.time_project_id
>WHERE TD.time_user_id = 'xpt' AND (
>SUM( TD.time_hours_worked ) <> '0.00'
an Paul Dibois said:
You cannot use aggregate functions like SUM() in the WHERE clause.
And He i
Hi,
>I am trying to select the column names from a table to be displayed in a
>web page. Is there anyway to select column names without desc?
I don't now, if it makes a difference to 'DESCRIBE' but you can do:
SHOW COLUMNS FROM [LIKE ...];
prosit
Klaus
--
MySQL General Mailing
Hello, i´m running the Mysql 3.23.57 version with Suse 7.1, and i´m
getting problems trying to add UDFs to my MySQL
- In /mysql/sql/tipo.h i´ve declared this data type:
typedef struct st_del {
int empty;
char *table;
List keys;
}BUFFER_DEL;
where List is included from the sql_list.h, a
I installed MySQL 4.0.14-standard from binary onto a Red Hat 8.0 system.
I always follow the steps described in INSTALL-BINARY as well as review
what shows up when I type ./configure.
The only thing I did this time around was that I changed the user's name
from mysql to mysqladmin. I get the fol
Contents are Direct Alliance Corporation CONFIDENTIAL
-
Your best bet is to grab 4.3.1 or greater
Windows version even has gui installer...
http://us2.php.net/get/php-4.3.3-installer.exe/from/a/mirror
This message is for the designated recipient(s) only and contains Direct
Alliance Corporation p
Matt,
Thanks for your response. It's going to take a bit for me to get the
actual SQL available. I don't yet have permission to show that off. In
the mean time, I can tell you that there are 10 table in the query, with
4 being references to the same table. I've been able to make an
improvement
What is the best version of PHP to use with MySQL on Win32 to
interact with the MySQL database in web-enabled forms with submit
button?
Thank you for your help.
Albert
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
try this link http://jeremy.zawodny.com/blog/archives/000796.html
setting avg_row_length at 50 worked for me I tested and got
mytable up to 9GB, (large table with variable size records )
the only reason I could see that it would matter to have an accurate
value for the avg_row_length would
I am trying to install a sourceforge application and in one of the
tables in the db, there is a column whose name is 'default'. When
installed on MySql version 4.1.0-alpha-standard, this works fine, but I
really need it to run on version 3.22.27. Is there a workaround? I
really don't want to edi
I remember that some weeks ago Heikki announced it is on his todo list but
in the far future unless someone is funding the project.
Thomas Spahni
On Thu, 4 Sep 2003, electroteque wrote:
> Hi i was wondering if there was ever going to be a time when Innodb can also
> be fulltext indexable ? Being
All:
(1) I've got "/user/local/mysql/data" in my path, but when I attempt to run
"mysqld_safe" I get a message reading:
"Please do a cd to the mysql installation directory and restart this script
from there as follows: ./bin/mysqld_safe"
Do I really need to be in the installation directory to ki
At 08:56 PM 9/4/2003, you wrote:
Hi all,
At the moment, we all know that InnoDB does not yet have FULLTEXT
indexes. This is not another message asking as to when we will have that
functionality.
This message is different. On the mailing list for DBMail, we've been
discussing MySQL table types, wit
On Friday, Sep 5, 2003, at 10:24 US/Eastern, Parker Morse wrote:
You'll need to edit the .bashrc file in your home directory to add the
/usr/local/mysql/bin directory to the search path if you want to avoid
typing the full path. Another alternative is to place links to the
binaries in one of the
here is part of the create table
CREATE TABLE `assets` (
`assetID` int(11) NOT NULL auto_increment,
`barcode_number` varchar(20) NOT NULL default '',
`asset_code` varchar(20) NOT NULL default '',
`serial_number` varchar(100) NOT NULL default '',
`asset_user` varchar(100) NOT NULL default
Really sorry about this i just worked out if i dont select the foreign key
in an insert statement it will return this error i have to include this
into the query, i have also noticed i usually dont add auto inc fields in
the insert query but my departments table has a foriegn key join and is
return
"Ligaya Turmelle" <[EMAIL PROTECTED]> wrote:
> there is no acknowledgement when a table is created. You don't find out
> about it until you turn off the gui and restart it.
Choose "Refresh all caches" in the "Manage" manu item.
BTW MySQLGUI is no longer under development. Use MySQL Control Cente
Also make sure you installed both the server and the client for MySQL.
And of course if you're not running bash, put the path to the MySQL
directory in the correct shell file. For example, I prefer the tsch shell,
so I would put it in the .tcshrc file in my home directory.
If you're not familiar
Daniel Rossi <[EMAIL PROTECTED]> wrote:
> Hi there i am having another issue with key constraints now, i emptied the tables
> and made the foreign keys fine although now when i try and insert a row into the
> table i get this
>
> ERROR 1216: Cannot add or update a child row: a foreign key constr
On Thursday, Sep 4, 2003, at 12:47 US/Eastern, Parker Morse wrote:
No, it turns out this is not the key. With mysql_connect() I'm
actually failing MORE often than with mysql_pconnect - so far it
hasn't stayed up 15 minutes without error. (Fortunately, I have a cron
job checking on it and restart
On Friday, Sep 5, 2003, at 00:51 US/Eastern, [EMAIL PROTECTED] wrote:
I installed the MySQL 4.0 on my Linxus machine (red hat 7.3). The
installation
shows no problem, and I can see that the 'mysqld' server is actually
runing
through a command like "./bin/mysqladmin version". However, it just
doe
Teemu,
the standard Perl stress test
perl run-all-tests --create-options=type=innodb
in the sql-bench directory does a lot of ADD COLUMN operations. But it does
not produce the warning you have seen. How big are the tables you ALTER?
What does a typical CREATE TABLE look like?
It would be valua
65 matches
Mail list logo
