I assume that you have already installed XAMPP in your Ubuntu OR Linux machine.
If not, then you may follow this link to do so: https://www.devopsschool.com/blog/installing-xampp-7-4-xxx-on-ubuntu/
NOTE: I also assume that, you are going to use the MySQL database that comes with XAMPP for doing database interactions from the applications you are going to host on the XAMPP server of the Ubuntu or Linux machine
Why it is needed?
Ans: After installing XAMPP in Ubuntu or Linux machine, you might need to create databases or the database users to access them from the application you are planning to deploy on Ubuntu’s XAMPP.
In order to do any database related stuff you need to execute the commands start with
Sample mysql commands:
mysql -u root -p
create user 'user_name'@'localhost' identified by 'password';
GRANT ALL PRIVILEGES ON * . * TO 'user_name'@'localhost';
SHOW GRANTS user_name;
create database database_name;
What happens with MySQL after you install XAMPP in a brand new Ubuntu or Linux machine?
Ans: It throws Command not found error
Temporary Solution: Run command:
Step 1: Open .profile file in ubuntu user directory using command:
sudo vi .profile
Step 2: Add the following line at the end of the .profile file in the vi editor
Step 3: Save the file by press
ESC followed by
Step 4: Restart XAMPP server just to make sure it’s up and running:
sudo /opt/lampp/lampp restart
Step 5: Test if it’s working by running the below command:
mysql -u root -p
Refer the below screenshot to verify:
That’s it! I hope you enjoyed the article.
- MyHospitalNow.com – PROD | Clean all patient user and related quote, bid and file data - March 21, 2020
- Sending Email with attachments in Laravel 5.5 using and PHP & JQuery - February 20, 2020
- How to run php artisan queue:listen in background on Ubuntu or Linux machine - February 6, 2020