NAT2K15 Development
DiscordStoreConfigGithubStatus Page
  • NAT2K15 Documentation
  • Paid Scripts
    • FiveM Framework
      • 💻Choose your hosting
        • 💻Windows Hosting
          • 🛢️MySQL Installation (xampp)
          • 🛢️MySQL Connection String
          • 👨‍💻Installing Framework
        • 🐧Linux Hosting
          • 🛢️MySQL Installation
          • 🛢️MySQL Connection String
          • 👨‍💻Installing Framework
        • 🎮Panel Hosting
      • 📋Framework Addons
        • FiveM Scoreboard
        • ☎️Framework 911 (paid)
        • 📲NPWD X Framework
          • 📋Editing NPWD Config
          • 🧠Installing npwd-framework
      • ✒️Change Logs
      • ✍️Developers Usage
        • Client Side Exports
        • Server Side Exports
      • ❌Frequent Issues
    • Personal Vehicle V2
      • Discord Bot Token
      • Installing Dependency
      • Editing the Config
    • FiveM Discord Whitelist
      • Discord Bot Token
      • Edit the config
  • FiveM vMenu Modification
  • FiveM Vehicle & Weapon Management System
    • Installing Dependency
    • Configuration Guide
  • FiveM Admin Zone
  • Paid Bots
    • Ticket Bot V2
      • 💻Windows Hosting Guide
        • 🛢️MySQL Installation (xampp)
        • 👨‍💻Installing Node.js
    • Multi Server Control
      • 💻Windows Hosting Guide
        • 👨‍💻Installing Node.js
        • 🚂Starting The Bot
Powered by GitBook
On this page

Was this helpful?

Edit on GitHub
  1. Paid Scripts
  2. FiveM Framework
  3. Choose your hosting
  4. 🐧Linux Hosting

🛢️MySQL Installation

Creating a local server environment on your Windows machine with XAMPP and setting up a database for FiveM involves a few steps. This guide will show you how to do it in no time!

Previous🐧Linux HostingNext🛢️MySQL Connection String

Last updated 1 year ago

Was this helpful?


Step 1: Update and Upgrade your linux machine

sudo update
sudo upgrade -y

This will take a little bit so give it sometime keep your SSH connection open while running this process.

Step 2: Installing mysql-server

sudo apt install mysql-server -y

Step 3: Connecting to mysql

Run the following command to get into the MySQL server in SSH

sudo mysql

Step 4: Assigning a password to the root account

Change password with the password you want the root account for this demo we used: COOLYou can generate a secure password by visiting this website

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'COOL';
FLUSH PRIVILEGES;
EXIT; 

Step 5: Logging back into your MySQL server after changing the password

sudo mysql -u root -p

Now enter your new password in this case it would be COOL

Step 6: Creating the FiveM database

CREATE DATABASE fivem;

Step 7: Exit

EXIT;

😊 Congratulations, you created your first database in a linux server.

💻
CLICK ME