Welcome to the XAMPP Setup Wizard.
Select the components you want to install; clear the components you do not want

to install. Click Next when you are ready to continue.XAMPP Core Files : Y (Cannot be edited)
XAMPP Developer Files [Y/n] :y
Is the selection above correct? [Y/n]: y
Installation Directory
XAMPP will be installed to /opt/lampp

Press [Enter] to continue:Setup is now ready to begin installing XAMPP on your computer.
Do you want to continue? [Y/n]: y
Please wait while Setup installs XAMPP on your computer.
Installing

0% ______________ 50% ______________ 100%

#########################################Setup has finished installing XAMPP on your computer.

安裝完成以後 可以使用你的服務器IP地址或者本地的127.0.0.1來測試切換到/opt/lampp目錄下

1 啓動關閉

需要切換目錄：cd /opt/lampp/
啓動 XAMPP
./lampp start
停止 XAMPP
./lampp stop
重啓 XAMPP
./lampp restart
2 訪問數據庫，並設置密碼
進入mysql
/opt/lampp/bin/mysql -uroot -p
xampp安裝完畢後，默認數據庫密碼為空
Enter password:

這裏如果沒有啓動lampp ,會報一下錯誤ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/lampp/var/mysql/mysql.sock' (2 "No such file or directory")

確定啓動lampp以後直接Enter就可以進入數據庫
Welcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 5Server version: 10.1.21-MariaDB Source distribution
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]>
設置root用户密碼
set password for root@localhost = password('123');

創建用户並設置遠程訪問權限,不要直接用root用户直接遠程訪問 創建一個個人用户MariaDB [(none)]> CREATE USER '用户名'@'%' IDENTIFIED BY '密碼';
MariaDB [(none)]> GRANT ALL ON . TO '用户名'@'%';
MariaDB [(none)]> flush privileges;

//2017-08-19一個實例，添加一個對某個數據庫只有查詢權限的用户
MariaDB [(none)]> create user 'zhangsl'@'%' identified by 'zhangsl2017';

Query OK, 0 rows affected (0.02 sec)MariaDB [(none)]> grant select  on db_name.* to 'zhangsl'@'%';

Query OK, 0 rows affected (0.00 sec)MariaDB [(none)]> flush privileges;

Query OK, 0 rows affected (0.00 sec)