[Solved]: mysql5-server install - FATAL ERROR: Could not find fill_help_tables.sql inside --basedir

[Bill Hernandez]

On Jul 9, 2009, at 6:47 PM, Chris Janton wrote:

> On 2009-07-09 , at 13:59 , Bill Hernandez wrote:
>
>> TRY THE PRIMARY METHOD :
>> [2009.22.06](07:59AM) -> [roscoe] ~	 $ sudo -u mysql  
>> mysql_install_db5
>> Password:
>
>
> what happens if you try
>
> sudo -u mysql mysql_install_db5 --basedir=/opt/local/share/mysql5/ 
> mysql
>
> also - on my 10.5.x system the mysql username (already there from  
> Apple) is
>
> 	_mysql
>
> note the leading underscore.
>
> 8)
> ----------------------------------
> Chris Janton  - face at CentosPrime dot COM
> Netminder for Opus1.COM

Chris,

I had not tried re-installing mysql.server for the last couple of  
weeks, because I was waiting to hear back once it had been fixed, but  
after I got your message I installed macports, apache2, and  
mysql.server and apparently the "help tables" problem has been fixed  
since my last attempt.

This time everything worked, at least so far....

As usual, thanks for the great help,

Bill Hernandez
Plano, Texas

[2009.10.07](08:48AM) -> [roscoe] ~  $ sudo -u mysql mysql_install_db5
Password:
  ---> Installing MySQL system tables...
  ---> 090710  9:00:45 [Warning] option 'max_join_size': unsigned  
value 18446744073709551615 adjusted to 4294967295
  ---> 090710  9:00:45 [Warning] option 'max_join_size': unsigned  
value 18446744073709551615 adjusted to 4294967295
  ---> 090710  9:00:45 [Warning] Setting lower_case_table_names=2  
because file system for /opt/local/var/db/mysql5/ is case insensitive
  ---> OK
  ---> Filling help tables...
  ---> 090710  9:00:45 [Warning] option 'max_join_size': unsigned  
value 18446744073709551615 adjusted to 4294967295
  ---> 090710  9:00:45 [Warning] option 'max_join_size': unsigned  
value 18446744073709551615 adjusted to 4294967295
  ---> 090710  9:00:45 [Warning] Setting lower_case_table_names=2  
because file system for /opt/local/var/db/mysql5/ is case insensitive
  ---> OK

  ---> To start mysqld at boot time you have to copy
  ---> support-files/mysql.server to the right place for your system

  ---> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
  ---> To do so, start the server, then issue the following commands:
  ---> /opt/local/lib/mysql5/bin/mysqladmin -u root password 'new- 
password'
  ---> /opt/local/lib/mysql5/bin/mysqladmin -u root -h eagle.local  
password 'new-password'

  ---> Alternatively you can run:
  ---> /opt/local/lib/mysql5/bin/mysql_secure_installation

  ---> which will also give you the option of removing the test
  ---> databases and anonymous user created by default.  This is
  ---> strongly recommended for production servers.

  ---> See the manual for more instructions.

  ---> You can start the MySQL daemon with:
  ---> cd /opt/local ; /opt/local/lib/mysql5/bin/mysqld_safe &

  ---> You can test the MySQL daemon with mysql-test-run.pl
  ---> cd mysql-test ; perl mysql-test-run.pl

  ---> Please report any problems with the /opt/local/lib/mysql5/bin/ 
mysqlbug script!

  ---> The latest information about MySQL is available on the web at
  ---> http://www.mysql.com
  ---> Support MySQL by buying support/licenses at http://shop.mysql.com

[2009.10.07](09:00AM) -> [roscoe] ~  $
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20090710/2642e137/attachment.html>