---
description: http://howtolamp.com/lamp/mysql/5.6/configuration-files/
---

# Lamp 5.6 full

lionel@ngoc:\~$ sudo /opt/lampp/lampp status \[sudo] password for lionel: Version: XAMPP for Linux 7.2.13-0 Apache is running. MySQL is running. ProFTPD is running. lionel@ngoc:\~$ sudo /opt/lampp/m man/ manual/ modules/ mysql/\
lionel@ngoc:\~$ sudo /opt/lampp/mysql/ sudo: /opt/lampp/mysql/: command not found lionel@ngoc:\~$ cd /opt/lampp/mysql/ lionel@ngoc:/opt/lampp/mysql$ ls README.txt scripts lionel@ngoc:/opt/lampp/mysql$ cd scripts/ lionel@ngoc:/opt/lampp/mysql/scripts$ ls ctl.sh lionel@ngoc:/opt/lampp/mysql/scripts$ cd ../ lionel@ngoc:/opt/lampp/mysql$ cd ../ lionel@ngoc:/opt/lampp$ ls apache2 icons manager-linux-x64.run RELEASENOTES bin img manual sbin build include modules share cgi-bin info mysql temp COPYING.thirdparty lampp pear uninstall ctlscript.sh lib php uninstall.dat docs libexec phpmyadmin var error licenses proftpd xampp etc logs properties.ini htdocs man README-wsrep lionel@ngoc:/opt/lampp$ cd bin/ lionel@ngoc:/opt/lampp/bin$ ls a2p jpegtran php-cgi-7.2.13 ab json\_pp php-config annotate ldapadd php-config-7.2.13 apachectl ldapcompare phpdbg apr-1-config ldapdelete phpize apreq2-config ldapexop phpize-7.2.13 apu-1-config ldapmodify phpunit apxs ldapmodrdn piconv aria\_chk ldappasswd pkgdata aria\_dump\_log ldapsearch pl2pm aria\_ftdump ldapurl png2dbl aria\_pack ldapwhoami pngtogd aria\_read\_log libmcrypt-config pngtogd2 autopoint libnetcfg pod2html bdftogd libpng15-config pod2latex bison libpng-config pod2man bmp2tiff listaction pod2text bsqldb listaction\_d pod2usage bunzip2 listfdb podchecker bzcat listjpeg podselect bzcmp listmp3 POST bzdiff listswf ppm2tiff bzegrep listswf\_d prove bzfgrep logresolve prxs bzgrep lwp-download psed bzip2 lwp-mirror pstruct bzip2recover lwp-request ptar bzless lwp-rget ptardiff bzmore makeconv ptargrep c2ph makefdb ras2tiff captoinfo makeswf raw2adpcm checkgid mariabackup raw2tiff cjpeg mbstream rdjpgcom clear ming-config recode-sr-latin config\_data mp2bug replace corelist msgattrib reset cpan msgcat resolveip cpan2dist msgcmp resolve\_stack\_dump cpanp msgcomm rgb2ycbcr cpanp-run-perl msgconv rotatelogs crc32 msgen s2p c\_rehash msgexec sabcmd curl msgfilter sablot-config curl-config msgfmt shasum datacopy msggrep splain dbilogstrip msginit sqlite dbiprof msgmerge sqlite3 dbiproxy msgunfmt suexec dbl2png msguniq swftocxx dbmmanage msql2mysql swftoperl defncopy myisamchk swftophp derb myisam\_ftdump swftopython djpeg myisamlog swftotcl enc2xs myisampack tabs envsubst my\_print\_defaults tdspool envvars mysql thumbnail envvars-std mysqlaccess tic fax2ps mysqladmin tiff2bw fax2tiff mysqlbinlog tiff2pdf fcgistarter mysqlbug tiff2ps find2perl mysqlcheck tiff2rgba fisql mysql\_client\_test tiffcmp fix\_rights mysql\_config tiffcp flex mysql\_convert\_table\_format tiffcrop flex++ mysqld\_multi tiffdither freebcp mysqld\_safe tiffdump freetype-config mysqld\_safe\_helper tiffinfo ftpasswd mysqldump tiffmedian ftpcount mysqldumpslow tiffset ftpdctl mysql\_find\_rows tiffsplit ftpmail mysql\_fix\_extensions toe ftpquota mysqlhotcopy tput ftptop mysqlimport tset ftpwho mysql\_install\_db tsql gd2copypal mysql\_plugin uconv gd2togif mysql\_secure\_installation unzip-mem gd2topng mysql.server unzzip gdcmpgif mysql\_setpermission unzzipcat gdlib-config mysqlshow unzzipcat-mem gdparttopng mysqlslap unzzipcat-seeko gdtopng mysqltest unzzipdir genbrk mysql\_tzinfo\_to\_sql unzzipdir-mem gencfu mysql\_upgrade wcmgr gencnval mysql\_waitpid webalizer genctd mysql\_zap webazolver gen\_php\_doc.sh mytop webpng genrb ncurses5-config wrjpgcom GET ngettext wsrep\_sst\_common gettext openssl wsrep\_sst\_mariabackup gettextize osql wsrep\_sst\_mysqldump gettext.sh pal2rgb wsrep\_sst\_rsync gif2tiff pcre-config wsrep\_sst\_rsync\_wan giftogd2 pcregrep wsrep\_sst\_xtrabackup h2ph pcretest wsrep\_sst\_xtrabackup-v2 h2xs pear xgettext HEAD peardev xml2-config htcacheclean pearinfo xmlcatalog htdbm pecl xmllint htdigest perl xmlwf html\_template\_phplibtool perl5.16.3 xslt-config htpasswd perlbug xsltproc httpd perldoc xsubpp httxt2dbm perlivp yacc iconv perlthanks ysh icu-config perror zipdetails icuinfo phar zzcat infocmp phar.phar zzdir infotocap php zzxorcat innochecksum php-7.2.13 zzxorcopy instmodsh php-cgi zzxordir lionel@ngoc:/opt/lampp/bin$ ./m makeconv mysqladmin makefdb mysqlbinlog makeswf mysqlbug mariabackup mysqlcheck mbstream mysql\_client\_test ming-config mysql\_config mp2bug mysql\_convert\_table\_format msgattrib mysqld\_multi msgcat mysqld\_safe msgcmp mysqld\_safe\_helper msgcomm mysqldump msgconv mysqldumpslow msgen mysql\_find\_rows msgexec mysql\_fix\_extensions msgfilter mysqlhotcopy msgfmt mysqlimport msggrep mysql\_install\_db msginit mysql\_plugin msgmerge mysql\_secure\_installation msgunfmt mysql.server msguniq mysql\_setpermission msql2mysql mysqlshow myisamchk mysqlslap --More--^C lionel@ngoc:/opt/lampp/bin$ ./mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 103 Server version: 10.1.37-MariaDB Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB \[(none)]> show databases; +---------------------+ | Database | +---------------------+ | dienthoaixanhnew | | information\_schema | | mysql | | performance\_schema | | phpmyadmin | | test | | tintuc\_shopdunk | | tintucdienthoaixanh | | wordpress | +---------------------+ 9 rows in set (0.10 sec)

