Re: Start up problem

2002-12-09 Thread Touch13
It's OK, MySQL start...

On Mon, 09 Dec 2002 10:48:47 -0600
gerald_clark [EMAIL PROTECTED] wrote:

 # su mysql
 $ mysqld
 
 What do you see now?
 
 
 Touch13 wrote:
 
 The data directory is well owned by mysql.
 In fact my problem is : 
 I cannot start mysql daemon in root user
 with change user in line command like this : 
  # safe_mysqld --user=mysql --log=/var/lib/mysql/mysql.log 
 
 touch13
 
 On Mon, 09 Dec 2002 09:28:30 -0600
 gerald_clark [EMAIL PROTECTED] wrote:
 
   
 
 If the data directory is not owned  by mysql, mysql will not be able
 to create a log file.
 Make  sure mysql's data directory, and every directory and file
 beneath it is owned my mysql.
 
 Touch13 wrote:
 
 
 
 
 
 

-
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: Start up problem

2002-12-09 Thread Touch13
The data directory is well owned by mysql.
In fact my problem is : 
I cannot start mysql daemon in root user
with change user in line command like this : 
# safe_mysqld --user=mysql --log=/var/lib/mysql/mysql.log 

touch13

On Mon, 09 Dec 2002 09:28:30 -0600
gerald_clark [EMAIL PROTECTED] wrote:

 If the data directory is not owned  by mysql, mysql will not be able
 to create a log file.
 Make  sure mysql's data directory, and every directory and file
 beneath it is owned my mysql.
 
 Touch13 wrote:
 
 On Fri, 6 Dec 2002 10:18:12 +0100
 David Bordas [EMAIL PROTECTED] wrote:
 
   
 
 Have a look to the mysql error log to see if you can find your
 problem
 
 ...
 
 
 This file should be in /usr/local/mysql/data
 
 
 
 I have no log file, the only file created is serveur name.err
 with the  
 
 number of the thread who crash.
 
 
 touch13
 
   
 
 This file IS the mysql error log.
 On one of mine i can see this for example :
 021128 10:48:21  mysqld ended
 
 021128 14:12:42  mysqld started
 /usr/local/mysql-3.23.53a/bin/mysqld: ready for connections
 
 So if mysql don't start, there'll normally be something there .
 
 David
 
 
 
 I repeat, i have no error log because mysql cannot start.
 i try this command under root: 
 safe_mysqld --user=mysql --log=/var/lib/mysql/mysql.log
 and this file is always empty...
 
 except if i cannot look in good file ;)
 
 touch13
   
 
 ---
 --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




Re: Start up problem

2002-12-09 Thread Sean Phillips
Try:
shell chown -R root /usr/local/mysql

shell chown -R mysql /usr/local/mysql/var

shell chgrp -R mysql /usr/local/mysql

then:

shell /usr/local/mysql/bin/safe_mysqld --user=mysql 
or
shell /usr/local/mysql/bin/mysqld_safe --user=mysql 
if you are running MySQL 4.x.

Sean

- Original Message -
From: Touch13 [EMAIL PROTECTED]
To: gerald_clark [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, December 09, 2002 10:00 AM
Subject: Re: Start up problem


 The data directory is well owned by mysql.
 In fact my problem is :
 I cannot start mysql daemon in root user
 with change user in line command like this :
 # safe_mysqld --user=mysql --log=/var/lib/mysql/mysql.log

 touch13

 On Mon, 09 Dec 2002 09:28:30 -0600
 gerald_clark [EMAIL PROTECTED] wrote:

  If the data directory is not owned  by mysql, mysql will not be able
  to create a log file.
  Make  sure mysql's data directory, and every directory and file
  beneath it is owned my mysql.
 
  Touch13 wrote:
 
  On Fri, 6 Dec 2002 10:18:12 +0100
  David Bordas [EMAIL PROTECTED] wrote:
  
  
  
  Have a look to the mysql error log to see if you can find your
  problem
  
  ...
  
  
  This file should be in /usr/local/mysql/data
  
  
  
  I have no log file, the only file created is serveur name.err
  with the
  
  number of the thread who crash.
  
  
  touch13
  
  
  
  This file IS the mysql error log.
  On one of mine i can see this for example :
  021128 10:48:21  mysqld ended
  
  021128 14:12:42  mysqld started
  /usr/local/mysql-3.23.53a/bin/mysqld: ready for connections
  
  So if mysql don't start, there'll normally be something there .
  
  David
  
  
  
  I repeat, i have no error log because mysql cannot start.
  i try this command under root:
  safe_mysqld --user=mysql --log=/var/lib/mysql/mysql.log
  and this file is always empty...
  
  except if i cannot look in good file ;)
  
  touch13
  
  
  ---
  --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





