Hi John,
You saved my day. Haven't laughed like this for long time ;-)
>How do I set no password for root?
> It worked!!. Thanks. Now how do I protect it so that not anyone who
> points to it cannot get to it without putting in a username/password?
Thanks a lot really.
Best regards
Ni
It worked!!. Thanks. Now how do I protect it so that not anyone who
points to it cannot get to it without putting in a username/password?
At 12:24 AM 6/14/2003 -0500, John Nichel wrote:
John Chang wrote:
I changes the password but it still doesn't work. This is the error I
get when I try to c
Try 'mysqladmin flush-privileges'
--cut--
flush-privileges
Reload grant tables (same as reload)
--end cut--
then login (been there... Stuck there too...)
chris
-Original Message-
From: John Chang [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 14, 2003 12:17 AM
To: [
John Chang wrote:
I changes the password but it still doesn't work. This is the error I
get when I try to connect to MySQL using phpmyadmin using a browser.
What do I need to change? Thanks.
Error
MySQL said:
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
At 11:37 PM 6/1
I changes the password but it still doesn't work. This is the error I get
when I try to connect to MySQL using phpmyadmin using a browser. What do
I need to change? Thanks.
Error
MySQL said:
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
At 11:37 PM 6/13/2003 -0500, Paul
Paul is right (I should have metnioned it as well ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 14日 土曜日 13:40、Paul DuBois さんは書きました:
> At 21:19 -0700 6/13/03, Suba Arunkumar wrote:
> >I want to put some of my users database under their
> >home directory, is it possible to do that. If so ca
At 21:19 -0700 6/13/03, Suba Arunkumar wrote:
I want to put some of my users database under their
home directory, is it possible to do that. If so can
any one point me to the right source.
Don't do it.
There is no advantage to doing this. The database directories
must be owned by the server in or
At 0:10 -0400 6/14/03, John Chang wrote:
How do I set no password for root?
mysql -u root -p
Enter password: (your current root password here)
mysql> SET PASSWORD = '';
mysql> quit
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http
Hello Suba,
I assume that yo are using any linux OS and MyISAM tables.
I think you have several options. The two most common are:
1) you use the "datadir" option
2) you create symbolic links (ls command) to the users home directory and copy
the data (shutdown mysql server before ;-)
I havent
I want to put some of my users database under their
home directory, is it possible to do that. If so can
any one point me to the right source.
Regards
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing Lis
How do I set no password for root?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Friday 13 June 2003 09:29 pm, Mark Stringham wrote:
> I'm querying a table of approximately 42 records based on 3 criteria. The
> results are then displayed in a pop-up window. When the query is executed
> the first time - the window opens and stalls for about 3 seconds before
> the results ar
I have read that Arrays are not coming before 5.0.
have a look in the Documentation and the UC presentations.
Best regards
NIls Valentin
Tokyo/Japan
2003年 6月 10日 火曜日 22:25、Hans Nerdell さんは書きました:
> table creation - arrays ?
>
> how are rows as ARRAYS specified and created on a table ?
>
> wbrgd
SHOW CREATE TABLE tblname;
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 14日 土曜日 05:22、Michael Conlen さんは書きました:
> I'm working on a system that will allow me to perform operations on a
> table using a web form, and I would like to know if a table has a
> foreign key, however I don't seem to s
I'm querying a table of approximately 42 records based on 3 criteria. The results are
then displayed in a pop-up window. When the query is executed the first time - the
window opens and stalls for about 3 seconds before the results are displayed.
An example query would be : select * from $tabl
Hi,
Does anyone know of a good tutorial on setting up a login page, and passing
the login primary key to other pages so that other tables will be able to
refernce the unique login
thanks
steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
Hi guys,
I had updated a field for all the entries in a table
by mistake, I need to undo that step. I dont have the
database back up to an stisfactory level. Is there a
way in MySQL I can step one action back? or undo one
command that I just did??
Thanks a lot guys!?
On Fri, 13 Jun 2003, Grimes, Dean wrote:
> I'm having some trouble with linking mysql-4.0.13 into php-4.3.2. I am
> getting following error:
>
> //usr/lib/libresolv.so.1: fatal error: symbol `_res` multiply defined in two
> shared objects /usr/lib/libsocket.so: size = 448; //usr/lib/libresolv.so.1:
I'm having some trouble with linking mysql-4.0.13 into php-4.3.2. I am
getting following error:
//usr/lib/libresolv.so.1: fatal error: symbol `_res` multiply defined in two
shared objects /usr/lib/libsocket.so: size = 448; //usr/lib/libresolv.so.1:
size = 512
collect2: ld returned 1 exit status
ma
Peter Burden wrote:
Subscriptions wrote:
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything that makes since
to me.
Can someone point me in a direction as to where I can find this out?
The problem I'm having is I have PHP 4.3
Peter,
When you get everything working please let me know how you did it. I have been trying for days without any luck.
Regards,
Jay
---Original Message---
From: Peter Burden
Date: vrijdag 13 juni 2003 22:46:20
To: Subscriptions
Cc: [EMAIL PROTECTED]
Subject: Re: PHP, M
Subscriptions wrote:
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything that makes since to me.
Can someone point me in a direction as to where I can find this out?
The problem I'm having is I have PHP 4.3.2, MySQL 4.0.13 and A
I'm working on a system that will allow me to perform operations on a
table using a web form, and I would like to know if a table has a
foreign key, however I don't seem to see this information listed in any
of the show commands output (or describe). Any idea how I could identify
what colums ar
Arrays are not currently supported in any production-release versions of MySQL.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Hans Nerdell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 10 June, 2003 09:25
Subject: table creation - array
table creation - arrays ?
how are rows as ARRAYS specified and created on a table ?
wbrgds
hans
_
Die aktuellsten Computer News gibts auf MSN! http://www.msn.at/computer
--
MySQL General Mailing List
For list archives: http://lists.m
What table type is this? If it's MyISAM select count(*) should be instantaneous. If
it's InnoDb and you've got a large dataset (say 1 million+) then select count(*) will
be slow b/c it doesn't store the # of records in the table, thus it has to count
records. MyISAM does store the count so it
If PHP was built without MySQL support, you need to recompile it. It should be
in there, though, so check the php.ini file.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Subscriptions" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, 13 June
MySQL can use indexes to sort, but not when your WHERE clause contains a
column other than the one being sorted on.
I think the MySQL manual has a good section on what 'filesort' means and
when MySQL uses it. Basically it's selecting all the rows that meet your
WHERE clause, then running a quicks
Losing your mind, perhaps?
http://www.mysql.com/downloads/download.php?file=Downloads%2FMySQL-4.1%2Fmysql-4
.1.0-alpha.zip&mirror=http%3A%2F%2Fmysql.secsup.org%2F
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
MySQL should have no problems running on your system, and if it runs better on
another box, that would indicate a configuration problem or background processes
clogging up the works. If you post your my.cnf file, someone here might be able
to rule out the former.
Edward Dudlik
Becoming Digital
ww
Sorts don't use indexes, for the most part, only the search part does.
Someone correct me if I'm wrong on that, I think I recall reading it in
SQL for Smarties. The index is on the entire database, not on the
subset that you have selected. If you know that your query is going to
return most of
I think something is definitely wrong with your setup or your query. A
query for a count of the number of rows should be almost instantaneous.
How are your querying? You should be using:
select count(*) from tablename
Any other query that you filter on should have a index on the search
field. A
I'm having a problem with some very slow queries that spend a very long
time in the 'Sorting result' state and I'm wondering how sorts are
implemented in mysql and what I can do to optimize these types of queries.
The query looks something like this:
SELECT col1,col2,col3 from table1 where col1
Wong Zach-CHZ013 wrote:
>
> Hi
> 1- Is there a command to rename an existing database ?
> 2- If not, how does one create a new database from an existing database ?
> could you show me the steps?
>
> Any help is appreciated.
> Thanks
Have you tried the mysqlhotcopy util?
http://www.mysql.com/doc
I've just started using mySql. I'm an experience programmer with SQL based
database, but know nothing about mySql. I'm setting up a single user
database to be accessed with some Perl programs, with one main table, which
will contain about 3 million lines. I'm running on an Athlon 1250 with
384m
Hi
1- Is there a command to rename an existing database ?
2- If not, how does one create a new database from an existing database ?
could you show me the steps?
Any help is appreciated.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
Since we are on the subject
Why is mysql-max(16meg) < mysql(25meg) (for x86 v4.1)?
No docs or something?
-Original Message-
From: V. M. Brasseur [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 1:00 PM
To: Jon Miller
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL-Max
Jon Miller w
Jon Miller wrote:
>
> I've been asked to setup a MySQL DB for critical mass usage. The programmer is
> asking that I use MySQL-Max. Does this have to be installed along with the regular
> MySQL version or is it a single product on it's own?
>From the MySQL/downloads page for 4.0:
The Stand
I've been asked to setup a MySQL DB for critical mass usage. The programmer is asking
that I use MySQL-Max. Does this have to be installed along with the regular MySQL
version or is it a single product on it's own?
Thanks
Jon L. Miller, MCNE, CNS
Director/Sr Systems Consultant
MMT Networks Pt
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything that makes since to me.
Can someone point me in a direction as to where I can find this out?
The problem I'm having is I have PHP 4.3.2, MySQL 4.0.13 and Apache 2.0.46.
I have
I think I need to clarify :
The fulltext indexing & searching here works great.
The search completes in good time, but then I want it in a different
order, as described by index1 down below. This resorting step is the one
that takes forever, not the fulltext search.
So essentially, a FORCE INDEX(
Curtis Maurand wrote:
What's the client running on?
Not the same machine as the server. Could either be a windows or
linux box across ethernet.
--Chris
Curtis Maurand wrote:
I'd write a perl script to pool the device and send the data to the
database.
Sorry for not being clearer. I can get t
At 14:20 -0300 6/13/03, Ronan Lucio wrote:
Mike,
I forgot to say I'm using mysql-3.23.52
The SHOW DATABASES privilege is not relevant until MySQL 4.0.2.
Perhaps, this GRANT option do not work for this version, look:
-
mysql> grant show databases to dfn@"%";
ERROR 1064
Mike,
I forgot to say I'm using mysql-3.23.52
Perhaps, this GRANT option do not work for this version, look:
-
mysql> grant show databases to dfn@"%";
ERROR 1064: You have an error in your SQL syntax near 'show databases to dfn@"%"' at
line 1
mysql> grant show datab
Hi!
On Jun 13, H M Kunzmann wrote:
> The answer is that a fulltext index can only be built on
> a TEXT field. Even though the mysql documentation describes
> MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
> they can not be used.
No, this is wrong.
Any xxxTEXT field can be
Mike,
On Fri, 13 Jun 2003 08:59:09 -0600
"Mike Hillyer" <[EMAIL PROTECTED]> wrote:
> GRANT SHOW DATABASES will allow a user to see all databases, whether the
> user can access them or not.
How should I securely grant SHOW DATABASES to an user?
GRANT SHOW DATABASES ON mysql.db to [EMAIL PROTECTE
At 17:44 +0200 6/13/03, Dingfelder Andy wrote:
Hi all,
is it ok, that the mysqld_safe process runs under the root account!
It should be okay.
Shouldn´t that be the mysql account, too?
10317 root 9 0 1060 1060 876 S 0.0 0.0 0:00 mysqld_safe
10359 mysql 9 0 1436 1436 104
Any reason why a SELECT which finds no matches returns instantly
but an update which has the same where clause takes about 2 secs to return.
explain reports that the select is exaninng 10 rows in a 300,000 row table.
which is exactly what i am expecting.
are there any know issues?
-Todd
--
M
As this is really a PHP specific question, you may get a better response on the PHP
general mailing list at http://www.php.net/mailing-lists.php
Anyway, if my limited experience in PHP serves correctly, you may need to call
echo(mysql_error()); near the potentially troublesome code.
Regards,
What's the client running on?
Curtis
On Thu, 12 Jun 2003, Chris Webster wrote:
> Curtis Maurand wrote:
> > I'd write a perl script to pool the device and send the data to the
> > database.
>
> Sorry for not being clearer. I can get the data into the database
> fine. Assuming new values or
Hi!
I am new here and wonder if anyone could help me with a problem in my community.
The adress is http://trashankarna.net/community/default.php
I can't figure this out. I get this message when I choose to read a message in my
outbox/utkorg:
Warning: 1 is not a valid MySQL-Link resource in
Have you tried adding force index on your fulltext index?
Something similar to this:
select field1,field2,field3 from table FORCE INDEX(index2)
where field1='something'
and field2='something_else'
and field3='something_more'
and match(field4) against ('word1 word2' in boolean mode)
orde
The answer is that a fulltext index can only be built on
a TEXT field. Even though the mysql documentation describes
MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
they can not be used.
On Thu, 2003-06-05 at 09:59, H M Kunzmann wrote:
> Hello All.
>
> I am using Redhat
The answer is that a fulltext index can only be built on
a TEXT field. Even though the mysql documentation describes
MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
they can not be used.
On Fri, 2003-06-06 at 09:36, H M Kunzmann wrote:
> Hi all.
>
> I am running RH9.0 wit
Hi all.
I have a fulltext index on a table.
If I have the following fields:
field1,field2,field3,field4
Field4 being the fulltext field.
I have the following indices:
index1->field1,field2,field3
index2->fulltext field4
If I do a select:
select * from table where match(index2)
aga
What's the latest version of MySQL for windows? Mysql.com says it's 4.1
alpha but the download that reads 4.1 alpha is actually 4.0.12. Is there no
version 4.1 available for Windows?
Many thanks,
rajendra
Unless expressly stated to the contrary, the views expressed in this email
are not necessar
Hi all,
is it ok, that the mysqld_safe process runs under the root account!
Shouldn´t that be the mysql account, too?
10317 root 9 0 1060 1060 876 S 0.0 0.0 0:00 mysqld_safe
10359 mysql 9 0 1436 1436 1044 S 0.0 0.0 0:00 mysqld
10361 mysql 8 0 1436 1436 1
Something else to consider here:
MySQL can use indexes to optimize order by as well, but your order by value can't be
indexed since
it is derived from a database lookup/calculation. If you really need to order by
"diferenca"
you may have to live with it, although you may still see "Using fileso
Hi,
You need to index the column that is used in the where clause
try this
ALTER TABLE tempo_resposta ADD INDEX idmaquina (idmaquina);
HTH
Dobromir Velev
- Original Message -
From: "Leonardo Rodrigues Magalhães" <[EMAIL PROTECTED]>
To: "MySQL ML" <[EMAIL PROTECTED]>
Sent: Friday, June 13
GRANT SHOW DATABASES will allow a user to see all databases, whether the
user can access them or not.
-Original Message-
From: Ronan Lucio [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 8:56 AM
To: Mike Hillyer
Cc: [EMAIL PROTECTED]
Subject: Re: Access denied
Mike,
On Fri, 13 Ju
Mike,
On Fri, 13 Jun 2003 08:38:32 -0600
"Mike Hillyer" <[EMAIL PROTECTED]> wrote:
> Did you GRANT SHOW DATABASES to the user? If not then they will not be
> able to use the command. The SHOW DATABASES GRANT clause is a new
> addition.
I'm sorry but I don't have experience with MySQL.
Actually,
Try using [EMAIL PROTECTED] (assuming you're connecting
from localhost) to grant permission. I had similar problems
and doing that fixed it for me.
Steven:)
Ronan Lucio wrote:
Hi All,
I created a user "dfn" and I granted access to only the
database "dfn".
Now, if I log as dfn user query for "SH
Did you GRANT SHOW DATABASES to the user? If not then they will not be
able to use the command. The SHOW DATABASES GRANT clause is a new
addition.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Ronan Lucio [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 8:34 AM
To:
Hi All,
I created a user "dfn" and I granted access to only the
database "dfn".
Now, if I log as dfn user query for "SHOW DATABASES", mysql
returns me the error:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
Would anybody know what could be wrong?
Thank's
Ronan
Hello Guys,
I have the following table:
CREATE TABLE tempo_resposta (
id int(11) NOT NULL auto_increment,
idmaquina int(11) NOT NULL default '0',
tempo int(11) NOT NULL default '0',
horario datetime NOT NULL default '-00-00 00:00:00',
PRIMARY KEY (id)
) TYPE=MyISAM;
I
Hello.
How can I recover query errors done on a mysql server?
Is there a log file?
It's very important to me to know about this.
Thanx so much!!!
Lorenzo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I receive the following error when trying to compile MySQL 3.23.56 on
Solaris 9:
config.status: creating readline/Makefile
config.status: error: cannot find input file: readline/Makefile.in
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
"Chris Boget" <[EMAIL PROTECTED]> wrote:
>> > What's going on with the MAX() function? Why did it return NULL
>> > in the first query above. There were no adding/deleting data between
>> > the above queries and yet MySQL didn't pull the MAX from the table
>> > until I added the "AND assets IS NOT
Patrick Shoaf <[EMAIL PROTECTED]> wrote:
> I have a question, when loading dates into mysql I have found I can always
> use MMDD or -MM-DD, but frequently I need to load data from ASCII
> csv files where the date is M/D/. Currently, I am using perl to read
> the datafile and insert
I have a question, when loading dates into mysql I have found I can always
use MMDD or -MM-DD, but frequently I need to load data from ASCII
csv files where the date is M/D/. Currently, I am using perl to read
the datafile and insert each record after converting the date data. I
w
>In the case of both the master and the slave the max_allowed_packet is set
to 1047552. In both cases I raised it to 2047552 just to be generous.
In order for changes to the max_allowed_packet to take effect, you'll need
to restart mysqld on that server.
Cheers,
Andrew
-Original Message
Hi Bruce,
I dont know the solution, but error 1236 is a server issue as described below.
Starting and stopping the slave wont help anything. Are you sure that the
servers binary log is not corrupted ?
Try to reset the master.
4.10.7.5 RESET MASTER (master)
Deletes all binary logs listed in
That got me greping through my Master's log and I came accross the
following :
Error reading packet from server: log event entry exceeded
max_allowed_packet - increase max_allowed_packet on master
(server_errno=65535)
This seems to have happened in the date ranges where replication was
failin
I thought I had most things figured out for our challenging replication
setup. However this morning we have a failure I can't figure out... Here are
the errors:
030613 5:13:50 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306',
replication started in log 'binary-log.035' at position
Hi Mehmet,
Sorry I send you the worng link. Try this one please
http://www.mysql.com/doc/en/GIS_spatial_extensions_in_MySQL.html
Best regards
2003年 6月 13日 金曜日 17:24、Mehmet KADAYIFÇI さんは書きました:
> Hi,
>
> I develop applications that about GIS. I am using Oracle Database for our
> projects. We sto
"John Telford" <[EMAIL PROTECTED]> wrote:
>
> I have had a problem with my install of MySQL on Rehat7.0 and I wonder if anyone has
> any advice. Here is what I have done.
> 1. When I installed RedHat, I installed the MySQL libraries from the RedHat CD. I
> think it was version 3.23
> 2. I insta
"Axel Tietje" <[EMAIL PROTECTED]> wrote:
> Hi everyone...
>
> I actually have two servers:
>
> 1. Server: MySQL 4.0.12
> 2. Server: MySQL 3.23.38
>
> This query:
>
> SELECT o_obj,
> MAX(CASE WHEN o_key = '69B96431' THEN o_val END) AS _69B96431,
> MAX(CASE WHEN o_key = '69B96431' TH
Fabio Bernardo <[EMAIL PROTECTED]> wrote:
>
> Hi there... I have this situation:
>
> table_A table_B
> id name id name
> 1 A 1 A
> 2 B 2 B
> 3 C
>
> If i run this statement :
> SELECT table_A.* FROM table_A outer join table_B ON table_A.id=table_B.id
>
Mehmet KADAYIF?I <[EMAIL PROTECTED]> wrote:
>
> I develop applications that about GIS. I am using Oracle Database for our projects.
> We store our geographical data on Oracle 9i with Oracle Spatial Support. But i don't
> like Oracle, i want to change my company's database policy. Because Oracle
Hi Mehmet,
I am not sure excactly what you are looking for as spatial data is quite new
for MySQL I believe.
How about this info ?
http://localhost/xoops/manuals/mysql/en/GIS_spatial_extensions_in_MySQL.html
2003年 6月 13日 金曜日 17:24、Mehmet KADAYIFÇI さんは書きました:
> Hi,
>
> I develop applications tha
Hi,
I develop applications that about GIS. I am using Oracle Database for our projects. We
store our geographical data on Oracle 9i with Oracle Spatial Support. But i don't like
Oracle, i want to change my company's database policy. Because Oracle is too
complex(in bad mean), expensive, its UI
Are you sure the mysql service is running? You can either check in the
control panel, but an easier is way is to launch
WinMySQLadmin, which should come with your distribution. Check in the
bin directory for the following file winmysqladmin.exe. Launching this
program will start the service aut
Hello,
I develop with C++Builder 5 and 6. I replaced BDE by MODBC component.
It was working fine with MySQL 2.5.0.
It seems it is no more compatible with version 3. I get the following
error :
42000[ODBC 3.51 Driver][You have an error in your SQL syntax near]
followed by the beginning of the SE
Hi people.
Installing MySQL 3.23.54 under Windows 2000
(according to instructions in Next handbook 'Introduction to MySQL.', and
from CD attached to book)
Installing MySQL
- worked fine.
Starting the Server
c:\mysql\bin\mysqld-nt
- worked fine.
Running the MySQL command line interface
c:\mysql\
84 matches
Mail list logo
