Error install MySql initial database

r3cursive · 03-30-2009, 03:31 PM

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!

willysr · 03-30-2009, 06:30 PM

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

r3cursive · 03-30-2009, 08:51 PM

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

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

r3cursive · 03-31-2009, 04:16 AM

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

mRgOBLIN · 03-31-2009, 05:22 AM

Try

Code:

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

Then see if it will start.

r3cursive · 03-31-2009, 05:40 AM

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??

SavoTU · 03-31-2009, 06:53 AM

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

r3cursive · 03-31-2009, 07:56 AM

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

SavoTU · 03-31-2009, 08:28 AM

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 .

bgeddy · 03-31-2009, 08:31 AM

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.

r3cursive · 03-31-2009, 09:14 AM

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

mRgOBLIN · 03-31-2009, 02:59 PM

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