Warning: Access denied for user: 'root@localhost' (Using password: NO)
in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255
Warning: MySQL Connection Failed: Access denied for user:
'root@localhost' (Using password: NO) in
/var/www/html/phpMyAdmin/lib.inc.php3 on line 255
Error
MySQL said:
Thank you all for your help. I think that is all I need to do is select
it by row.
-Original Message-
From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 2:02 PM
To: Christopher Lyon; MySQL Mailinglist
Subject: Re: sql query using select and row
Description:
When I tried to start MySQL server with
shell/usr/bin/safe_mysqld
it gave me the error:
-
Starting mysqld daemon with databases from /var/lib/mysql
030128 08:56:42 mysqld ended
Hello,
I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on Sun
Solaris 2.8 and I have got the binaries form the mysql web site.
The machine I am using has 32GB of RAM + 64GB of swap.
At the certain point I got :
Hello,
I see in the mysqladmin man page for version 3.23.55-1 that 'slave-start' and
'slave-stop' have at least been thought of at some stage (they're listed in the
COMMAND SYNOPSIS section), but they don't seem to work when I try them... I've just
been through the change logs for version 4,
hi all..
having a little problem with mysql_query()... for some reason when i type
mysql_query(insert into table_name ('$var list'...); i come up with a bunch
of
blank/empty variables... im using apache 1.3.4x mysql 3.2.3.x wwinME ..
any ideas how to fix the problem...?
---
Outgoing mail is
i have a select that seem to be taking too long for what it is, and after
looking over the documents i can't seem to find a better way.
probably some things that would help:
-on a datetime field, is there a way to look at everything from a month that
still uses the index.
-is there a way to
I've since given up, installed with the exact configure line shown
in the MySQL docs, FreeBSD section, and it worked perfectly, so I'm
worrying about moving my grant tables from 3.23.49 and so forth,
instead of getting Linuxthreads to workBut I'd be happy to try
to get this fixed,
Has anyone any experience of running MySQL on Netware 6? I am thinking
of porting our helpdesk to Netware AMP (Apache/MySQL/PHP) to better
integrate it with eDirectory.
Cheers,
Martin S.
--
Martin Skjoldebrand
http://www.skjoldebrand.org
I am using mysql 3.23.59. By using the command mysql -h Remote
--database=db -uuser -ppassword --execute load data local infile
.. I get error nr. 1148: The used command is not allowed with this
MySQL Version. Before I used mysql 3.23.37 and the above command was
OK. I tested the --execute
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 29 January 2003 5:11 PM
To: Inmate 67859432
Subject: Re: just a question.
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter
On Tue, Jan 28, 2003 at 04:28:53PM -0500, Jesse Sheidlower wrote:
Out of curiosity, which version of gcc are you using?
As I posted a few lines up, it's gcc 2.95.4 ;-)
Oh, err. Hm. Right. I can read. Yeah.
After I sent the original message, I tried to play around with the
configure
On Tue, Jan 28, 2003 at 01:20:16PM -0500, Grigor, Peter wrote:
Heya Folkth:
I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with linuxthreads
(2.2.3) and still encounter the 'strange threading' behavior described in J.
Zawodny's blog.
Here's the situation...
1/ there are three
In the last episode (Jan 28), Jonathan Disher said:
On Tue, 28 Jan 2003, Jesse Sheidlower wrote:
I've been trying to install MySQL 4.0.9 on FreeBSD 4.7, and have
been getting stuck in the configure phase. I'd be grateful for any
suggestions.
I'm running FreeBSD 4.7 on a single-processor
On 1/28/03 3:42 PM, Jon Miller [EMAIL PROTECTED] wrote:
Warning: Access denied for user: 'root@localhost' (Using password: NO)
in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255
Warning: MySQL Connection Failed: Access denied for user:
'root@localhost' (Using password: NO) in
-Original Message-
From: Salada, Duncan [mailto:[EMAIL PROTECTED]]
Sent: 28. januar 2003 20:40
To: '[EMAIL PROTECTED]'
Subject: problems creating fulltext index
Hello everyone,
I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on
i686. I'm
trying to create a
-Original Message-
From: Harald Fuchs [mailto:[EMAIL PROTECTED]]
Sent: 28. januar 2003 10:46
To: [EMAIL PROTECTED]
Subject: Re: Mysqlhotcopy and reuilding indexes
In article [EMAIL PROTECTED],
Erlend Hopsø Strømsvik [EMAIL PROTECTED] writes:
Hi
Sorry if I'm just being
A understand that a problem with temporary tables is that you can't
do a self-join in MySQL 3.xx using temporary tables. I have a situation
that requires exactly this (the alternative is not algorithm-effective).
I wonder if the following is a practical solution: to create a copy of the
Hi Stefan,
Thanks to Dobromir, this works with mysql 3.23 too:
select user_profile.user_id
from user_profile
left join team_member
on
(team_member.user_id=user_profile.user_id and team_member.team_id=2)
where team_member.user_id is NULL;
Regards Heiko
- Original Message -
Subject:
have look at http://www.mysql.com/doc/en/mysql_install_db.html
[EMAIL PROTECTED] wrote:
Description:
When I tried to start MySQL server with
shell/usr/bin/safe_mysqld
it gave me the error:
-
Starting
- Original Message -
From: Mariella Di Giacomo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, January 29, 2003 1:12 AM
Subject: mysqld got signal 11; This could be because you hit a bug
Hello,
I am running mysql server
Hello again!
Thanks for all who replied. Im currently setting up Mysql 4.1 to test with
my codes. Unfortunately, Binaries for 4.1 version are not yet available. I
Followed the steps in building from development source and encountered some
problems.
In the process of cloning 4.1 branch, while
Hi,
I think you misunderstood /proc/sys/fs/file-max meaning, it IS
an averall machine limit, not per process.
From linux kernel documentation
(/usr/src/linux/Documentation/sysctl/fs.txt):
file-max file-nr:
The kernel allocates file handles dynamically, but as yet it
doesn't free them again.
Hi,
we use this table mobile_pos
+-+-+-+
| team_id | time| geometry|
+-+-+-+
| 3 | 2003-01-28 16:17:06 | 727105 5282634 651 |
| 5 | 2003-01-28 16:19:22 |
Dear Sir/Madam,
Here I've attached one Table of MySQL, named as M_Filed. When I am
trying to select all tables from VB, it gives me following error
Run-time error '-2147467259 (80004005)':
[TCX][MyODBC]Got error 127 from table handler
Waiting for your reply.
Regards,
Shripal.
vim m wrote:
Hi: I am new to Mysql. I have installed mysql3.23.55
on linux RH7.1. Now mysql is running successfully on
my system.
When I try connecting thru
java(mysql-connector-java-3.0.1) I am getting an
Access Denied error. It says mysql@machinename access
denied.
Now i tried from command
:when i type
:mysql_query(insert into table_name ('$var list'...); i come
:up with a bunch
:of
:blank/empty variables...
Try to debug your query by outputting to the stdout instead of sending to
the
mysql server. You can do it by simply echo()ing your query as it is to the
Hi All,
I recently downloaded and installed MySQL-3.23.55 for Windows XP.
Previously I was running MySQL-3.23.53-max-nt, but now the Service entry
that appears under the Services List under Administrative Tools runs
3.23.55-nt when started, when I would prefer it to run 3.23.55-max or
Dirk,
you're right. LOCAL is disabled by default with all newer versions of
MySQL (server and client). One can enable LOCAL by _compiling_ MySQL
with --enable-local-infile, but this is not possible for binaries, of
course.
The manual says you can enable LOCAL with --local-infile=1, either for
I have a hit logger tool, which does approximately 200,000 INSERTs a day
into tables.
The other application uses the same tables to run somewhat complex SELECT
queries.
Since these tables will be large, SELECT queries are quite slow.
Indexing the tables produced prefect results for these SELECT
FLUSH PRIVILEGES
On 29 Jan 2003 07:05:29 +0800, Jon Miller wrote:
When granting someone permissions are these permissions dynamic or do I
have to reload mysql?
Also we have a developer who stated he cannot access the database
remotely. I've granted him privileges as follows since he works on
You need to include the (correct) Root password in mysql_connect(h,u,p)
On 29 Jan 2003 07:42:37 +0800, Jon Miller wrote:
Warning: Access denied for user: 'root@localhost' (Using password: NO)
in /var/www/html/phpMyAdmin/lib.inc.php3 on line 255
Warning: MySQL Connection Failed: Access denied
mysql Ver 11.18 Distrib 3.23.54, for pc-linux (i686)
INDEXING PROBLEM
I'm building an application which will have a self install script,
intended for use by many people. One particular area of the program
requires the need for an index. If I create this index when I build the
table or
Hi All,
I have MySql on Windows.
Today i had an electrical power interruption in the middle of working.
The database remain not consistent and i could not continue working with it.
Is there any Recovery after crash mechanism in mySql?
Thanks, Inbal
Description:
With mysqlhotcopy version 1.15 (from MySQL-3.23.49-1) I used
to do like this:
mysqlhotcopy --user=root --password=foo -q --allowold
--record_log_pos backup.log_pos db1 db2 backup $TMPDIR
After upgrading to MySQL-3.23.55-1 and thus mysqlhotcopy
Jon:
Reload the permissions tables.
It looks like your permissions for Joseph are on the money ... are other
people able to access the database remotely?
Gerald Jensen
- Original Message -
From: Jon Miller [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Tuesday, January 28,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark --
...and then Mark Stringham said...
%
% Does anyone have a suggestion as to how I could run a periodic mysql dump
% for a db that is hosted remotely - IE a web host. I do know that this host
% does not support crons.
Do you want it dumped on
I was reading about user defined functions, and although they sound
interesting, I can't find many examples of their use. If anyone is using
them, what are you using them for? Are they a way to manipulate data
going into a record, or a way to run pre-defined queries?
-bill
On Tue, 28 Jan 2003 17:12:14 -0700
Mariella Di Giacomo [EMAIL PROTECTED] wrote:
Hello,
I am running mysql server (mysql-standard-4.0.5-beta-64bit) 64 bit on
Sun Solaris 2.8 and I have got the binaries form the mysql web site.
The machine I am using has 32GB of RAM + 64GB of swap.
Thanks
I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with
linuxthreads
(2.2.3) and still encounter the 'strange threading'
behavior described in J.
Zawodny's blog.
Here's the situation...
1/ there are three threads which lock and then write to two
different
tables...
At
Hi!
-Original Message-
From: Erlend Hopsø Strømsvik [mailto:[EMAIL PROTECTED]]
-Original Message-
From: Salada, Duncan [mailto:[EMAIL PROTECTED]]
Hello everyone,
I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on
i686. I'm
trying to create a
dell 4100 256mb, 11gb hd, Redhat grub-linux
linux novice cannot resolve apache-php-mysql linkage.
local closed system (No modem, no www access, no internet)
I have tried to create a database of 7 tables with about 840mb
of data since the 20th of November 2002. My own db handler (.cpp's)
will
Could you help me with this. I`m trying to increment values of primary auto_increment
field from table, and ofcourse it is not working. Could you tell me how to construct a
query correctly.
+---+--+--+-+-++
| Field | Type | Null | Key
Hi!
I've got one question which belongs to the new query cache in 4.01.
I wonder why the cache should be deleted if there's a statement like update,
insert etc.
I think it must be considered that there are possible situations where this
isn't the best way.
For example:
1) select * from
Dear my friends,
My boss wants a database application running on linux
machine without XWindows.
Is it easy to make the connection to MySQL with GNU
C++ .
Is perl better then GNU C++ in this case?
How is Jave ?
TAC.
__
Do you Yahoo!?
Yahoo!
hi all,
which is the command to rebuilt innodb tables
indexes?
(if exists).
many thanks.
(mysql,sql)
__
Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino
is there a way to use the date part of a datetime field that still uses the
index on the datetime field? i've tried a few different things and it keeps
saying in the explain it says that its a possible_key, but NULL for the key
--
mysql, sql, query, sql, sql, sql
* Wong Zach-CHZ013
[...]
In table a, the columns are
my_date - longtext
num - int(11)
[...]
Q:
How do I convert 08/06/2002 to 2002-08-06 format
LONGTEXT is not a good column type for dates, you should use the special
'date' type, see URL: http://www.mysql.com/doc/en/Column_types.html .
To
* heiko mundle
we use this table mobile_pos
+-+-+-+
| team_id | time| geometry|
+-+-+-+
| 3 | 2003-01-28 16:17:06 | 727105 5282634 651 |
| 5 | 2003-01-28
Hi,
We just cvsup'd a FreeBSD machine from 4.6.2 to 4.7, made world,
and installed a new kernel. Now mysql is complaining :
Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthre
ad/uthread_create.c (errno = ?)
030129 10:36:35 mysqld restarted
Fatal error
Hi Mark,
Thanks.
The memory that we are using is ECC.
The reason I have only 16 connections is because that DB is used only
for updates.
In reality for that DB we use 3 or 4 connections maximum.
We have a mirror copy used for customers which has a lot of
connections.
Mariella
At 10:22 AM
Description:
After fixing a table with myisamcheck on Linux, the auto_increment on
Solaris was completely off (very large 9-digit integer instead of
around 50,000). My suspicion is that this has to do with an endianness
issue.
(I had to use Linux since the Solaris version of myisamcheck just
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.5 a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
It is now available in source and binary form from the Connector/J
download pages at http://www.mysql.com/downloads/api-jdbc-dev.html and
is they a way to have mysqldump ignore a list of tables, but get everything
else?
something like:
mysqldump -ume -psecret -hserver --all-databases
--exclude-tables=server.acctlog
mysql 3.23.49-8.2 debian
--
mysql, sql, query, sql, sql, sql
Try this, this is what I used (I didn't need things like innodb, but
needed static linkings):
king as jdisher# more foo
CFLAGS=-O3 -pipe -mcpu=pentiumpro -D__USE_UNIX98 -D_REENTRANT
-D_THREAD_SAFE -DHAVE_BROKEN_REALPATH -I/usr/local/include/pthread/li
nuxthreads CXXFLAGS=-O3 -pipe
have you looked at the mysql command
flush privileges
- hcir
On Tuesday, January 28, 2003, at 02:05 PM, Jon Miller wrote:
When granting someone permissions are these permissions dynamic or do I
have to reload mysql?
Also we have a developer who stated he cannot access the database
remotely.
You need to run [analyze table] to create the index stats...do this
reasonable often (once a day for a well-used table).
Running [optimize table] on the table recreates index stats AND
reorganizes/defrags/coalesces data pages...do this once a week or so.
Look up the mysqlcheck utility--it lets
--
Joe Stump [EMAIL PROTECTED]
http://www.joestump.net
Label makers are proof God wants Sys Admins to be happy.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 11:29 AM
To: Joe Stump
Subject: Re: InnoDB / MyISAM
Your message
Hello Inbal,
Wednesday, January 29, 2003, 4:13:24 PM, you wrote:
IO Hi All,
IO I have MySql on Windows.
IO Today i had an electrical power interruption in the middle of working.
IO The database remain not consistent and i could not continue working with it.
IO Is there any Recovery after crash
ok will try that too...
- Original Message -
From: Sherzod Ruzmetov [EMAIL PROTECTED]
To: Sunfire [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, January 29, 2003 7:07 AM
Subject: RE: mysql php and blank variables...
:when i type
:mysql_query(insert into table_name
On 1/29/03 5:13 AM, Inbal Ovadia [EMAIL PROTECTED] wrote:
Hi All,
I have MySql on Windows.
Today i had an electrical power interruption in the middle of working.
The database remain not consistent and i could not continue working with it.
Is there any Recovery after crash mechanism in
It´s happen exactly the same with me. Do you have some suggestion to
solve this?
I'm on Linux Redhat 7.2 and MySQL v. 3.23.41
I can make connections from the server... including the use of other
hostnames for test purposes. All my PHP/MySQL sites are up and running.
I can access the
Well it looks like I have limited options.
I'm guessing that the web host will let me have limited rights to the
server as it is - probably only basic FTP and other limited DB rights -
I do hve some control using phpmyadmin to manipulate data.
I'll almost bet that they won't let me run a
Well it looks like I have limited options.
I'm guessing that the web host will let me have limited rights to the
server as it is - probably only basic FTP and other limited DB rights -
I do hve some control using phpmyadmin to manipulate data.
I'll almost bet that they won't let me run a
this command should get your data moved to a new sql table
insert into table2
select
(concat(mid(my_date,7,4),'-',mid(my_date,1,2),'-',mid(my_date,4,2)))
from table1;
- hcir
On Tuesday, January 28, 2003, at 01:45 PM, Wong Zach-CHZ013 wrote:
Hi
I have a few tables in a database Z, namely
table
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mark --
...and then Mark Stringham said...
%
% Well it looks like I have limited options.
Yep. Hey, you could always host with me ;-)
%
% I'm guessing that the web host will let me have limited rights to the
% server as it is - probably only
Description:
While building 4.0.9:
gcc -O3 -DDBUG_OFF -rdynamic -o test-ssl test-ssl.o -lstdc++
../dbug/libdbug.a ../mysys/libmysys.a ../strings/libmystrings.a libvio.a -L/usr/lib
-lssl -lcrypto -lz -lcrypt -lnsl -lm -lpthread
libvio.a(viosocket.o)(.text+0x2b6): In
Hi!
I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on
i686. I'm
trying to create a fulltext index on an existing myisam table
and running up
against an error. From what I can tell, I'm using the alter
table command
correctly, but I keep getting errno 140. Can
We're having difficulties compiling MySQL on a RedHat 6.2 machine and then
installing on a RedHat 7.2 machine. This has worked in the past. The
reason for doing this is to avoid the gcc 2.96 compilation problems
indicated on the mysql.com download page.
The symptoms are that the 'make
Hi all,
I am trying to get my mysql database to be searchable
by
date, by both current and past events.
My perl program doesn't compile--- here's an excerpt--
package Date::Range;
my $range = Date::Range - new ($date1, $date2);
error message:
--
can't locate object method new
In the last episode (Jan 28), Salada, Duncan said:
I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on i686.
I'm trying to create a fulltext index on an existing myisam table and
running up against an error. From what I can tell, I'm using the
alter table command correctly, but I
dell 4100 256mb, 11gb hd, Redhat 8.0 grub-linux
linux novice cannot resolve apache-php-mysql linkage.
local closed system (No modem, no www access, no internet)
I have tried to create a database of 7 tables with about 840mb
of data since the 20th of November 2002. My own db handler (.cpp's)
In the last episode (Jan 29), Igor Kutsyy said:
Could you help me with this. I`m trying to increment values of
primary auto_increment field from table, and ofcourse it is not
working. Could you tell me how to construct a query correctly.
73 matches
Mail list logo