MariaDB \[(none)]> exit Bye lionel@ngoc:/opt/lampp/bin$ cd lionel@ngoc:\~$ ls Desktop Documents Pictures tintuc.sql dienthoaixanh.sql.gz Downloads Public Videos docker-compose.debug.yml lionel snap docker-compose.yml Music Templates Dockerfile node\_modules tintucdienthoaixanh.sql.gz lionel@ngoc:\~$ ls -sh tintuc.sql 214M tintuc.sql lionel@ngoc:\~$ sudo /opt/lampp/b bin/ build/ lionel@ngoc:\~$ sudo /opt/lampp/bin/mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) lionel@ngoc:\~$ sudo /opt/lampp/bin/mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 105 Server version: 10.1.37-MariaDB Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB \[(none)]> use tintucdienthoaixanh; Database changed MariaDB \[tintucdienthoaixanh]> show tables; +-------------------------------+ | Tables\_in\_tintucdienthoaixanh | +-------------------------------+ | wp\_commentmeta | | wp\_comments | | wp\_duplicator\_pro\_entities | | wp\_duplicator\_pro\_packages | | wp\_links | | wp\_options | | wp\_postmeta | | wp\_posts | +-------------------------------+ 8 rows in set (0.05 sec)

MariaDB \[tintucdienthoaixanh]> use mysql; Database changed MariaDB \[mysql]> drop database tintucdienthoaixanh; Query OK, 8 rows affected (2.15 sec)

MariaDB \[mysql]> create database tintuc\_dienthoaixanh; Query OK, 1 row affected (0.01 sec)

MariaDB \[mysql]> exit Bye lionel@ngoc:\~$ sudo /opt/lampp/bin/mysql -u root -p tintuc\_dienthoaixanh < tintuc.sql Enter password: ERROR 2006 (HY000) at line 475: MySQL server has gone away lionel@ngoc:\~$ cd /opt/lampp/mysql/ lionel@ngoc:/opt/lampp/mysql$ ls README.txt scripts lionel@ngoc:/opt/lampp/mysql$ cd ../ lionel@ngoc:/opt/lampp$ ls apache2 icons manager-linux-x64.run RELEASENOTES bin img manual sbin build include modules share cgi-bin info mysql temp COPYING.thirdparty lampp pear uninstall ctlscript.sh lib php uninstall.dat docs libexec phpmyadmin var error licenses proftpd xampp etc logs properties.ini htdocs man README-wsrep lionel@ngoc:/opt/lampp$ cd etc/ lionel@ngoc:/opt/lampp/etc$ ls extra magic original proftpd.conf xampp freetds.conf mime.types pear.conf ssl.crt httpd.conf my.cnf php.ini ssl.key httpd.conf.bak openldap php.ini-pre1.7.2 webalizer.conf locales.conf openssl.cnf pool.conf webalizer.conf.sample lionel@ngoc:/opt/lampp/etc$ sudo nano my.cnf lionel@ngoc:/opt/lampp/etc$ sudo /opt/lampp/lampp restart Restarting XAMPP for Linux 7.2.13-0... XAMPP: Stopping Apache...ok. XAMPP: Stopping MySQL...ok. XAMPP: Stopping ProFTPD...ok. XAMPP: Starting Apache...ok. XAMPP: Starting MySQL...ok. XAMPP: Starting ProFTPD...ok. lionel@ngoc:/opt/lampp/etc$ sudo /opt/lampp/bin/mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 10.1.37-MariaDB Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB \[(none)]> drop database tintuc\_dienthoaixanh; Query OK, 8 rows affected (1.75 sec)

MariaDB \[(none)]> create database tintuc\_dienthoaixanh; Query OK, 1 row affected (0.00 sec)

MariaDB \[(none)]> exit Bye lionel@ngoc:/opt/lampp/etc$ cd lionel@ngoc:\~$ sudo /opt/lampp/bin/mysql -u root -p tintuc\_dienthoaixanh < tintuc.sql Enter password: lionel@ngoc:\~$
