I've installed mysql through
$ sudo apt-get install mysql-server-core-5.1 $ sudo apt-get install mysql-client-core-5.1
This is my current conf file
And the service won't start, at first the socket and var folders did not exist, I created the mysql user and mysql group as system accounts and gave ownership and full control to the directories specified in the conf file.
the I tried running the
mysqld as the mysql user:
$ sudo -u mysql mysqld
And I get I get the following error
120201 13:52:58 [Note] Plugin 'FEDERATED' is disabled. mysqld: Table 'mysql.plugin' doesn't exist 120201 13:52:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 120201 13:52:58 InnoDB: Initializing buffer pool, size = 8.0M 120201 13:52:58 InnoDB: Completed initialization of buffer pool 120201 13:52:58 InnoDB: Started; log sequence number 0 44233 120201 13:52:58 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Also I'tried running it like this:
$ sudo service mysql start
mysql: unrecognized service
Any suggestions are GREATLY appreciated.