Hi,
the root password for mysql is not the same as the password
for your linux system.
If you haven't set a password for mysql, you don't have any.
So you can check e.g. with:
mysqladmin ping
that you have not a password
or try
mysqladmin -p ping
and when he asks you: Password:
you press
Hi All,
I have recently installed MySQL on my windows 2000 machine and
everything is great except for the fact that it doesnt't seem to recognize
upper case table / column names? This wouldn't be a problem if I was just
developing locally because I could just name everything lowercase.
On Mon, 2 Jul 2001, craig riley wrote:
Hi All,
I have recently installed MySQL on my windows 2000 machine and
everything is great except for the fact that it doesnt't seem to recognize
upper case table / column names? This wouldn't be a problem if I was just
developing locally
Daniel,
This would be a 'contre-coeur' to any database...
If you want some output like this, make it so in your query:
SELECT *, (column_1 * column_2) AS column_3 FROM table;
If you actually want to store the result of the calculation, do it in your
insert query; However, a 'dynamic value'
MAX() Query
Hello,
I'm trying to write 2 queries, the first to find the most recent club a
player has played for, and then the previous club they played for.
To find the most recent club i use this :
substring(max(concat(STARTDATE,TEAM)),11,100) as TEAM
which concats a players start date to
Hi,
I am a Vb programmer wants to connect with Mysql database please suggest me.
I have download Mysql for windows95 .
My mail address is [EMAIL PROTECTED]
Thanks,
Sougata
hello,
I have installed mysql 3.23.38 binaries on win 98
first mysqld --version says mysqld-max debug and not mysqld without
additionnal database systems.
mysqld-max corresponds to mysqld-max ok
I have innodb_* set in my.ini file innodb_dazta_file_path=ibevolif:1M
when trying to start the
Hi all,
I'm using visual basic with ODBC to update my mysql databases, and
all worked fine until now.
Now I have a new database in a different host, and when I try to
connect I receive this error message:
Can't intialize character set 7 (path: c:\mysql\\share\charsets\) (2019)
this error
Hello Michael,
Thursday, June 28, 2001, 11:41:57 PM, you wrote:
I'm getting this again and again with two tables which are used in
quite the same fation - some selects, often updates, rare inserts, no
deletes:
mysql repair table counter.quickstat;
I am using MySQL version 3.23.38-nt and I am writing a very simple SQL
statement to create a new schema as follows:
CREATE SCHEMA schema_name
but I got an error.
I need to use more than one schema, is not sceham supported in this release?
And if it is supported please tell me how to use it, thanx
Hi,
I've been using 3.23.37 source tarball compiled for Linux 2.2.19. Now I
upgraded to 3.23.39 but still the same result... Anyway, it's not that
important - I was just wondering why SELECT DISTINCT ... LIMIT is slower than
the
one without LIMIT. It's not crucial for my application and
does
Description:
MySQL lies about what ist grater than 0.
How-To-Repeat:
Imagine having a table...
CREATE TABLE `Customer` (
`ID` int(10) unsigned NOT NULL default '0',
`Seller` tinyint(3) default NULL,
PRIMARY KEY (`ID`));
Seller is either 0, 1 or 2. Look at the following selects:
mysql
Hi,
are you sure, that mysql make the same sorting order??
I seems in the second query first all with 1, you cann't be sure whether
the to in not listet later on.
Try it again with order by id every three statements and compare then the
listings.
Gerlinde
At 12:50 02.07.01 +0200, you wrote:
You can control the case-sensitivity of MySQL in my.ini (or my.cnf).
If lower_case_table_names is=1 MySQL will convert all table names to lower
case on storage and lookup ... but you need to first convert your old table
names to lower case before starting mysqld.
If you have not done so, you
Yes look for mssql2mysql.txt on Mysql.com or even yahoo.com.
Atenciosamente,
Tiago Luchini
Diretor Técnico-Comercial
Galluch Soluções Internet
Telefax: 11 6912 3255
Celular: 11 3176 7740
http://www.galluch.com.br/
-Original Message-
From: Lok Woei Ming [EMAIL PROTECTED]
To: [EMAIL
Easy solution: download MyODBC from mysql.com
Atenciosamente,
Tiago Luchini
Diretor Técnico-Comercial
Galluch Soluções Internet
Telefax: 11 6912 3255
Celular: 11 3176 7740
http://www.galluch.com.br/
-Original Message-
From: Gopal Saha [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL
John Griffin-Wiesner writes:
I am trying to connect to my database with mysqlgui
as root. I have gone into options and entered the
port number and the path to the socket. I have ask for
password checked on and am using the same password that
works when I do mysql -u root -p. I have tried
Hi!
The standard MySQL -Max binary for FreeBSD (Intel) is at
www.mysql.com, look at the MySQL -Max downloads.
Max contains InnoDB, non-Max does not contain.
The downloads at www.mysql.com should always be the
best versions available.
Regards,
Heikki
http://www.innodb.com
Copied message:
Hi!
In .38 mysqld.exe was accidentally copied with __NT__
defined. Use mysqld-max.exe or download a new
3.23.39 from www.mysql.com.
Regards,
Heikki
http://www.innodb.com
Copied message:
hello,
I have installed mysql 3.23.38 binaries on win 98
first mysqld --version
I have a simple table I created that was made from parts of other tables
that just has 2 fileds. The first field is an ID number and the second is a
score. Now each ID can have from 1 to 15 scores and what I need to do is for
each ID, get the average of the top 6 scores.
Is there a way to do
Hi all,
We want to use the Windows GUI tool to connect to a database on
a Linux box.
However, after trying to configure it and attempting to connect,
we get a message along the lines of Host 'ip_address' not allowed to
connect
to this MySQL server.
I'm sure that this is some silly
X Gogo writes:
Hi,
I've been using 3.23.37 source tarball compiled for Linux 2.2.19. Now I
upgraded to 3.23.39 but still the same result... Anyway, it's not that
important - I was just wondering why SELECT DISTINCT ... LIMIT is slower than
the
one without LIMIT. It's not crucial for my
Paul Linehan writes:
Hi all,
We want to use the Windows GUI tool to connect to a database on
a Linux box.
However, after trying to configure it and attempting to connect,
we get a message along the lines of Host 'ip_address' not allowed to
connect
to this MySQL server.
Hello,
Anybody has any experiences as how to best backup the databases? It should
be a part of an automated process, and should happen in such a way as to
secure that database integrity is preserved, even upon restoring. So I
cannot just backup the files of the databases, because they might be
try this :
Mysql VB6
http://www.avukatpro.com/mysql.html
- Original Message -
From: Tiago Luchini [EMAIL PROTECTED]
To: Gopal Saha [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 2:56 PM
Subject: Re: How to connect Mysql with vb6 applications?
Easy solution:
Once you moved the files, did you check the ownership and permissions?
I have had the same error after restoring databases from a backup, only
to find the files were owned by root and the permissions were munched.
Something that I have been known to do is to add another, larger disk
drive,
I need to provide MyODBC with one of my systems' installation. It would need to be as
smooth and simple as possible (completely unattended is preferred).
Does anyone know how to do this or where I could find some information?
Thanks a lot.
Atenciosamente,
Tiago Luchini
Diretor
Check the source. There is an error.h file.
Lee, John wrote:
Hi all,
I am a newbie in MySQL and would like to know if there is a list of error
codes for accessing MySQL database.
What I am asking is something like What is the return error code for record
(or row) not found? or What is
If you shoot something with a shotgun enough times, you will kill it.
You have done so many vague things that I am not sure what your problem
is right now.
The directories and files in which the databases are stores must be
owned by mysql.
The owner of the symbolic link is not as important.
Hi,
I need a transaction Database with Mysql.
I have compiled the sourccode 3.23.39 the following on Linux.
./configure --with-innodb
after that I have stopped and restartet mysql.
but if I make create table .. type=InnoDB;
I create a ISAM-Table. How can I make a InnoDB-Table.
Please help.
I doubt this is a MySQL problem. You are probly not indexing properly,
and you are always missing one or two entries, but only notice it with
the DESC option.
Pat Malone wrote:
I have a problem with a bulletin board type system. When a new
message is posted the script redirects back to
Hi Everybody,
We are using Mysql in Sun5.8 environment. Presently it has installed in
/usr/local/mysql. I want to change this location to /export/home/mysql. What should i
take necessary steps.
Is it work properly if move my Mysql dir to /usr/local/mysql to /export/home/mysql and
chage
chown -R mysql /home/ecom
tpchan wrote:
Hi all,
I try the solution from David but seem it didn't work.
Here is my steps:
1) Stop the mysql services.
2) Move the ecom database directory from '/var/lib/mysql/ecom' to
'/home/ecom'
3) Make symbolic link in '/var/lib/mysql' using 'ln
Has anyone done a bake-off among the different table types available for
mysql? Which, of the non-beta types is the fastest at Insert, update,
delete, etc?
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
Hi noelt,
i mean, the value of the duration field will be transferred or
copied to the consumed field w/c is in a diff. table.
So these are just some fields like column1 and column2 - nothing
to do with duration of the process itself.
The following is in php and uses class db_mysql - there
The following Statement ("GRANT ALL ") will create
a user who will have access on mydatabase.MYTABLE only...
But My question was ... .. okay, let me describe again..
In MySQL manual I was reading the sytax of CREATE TABLE
and I found the password option there... .. My Question is 'How
Good Morning Robert,
I use Visio, first setup an ODBC connection to the database
(MyODBC) then run the database Wizard and if fetches all the keys and
coulmns and builds a big drawing.
Good Luck,
Ken
- Original Message -
From: Robert Goeres [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hello,
Anybody has any experiences as how to best backup the databases? It should
be a part of an automated process, and should happen in such a way as to
secure that database integrity is preserved, even upon restoring. So I
cannot just backup the files of the databases, because they might be
Hi Ken,
Make sure you cvsup the latest ports before building if you use
ports. THe innodb is not included (I believe) because it does yet
support all features of MySQL. You can use the ports just edit the
make file and find the line:
CONFIGURE_ARGS+=--enable-assembler --with-berkeley-db
and
This is in the manual - how to find out and some examples:
perror 126 127 132 134 135 136 141 144 145
126 = Index file is crashed / Wrong file format
127 = Record-file is crashed
132 = Old database file
134 = Record was already deleted (or record file crashed)
135 = No more room in record file
Is it wrong to hand edit these tables? root with the
password new_password is a valid logon for this db.
Don't touch MySQL privilege tables, except host table.
That way you just mess up the things, as you did.
Use GRANT / REVOKE / SET PASSWORD ..
OK - fair enough - two questions
I would like to know if there is a module/extension/engine which supports the storage
of spatial data in MySQL. If not, how could I store spatial data in MySQL?
Thanks a lot
-
Before posting, please check:
please,
is there a way to get the size of a mysql table through
an SQL query ?
thank you
karel pitra
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi
when i am updating the rows with prepared statement/statement( the
values may/may not be same), the count returning is different in
different cases. Why it so like this..
In my program some times the values may/may not be changed.
Irrespective of the values, the database should be
Bonjour,
When you have a big web site with a lot of pages, programs,
cronjobs, applications ... connecting to Mysql, it's sometimes
difficult to find from where a given query/connection comes from.
And it's sometimes urgent to find the origin of a disturbing query.
MySQL Support:
I need some help about import data of Microsoft SQL
Server to MySql Server 3.23.39. Please, send me more information about it, thank
you for all
Hi!
Have you specified the InnoDB startup options in
your my.cnf, in the [mysqld] section of my.cnf?
You can look at the manual at http://ww.innodb.com
where you see what kind of values you should specify.
When InnoDB starts the first time it will say:
InnoDB: The first specified data file
Just curious, can you convert access database to MySQL and visa versa.
Meaning from win98 access 2000 to Linux Mysql 3.22.32?
At 04:56 AM 07/02/2001 , you wrote:
Yes look for mssql2mysql.txt on Mysql.com or even yahoo.com.
Atenciosamente,
Tiago Luchini
Diretor Técnico-Comercial
Galluch
I have a database of dealer bulletins. I have a web page that shows the
results of sorting
the info in the database in certain ways. I also want to add a field to the
page to allow the
user to input a search word(s) and have the results displayed. I can't find
the answer to this
in the docs on
Yes! Piece of cake. Simple script. Works most times.
Atenciosamente,
Tiago Luchini
Diretor Técnico-Comercial
Galluch Soluções Internet
Telefax: 11 6912 3255
Celular: 11 3176 7740
http://www.galluch.com.br/
-Original Message-
From: Joe Taraba [EMAIL PROTECTED]
To: Tiago Luchini [EMAIL
At 09:50 AM 07/02/2001 , you wrote:
Yes! Piece of cake. Simple script. Works most times.
What script would that be--please??
I want to convert an MDB database to use with MySQL on my nix box. What
about the associated ini and dat files?
Atenciosamente,
Tiago Luchini
Diretor
Hoping someone can point me in the right direction.
I have Nusphere Mysql database in production [using mysql/PHP/apache, no
perl]. The database has 1 table, 20 columns, with 3500 entries and
growing.
I am backing up the database to tape 2 times a day. At noon and at 5pm,
both are full backups.
Hello!
I've been using MySQL version 3.22.32 and query with AND NOT phrase worked
fine. Now I have MySQL version 3.23.36 and the same query is losing records.
(the same data).
The query is quite complicated:
SELECT * FROM docs LEFT OUTER JOIN typy ON docs.nr = typy.nr LEFT
OUTER JOIN
Hello,
Has there been any thought about using mysql for SAP R/3 systems?
The reason I ask the question is because we work in SAP and we use mysql
as the db for our office applications. So we know them both quite well and it
would be nice if we could use the combined knowledge for our clients.
I
I do this by using a whole bunch of descriptive usernames. It is more work
than your idea, but you could use this method for now. I like your idea
though.
D'Arcy Rittich
- Original Message -
From: BAUMEISTER Alexandre [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 02, 2001
Paul Linehan writes:
OK - fair enough - two questions though.
Can I just hand delete the records that I manually inserted?
If you are brave and sure in yourslef.
What is the syntax of the grant?
This is properly described in our fine manual.
I log on as the root to the
Description:
Mysql 4.0 bitkeeper fails to compile
How-To-Repeat:
Try to compile
Fix:
Fails with a syntax error
Submitter-Id: submitter ID
Originator:John
Organization:
MySQL support: none
Synopsis: Mysql 4.0 bitkeeper fails to compile
Severity:
Yes, but it is usually among separate applications that I use different
names. In a web app, though, I would use different users for admin stuff
versus regular stuff. You want to make use of persistent connections where
possible of course, and changing usernames a lot can get in the way of
Can I just hand delete the records that I manually inserted?
If you are brave and sure in yourslef.
I'm not really that brave, it's just that I didn't have
a choice - it appears to have worked fine - I am now
able to connect using the GUI tool.
What is the syntax of the grant?
Thanks for your help, it's not that mysql does not accept my password as
root, the problem is that I'm not allowed to access mysql as root (in fact
as any user) anymore, 'cause I deleted by mistake the entry corresponding to
root in the tables in the mysql database.Can I alter the tables without
I have a Contact information page that draws from or writes to a
table [contact] and displays that information in an HTML form. There
is a field [type] that I want to have populated from a pulldown list,
and that pulldown list is drawn from another table [contact_type].
I'm using PHP 3.x for
Hi!
Mysqldump creates the files brand.txt brand.sql etc.
How do i restore the database in a simple way..?
I've looked in the manual but couldn't find out...
Sincerely Victor
-
Before posting, please check:
do this:
mysql -uusrename -ppassword dbname brand.txt
mysql -uusrename -ppassword dbname brand.sql
Tyler
- Original Message -
From: Victor Spång Arthursson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 1:59 PM
Subject: How do I restore a database backed up using
Run your transaction log against the restored database.
Pete Kuczynski wrote:
Hoping someone can point me in the right direction.
I have Nusphere Mysql database in production [using mysql/PHP/apache, no
perl]. The database has 1 table, 20 columns, with 3500 entries and
growing.
I am
Print the current value as the first entry of the pulldown.
It will be in the pulldown twice, but so what?
Nelson Goforth wrote:
I have a Contact information page that draws from or writes to a table
[contact] and displays that information in an HTML form. There is a
field [type] that I
Hi John,
Try prefixing the command line with YACC='bison -y '
Here is my build script:
bash-2.05$ cat build.sh
cd mysql-4.0
YACC='bison -y ' ./BUILD/compile-pentium-debug-max
bash-2.05$
Good luck.
Ken
- Original Message -
From: John Barton [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
If I understand you correctly, here is my approach in php:
You look at the selected value first and store it in idSelected;
then you insert a condition and evaluate that condition in your
printf statement:
while ($row = mysql_fetch_object ($list)) {
$selected = $row-id ==
Paul DuBois' Book.
it is extremely well written and indexed. I've gone from a complete mysql bumbler to
somebody that can actually make it work in a short time thanks to his book.
Chris
On Sat, 23 Jun 2001 16:40:04 -0500, Chris Petersen wrote:
Does anyone have any recommendations for a
Actually, a new book by Paul is to be published MySql and Perl for WWW.
Gonna be a great one. (to be published on August 13th)
--
sherzod_ruzmetov (sherzodR)
email: [EMAIL PROTECTED]
It really doesn't bother me if people want to use grep or map in a void
context. It didn't bother me
I'm trying to upgrade from 3.22 to 3.23.39 and have discovered that I can't
create a table which has a column named when. This has worked in the past,
including on 3.23.36. Here is the output I got:
mysql CREATE TABLE wasp_project_hist (
- id int(11)
Title: Blank
This is what I have done
[root@MySQL Msql-Mysql-modules-1.2216]# perl Makefile.PL Which drivers
do you want to install?
1) MySQL only 2) mSQL
only (either of mSQL 1 or mSQL 2) 3) MySQL and mSQL
(either of mSQL 1 or mSQL 2)
4) mSQL 1 and mSQL 2
5) MySQL, mSQL 1 and mSQL 2
When is a reserved word in ANSI SQL. See the link below for the full
list.
http://www.mysql.com/doc/R/e/Reserved_words.html
Chris Bare [EMAIL PROTECTED] wrote:
ERROR 1064: You have an error in your SQL syntax near
'when datetime,
who varchar(16)
Gerald,
Check out the tutorial at the following link:
http://www.thickbook.com/extra/php_loopoption.phtml
Julie is very clear in her explanation of how to do exactly what you want to
accomplish.
Josh
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Monday, July
OK, what are all you guys using for a reporting tool, with MySQL as a
backend (where you don't need Windows)?
I need a reporting tool to generate management reports/letters out of MySQL,
which I will be using for a web-based application.
I guess I am looking for something like Crystal Reports,
Print to HTML. Pull up in browser. Print.
But seriously, have you tried looking on freshmeat?
j- k-
On Monday 02 July 2001 14:32, Mazur wrote:
OK, what are all you guys using for a reporting tool, with MySQL as a
backend (where you don't need Windows)?
I need a reporting tool to
:-) Ya, I was thinking I would try to stay away from formatting in HTML,
and let the tool do it, quite like Crystal would (at least, I think it
does...have only read books on it in Barnes Noble). But I could resort to
using JSP's to build the reports.
H, I will check Freshmeat too,
Hi
I'm new to MySQL.
Please can anyone give me the connection sentences in Java.
Exactly:
How to charge the driver:
Class.forName(
I use windows98. And want to make experimental local connections.
Regards,
Daniel Aderhold
Hi Everyone,
Does this make sense:
select * from table_name where column_1 LIKE %word1% OR %word2%;
yeilds 1 record but...
select * from table_name where column_1 LIKE %word2% OR %word1%;
yields 0 records.
I'm scanning a VARCHAR column trying to return records that contain or
word1 and
I need to create a new login for a already created
database. I have tryed to from the command prompt of
my windows 2000 adv server box.
c:\mysql\binCreate User mark
But know luck at all what am I doing wrong??
PLease help.
Thanks
__
Do You
On Tue, 3 Jul 2001 09:44, Eric Fegraus wrote:
Hi Everyone,
Does this make sense:
select * from table_name where column_1 LIKE %word1% OR %word2%;
yeilds 1 record but...
select * from table_name where column_1 LIKE %word2% OR %word1%;
yields 0 records.
I'm scanning a VARCHAR column
Hi,
This is a start of a mini HowTo for getting Linux WebCatalog,
unixODBC, MyODBC to work with MySQL
It's a work in progress. The ODBC part worked only on 2 of 4 servers.
Q1: Do I have a config problem with unixODBC or MyODBC ?
Q2: Is there a way for force the ODBC Libraries to
Hi Everyone,
Does this make sense:
select * from table_name where column_1 LIKE %word1% OR %word2%;
That should be:
column_1 LIKE %word1% OR column_1 LIKE %word2%
yeilds 1 record but...
select * from table_name where column_1 LIKE %word2% OR %word1%;
yields 0 records.
I'm scanning a
I fixed the other errors, however I am still getting
other errors. This database is tied into PHP. I want
to be able to have an admin screen so I can make
changes but it is not working for me. The errors I am
getting on the Index page are :
Warning: Supplied argument is not a valid MySQL
1) I left my ESP in my other pants, so I can't really debug your code.
2) Somebody will probably tell you that this isn't the appropriate group
for questions like this. You might try news://news.php.net or a site like
http://www.phpdeveloper.org or http://www.phpbuilder.com for tutorials.
Also: If you are looking to build a MySQL, PHP website go to
http://phpnuke.org/ and download the 5.0RC1. Follow the Install.txt file and
you have an entire site to Play with in 1/2 an hour and there is excellent
help at http://www.nukeforums.com/forums/index.php?viewcat=5 in Spanish
English
On Tue, 3 Jul 2001 12:57, help wrote:
I fixed the other errors, however I am still getting
other errors. This database is tied into PHP. I want
to be able to have an admin screen so I can make
changes but it is not working for me. The errors I am
getting on the Index page are :
Warning:
On Tue, 3 Jul 2001 01:53, [EMAIL PROTECTED] wrote:
I have a database of dealer bulletins. I have a web page that shows the
results of sorting
the info in the database in certain ways. I also want to add a field to
the page to allow the
user to input a search word(s) and have the results
Has anybody successfully compiled MySQL GUI on the Mac OS X platform (or
rather Darwin)?
Hannes
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi Werner,
--
On Mon, 2 Jul 2001 15:59:19Werner Stuerenburg wrote:
Hi noelt,
i mean, the value of the duration field will be transferred or
copied to the consumed field w/c is in a diff. table.
So these are just some fields like column1 and column2 - nothing
to do with duration
hi,
i updated the password field using update statement in the command line for the root
user. other users in the table don't have any privilege to access the mysql database.
when i tried to connect the database i can't able to connect with the new password.
the passord i gave was kannan1.
Try this :
myodbc silent installation merge module
http://www.avukatpro.com/mysql.html
- Original Message -
From: Tiago Luchini [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 3:58 PM
Subject: Unattended MyODBC installation
I need to provide MyODBC with one of my
Look up skip grants in the manual and in future I recommend the GRANT
command.
- Original Message -
From: harvin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 03, 2001 13:56
Subject: forget password in user table and no other user has access
privilege to mysql database
92 matches
Mail list logo