-
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




Start up problem

2002-12-06 Thread Touch13
Hello,

I upgrade my server from Mandrake 8.2 to Mandrake 9.0 and i have a little problem with 
MySql 3.23 (Ver 3.23.52 for pc-linux-gnu on i686):
When i try to start MySQL with this command with root user :
# safe_mysqld --user=mysql 
I obtains the following response:
# Starting mysqld daemon with databases from /var/lib/mysql
# 021205 17:40:17  mysqld ended
Then when i try to run under mysql user 
# safe_mysqld 
Its OK

I have make many reinstall and i have always the same problem.

Any idea ?

Best regard

ps: sorry for my english, i'm french ;-)

-
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: Start up problem

2002-12-06 Thread David Bordas
 Hello,

 I upgrade my server from Mandrake 8.2 to Mandrake 9.0 and i have a little
problem with MySql 3.23 (Ver 3.23.52 for pc-linux-gnu on i686):
 When i try to start MySQL with this command with root user :
 # safe_mysqld --user=mysql 
 I obtains the following response:
 # Starting mysqld daemon with databases from /var/lib/mysql
 # 021205 17:40:17  mysqld ended
 Then when i try to run under mysql user
 # safe_mysqld 
 Its OK

 I have make many reinstall and i have always the same problem.

 Any idea ?


Have a look to the mysql error log to see if you can find your problem ...
This file should be in /usr/local/mysql/data

David


-
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: Start up problem

2002-12-06 Thread Touch13
On Fri, 6 Dec 2002 09:36:17 +0100
David Bordas [EMAIL PROTECTED] wrote:

  Hello,
 
  I upgrade my server from Mandrake 8.2 to Mandrake 9.0 and i have a little
 problem with MySql 3.23 (Ver 3.23.52 for pc-linux-gnu on i686):
  When i try to start MySQL with this command with root user :
  # safe_mysqld --user=mysql 
  I obtains the following response:
  # Starting mysqld daemon with databases from /var/lib/mysql
  # 021205 17:40:17  mysqld ended
  Then when i try to run under mysql user
  # safe_mysqld 
  Its OK
 
  I have make many reinstall and i have always the same problem.
 
  Any idea ?
 
 
 Have a look to the mysql error log to see if you can find your problem ...
 This file should be in /usr/local/mysql/data
 
 David
 
I have no log file, the only file created is serveur name.err with the number of the 
thread who crash.

touch13

 
 -
 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




Re: Start up problem

2002-12-06 Thread David Bordas

 Have a look to the mysql error log to see if you can find your problem
...
 This file should be in /usr/local/mysql/data

 I have no log file, the only file created is serveur name.err with the
number of the thread who crash.

 touch13

This file IS the mysql error log.
On one of mine i can see this for example :
021128 10:48:21  mysqld ended

021128 14:12:42  mysqld started
/usr/local/mysql-3.23.53a/bin/mysqld: ready for connections

So if mysql don't start, there'll normally be something there .

David


-
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: Start up problem

