Please support VectorLinux!

Author Topic: mysqld (SOLVED)  (Read 1668 times)

StrayBit

  • Vectorian
  • ****
  • Posts: 542
mysqld (SOLVED)
« on: May 15, 2017, 01:05:47 pm »
I finally am back to trying to get mysqld working.  I am in 7.2 STD B1.1 built on Dec-20-2016.
The data directory is /home/mysql which is owned by mysql.
Running
Quote
root:# mysqld --user=mysql
...
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
...
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2017-05-15T19:56:27.504478Z 0 [ERROR] Aborting
I can't run mysql_upgrade as mysqld isn't running!
I have googled mysql.user but the best I can find is to add a user.
Any suggestions?
« Last Edit: May 19, 2017, 08:28:15 am by StrayBit »
7.2 STD B2 built on Feb-01-2017
HP 670 Win7 & VL7.0

M0E-lnx

  • Administrator
  • Vectorian
  • *****
  • Posts: 3497
Re: mysqld
« Reply #1 on: May 18, 2017, 10:37:28 am »
How did you start the mysql daemon?  You should have chmod +x /etc/rc.d/rc.mysqld and then /etc/rc.d/rc.mysqld start

StrayBit

  • Vectorian
  • ****
  • Posts: 542
Re: mysqld
« Reply #2 on: May 19, 2017, 08:27:45 am »
Thanks MOE.
7.2 STD B2 built on Feb-01-2017
HP 670 Win7 & VL7.0