Re: MySQL with Redhat 7.1

2001-07-23 Thread Trond Eivind Glomsrød

[EMAIL PROTECTED] writes:

 I have installed Redhat Linux 7.1 with the supplied MySQL distribution
 (3.23.36?). I've run the mysql_install_db script, but when I try to start
 MySQL using ./bin/safe_mysqld --user=mysql , from the installation directory,
 MySQL starts then ends immedately (MySQL ends) without an error!!

1) Don't run mysql_install_db or safe_mysqld directly - use service
   mysqld start, it will automatically initialize the database

2) When you run mysql_install_db, you create the files as root -
   later, you try to run the database as mysql. This user won't have
   access to your files.

To fix it, do chown -R mysql.mysql /var/lib/mysql. And you should
run mysql with service mysqld start in the future - or just enable
it by default, with chkconfig mysqld on

-- 
Trond Eivind Glomsrød
Red Hat, Inc.

-
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 on RedHat 7.1.

2001-07-16 Thread Dvoek Michal

Hi,

try check your permission in your MySQL and in scripts.

S pozdravem
   Michal Dvoracek   [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: MYSQL on RedHat 7.1.

2001-07-16 Thread Milos Rackov

Most likely that there is a problem with where PHP and Java are looking for
the socket. One more possibility (I don't know for Java, but for PHP) - you
need to install a php-mysql (or mysql-php) package.

Regards,

Milos Rackov

 From: Kalpesh Modha [mailto:[EMAIL PROTECTED]]
 Sent: Monday, July 16, 2001 4:04 PM
 To: [EMAIL PROTECTED]
 Subject: MYSQL on RedHat 7.1.


 Hello.

 I am trying to get mysql working on RedHat 7.1 and it works fine however,
 when I try to make a local connection from either Java or PHP.  I get a
 connection refused message.  Whats missing ?

 Thanks for your help in advance.

 Regards
 Kal.



-
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 on RedHat 7.1.

2001-07-16 Thread Nils O. Selåsdal

On Monday 16 July 2001 15:03, Kalpesh Modha wrote:
 Hello.

 I am trying to get mysql working on RedHat 7.1 and it works fine however,
 when I try to make a local connection from either Java or PHP.  I get a
 connection refused message.  Whats missing ?

 Thanks for your help in advance.
You need to grant the user you are connecting as the appropriate rights from 
the appropriate host. The jdbc driver uses the default mysql port when 
connecting(check that mysql are listening to the default port), and if you 
also connect from the same machine as you run the server, the client will be 
connecting from 'localhost', or the hostname of your computer, the stacktrace 
from your javaprogram, or a mysql logfile should tell you which host. So you 
need to grant the user in question the  right to connect to the server from 
'localhost'. MySQL manual will tell you how to fo that.

-- 
Nils O. Selåsdal

-
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