mysql problem

2002-06-10 Thread Simona D'Ambrosio

Hi! I am new to mysql and this is my problem.
The daemon runs well but I can start it only with --skip-grant-tables
option, otherwise nothing will work.
I set the password for the root user but when I exit the Mysql monitor and
try to get in again, no password is request.
When I set the password I entered flush privileges, but it returns 0 rows
affected, if  I try with mysqladmin it returns You have no
privileges.
Please, help me... I am almost out of mind for this!

Simona


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: mysql problem

2002-06-10 Thread Simona D'Ambrosio

Now it works!!!
My problem was that I didn't know that if I set up passwords for users I had
to tell it to the web pages where I connect to the database (postgres
doesn't work like that).
I know this is stupid, but I began my message with I am new to mysql :-)
Anyway thank you for your replies.
Simona

 What happend when you ran scripts/mysql_install_db ?
 Also when you run the databases with --skip-grant-tables as soon as you
 grant a user acess and flush privileges it will then use the grant tables
(I
 think)..
 Simon

 -Original Message-
 From: Simona D'Ambrosio [mailto:[EMAIL PROTECTED]]
 Sent: 10 June 2002 14:32
 To: [EMAIL PROTECTED]
 Subject: mysql problem


 Hi! I am new to mysql and this is my problem.
 The daemon runs well but I can start it only with --skip-grant-tables
 option, otherwise nothing will work.
 I set the password for the root user but when I exit the Mysql monitor and
 try to get in again, no password is request.
 When I set the password I entered flush privileges, but it returns 0 rows
 affected, if  I try with mysqladmin it returns You have no
 privileges.
 Please, help me... I am almost out of mind for this!

 Simona


 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php