Land F/X
  • Portal
  • Products
    • Design F/X
    • Planting F/X
    • Irrigation F/X
    • F/X CAD
    • Plugin for Revit®
    • Plugin for SketchUp®
    • Lighting
    • Plugin for Rhino®
    • Manufacturer Connection
    • Academic
  • Support
  • Videos
  • Who We Are
  • Trial
  • Purchase
Land F/X
  • Portal
    • Dashboard
    • Account
    • Licenses
    • Data
    • Support
  • Products
    • Design F/X
      • Product
      • Features
      • Trial
      • Purchase
    • Planting F/X
      • Product
      • Features
      • Trial
      • Purchase
    • Irrigation F/X
      • Product
      • Features
      • Trial
      • Purchase
    • F/X CAD
    • Plugin for Revit®
    • Plugin for SketchUp®
    • Plugin for Rhino®
    • Site & Hardscape
    • Lighting
    • Manufacturer Connection
    • Academic
    • Purchase
  • Support
    • Knowledge Base
    • Documentation
    • Submit Ticket
    • Updates
    • Forum
    • Install
    • Remote Assistance
  • Videos
    • Power Tips
    • Webinars
  • Who We Are
    • Contact Us
    • Careers
    • Gallery
    • News
  1. Knowledge Base
  2. Installation Troubleshooting & Errors
  3. MySQL
  4. Error 1067 – When Starting Service

Replace a Broken MySQL Database

Issue

You need to replace a broken or corrupt MySQL database.

 

You may need to complete these steps because:

 

  • Your MySQL database may no longer be accessible. MySQL service may be running on your server, but your office workstations either fail to connect or present database errors, and connection information has been verified as accurate.
  • Your office had a power outage, or the server was not properly shut down, and the MySQL service was still running.

 

For further information, see the following articles:

  • MySQL Stops or Will Not Start
  • MySQL Errors and Troubleshooting

 

 

Solution

Important:

These steps should only be completed by an IT Administrator and will need to be performed on the machine running the MySQL service. Completing the steps below will erase all content in your Land F/X database and remove all projects, preferences, and templates.

 

1. Make sure you have a backup of all Land F/X projects, preferences and templates. If you do not have a recent backup in your Land FX/data/backup folder, you'll need to locate projects individually in the same folder directory where your DWGs are stored. Follow our steps to Import Project Data from .lfx or auto_projdata.lfx or a backup file.

 

 

2. Open the MySQL command line. Open the Start menu and either:

  • Search for MySQL in the list of programs, then launch the MySQL Command Line Client, or
  • Type MySQL into the search bar and select MySQL Command Line Client from the search results

 

 

 

3. With the command line open, you'll be prompted for a password. Type landfx, then press Enter.

Entering landfx as the password

 

 

 

MySQL Command Prompt

4. You'll now see a command prompt displaying MySQL>. Copy and paste the following text at the command prompt:

 

DROP DATABASE landfx;

 

Then press Enter.

 

 

 

5. Once the database has been removed, copy and paste the following text at the command prompt:

 

CREATE DATABASE landfx;

 

Then press Enter.

 

6. Grant access to the database:

 

  • If installing to a workstation (not a laptop): Copy and paste the following text at the command prompt:

 

GRANT ALL ON landfx.* TO 'ODBC';

 

Then press Enter.

 

 

  • If installing to a laptop: Copy and paste the following text at the command prompt:

 

GRANT ALL ON landfx.* to ''@'localhost';

 

NOTE: '' is not a double quote – it's two single quotes.

 

Then press Enter.

Command prompt commands

Contact

  • Land F/X
  • PMB 351
    3940 Broad St. STE 7
    San Luis Obispo, CA 93401
  • +1 805-541-1003
Email Logo Facebook Logo Instagram Logo LinkedIn Logo
Land F/X Logo

Our software tailors AutoCAD®, Revit®, and SketchUp® to the needs of landscape architects, irrigation designers, and other professionals. We automate your most tedious tasks and ensure accuracy, giving you more time to design.

  • Portal
  • Products
  • Support
  • Videos
  • Who We Are