2002-12-06 Thread Touch13
On Fri, 6 Dec 2002 10:18:12 +0100
David Bordas [EMAIL PROTECTED] wrote:

 
  Have a look to the mysql error log to see if you can find your problem
 ...
  This file should be in /usr/local/mysql/data
 
  I have no log file, the only file created is serveur name.err with the
 number of the thread who crash.
 
  touch13
 
 This file IS the mysql error log.
 On one of mine i can see this for example :
 021128 10:48:21  mysqld ended
 
 021128 14:12:42  mysqld started
 /usr/local/mysql-3.23.53a/bin/mysqld: ready for connections
 
 So if mysql don't start, there'll normally be something there .
 
 David

I repeat, i have no error log because mysql cannot start.
i try this command under root: 
safe_mysqld --user=mysql --log=/var/lib/mysql/mysql.log
and this file is always empty...

except if i cannot look in good file ;)

touch13
 
 
 -
 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




Re: start up problem

2002-04-30 Thread Victoria Reznichenko

Cindy,
Monday, April 29, 2002, 8:03:24 PM, you wrote:

I combine into one all your postings

C OK, it seems like every time I install mysql, I run smack dab into
C some type of access problem -- if it isn't a password hangup, it's a
C mysql.sock problem or (at the moment) a refusal to allow me to create
C databases.  I've puzzled through most of it for now, but this one
C has me stumped.

C It's giving me perror 13, which is a write permission problem.  But
C I've checked and double checked, and the data directory is indeed
C writable by my mysql account:

Cindy, error 13 occurs when your *nix user doesn't have permission on
MySQL datadir. You wrote that you had checked permissions, but I can't
see if your permissions are right. So, give me the output of following:
ls -ls mysql_data_dir

[skip]

C Thoughts?

C And while I'm at it, can someone also tell me what the heck the
C /usr/local/mysql/var directory is all about?  Inevitably, the reason I
C reinstall mysql all the time (binary dist) is because when I get back
C to a machine and want to do something administrative about once a
C quarter, it can't find things in the var directory, but I don't HAVE a
C var directory.  (I think the source code dist creates that, but not
C the binary code dist.)

I assume /usr/local/mysql/var is your datadir, isn't it?
What OS do you use?

C Now I'm getting:
C mysql_att /usr/local/mysql/bin/mysqladmin -u root password '***'
C /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
C error: 'Access denied for user: 'root@localhost' (Using password: NO)'

[skip]

C But that's not quite the same command I used, and that's got password
C YES.  And mind you, this is what I'm doing right after the
C mysql_install_db script and starting up the safe_mysqld for the first
C time.  So of *course* there's no password.

Cindy, You wrote that you reinstalled MySQL server. Are you sure that
there was no installed grant tables before running mysql_install_db?

C I finally noticed that the usernames didn't match -- the safe_mysqld
C script assumes username mysql, but I use mysql_att, etc for different
C machines.  So.  I fixed that, and reran safe_mysqld.  Now I get
C can't find host.frm.  Aha, I say.  I know what that is.  So I run
C the scripts/mysql_install_db.  That runs.  OK, cool, now I set the
C root password.

C [11:23am] root@attalus ./bin/mysqladmin -u root -p password '***'
C Enter password: ***
C ./bin/mysqladmin: connect to server at 'localhost' failed
C error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
C Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

C OK, so the sticky bit is set on the /tmp dir, so I'm guessing this is
C still a matter of an access problem.  But I thought the script
C took care of that.

1. Is your MySQL server running?
2. If MySQL server is running and file mysql.sock exists in the /tmp
dir, it's really a permission problem. It's not a MySQL permission problem,
it's a problems with permissions on file and dirs.
3. If MySQL server is running and file mysql.sock doesn't exist in
the /tmp dir, it means that socket file is created in another dir. You
should specify path to your socket file using --socket options or
editing my.cnf file. You can also create a symbolik link to your socket file.


C Thanks,
C --Cindy




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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




start up problem

2002-04-29 Thread Cindy


OK, it seems like every time I install mysql, I run smack dab into
some type of access problem -- if it isn't a password hangup, it's a
mysql.sock problem or (at the moment) a refusal to allow me to create
databases.  I've puzzled through most of it for now, but this one
has me stumped.

