xampp install, acces mysql - playmakermz/warkop-website GitHub Wiki

To install XAMPP on Ubuntu, you can try the following steps:

  • Download the XAMPP package for Linux from the official Apache Friends website
  • Open the terminal, move to the XAMPP download folder, and assign permission using “chmod” in the command
  • Launch the installer using the command ./xampp-linux-x64-8.0.28-0-installer.run
  • Complete the installation by hitting the “Forward” button in the XAMPP window
  • Launch XAMPP using the command
sudo /opt/lampp/lampp start 
  • Verify the XAMPP installation by opening a web browser and navigating to http://localhost

To acces mysql

To access MySQL from the terminal on Ubuntu, you can try these steps:

  • Go to the folder
cd /opt/lampp/bin/
  • Call
mysql -u root
  • If you get a notification that the command is unknown, add the following line to your .bashrc file:
  • export PATH=/opt/lampp/bin/:$PATH
export PATH=/opt/lampp/bin/:$PATH
  • Close and source the file with:
  • source ~/.bashrc
source ~/.bashrc
  • If there are no errors from the source command, you can try mysql -u root -p from your terminal
mysql -u root -p

Mysql configure ( my.ini | windows )

ini adalh untuk ubuntu

locate my.cnf // /opt/lampp/etc/my.cnf

ref: https://askubuntu.com/questions/1210249/where-is-mysqls-configuration-file-in-ubuntu-server-18-04

Reference