Adding some more info.
I start up mysql with:
sudo mysqld --datadir=/var/lib/mysql --user=mysql --socket=/var/run/mysqld/mysqld.sock
On startup, I get a lot of errors like:
[ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
performance_schema is a database I used to have, but haven't been using, so I dropped it earlier as I was getting tons of startup errors related to it. Now I'm getting fewer of them, but still getting them(?).
I ran mysqlcheck on each database in there (information_schema, mysql, and mythconverg) and got all 'OK's.
I ran a mysqlcheck on performance_schema as well (the one I had dropped) but just got a blank back as expected.
I shut it down with mysqladmin shutdown -u root -p
Then I get:
mysqladmin: query failed; error: 'Table 'performance_schema.session_variables' doesn't exist'
No idea why it's doing anything with that database on shutdown, or why it's doing anything with that database at /all/.
I still get no errors in the error log when trying to start with systemctl start mysql. Just the same errors above from status and journalctl.
To check the my.cnf, I added '--defaults-file=/etc/mysql/my.cnf' as the first argument to start it up, and I get the same stuff. It starts, but with loads of performance_schema errors and then is ready for connections (and everything seems to work).
The only interesting thing here is that each time I connect, it tells me my password has expired and I need to change it. So I do (set password = password('newpass')) and that works again. Not sure if this is an artifact of starting it manually like this or what.
I start up mysql with:
sudo mysqld --datadir=/var/lib/mysql --user=mysql --socket=/var/run/mysqld/mysqld.sock
On startup, I get a lot of errors like:
[ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
performance_schema is a database I used to have, but haven't been using, so I dropped it earlier as I was getting tons of startup errors related to it. Now I'm getting fewer of them, but still getting them(?).
I ran mysqlcheck on each database in there (information_schema, mysql, and mythconverg) and got all 'OK's.
I ran a mysqlcheck on performance_schema as well (the one I had dropped) but just got a blank back as expected.
I shut it down with mysqladmin shutdown -u root -p
Then I get:
mysqladmin: query failed; error: 'Table 'performance_schema.session_variables' doesn't exist'
No idea why it's doing anything with that database on shutdown, or why it's doing anything with that database at /all/.
I still get no errors in the error log when trying to start with systemctl start mysql. Just the same errors above from status and journalctl.
To check the my.cnf, I added '--defaults-file=/etc/mysql/my.cnf' as the first argument to start it up, and I get the same stuff. It starts, but with loads of performance_schema errors and then is ready for connections (and everything seems to work).
The only interesting thing here is that each time I connect, it tells me my password has expired and I need to change it. So I do (set password = password('newpass')) and that works again. Not sure if this is an artifact of starting it manually like this or what.
The combination of the LAMP is L-Linux operating system, A-Apache web server, M-MySQL database, P-PHP. In Apache web server installed in Linux operating system, MySQL database stores the site data, and PHP processes dynamic content. Here, I am going to show you how to install LAMP on Ubuntu. Basic Requirements.