LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 08-08-2017, 10:20 AM   #1
RandomTroll
Senior Member
 
Registered: Mar 2010
Distribution: Slackware
Posts: 1,963

Rep: Reputation: 271Reputation: 271Reputation: 271
Initializing mysql


When I try to start it on my computer for the first time it reports:

Quote:

170807 19:56:35 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170807 19:56:35 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
170807 19:56:35 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
170807 19:56:35 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended
When I run mysql_upgrade it reports:

Quote:
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2 "No such file or directory")
FATAL ERROR: Upgrade failed
It seems that mysqld won't start without 'the mysql.plugin table',
which mysql_upgrade creates, but mysql_upgrade won't run because
there's no /var/run/mysql/mysql.sock , which mysqld creates: catch-22
mysql edition. I must be making a beginner's mistake. I'm using
MariaDB
 
Old 08-08-2017, 10:40 AM   #2
AwesomeMachine
LQ Guru
 
Registered: Jan 2005
Location: USA and Italy
Distribution: Debian testing/sid; OpenSuSE; Fedora; Mint
Posts: 5,524

Rep: Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015
See this: https://dev.mysql.com/doc/refman/5.7...on-mysqld.html
 
Old 08-09-2017, 06:48 PM   #3
RandomTroll
Senior Member
 
Registered: Mar 2010
Distribution: Slackware
Posts: 1,963

Original Poster
Rep: Reputation: 271Reputation: 271Reputation: 271
Its instructions don't work: mysqld no longer has an --initialize function; perhaps that page is outdated.
 
Old 08-10-2017, 01:11 AM   #4
AwesomeMachine
LQ Guru
 
Registered: Jan 2005
Location: USA and Italy
Distribution: Debian testing/sid; OpenSuSE; Fedora; Mint
Posts: 5,524

Rep: Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015Reputation: 1015
Actually mysqld just added the initialize function. Try this: https://dev.mysql.com/doc/refman/5.7...nstall-db.html
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] RT mysql database initializing error procfs Linux - Software 1 07-08-2012 12:12 PM
mysqld failed. the error was: initializing MySQL database. avnat Linux - Newbie 5 03-18-2011 11:58 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 03:35 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:36 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration