LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Initializing mysql (https://www.linuxquestions.org/questions/linux-software-2/initializing-mysql-4175611561/)

RandomTroll 08-08-2017 11: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

AwesomeMachine 08-08-2017 11:40 AM

See this: https://dev.mysql.com/doc/refman/5.7...on-mysqld.html

RandomTroll 08-09-2017 07:48 PM

Its instructions don't work: mysqld no longer has an --initialize function; perhaps that page is outdated.

AwesomeMachine 08-10-2017 02:11 AM

Actually mysqld just added the initialize function. Try this: https://dev.mysql.com/doc/refman/5.7...nstall-db.html


All times are GMT -5. The time now is 11:08 AM.