VectorLinux

The nuts and bolts => Technical General => Topic started by: StrayBit on May 15, 2017, 01:05:47 pm

Title: mysqld (SOLVED)
Post by: StrayBit 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?
Title: Re: mysqld
Post by: M0E-lnx 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
Title: Re: mysqld
Post by: StrayBit on May 19, 2017, 08:27:45 am
Thanks MOE.