mysql installation

[mikeng]

I am trying to install mysql, I guess the latest version installed is mysql-5.5.19-1

I can't get it to start and been shifting around the internet with no results, anyone has any similar trouble and resolved it??

I already tried uninstalling and reinstalling to no avail.

I am already logged on as root, so I am assuming I am starting it as such...
$this->bbcode_second_pass_code('', ' mysqld --verbose
111214 10:28:10 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

111214 10:28:10 [ERROR] Aborting

111214 10:28:10 [Note] mysqld: Shutdown complete')

[pepedog]

From here
https://wiki.archlinux.org/index.php/MySQL
After installing MySQL, you should run the setup script as root:
rc.d start mysqld && mysql_secure_installation
Then restart MySQL:
rc.d restart mysqld
To start MySQL automatically at boot, edit /etc/rc.conf and add mysqld to the DAEMONS array.

[mikeng]

that is the instructions i followed actually, but it fails...

[mikeng]

Solved:

After stumbling through the mysql log file, in my case under

$this->bbcode_second_pass_code('', '/var/lib/mysql/alarm.err')

and I see this error

$this->bbcode_second_pass_code('', 'InnoDB: The InnoDB memory heap is disabled')

edit file:

$this->bbcode_second_pass_code('', '/etc/mysql/my.cnf')

uncomment out the innodb section... and then followed steps through the guide....

$this->bbcode_second_pass_code('', '# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /var/lib/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50')

[WarheadsSE]

I might suggest just turning off InnoDB entirely.

[mikeng]

mysql doesn't start without it, it seems? I assume you are saying that for performance issues? Is there a way around mysql being dependent on innodb and not starting? thanks...

Some of the documentation I have read on mysql 5.5 says innodb is the default storage engine, but not sure why these options are turned off by default...

[Geoff]

$this->bbcode_second_pass_quote('mikeng', '
')$this->bbcode_second_pass_code('', 'InnoDB: The InnoDB memory heap is disabled')

[ZzyzxOh]

The Secure Installation seems to step you through the easiest path to getting things up and running without leaving things wide open to unauthorized use. You can certainly configure without it.

That said, it would be nice if it handled the config file changes that enable InnoDB.