It's giving me perror 13, which is a write permission problem.  But
I've checked and double checked, and the data directory is indeed
writable by my mysql account:

mysql create database Text; use Text;
ERROR 1006: Can't create database 'Text'. (errno: 13)
mysql
Suspended
mysql_att mkdir /usr/local/mysql/data/Text
mysql_att ls
Text attalus.**.err  mysql

I've linked the /usr/local/mysql/data file to another filesystem
with a good deal more space, but that shouldn't be a problem (that's
how I set it up on another one of our machines).

Thoughts?

And while I'm at it, can someone also tell me what the heck the
/usr/local/mysql/var directory is all about?  Inevitably, the reason I
reinstall mysql all the time (binary dist) is because when I get back
to a machine and want to do something administrative about once a
quarter, it can't find things in the var directory, but I don't HAVE a
var directory.  (I think the source code dist creates that, but not
the binary code dist.)


Thanks,
--Cindy
-- 
[EMAIL PROTECTED]

-
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: start up problem

2002-04-29 Thread Steven Hajducko

The var dir is usually where the databases and logs go.  At least, from
the sources I've compiled, thats where it always gets stored.

On Mon, 2002-04-29 at 10:03, Cindy wrote:
 
 OK, it seems like every time I install mysql, I run smack dab into
 some type of access problem -- if it isn't a password hangup, it's a
 mysql.sock problem or (at the moment) a refusal to allow me to create
 databases.  I've puzzled through most of it for now, but this one
 has me stumped.
 
 It's giving me perror 13, which is a write permission problem.  But
 I've checked and double checked, and the data directory is indeed
 writable by my mysql account:
 
 mysql create database Text; use Text;
 ERROR 1006: Can't create database 'Text'. (errno: 13)
 mysql
 Suspended
 mysql_att mkdir /usr/local/mysql/data/Text
 mysql_att ls
 Text attalus.**.err  mysql
 
 I've linked the /usr/local/mysql/data file to another filesystem
 with a good deal more space, but that shouldn't be a problem (that's
 how I set it up on another one of our machines).
 
 Thoughts?
 
 And while I'm at it, can someone also tell me what the heck the
 /usr/local/mysql/var directory is all about?  Inevitably, the reason I
 reinstall mysql all the time (binary dist) is because when I get back
 to a machine and want to do something administrative about once a
 quarter, it can't find things in the var directory, but I don't HAVE a
 var directory.  (I think the source code dist creates that, but not
 the binary code dist.)
 
 
 Thanks,
 --Cindy
 -- 
 [EMAIL PROTECTED]
 
 -
 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




Re: start up problem

2002-04-29 Thread Cindy


Cindy writes:
 
 OK, it seems like every time I install mysql, I run smack dab into
 some type of access problem -- if it isn't a password hangup, it's a
 mysql.sock problem or (at the moment) a refusal to allow me to create
 databases.  I've puzzled through most of it for now, but this one
 has me stumped.

A bit of an update.  I've come around full circle, so I'm ready
to scream.

I finally noticed that the usernames didn't match -- the safe_mysqld
script assumes username mysql, but I use mysql_att, etc for different
machines.  So.  I fixed that, and reran safe_mysqld.  Now I get
can't find host.frm.  Aha, I say.  I know what that is.  So I run
the scripts/mysql_install_db.  That runs.  OK, cool, now I set the
root password.

[11:23am] root@attalus ./bin/mysqladmin -u root -p password '***'
Enter password: ***
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

.

OK, so the sticky bit is set on the /tmp dir, so I'm guessing this is
still a matter of an access problem.  But I thought the script
took care of that.

Getting dizzy from these circles,
--Cindy

-
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: start up problem

2002-04-29 Thread Steven Hajducko

Hey Cindy,

Usually you can get a better idea of the real problem by looking in the
hostname.err (where hostname is the hostname of your machine) file in
whatever directory you are storing your logs in.  Is there any info in
that file that you can post?

