LinuxQuestions.org - Error install MySql initial database

- Slackware (https://www.linuxquestions.org/questions/slackware-14/)

- - Error install MySql initial database (https://www.linuxquestions.org/questions/slackware-14/error-install-mysql-initial-database-715576/)

Error install MySql initial database

hallo slackware gurus

a problem come, when i want to install an initial database
i had read instruction on /etc/rc.d/rc.mysqld to run this as root

Code:

mysql_install_db --user=mysql

but after execute this command, i got this

Code:

root@Rachel:~# mysql_install_db --user=mysql

Installing MySQL system tables...

090729  3:47:30 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

090729  3:47:30 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

/usr/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)

090729  3:47:30 [ERROR] Aborting



090729  3:47:30 [Note] /usr/libexec/mysqld: Shutdown complete



Installation of system tables failed!



Examine the logs in /var/lib/mysql for more information.

You can try to start the mysqld daemon with:

/usr/libexec/mysqld --skip-grant &

and use the command line tool

/usr/bin/mysql to connect to the mysql

database and look at the grant tables:



shell> /usr/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 /usr/bin/mysqlbug script!

whats wrong with MySql??
Thanks before!

Can you please give information about MySQL version and Slackware version?

^ wah ternyata ada bang willy..makasih bang dah di respone

ok, i used slackware 12.2 and mysql-5.0.67-i486-1

hope someone can help..i really stuck in here..

Try

Code:

chown -R mysql:mysql /var/lib/mysql

Then see if it will start.

thanks for your respone mRgOBLIN

itry it and i got this

Code:

Installing MySQL system tables...

090729 18:03:39 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

090729 18:03:39 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

OK

Filling help tables...

090729 18:03:39 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

090729 18:03:39 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

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:

/usr/bin/mysqladmin -u root password 'new-password'

/usr/bin/mysqladmin -u root -h Rachel password 'new-password'



Alternatively you can run:

/usr/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 /usr ; /usr/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 /usr/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

there is no error like before. but, what meaning of warning in here??

Its not an error just run mysql

/etc/rc.d/rc.mysqld start

Keep a note of the commands mine are building up and come in very useful when you reinstall or upgrade.

Sav

thanks for your respone SavoTU

so, what the meaning of this??

Code:

090729 18:03:39 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

090729 18:03:39 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

OK

Filling help tables...

090729 18:03:39 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

090729 18:03:39 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

OK

I don't think that it is anything to worry about looks like its just setting its self up to me?

Sorry i am no expert still consider my self a newbie to Linux something i was going to make my own thread about in a minute .

This is the default value that is assigned to max_join_size if none is supplied in any of the configuration files.

It defaults to a value that is too large. This is an know bug and is talked about on the MySql forum here.

oh i see..thank for the explanation bgeddy..

Yes just copy one of the /etc/my-{huge,large,medium,small}.cnf files to /etc/my.cnf