You can't tell me this isn't in the archives.
Since you didn't run it as
mysql_install_db --user=mysql
the databases were created with the wrong owner.
chown -R mysql /usr/local/mysql/var ( or whatever it is on your system )
I wish mysql_install_db would error out and complain if no user is
specified!
Jerry Davis wrote:
>
> On system: SuSE 7.1 Professional
> MySql version: Ver 3.23.32 for pc-linux-gnu on i686
>
> have also run the mysql_install_db, which says that all files have been
> installed.
>
> when running safe_mysql &
>
> 1) mysqld errors out
> 2) I get the following in linux.err
>
> Jerry
> --------------------------------------------------------------
>
> To see what values a running MySQL server is using, type
> 'mysqladmin variables' instead of 'mysqld --help'.
> The default values (after parsing the command line arguments) are:
>
> basedir: /usr/
> datadir: /var/lib/mysql/
> tmpdir: /tmp/
> language: /usr/share/mysql/english/
> pid file: /var/lib/mysql/linux.pid
> binary log:
> binary log index:
> TCP port: 3306
> Unix socket: /var/lib/mysql/mysql.sock
>
> system locking is not in use
>
> Possible variables for option --set-variable (-O) are:
> back_log current value: 50
> binlog_cache_size current value: 32768
> connect_timeout current value: 5
> delayed_insert_timeout current value: 300
> delayed_insert_limit current value: 100
> delayed_queue_size current value: 1000
> flush_time current value: 0
> interactive_timeout current value: 28800
> join_buffer_size current value: 131072
> key_buffer_size current value: 16773120
> long_query_time current value: 10
> lower_case_table_names current value: 0
> max_allowed_packet current value: 1047552
> max_binlog_cache_size current value: 4294967295
> max_connections current value: 100
> max_connect_errors current value: 10
> max_delayed_threads current value: 20
> max_heap_table_size current value: 16777216
> max_join_size current value: 4294967295
> max_sort_length current value: 1024
> max_tmp_tables current value: 32
> max_write_lock_count current value: 4294967295
> myisam_sort_buffer_size current value: 8388608
> net_buffer_length current value: 7168
> net_retry_count current value: 10
> net_read_timeout current value: 30
> net_write_timeout current value: 60
> open_files_limit current value: 0
> query_buffer_size current value: 0
> record_buffer current value: 131072
> slow_launch_time current value: 2
> sort_buffer current value: 524280
> table_cache current value: 64
> thread_concurrency current value: 10
> thread_cache_size current value: 0
> tmp_table_size current value: 1048576
> thread_stack current value: 65536
> wait_timeout current value: 28800
> 010307 18:59:03 mysqld ended
>
> 010308 06:43:43 mysqld started
> 010308 6:43:43 /usr/sbin/mysqld: Table 'mysql.host' doesn't exist
> 010308 06:43:43 mysqld ended
>
> 010308 17:48:08 mysqld started
> 010308 17:48:08 /usr/sbin/mysqld: Can't find file: './mysql/host.frm'
> (errno: 13)
> 010308 17:48:08 mysqld ended
>
>
>
> --
> Boycott the outlaw Microsoft - and use Linux - the Software that gives you
> Freedom to choose!
>
> ---------------------------------------------------------------------
> 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