You can check to make sure another mysql.sock doesn't exist in /tmp
already ( Maybe one got created by the mysql_att user, and the mysql
user can't overwrite it. ).  That or you may want to shut down the
server, clear out any mysql.sock files in /tmp and restart the mysql
server.

--
sh


On Mon, 2002-04-29 at 11:28, Cindy wrote:
 
 Cindy writes:
  
  OK, it seems like every time I install mysql, I run smack dab into
  some type of access problem -- if it isn't a password hangup, it's a
  mysql.sock problem or (at the moment) a refusal to allow me to create
  databases.  I've puzzled through most of it for now, but this one
  has me stumped.
 
 A bit of an update.  I've come around full circle, so I'm ready
 to scream.
 
 I finally noticed that the usernames didn't match -- the safe_mysqld
 script assumes username mysql, but I use mysql_att, etc for different
 machines.  So.  I fixed that, and reran safe_mysqld.  Now I get
 can't find host.frm.  Aha, I say.  I know what that is.  So I run
 the scripts/mysql_install_db.  That runs.  OK, cool, now I set the
 root password.
 
 [11:23am] root@attalus ./bin/mysqladmin -u root -p password '***'
 Enter password: ***
 ./bin/mysqladmin: connect to server at 'localhost' failed
 error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
 Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
 
 .
 
 OK, so the sticky bit is set on the /tmp dir, so I'm guessing this is
 still a matter of an access problem.  But I thought the script
 took care of that.
 
 Getting dizzy from these circles,
 --Cindy
 
 -
 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




Re: start up problem

2002-04-29 Thread Cindy


Cindy writes:
 
 OK, it seems like every time I install mysql, I run smack dab into
 some type of access problem -- if it isn't a password hangup, it's a
 mysql.sock problem or (at the moment) a refusal to allow me to create
 databases.  I've puzzled through most of it for now, but this one
 has me stumped.


Now I'm getting:
mysql_att /usr/local/mysql/bin/mysqladmin -u root password '***'
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

The documentation on Access_denied does say:
If you get an error like the following:
shell mysqladmin -u root -p ver
Access denied for user: 'root@localhost' (Using password: YES)

It means that you are using a wrong password. See section 4.3.6
Setting Up Passwords. If you have forgot the root password, you can
restart mysqld with --skip-grant-tables to change the password.

But that's not quite the same command I used, and that's got password
YES.  And mind you, this is what I'm doing right after the
mysql_install_db script and starting up the safe_mysqld for the first
time.  So of *course* there's no password.

Spinning away,
--Cindy

-
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: start up problem

2002-04-29 Thread Frédéric COURCIER

Thanx for your answer.
I don't know how much I understand the way to follow because of my poor
english that will ever be a french one.
I think I have found a good solution in downloading a SQL compatible frontal
program that allowes me to work with a graphical interface very helpul for
starters like me.

Ha ve a nice day.

Frederic COURCIER

- Original Message -
From: Cindy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 29, 2002 9:16 PM
Subject: Re: start up problem



 Cindy writes:
  
  OK, it seems like every time I install mysql, I run smack dab into
  some type of access problem -- if it isn't a password hangup, it's a
  mysql.sock problem or (at the moment) a refusal to allow me to create
  databases.  I've puzzled through most of it for now, but this one
  has me stumped.


 Now I'm getting:
 mysql_att /usr/local/mysql/bin/mysqladmin -u root password '***'
 /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
 error: 'Access denied for user: 'root@localhost' (Using password: NO)'

 The documentation on Access_denied does say:
 If you get an error like the following:
 shell mysqladmin -u root -p ver
 Access denied for user: 'root@localhost' (Using password: YES)

 It means that you are using a wrong password. See section 4.3.6
 Setting Up Passwords. If you have forgot the root password, you can
 restart mysqld with --skip-grant-tables to change the password.

 But that's not quite the same command I used, and that's got password
 YES.  And mind you, this is what I'm doing right after the
 mysql_install_db script and starting up the safe_mysqld for the first
 time.  So of *course* there's no password.

 Spinning away,
 --Cindy

 -
 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