VectorLinux

Please login or register.

Login with username, password and session length
Advanced search  

News:

Visit our home page for VL info. For support and documentation, visit the Vector Linux Knowledge Center or search the Knowledge Center and this Forum using the search box above.

Author Topic: mysqld (SOLVED)  (Read 518 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 »
Logged
7.2 STD B2 built on Feb-01-2017
HP 670 Win7 & VL7.0

M0E-lnx

  • Administrator
  • Vectorian
  • *****
  • Posts: 3479
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
Logged

StrayBit

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