Discord Developer Mode
FiveM Color Codes
Install FFMPEG
Installing an EJS Website
Markdown Guide
MySQL Install Guide
NPM Accounts
NGINX Upload Limits
Node 16 Linux (nvm)
Screen Sessions (quick)
KoroxCAD API
Hyperz Documentation > Knowledgebase > MySQL Install Guide
MySQL Install Guide
This guide will explain how to INSTALL MySQL on different OS's
AVAILABLE OS's ¶
Windows ¶
Required Programs: ¶
XAMPP: ¶
- Go through the installer for XAMPP as you normally would.
- When complete, click the checkbox here:
- Then click the small start buttone here:
This should get the program to start using MySQL, and it should start console logging something like the below screenshot:
HeidiSQL: ¶
- First thing is to open HeidiSQL.
- It may look like this:
- So put hit new then put a name or something.
- The login details may be the same like this:
Hostname/IP = localhost, Username = root, Password = <Nothing>, Port = 3306
- Once the details have been entered then hit open.
- It may look like this:
- Right click on this bit:
- Then hit Create New then click New Database
- In the box put a database name you prefer then click ok
- Once the database has been made click files at the top left.
- Then hit load sql file or press
CTR + O
and choose all the sql files you need to execute. - Then it should look like this
- Then press the blue play button
- This will load all the tables and make then in your database.
Linux Ubuntu ¶
Start off by running this command to install the base of MySQL:
sudo apt install mysql-server
When prompted press Y
to install MySQL-Server.
Then lets login to MySQL:
sudo mysql
Then, lets set a password for your new MySQL Server!
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Changing your MySQL Password in Linux Ubuntu ¶
- Run
mysql -u root -p
- Enter your current password
- Enter the following commands
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'SETYOURPASSWORDHERE';
FLUSH PRIVILEGES;
- Then your password will be changed!
Create A MySQL Database ¶
- Run
mysql -u root -p
- Enter your current password
- Enter the following command:
CREATE DATABASE databasenamehere;
- Then you have made a MySQL Database
Import an SQL File ¶
- Run
mysql -u root -p
- Enter your current password
- Make sure you already have a database created
- Enter the following commands
use databasename;
source /path/to/your/file.sql
- To check that all the tables have been imported, run:
SHOW TABLES;
- Then you're done!
Was this article helpful?
48 out of 99 found this helpful