Hi there,
First shutdown the running server.
mysqladmin shutdown
or
/etc/init.d/mysql.server stop
or
/etc/init.d/mysqld stop
(depending on your Linux distribution)
Then restart the mysql server with option "--skip-grant-tables" like this.
safe_mysqld --skip-grant-tables
You can then login
Read http://www.mysql.com/doc/en/Command-line_options.html
Start mysqld with the --skip-grant-tables option then change your root
password again, then restart mysqld, this time with out
the --skip-grant-tables
hope that helps.
Sherwin T. Ang
Tridel Technologies Incorporated
PS: you don't have t
FT wrote:
Hi everyone
I am quiet new to DB and MySql
I must have made a big mistake by changing the root @ localhost password via
phpMyAdmin and now it is impossible to connect from neither the mysql prompt
nor phpMyAdmin...
Does anyone know how to recover this problem...I did try to reinstall M
Hi everyone
I am quiet new to DB and MySql
I must have made a big mistake by changing the root @ localhost password via
phpMyAdmin and now it is impossible to connect from neither the mysql prompt
nor phpMyAdmin...
Does anyone know how to recover this problem...I did try to reinstall MySql
after u
One problem is that you have quoted your "sub-query", which makes it to return a
constant string.
Another problem I saw in your code is that you used the same aliases for tables
in the query and in the sub-query. In such case, the SQL parser would take all
of them to refer to the same table, prob
Dan Nelson wrote:
In the last episode (Aug 02), Pascal Dlisle said:
I try to figure out how to use a nested "SELECT" statement after the
"IN" predicate. For example, when I try this code, it doesn't return
anything although it should:
SELECT book.IDLivre, aut.Prenom, aut.Nom FROM livre book,
In the last episode (Aug 02), Pascal Dlisle said:
> I try to figure out how to use a nested "SELECT" statement after the
> "IN" predicate. For example, when I try this code, it doesn't return
> anything although it should:
>
> SELECT book.IDLivre, aut.Prenom, aut.Nom FROM livre book,
> livreEcrit
Hi!
I try to figure out how to use a nested "SELECT" statement after the
"IN" predicate. For example, when I try this code, it doesn't return
anything although it should:
SELECT book.IDLivre, aut.Prenom, aut.Nom FROM livre book, livreEcritPar
ecr, auteur aut WHERE ecr.IDLivre = book.IDLivre A
Well, unless you like a bucket of spaghetti with your code.
Avoid an MS solution like VB at all costs. If you want a non web-based
solution.
I would use Java RMI on Linux. The MOST flexible and the MOST robust
solution.
And, stay way from the Win platforms for your server box. As the
previous po
KB,
1) There's an interesting virus alert attached to your message.
2) >> what front end tools should i think of using for dataentry clients
IMHO, the answer is 'the web'. Is there a good reason why you don't want
to do that? I realise that JSP is an obvious choice and perhaps like me
you think it
In the last episode (Aug 03), web4.hm - Peter Padberg said:
> Hi!
>
> I updated my MySQL from 3.23 upto 4.0 and now began the problems!
>
> All Users in my mysql-db are with this privileges:
> INSERT INTO `user` (`Host`, `User`, `password`, `Select_priv`,
> `Insert_priv`, `Update_priv`, `Delete_p
Mattias,
It may not be such a good idea to store the 6 items in 1 record. An
alternative structure is one table with Item ID and Name and another
with Item Id and Component Id, both of which point back to item id in
the first table. This avoids having to know how many components there
are and allow
Mike,
Is the field meant to be the number of days until ?
(This is implied by the number 14 you gave). If so, you shouldn't be
storing the days value in the database at all (the reason being it
causes exactly the problem you seem to have).
Instead you should store only expdate and then calculate
Hi!
I updated my MySQL from 3.23 upto 4.0 and now began the problems!
All Users in my mysql-db are with this privileges:
INSERT INTO `user` (`Host`, `User`, `password`, `Select_priv`,
`Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`,
`Reload_priv`, `Shutdown_priv`, `Process
Hello,
I need to update one of our mysql tables, which has about 60,000 entires and
correct the amount of days remain on each data record. An example of one of the
data entires is:
memiddaysregdate expdate
--
625290 | 5 | 2003-07-15 | 2003-08-
try the shortest.
mysql < yoursource.sql
;)
--
Aftab Jahan Subedar
Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
81/1-A North Jatrbari
Dhaka 1204
Bangladesh
sms://+447765341890
sms://+880171859159
http://www.ceobangladesh.com
http://www.DhakaStockExchangeGame.com
http://www.
SELECT [field list] FROM archivetable,currenttable WHERE
archivetable.username=currenttable.username
notes: can use join,left,right,select inside select aka subselect check
the manual for detail
Regards,
--
Aftab Jahan Subedar
Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha #
Hi,
I'm trying to change the value of max_connections variable but mysqld
doesn't accept that.
I use mysql 3.23.54 and my config file /etc/my.cnf looks like:
[mysql.server]
...
...
set-variable max_connections=200
After a newstart of mysqld the value of max_connections is unchanged and
equals
hi all,
i am a new-bie,
should i even think of using mySQL in the following scenario ?
i have a situation in mind where two or three ( sometimes concurrently ) people will
be making invoices, on three computers in different locations on lan.
what front end tools should i think of using for dataen
Jim Smith wrote:
Wasn't my question.
well ... it was mine but I'll share it with you ;)
Why do you need to label a table as a table?
That was my thought, too.
There is some merit in using
type prefixes in VB because of its loose typing, but it makes no sense in a
database context where the t
Mary,
I guess, depending on your perspective, that is the case. MySQL
identifies users by their user name and their originating host. For
example: "[EMAIL PROTECTED]" is different than "[EMAIL PROTECTED]". Its
likely you have 2-entries in your mysql.user table for root: localhost
and [workstat
Hi There,
Though it's in the manual, you may want to do something like this:
GRANT ALL ON database.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'
Of course, you'll want to replace:
- ALL with access privelages that are much safer (assuming you don't
completely trust the remote user).
- databa
Hi Roger this was very useful indeed thank you.
I would really like to know any other views on this design and implications for
the future development of such a system in terms of flexibility
Andrew
>-Original Message-
>From: Roger Baklund [mailto:[EMAIL PROTECTED]
>Sent: 02 August 2003
I have been using MySQL for awhile, and for the first time someone from
outside our portable /16 needs access to some tables. We have given them
the server IP address, the dB name, the port 3306, the root username, and
the password, but they still can't get access. Of course, no firewalls or
* Andrew
> guess this was too much information for you all! Or too
> complicated :)
...or maybe too vague? ;)
> Well this is what we came up with, I would like to know your
> opinions if you have any?
ok, but be warned, I would have done this _totally_ different... :)
> I can see two flaws in
Heikki,
Thanks so much! That did the trick - mysqld is up and humming.
SJohnson
Heikki Tuuri wrote:
Hi!
mysqld thinks some character pairs like \b and \s are special characters.
You should replace
basedir=C:\mysql\bin
language=c:\mysql\share\english\
by
basedir=C:/mysql/bin
language=c:/mysql/sh
Hi there.
I have a little problem with a sql-query I'm trying to get together.
Well I got it to work halfways.
I have a table with items, which are composed of 1-6 other items, which
is saved in the same table.
You might call it a recursive query, I need to get the names of the
components tha
Hello,
I've got 2 sites.
1) server : mysqld 4.0.14 standard from mysql.com on linux
2) client : windows 2000 whith mysqlcc 0.9.2 beta and myodbc 3.51.6
Both have dynamic IPs.
The server listens on e.g. server.dyndns.org with ssh port open.
In reality it's IP is something like dialin-a-b-c-d.so
System rh9
Mysql 4
Php 4.2.3
I compiled apache with mpm=worker and have lot of problem with "mysql too
many connections"
If I install apache in traditional way there is no problem
So what's the problem?
>From http://httpd.apache.org/docs-2.0/mod/worker.html "By using threads to
serve requests, it
Prem,
I had this problem and adding the library 'z' (whatever that is) helped.
Try putting -lz at the end of your compile line.
Regards,
Andy.
Prem Soman wrote:
>
> i am using Linux 6.2(Zoot) and MySql 2.23.36and found the following error while
> compiling the C program using mysql APIcc -o test
Dave,
The documentation has several examples. Here's a function we use. Are
you having a particular difficulty?
Regards,
Andy.
MYSQL *aDb = NULL;
int xConnect()
{
#define MYSQL_HOST "192.168.103.112" // or host name
#define MYSQL_DB"foodb" // database n
Woah! 10.3! Some is using the developer preview of Panther!
Actually, MySQL doesn't normally give overrun cut-off information (best
I know). Use MySQL 4.0.x on 10.2.6, and MySQL has always performed
that way.
Regards,
A$
On Friday, August 1, 2003, at 05:37 PM, Ray Kiddy wrote:
I am trying to
guess this was too much information for you all! Or too complicated :) Well
this is what we came up with, I would like to know your opinions if you have
any? I can see two flaws in the design for the Time/Date so I really would be
interested in any of your views :)
CREATE TABLE booking (
id v
Hi!
mysqld thinks some character pairs like \b and \s are special characters.
You should replace
basedir=C:\mysql\bin
language=c:\mysql\share\english\
by
basedir=C:/mysql/bin
language=c:/mysql/share/english/
mysqld will internally convert those slashes to backslashes on Windows.
Best regards,
Hi Lists,
Just like to share what I found out in resolving my own problem.
Actually, my script is using the mysqlimport client in loading a file to
mysql and did not noticed that I used the option '-r'(replace) when I
first created the script. When I upgrade to 4.0.13, I created an index to
Hi List,
Does anyone knows why this error message is displaying when I ran a cshell
script which is using mysql and mysqlimport client commands? I encountered
this after I upgrade from 4.0 gamma to 4.0.13.
Error: Lost connection to MySQL server during query, when using table:
SUMMARY
Thanks.
Hi Mysql fans ;-);
I have a problem understanding why MySQL is deleting a unique key instead of
a primary key.
from Documentation: DROP PRIMARY KEY drops the primary index. If no such index
exists, it drops the first UNIQUE index in the table.
When I do it then I get this:
mysql> desc uksam
37 matches
Mail list logo
