Never mind. I figured it out. I had to run the install_db script as
mysql user.
Gobi wrote:
I find that I can start mysqld by using the "--skip-grant-tables"
option but as soon as I run mysqld without that option, it dies
again. I did try running "mysql_install_db --user=mysql" but when I
I find that I can start mysqld by using the "--skip-grant-tables" option
but as soon as I run mysqld without that option, it dies again. I did
try running "mysql_install_db --user=mysql" but when I did "mysqlshow
mysql", it was empty.
Any ideas on how to proceed?
Thanks,
Michael.
Gleb Paha
Hello.
Check that mysql_install_db filled mysql database in the same directory
as your datadir. See:
http://dev.mysql.com/doc/mysql/en/unix-post-installation.html
Gobi <[EMAIL PROTECTED]> wrote:
> Thanks for your reply. I confirmed that user and group, mysql, exists
> and performe
Thanks for your reply. I confirmed that user and group, mysql, exists
and performed the chown as instructed but same thing. Here is my log
again after I did this:
050810 23:18:09 mysqld started
050810 23:18:09 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
Inn
check if rpm creates mysql user and group.
then mysql_install_db, chown mysql:mysql /var/lib/mysql -R
and finally try starting mysqld again
t
>050810 20:26:52 [ERROR] Fatal error: Can't open privilege tables: Table
>'mysql.host' doesn't exist
>050810 20:26:52 mysqld ended
--
MySQL General Maili
I installed mysql from the following rpm packages:
mysql-4.1.10a-2.RHEL4.1
mysql-server-4.1.10a-2.RHEL4.1
I tried running 'mysqld start' and the server said startup failed. Here
is the mysq.log:
050810 20:26:48 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
Inno
Hi.
I am running Windows 98 and have installed MySQL 3.23.47 under
D:\Program Files\MySQL\. I created C:\my.cnf and it contains the
following:
[mysqld]
skip-innodb
basedir=D:/Program Files/MySQL/
datadir=E:/mysql/
When I start mysqld, I get the following in the error file:
D:\Program Files\MyS
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id: imamferianto
>Originator:root
>Organization: unsoed
>MySQL support: none
>Synopsis: cannot start mysqld
>Severity: critical
>Priority: high
>Category: mysql