Lamp 5.6 full

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

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

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

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

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

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

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:~$

PreviousCách tìm file hay sử dụng NextCách kết nối ftp trên local

Last updated 5 years ago