Re: Binary install instructions wrong?
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?
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
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
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