Re: Binary install instructions wrong?

2003-12-18 Thread Dave Best
  Has anyone done this before?   I can't be the only one that likes custom
paths/directories! :)



[EMAIL PROTECTED]
Thanks to the remote control I have the attention span of a gerbil!
There are 10 types of people in the world.  Those who understand binary,
and those who don't.
- Original Message - 
From: Dave Best [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 11:57 PM
Subject: Binary install instructions wrong?


 Hey all,

 I don't like the default locations that mysql tries to install into..
I
 like putting stuff in user accounts, with a version directory.  Easier to
 maintain, yada yada.

 Anyways, as per the instructions you have to change a path in
 ./bin/mysqlaccess

 I did this but when I run the scripts/mysql_install_db I get the
 following...  What am I missing?


 mkdir: cannot create directory `/var/lib/mysql': Permission denied
 chmod: failed to get attributes of `/var/lib/mysql': No such file or
 directory
 mkdir: cannot create directory `/var/lib/mysql/mysql': No such file or
 directory
 chmod: failed to get attributes of `/var/lib/mysql/mysql': No such file or
 directory
 mkdir: cannot create directory `/var/lib/mysql/test': No such file or
 directory
 chmod: failed to get attributes of `/var/lib/mysql/test': No such file or
 directory
 Preparing db table
 Preparing host table
 Preparing user table
 Preparing func table
 Preparing tables_priv table
 Preparing columns_priv table
 Installing all prepared tables
 031217 23:57:16  Warning: Can't create test file
 /var/lib/mysql/localhost.lower-test
 ./bin/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)
 031217 23:57:16  Aborting

 031217 23:57:16  ./bin/mysqld: Shutdown Complete

 Installation of grant tables failed!

 Examine the logs in /var/lib/mysql for more information.
 You can also try to start the mysqld daemon with:
 ./bin/mysqld --skip-grant 
 You can use the command line tool
 ./bin/mysql to connect to the mysql
 database and look at the grant tables:

 shell ./bin/mysql -u root mysql
 mysql show tables

 Try 'mysqld --help' if you have problems with paths. Using --log
 gives you a log in /var/lib/mysql that may be helpful.

 The latest information about MySQL is available on the web at
 http://www.mysql.com
 Please consult the MySQL manual section: 'Problems running
 mysql_install_db',
 and the manual section that describes problems on your OS.
 Another information source is the MySQL email archive.
 Please check all of the above before mailing us!
 And if you do mail us, you MUST use the ./bin/mysqlbug script!



 
 [EMAIL PROTECTED]
 Thanks to the remote control I have the attention span of a gerbil!
 There are 10 types of people in the world.  Those who understand binary,
 and those who don't.



 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Binary install instructions wrong?

2003-12-17 Thread Dave Best
Hey all,

I don't like the default locations that mysql tries to install into.. I
like putting stuff in user accounts, with a version directory.  Easier to
maintain, yada yada.

Anyways, as per the instructions you have to change a path in
./bin/mysqlaccess

I did this but when I run the scripts/mysql_install_db I get the
following...  What am I missing?


mkdir: cannot create directory `/var/lib/mysql': Permission denied
chmod: failed to get attributes of `/var/lib/mysql': No such file or
directory
mkdir: cannot create directory `/var/lib/mysql/mysql': No such file or
directory
chmod: failed to get attributes of `/var/lib/mysql/mysql': No such file or
directory
mkdir: cannot create directory `/var/lib/mysql/test': No such file or
directory
chmod: failed to get attributes of `/var/lib/mysql/test': No such file or
directory
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
031217 23:57:16  Warning: Can't create test file
/var/lib/mysql/localhost.lower-test
./bin/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 2)
031217 23:57:16  Aborting

031217 23:57:16  ./bin/mysqld: Shutdown Complete

Installation of grant tables failed!

Examine the logs in /var/lib/mysql for more information.
You can also try to start the mysqld daemon with:
./bin/mysqld --skip-grant 
You can use the command line tool
./bin/mysql to connect to the mysql
database and look at the grant tables:

shell ./bin/mysql -u root mysql
mysql show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running
mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!




[EMAIL PROTECTED]
Thanks to the remote control I have the attention span of a gerbil!
There are 10 types of people in the world.  Those who understand binary,
and those who don't.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Gah, mysql and PHP woes

2002-10-19 Thread Dave Best
I hope this is the right mailing list so here goes..

Anyone have any good information on how to setup PHP and mysql?

I downloaded the latest mysql binaries and placed them in
/usr/local/mysql

php was already installed on my system, redhat 7.2 but for some reason it
couldn't find any of the mysql functions.

I noticed when I looked at the config php, for mysql php was pointing to
/usr

So I downloaded the latest php, ./configure --with_mysql /usr/local/mysql
(or whatever the parameter is), installed it, but yet more problems with
libraries.

Anyways, I tried so many different things and ran into so many problems I
won't include them all here...

But does anyone out there have a step by step guide to get this running?

Thanks.


-
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: Gah, mysql and PHP woes

2002-10-19 Thread Dave Best
   I can get PHP to work fine, its just the mysql functions...

The PHP setting --with_mysql points to /usr but its installed in /usr/local.
The only way I found to change this is to recompile PHP but then I run into
a multitude of problems for some reason.

If you could send me that, it would be great.

Thanks.
- Original Message -
From: Mertens Bram [EMAIL PROTECTED]
To: mysql mailing list [EMAIL PROTECTED]
Sent: Saturday, October 19, 2002 9:06 AM
Subject: Re: Gah, mysql and PHP woes


 On Sat, 2002-10-19 at 07:04, Dave Best wrote:
  Anyone have any good information on how to setup PHP and mysql?

 [snip]

 I followed the instructions from the Create dynamic sites with PHP 
 MySQL I downloaded from http//www.ibm.com/developerWorks (you have to
 register first).

 If you want I can mail it to you off-list (it's a pdf file), but if you
 follow the online version you can copy-paste the example code (saves a
 lot of time and typos!).

 However I must add PHP and apache were already installed on my RH7.3
 system, and I only had some probs with apache...

 HTH
 --
  #  Mertens Bram M8ram [EMAIL PROTECTED]   Linux User #249103  #
  #  Red Hat Linux 7.3  KDE 3.0.0-10  kernel 2.4.18-3  i686  128MB RAM  #


 -
 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