MySQL Forums
Forum List  »  Newbie

Cann not start server
Posted by: Ronald Fischer
Date: November 05, 2015 06:02AM

I have installed the Cygwin version of MySql and want to run the server for the first time. Running

mysqld

results in the following output:


151105 12:45:59 [Note] mysqld (mysqld 5.5.45) starting as process 9844 ...
151105 12:45:59 [Warning] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is
case insensitive
151105 12:45:59 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
151105 12:45:59 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
151105 12:45:59 InnoDB: The InnoDB memory heap is disabled
151105 12:45:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151105 12:45:59 InnoDB: Compressed tables use zlib 1.2.8
151105 12:45:59 InnoDB: Initializing buffer pool, size = 128.0M
151105 12:45:59 InnoDB: Completed initialization of buffer pool
151105 12:45:59 InnoDB: highest supported file format is Barracuda.
151105 12:45:59 InnoDB: Waiting for the background threads to start
151105 12:46:00 InnoDB: 5.5.45 started; log sequence number 1595675
151105 12:46:00 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151105 12:46:00 [Note] - '0.0.0.0' resolves to '0.0.0.0';
151105 12:46:00 [Note] Server socket created on IP: '0.0.0.0'.
151105 12:46:00 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't
exist


I therefore executed

mysql_upgrade

(though I don't understand, why I should upgrade, if I have it installed just now), and now get the error messages

Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed



What do I have to do in order to get the server running?

Options: ReplyQuote


Subject
Written By
Posted
Cann not start server
November 05, 2015 06:02AM
November 05, 2015 12:41PM
November 06, 2015 01:43AM
November 06, 2015 12:22PM
November 09, 2015 05:18AM
November 09, 2015 11:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.