| RandomTroll |
08-08-2017 10:20 AM |
Initializing mysql
When I try to start it on my computer for the first time it reports:
Quote:
170807 19:56:35 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170807 19:56:35 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
170807 19:56:35 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
170807 19:56:35 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended
|
When I run mysql_upgrade it reports:
Quote:
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2 "No such file or directory")
FATAL ERROR: Upgrade failed
|
It seems that mysqld won't start without 'the mysql.plugin table',
which mysql_upgrade creates, but mysql_upgrade won't run because
there's no /var/run/mysql/mysql.sock , which mysqld creates: catch-22
mysql edition. I must be making a beginner's mistake. I'm using
MariaDB |
