thaicosmic.com

หนัง

วันพุธที่ 26 กุมภาพันธ์ พ.ศ. 2563

xampp 1.7.1 ubuntu 18.04.6

(In red if use this mySQL for jhcisdb)
sudo su
sudo apt-get install lib32stdc++6
apt-get install libodbc1:i386
wget https://master.dl.sourceforge.net/project/xampp/XAMPP%20Linux/1.7.1/xampp-linux-1.7.1.tar.gz
tar -xf xampp-linux-1.7.1.tar.gz -C /opt
/opt/lampp/lampp start
/opt/lampp/etc/my.cnf
       bind-address = 0.0.0.0
       port = 3333
chmod 644 /opt/lampp/etc/my.cnf
/opt/lampp/bin/mysql
       UPDATE mysql.user SET Password=PASSWORD('123456') WHERE User='root';
       GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '123456';
       GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '';
FLUSH PRIVILEGES;
/opt/lampp/lampp restart

/opt/lampp/bin/mysql --port=3333 -u root -p
opt/lampp/phpmyadmin/config.inc.php
       Password = '123456';
==============================================================
/opt/lampp/phpmyadmin/config.inc.php
        /* Authentication type and info */
//$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = '127.0.0.1:3333';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '123456';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;