{"id":9788,"date":"2020-01-31T03:53:06","date_gmt":"2020-01-31T03:53:06","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=9788"},"modified":"2020-05-27T08:20:58","modified_gmt":"2020-05-27T08:20:58","slug":"how-to-link-mysql-from-xampp-opt-lampp-bin-to-use-mysql-command-from-any-directory-in-ubuntu-or-linux","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-link-mysql-from-xampp-opt-lampp-bin-to-use-mysql-command-from-any-directory-in-ubuntu-or-linux\/","title":{"rendered":"How to link MySQL from XAMPP (\/opt\/lampp\/bin) to use mysql command from any directory in Ubuntu or Linux"},"content":{"rendered":"\n

Assumption:<\/strong>
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\/<\/a>
and
https:\/\/www.devopsschool.com\/blog\/how-to-link-php-from-xampp-installation-to-use-php-command-from-user-or-any-other-directory-in-ubuntu-or-linux\/<\/a>

NOTE:<\/strong> 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?<\/strong>
Ans: <\/strong>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 mysql<\/strong><\/code>

Sample mysql commands<\/strong>:
mysql
which mysql
mysql -u root -p
show databases;
create user 'user_name'@'localhost' identified by 'password';
GRANT ALL PRIVILEGES ON * . * TO 'user_name'@'localhost';
FLUSH PRIVILEGES;
SHOW GRANTS user_name;
create database database_name;<\/code>

What happens with MySQL after you install XAMPP in a brand new Ubuntu or Linux machine?<\/strong><\/p>\n\n\n\n

Ans:<\/strong> It throws Command not found error<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Temporary Solution<\/span>:<\/strong> Run command:
export PATH=$PATH:\/opt\/lampp\/bin<\/strong><\/code><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Permanent Solution:<\/span><\/strong>
Step 1:<\/strong> Open .profile<\/strong> file in ubuntu <\/strong>user directory using command: sudo vi .profile<\/strong><\/code>
Step 2<\/strong>: Add the following line at the end of the .profile<\/strong> file in the vi editor
export PATH=$PATH:\/opt\/lampp\/bin <\/strong><\/code>
Step 3:<\/strong> Save the file by press ESC <\/strong><\/code>followed by :wq<\/code><\/strong> commands
Step 4:<\/strong> Restart XAMPP server just to make sure it’s up and running:
sudo \/opt\/lampp\/lampp restart<\/code><\/strong>
Step 5:<\/strong> Test if it’s working by running the below command:
mysql -u root -p <\/code><\/strong>
<\/p>\n\n\n\n

Refer the below screenshot to verify:<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

That’s it! I hope you enjoyed the article.<\/p>\n","protected":false},"excerpt":{"rendered":"

Assumption: 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\/ and https:\/\/www.devopsschool.com\/blog\/how-to-link-php-from-xampp-installation-to-use-php-command-from-user-or-any-other-directory-in-ubuntu-or-linux\/ 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…<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[4957],"tags":[],"class_list":["post-9788","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/9788","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=9788"}],"version-history":[{"count":2,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/9788\/revisions"}],"predecessor-version":[{"id":9793,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/9788\/revisions\/9793"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=9788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=9788"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=9788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}