look alike dating service - Starting mysql manager of pid file quit without updating fi

by  |  27-Feb-2018 16:24

101112 Inno DB: Initializing buffer pool, size = 128.0M 101112 Inno DB: Completed initialization of buffer pool 101112 Inno DB: highest supported file format is Barracuda.101112 Inno DB: 1.1.3 started; log sequence number 1589404 101112 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.proxies_priv' doesn't exist 101112 mysqld_safe mysqld from pid file /var/db/mysql/ ended Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock' Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/tmp/mysql.sock' mysql.columns_priv OK OK mysql.event OK OK mysql.general_log OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK OK mysql.ndb_binlog_index OK mysql.plugin OK OK mysql.procs_priv OK mysql.servers OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK OK Running 'mysql_fix_privilege_tables'...I practice public speaking, travel quite a bit and have a big passion in entrepreneurship. Avoiding danger is no safer in the long run than outright exposure.

Inform us if you still get same error after removing pid file.

Please remove pid file manually, then start mysqld.

It's always a laugh or three when talking to Jeff and since this was a critical server (high traffic) I thought first to call him to see if he has hit this yet...

and in fact he had, however it would be nice to understand the exact details here and how we can prevent this for the common user in the future.

If you are getting this error when you try to start mysql server, mysql is having a problem with one of the variables that you have in its configuration file

Community Discussion