· 8 years ago · Nov 21, 2017, 07:28 PM
1Last login: Mon Nov 20 23:27:20 on console
2MacBook-Pro-Andrew:~ andrewsapa$ ssh root@95.213.191.127
3root@95.213.191.127's password:
4Welcome to Ubuntu 16.04.2 LTS (GNU/Linux 4.4.0-92-generic x86_64)
5
6 * Documentation: https://help.ubuntu.com
7 * Management: https://landscape.canonical.com
8 * Support: https://ubuntu.com/advantage
9Last login: Sun Nov 19 17:34:56 2017 from 87.247.63.205
10root@carclick:~# php -v
11PHP 7.0.22-0ubuntu0.16.04.1 (cli) ( NTS )
12Copyright (c) 1997-2017 The PHP Group
13Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies
14 with Zend OPcache v7.0.22-0ubuntu0.16.04.1, Copyright (c) 1999-2017, by Zend Technologies
15root@carclick:~# php status
16Could not open input file: status
17root@carclick:~# sudo systemctl restart php7.0-fpm
18root@carclick:~# packet_write_wait: Connection to 95.213.191.127 port 22: Broken pipe
19MacBook-Pro-Andrew:~ andrewsapa$ ssh root@95.213.191.127
20root@95.213.191.127's password:
21Welcome to Ubuntu 16.04.2 LTS (GNU/Linux 4.4.0-92-generic x86_64)
22
23 * Documentation: https://help.ubuntu.com
24 * Management: https://landscape.canonical.com
25 * Support: https://ubuntu.com/advantage
26Last login: Mon Nov 20 17:44:01 2017 from 2.132.74.155
27root@carclick:~# php -v
28PHP 7.0.22-0ubuntu0.16.04.1 (cli) ( NTS )
29Copyright (c) 1997-2017 The PHP Group
30Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies
31 with Zend OPcache v7.0.22-0ubuntu0.16.04.1, Copyright (c) 1999-2017, by Zend Technologies
32root@carclick:~# nginx restart
33nginx: invalid option: "restart"
34root@carclick:~# service nginx restart
35root@carclick:~# service nginx status
36â— nginx.service - A high performance web server and a reverse proxy server
37 Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: en
38 Active: active (running) since Tue 2017-11-21 16:15:56 GMT; 6s ago
39 Process: 30358 ExecStop=/sbin/start-stop-daemon --quiet --stop --retry QUIT/5
40 Process: 30366 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (cod
41 Process: 30363 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process
42 Main PID: 30371 (nginx)
43 CGroup: /system.slice/nginx.service
44 ├─30371 nginx: master process /usr/sbin/nginx -g daemon on; master_pr
45 ├─30372 nginx: worker process
46 └─30373 nginx: worker process
47
48Nov 21 16:15:56 carclick systemd[1]: Stopped A high performance web server and a
49Nov 21 16:15:56 carclick systemd[1]: Starting A high performance web server and
50Nov 21 16:15:56 carclick systemd[1]: Started A high performance web server and a
51lines 1-15/15 (END)
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76â— nginx.service - A high performance web server and a reverse proxy server
77 Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enab
78 Active: active (running) since Tue 2017-11-21 16:15:56 GMT; 6s ago
79 Process: 30358 ExecStop=/sbin/start-stop-daemon --quiet --stop --retry QUIT/5 --
80 Process: 30366 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=
81 Process: 30363 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process o
82 Main PID: 30371 (nginx)
83 CGroup: /system.slice/nginx.service
84 ├─30371 nginx: master process /usr/sbin/nginx -g daemon on; master_proc
85 ├─30372 nginx: worker process
86 └─30373 nginx: worker process
87
88Nov 21 16:15:56 carclick systemd[1]: Stopped A high performance web server and a r
89Nov 21 16:15:56 carclick systemd[1]: Starting A high performance web server and a
90Nov 21 16:15:56 carclick systemd[1]: Started A high performance web server and a r
91~
92~
93~
94~
95~
96~
97~
98~
99lines 1-15/15 (END)
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124â— nginx.service - A high performance web server and a reverse proxy server
125 Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
126 Active: active (running) since Tue 2017-11-21 16:15:56 GMT; 6s ago
127 Process: 30358 ExecStop=/sbin/start-stop-daemon --quiet --stop --retry QUIT/5 --pidfile /run/nginx.pid
128 Process: 30366 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=exited, status=0/SUCCES
129 Process: 30363 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status
130 Main PID: 30371 (nginx)
131 CGroup: /system.slice/nginx.service
132 ├─30371 nginx: master process /usr/sbin/nginx -g daemon on; master_process on
133 ├─30372 nginx: worker process
134 └─30373 nginx: worker process
135
136Nov 21 16:15:56 carclick systemd[1]: Stopped A high performance web server and a reverse proxy server.
137Nov 21 16:15:56 carclick systemd[1]: Starting A high performance web server and a reverse proxy server...
138Nov 21 16:15:56 carclick systemd[1]: Started A high performance web server and a reverse proxy server.
139~
140~
141~
142~
143~
144~
145~
146~
147lines 1-15/15 (END)
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172â— nginx.service - A high performance web server and a reverse proxy server
173 Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
174 Active: active (running) since Tue 2017-11-21 16:15:56 GMT; 6s ago
175 Process: 30358 ExecStop=/sbin/start-stop-daemon --quiet --stop --retry QUIT/5 --pidfile /run/nginx.pid (co
176 Process: 30366 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
177 Process: 30363 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=0/
178 Main PID: 30371 (nginx)
179 CGroup: /system.slice/nginx.service
180 ├─30371 nginx: master process /usr/sbin/nginx -g daemon on; master_process on
181 ├─30372 nginx: worker process
182 └─30373 nginx: worker process
183
184Nov 21 16:15:56 carclick systemd[1]: Stopped A high performance web server and a reverse proxy server.
185Nov 21 16:15:56 carclick systemd[1]: Starting A high performance web server and a reverse proxy server...
186Nov 21 16:15:56 carclick systemd[1]: Started A high performance web server and a reverse proxy server.
187~
188~
189~
190~
191~
192~
193~
194~
195lines 1-15/15 (END)
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220â— nginx.service - A high performance web server and a reverse proxy server
221 Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
222 Active: active (running) since Tue 2017-11-21 16:15:56 GMT; 6s ago
223 Process: 30358 ExecStop=/sbin/start-stop-daemon --quiet --stop --retry QUIT/5 --pidfile /run/nginx.pid (code=exited,
224 Process: 30366 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
225 Process: 30363 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
226 Main PID: 30371 (nginx)
227 CGroup: /system.slice/nginx.service
228 ├─30371 nginx: master process /usr/sbin/nginx -g daemon on; master_process on
229 ├─30372 nginx: worker process
230 └─30373 nginx: worker process
231
232Nov 21 16:15:56 carclick systemd[1]: Stopped A high performance web server and a reverse proxy server.
233Nov 21 16:15:56 carclick systemd[1]: Starting A high performance web server and a reverse proxy server...
234Nov 21 16:15:56 carclick systemd[1]: Started A high performance web server and a reverse proxy server.
235~
236~
237~
238~
239~
240~
241~
242~
243lines 1-15/15 (END)
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268â— nginx.service - A high performance web server and a reverse proxy server
269 Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
270 Active: active (running) since Tue 2017-11-21 16:15:56 GMT; 6s ago
271 Process: 30358 ExecStop=/sbin/start-stop-daemon --quiet --stop --retry QUIT/5 --pidfile /run/nginx.pid (code=exited, s
272 Process: 30366 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
273 Process: 30363 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
274 Main PID: 30371 (nginx)
275 CGroup: /system.slice/nginx.service
276 ├─30371 nginx: master process /usr/sbin/nginx -g daemon on; master_process on
277 ├─30372 nginx: worker process
278 └─30373 nginx: worker process
279
280Nov 21 16:15:56 carclick systemd[1]: Stopped A high performance web server and a reverse proxy server.
281Nov 21 16:15:56 carclick systemd[1]: Starting A high performance web server and a reverse proxy server...
282Nov 21 16:15:56 carclick systemd[1]: Started A high performance web server and a reverse proxy server.
283~
284~
285~
286~
287~
288~
289~
290~
291lines 1-15/15 (END)
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316â— nginx.service - A high performance web server and a reverse proxy server
317 Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
318 Active: active (running) since Tue 2017-11-21 16:15:56 GMT; 6s ago
319 Process: 30358 ExecStop=/sbin/start-stop-daemon --quiet --stop --retry QUIT/5 --pidfile /run/nginx.pid (code=exited, stat
320 Process: 30366 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
321 Process: 30363 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
322 Main PID: 30371 (nginx)
323 CGroup: /system.slice/nginx.service
324 ├─30371 nginx: master process /usr/sbin/nginx -g daemon on; master_process on
325 ├─30372 nginx: worker process
326 └─30373 nginx: worker process
327
328Nov 21 16:15:56 carclick systemd[1]: Stopped A high performance web server and a reverse proxy server.
329Nov 21 16:15:56 carclick systemd[1]: Starting A high performance web server and a reverse proxy server...
330Nov 21 16:15:56 carclick systemd[1]: Started A high performance web server and a reverse proxy server.
331~
332~
333~
334~
335~
336~
337~
338~
339lines 1-15/15 (END)
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364â— nginx.service - A high performance web server and a reverse proxy server
365 Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
366 Active: active (running) since Tue 2017-11-21 16:15:56 GMT; 6s ago
367 Process: 30358 ExecStop=/sbin/start-stop-daemon --quiet --stop --retry QUIT/5 --pidfile /run/nginx.pid (code=exited, statu
368 Process: 30366 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
369 Process: 30363 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
370 Main PID: 30371 (nginx)
371 CGroup: /system.slice/nginx.service
372 ├─30371 nginx: master process /usr/sbin/nginx -g daemon on; master_process on
373 ├─30372 nginx: worker process
374 └─30373 nginx: worker process
375
376Nov 21 16:15:56 carclick systemd[1]: Stopped A high performance web server and a reverse proxy server.
377Nov 21 16:15:56 carclick systemd[1]: Starting A high performance web server and a reverse proxy server...
378Nov 21 16:15:56 carclick systemd[1]: Started A high performance web server and a reverse proxy server.
379~
380~
381~
382~
383~
384~
385~
386~
387
388root@carclick:~# mysql --version
389mysql Ver 14.14 Distrib 5.7.20, for Linux (x86_64) using EditLine wrapper
390root@carclick:~# sudo nano /etc/php/7.0/fpm/php.ini
391root@carclick:~# sudo systemctl restart php7.0-fpm
392root@carclick:~# php
393^C
394root@carclick:~# ^C
395root@carclick:~# php
396-v
397hui
398[eq
399dick
400info
401^C
402root@carclick:~# php php_info()
403-bash: syntax error near unexpected token `('
404root@carclick:~# php php_info
405Could not open input file: php_info
406root@carclick:~# sudo nano /etc/nginx/sites-available/default
407root@carclick:~# sudo systemctl restart nginx
408root@carclick:~# mysql
409ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
410root@carclick:~# mysql -v
411ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
412root@carclick:~# mysql root@'localhost'
413ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
414root@carclick:~# mysql root@'localhost' Deb3rely
415mysql Ver 14.14 Distrib 5.7.20, for Linux (x86_64) using EditLine wrapper
416Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
417
418Oracle is a registered trademark of Oracle Corporation and/or its
419affiliates. Other names may be trademarks of their respective
420owners.
421
422Usage: mysql [OPTIONS] [database]
423 -?, --help Display this help and exit.
424 -I, --help Synonym for -?
425 --auto-rehash Enable automatic rehashing. One doesn't need to use
426 'rehash' to get table and field completion, but startup
427 and reconnecting may take a longer time. Disable with
428 --disable-auto-rehash.
429 (Defaults to on; use --skip-auto-rehash to disable.)
430 -A, --no-auto-rehash
431 No automatic rehashing. One has to use 'rehash' to get
432 table and field completion. This gives a quicker start of
433 mysql and disables rehashing on reconnect.
434 --auto-vertical-output
435 Automatically switch to vertical output mode if the
436 result is wider than the terminal width.
437 -B, --batch Don't use history file. Disable interactive behavior.
438 (Enables --silent.)
439 --bind-address=name IP address to bind to.
440 -b, --binary-as-hex Print binary data as hex
441 --character-sets-dir=name
442 Directory for character set files.
443 --column-type-info Display column type information.
444 -c, --comments Preserve comments. Send comments to the server. The
445 default is --skip-comments (discard comments), enable
446 with --comments.
447 -C, --compress Use compression in server/client protocol.
448 -#, --debug[=#] This is a non-debug version. Catch this and exit.
449 --debug-check This is a non-debug version. Catch this and exit.
450 -T, --debug-info This is a non-debug version. Catch this and exit.
451 -D, --database=name Database to use.
452 --default-character-set=name
453 Set the default character set.
454 --delimiter=name Delimiter to be used.
455 --enable-cleartext-plugin
456 Enable/disable the clear text authentication plugin.
457 -e, --execute=name Execute command and quit. (Disables --force and history
458 file.)
459 -E, --vertical Print the output of a query (rows) vertically.
460 -f, --force Continue even if we get an SQL error.
461 --histignore=name A colon-separated list of patterns to keep statements
462 from getting logged into syslog and mysql history.
463 -G, --named-commands
464 Enable named commands. Named commands mean this program's
465 internal commands; see mysql> help . When enabled, the
466 named commands can be used from any line of the query,
467 otherwise only from the first line, before an enter.
468 Disable with --disable-named-commands. This option is
469 disabled by default.
470 -i, --ignore-spaces Ignore space after function names.
471 --init-command=name SQL Command to execute when connecting to MySQL server.
472 Will automatically be re-executed when reconnecting.
473 --local-infile Enable/disable LOAD DATA LOCAL INFILE.
474 -b, --no-beep Turn off beep on error.
475 -h, --host=name Connect to host.
476 -H, --html Produce HTML output.
477 -X, --xml Produce XML output.
478 --line-numbers Write line numbers for errors.
479 (Defaults to on; use --skip-line-numbers to disable.)
480 -L, --skip-line-numbers
481 Don't write line number for errors.
482 -n, --unbuffered Flush buffer after each query.
483 --column-names Write column names in results.
484 (Defaults to on; use --skip-column-names to disable.)
485 -N, --skip-column-names
486 Don't write column names in results.
487 --sigint-ignore Ignore SIGINT (CTRL-C).
488 -o, --one-database Ignore statements except those that occur while the
489 default database is the one named at the command line.
490 --pager[=name] Pager to use to display results. If you don't supply an
491 option, the default pager is taken from your ENV variable
492 PAGER. Valid pagers are less, more, cat [> filename],
493 etc. See interactive help (\h) also. This option does not
494 work in batch mode. Disable with --disable-pager. This
495 option is disabled by default.
496 -p, --password[=name]
497 Password to use when connecting to server. If password is
498 not given it's asked from the tty.
499 -P, --port=# Port number to use for connection or 0 for default to, in
500 order of preference, my.cnf, $MYSQL_TCP_PORT,
501 /etc/services, built-in default (3306).
502 --prompt=name Set the mysql prompt to this value.
503 --protocol=name The protocol to use for connection (tcp, socket, pipe,
504 memory).
505 -q, --quick Don't cache result, print it row by row. This may slow
506 down the server if the output is suspended. Doesn't use
507 history file.
508 -r, --raw Write fields without conversion. Used with --batch.
509 --reconnect Reconnect if the connection is lost. Disable with
510 --disable-reconnect. This option is enabled by default.
511 (Defaults to on; use --skip-reconnect to disable.)
512 -s, --silent Be more silent. Print results with a tab as separator,
513 each row on new line.
514 -S, --socket=name The socket file to use for connection.
515 --ssl-mode=name SSL connection mode.
516 --ssl Deprecated. Use --ssl-mode instead.
517 (Defaults to on; use --skip-ssl to disable.)
518 --ssl-verify-server-cert
519 Deprecated. Use --ssl-mode=VERIFY_IDENTITY instead.
520 --ssl-ca=name CA file in PEM format.
521 --ssl-capath=name CA directory.
522 --ssl-cert=name X509 cert in PEM format.
523 --ssl-cipher=name SSL cipher to use.
524 --ssl-key=name X509 key in PEM format.
525 --ssl-crl=name Certificate revocation list.
526 --ssl-crlpath=name Certificate revocation list path.
527 --tls-version=name TLS version to use, permitted values are: TLSv1, TLSv1.1
528 -t, --table Output in table format.
529 --tee=name Append everything into outfile. See interactive help (\h)
530 also. Does not work in batch mode. Disable with
531 --disable-tee. This option is disabled by default.
532 -u, --user=name User for login if not current user.
533 -U, --safe-updates Only allow UPDATE and DELETE that uses keys.
534 -U, --i-am-a-dummy Synonym for option --safe-updates, -U.
535 -v, --verbose Write more. (-v -v -v gives the table output format).
536 -V, --version Output version information and exit.
537 -w, --wait Wait and retry if connection is down.
538 --connect-timeout=# Number of seconds before connection timeout.
539 --max-allowed-packet=#
540 The maximum packet length to send to or receive from
541 server.
542 --net-buffer-length=#
543 The buffer size for TCP/IP and socket communication.
544 --select-limit=# Automatic limit for SELECT when using --safe-updates.
545 --max-join-size=# Automatic limit for rows in a join when using
546 --safe-updates.
547 --secure-auth Refuse client connecting to server if it uses old
548 (pre-4.1.1) protocol. Deprecated. Always TRUE
549 --server-arg=name Send embedded server this as a parameter.
550 --show-warnings Show warnings after every statement.
551 -j, --syslog Log filtered interactive commands to syslog. Filtering of
552 commands depends on the patterns supplied via histignore
553 option besides the default patterns.
554 --plugin-dir=name Directory for client-side plugins.
555 --default-auth=name Default authentication client-side plugin to use.
556 --binary-mode By default, ASCII '\0' is disallowed and '\r\n' is
557 translated to '\n'. This switch turns off both features,
558 and also turns off parsing of all clientcommands except
559 \C and DELIMITER, in non-interactive mode (for input
560 piped to mysql or loaded using the 'source' command).
561 This is necessary when processing output from mysqlbinlog
562 that may contain blobs.
563 --connect-expired-password
564 Notify the server that this client is prepared to handle
565 expired password sandbox mode.
566
567Default options are read from the following files in the given order:
568/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
569The following groups are read: mysql client
570The following options may be given as the first argument:
571--print-defaults Print the program argument list and exit.
572--no-defaults Don't read default options from any option file,
573 except for login file.
574--defaults-file=# Only read default options from the given file #.
575--defaults-extra-file=# Read this file after the global files are read.
576--defaults-group-suffix=#
577 Also read groups with concat(group, suffix)
578--login-path=# Read this path from the login file.
579
580Variables (--variable-name=value)
581and boolean options {FALSE|TRUE} Value (after reading options)
582--------------------------------- ----------------------------------------
583auto-rehash TRUE
584auto-vertical-output FALSE
585bind-address (No default value)
586binary-as-hex FALSE
587character-sets-dir (No default value)
588column-type-info FALSE
589comments FALSE
590compress FALSE
591database (No default value)
592default-character-set auto
593delimiter ;
594enable-cleartext-plugin FALSE
595vertical FALSE
596force FALSE
597histignore (No default value)
598named-commands FALSE
599ignore-spaces FALSE
600init-command (No default value)
601local-infile FALSE
602no-beep FALSE
603host (No default value)
604html FALSE
605xml FALSE
606line-numbers TRUE
607unbuffered FALSE
608column-names TRUE
609sigint-ignore FALSE
610port 0
611prompt mysql>
612quick FALSE
613raw FALSE
614reconnect TRUE
615socket (No default value)
616ssl TRUE
617ssl-verify-server-cert FALSE
618ssl-ca (No default value)
619ssl-capath (No default value)
620ssl-cert (No default value)
621ssl-cipher (No default value)
622ssl-key (No default value)
623ssl-crl (No default value)
624ssl-crlpath (No default value)
625tls-version (No default value)
626table FALSE
627user (No default value)
628safe-updates FALSE
629i-am-a-dummy FALSE
630connect-timeout 0
631max-allowed-packet 16777216
632net-buffer-length 16384
633select-limit 1000
634max-join-size 1000000
635secure-auth TRUE
636show-warnings FALSE
637plugin-dir (No default value)
638default-auth (No default value)
639binary-mode FALSE
640connect-expired-password FALSE
641root@carclick:~# mysql --version
642mysql Ver 14.14 Distrib 5.7.20, for Linux (x86_64) using EditLine wrapper
643root@carclick:~# sudo systemctl status mysql
644â— mysql.service - MySQL Community Server
645 Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
646 Active: active (running) since Sun 2017-11-19 18:54:15 GMT; 1 day 21h ago
647 Main PID: 10613 (mysqld)
648 CGroup: /system.slice/mysql.service
649 └─10613 /usr/sbin/mysqld
650
651Warning: Journal has been rotated since unit was started. Log output is incomplete or un
652lines 1-8/8 (END)
653root@carclick:~# mysql -u admin -p
654Enter password:
655ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
656root@carclick:~# mysql -u asapa454_admin -p asapa454_wp444
657Enter password:
658Welcome to the MySQL monitor. Commands end with ; or \g.
659Your MySQL connection id is 26
660Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu)
661
662Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
663
664Oracle is a registered trademark of Oracle Corporation and/or its
665affiliates. Other names may be trademarks of their respective
666owners.
667
668Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
669
670mysql> show databases
671 -> ;
672+--------------------+
673| Database |
674+--------------------+
675| information_schema |
676| asapa454_wp444 |
677+--------------------+
6782 rows in set (0.00 sec)
679
680mysql> show tables;
681Empty set (0.00 sec)
682
683mysql> use asapa454_wp444 ;
684Database changed
685mysql> show tables;
686Empty set (0.00 sec)
687
688mysql> asapa454_wp444 < /var/www/asapa454_wp444.sql
689 -> ;
690ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'asapa454_wp444 < /var/www/asapa454_wp444.sql' at line 1
691mysql> ^
692
693^C
694mysql> exit
695Bye
696root@carclick:~# cd /var/www/
697root@carclick:/var/www# mysql
698ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
699root@carclick:/var/www# mysql -u asapa454_admin -p asapa454_wp444
700Enter password:
701Welcome to the MySQL monitor. Commands end with ; or \g.
702Your MySQL connection id is 28
703Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu)
704
705Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
706
707Oracle is a registered trademark of Oracle Corporation and/or its
708affiliates. Other names may be trademarks of their respective
709owners.
710
711Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
712
713mysql> asapa454_wp444 < asapa454_wp444.sql;
714ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'asapa454_wp444 < asapa454_wp444.sql' at line 1
715mysql> exit
716Bye
717root@carclick:/var/www# mysql -uasapa454_admin -pDeb3rely < asapa454_wp444.sql
718mysql: [Warning] Using a password on the command line interface can be insecure.
719ERROR 1046 (3D000) at line 31: No database selected
720root@carclick:/var/www# mysql -uasapa454_admin -pDeb3rely asapa454_wp444 < asapa454_wp444.sql
721mysql: [Warning] Using a password on the command line interface can be insecure.
722root@carclick:/var/www# mysql
723ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
724root@carclick:/var/www# mysql -u asapa454_admin -p asapa454_wp444
725Enter password:
726Reading table information for completion of table and column names
727You can turn off this feature to get a quicker startup with -A
728
729Welcome to the MySQL monitor. Commands end with ; or \g.
730Your MySQL connection id is 33
731Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu)
732
733Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
734
735Oracle is a registered trademark of Oracle Corporation and/or its
736affiliates. Other names may be trademarks of their respective
737owners.
738
739Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
740
741mysql> Show tables
742 -> ;
743+--------------------------+
744| Tables_in_asapa454_wp444 |
745+--------------------------+
746| wpp6_commentmeta |
747| wpp6_comments |
748| wpp6_links |
749| wpp6_newsletter |
750| wpp6_newsletter_emails |
751| wpp6_newsletter_sent |
752| wpp6_newsletter_stats |
753| wpp6_options |
754| wpp6_postmeta |
755| wpp6_posts |
756| wpp6_term_relationships |
757| wpp6_term_taxonomy |
758| wpp6_termmeta |
759| wpp6_terms |
760| wpp6_usermeta |
761| wpp6_users |
762+--------------------------+
76316 rows in set (0.00 sec)
764
765mysql> drop table *;
766ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*' at line 1
767mysql> drop table;
768ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
769mysql> drop table
770Display all 1152 possibilities? (y or n)
771mysql> drop table
772Display all 1152 possibilities? (y or n)
773? OPTIONALLY
774ABS options
775ACOS OR
776ACTION ORD
777ADD ORDER
778ADDDATE OUT
779ADDTIME OUTER
780AES_DECRYPT OUTFILE
781AES_ENCRYPT OVERLAPS
782AFTER PACK_KEYS
783AGAINST pager
784AGGREGATE parent
785ALGORITHM PARTIAL
786ALL PASSWORD
787ALTER PERIOD_ADD
788alter table PERIOD_DIFF
789ANALYZE PHASE
790anchor PI
791AND ping_status
792ANY pinged
793AREA POINT
794AS POINTFROMTEXT
795asapa454_wp444 POINTFROMWKB
796ASBINARY POINTN
797ASC POLYFROMTEXT
798ASCII POLYFROMWKB
799ASENSITIVE POLYGON
800ASIN POLYGONFROMTEXT
801ASTEXT POLYGONFROMWKB
802ASWKB POSITION
803ASWKT post_author
804ATAN post_content
805ATAN2 post_content_filtered
806AUTO_INCREMENT post_date
807autoload post_date_gmt
808AVG post_excerpt
809AVG_ROW_LENGTH post_id
810BACKUP post_mime_type
811BDB post_modified
812BEFORE post_modified_gmt
813BEGIN post_name
814BENCHMARK post_parent
815BERKELEYDB post_password
816BETWEEN post_status
817BIGINT post_title
818BIN post_type
819BINARY POW
820BINLOG POWER
821BIT PRECISION
822BIT_AND preferences
823BIT_COUNT PREPARE
824BIT_LENGTH PREV
825BIT_OR PRIMARY
826BIT_XOR print
827BLOB private
828BOOL PRIVILEGES
829BOOLEAN PROCEDURE
830BOTH PROCESS
831BTREE PROCESSLIST
832BY profile
833BYTE profile_1
834CACHE profile_10
835CALL profile_11
836CASCADE profile_12
837CASCADED profile_13
838CASE profile_14
839CAST profile_15
840CEIL profile_16
841CEILING profile_17
842CENTROID profile_18
843CHAIN profile_19
844CHANGE profile_2
845CHANGED profile_20
846CHAR profile_3
847CHAR_LENGTH profile_4
848CHARACTER profile_5
849CHARACTER_LENGTH profile_6
850charset profile_7
851CHARSET profile_8
852CHECK profile_9
853CHECKSUM prompt
854CIPHER PURGE
855city QUARTER
856clear query
857click_count QUERY
858CLIENT QUICK
859CLOSE quit
860COALESCE QUOTE
861CODE RADIANS
862COERCIBILITY RAND
863COLLATE READ
864COLLATION READS
865COLUMN REAL
866COLUMNS RECOVER
867COMMENT REDUNDANT
868comment_agent REFERENCES
869comment_approved referrer
870comment_author REGEXP
871comment_author_email region
872comment_author_IP rehash
873comment_author_url RELAY_LOG_FILE
874comment_content RELAY_LOG_POS
875comment_count RELAY_THREAD
876comment_date RELEASE
877comment_date_gmt RELEASE_LOCK
878comment_ID RELOAD
879comment_id RENAME
880comment_karma REPAIR
881comment_parent REPEAT
882comment_post_ID REPEATABLE
883comment_status REPLACE
884comment_type REPLICATION
885COMMIT REQUIRE
886COMMITTED RESET
887COMPACT resetconnection
888COMPRESS RESTORE
889COMPRESSED RESTRICT
890CONCAT RESUME
891CONCAT_WS RETURN
892CONCURRENT RETURNS
893CONDITION REVERSE
894connect REVOKE
895CONNECTION RIGHT
896CONNECTION_ID RLIKE
897CONSISTENT ROLLBACK
898CONSTRAINT ROLLUP
899CONTAINS ROUND
900CONTINUE ROUTINE
901CONV ROW
902CONVERT ROW_COUNT
903CONVERT_TZ ROW_FORMAT
904COS ROWS
905COT RPAD
906COUNT RTREE
907count RTRIM
908country SAVEPOINT
909CRC32 SCHEMA
910CREATE SCHEMAS
911create database SEC_TO_TIME
912create table SECOND
913created SECOND_MICROSECOND
914CROSS SECURITY
915CROSSES SELECT
916CUBE send_on
917CURDATE SENSITIVE
918CURRENT_DATE sent
919CURRENT_TIME SEPARATOR
920CURRENT_TIMESTAMP SERIAL
921CURRENT_USER SERIALIZABLE
922CURSOR SESSION
923CURTIME SESSION_USER
924DATA SET
925DATABASE set option
926DATABASES sex
927DATE SHA
928DATE_ADD SHA1
929DATE_FORMAT SHARE
930DATE_SUB SHOW
931DATEDIFF show databases
932DATETIME show fields from
933DAY show keys from
934DAY_HOUR show tables
935DAY_MICROSECOND SHUTDOWN
936DAY_MINUTE SIGN
937DAY_SECOND SIGNED
938DAYNAME SIMPLE
939DAYOFMONTH SIN
940DAYOFWEEK SLAVE
941DAYOFYEAR SLEEP
942DEALLOCATE slug
943DEC SMALLINT
944DECIMAL SNAPSHOT
945DECLARE SOME
946DECODE SONAME
947DEFAULT SOUNDEX
948DEFINER SOUNDS
949DEGREES source
950DELAY_KEY_WRITE SPACE
951DELAYED SPATIAL
952DELETE SPECIFIC
953delimiter SQL
954DES_DECRYPT SQL_BIG_RESULT
955DES_ENCRYPT SQL_BUFFER_RESULT
956DES_KEY_FILE SQL_CACHE
957DESC SQL_CALC_FOUND_ROWS
958DESCRIBE SQL_NO_CACHE
959description SQL_SMALL_RESULT
960DETERMINISTIC SQL_THREAD
961DIMENSION SQL_TSI_DAY
962DIRECTORY SQL_TSI_HOUR
963DISABLE SQL_TSI_MINUTE
964DISCARD SQL_TSI_MONTH
965DISJOINT SQL_TSI_QUARTER
966display_name SQL_TSI_SECOND
967DISTINCT SQL_TSI_WEEK
968DISTINCTROW SQL_TSI_YEAR
969DIV SQLEXCEPTION
970DO SQLSTATE
971DOUBLE SQLWARNING
972DROP SQRT
973DUAL SRID
974DUMPFILE SSL
975DUPLICATE START
976DYNAMIC STARTING
977EACH STARTPOINT
978edit STATUS
979editor status
980ego STD
981ELSE STDDEV
982ELSEIF STDDEV_POP
983ELT STDDEV_SAMP
984email STOP
985email_id STORAGE
986ENABLE STR_TO_DATE
987ENCLOSED STRAIGHT_JOIN
988ENCODE STRCMP
989ENCRYPT STRING
990END STRIPED
991ENDPOINT SUBDATE
992ENGINE subject
993ENGINES SUBJECT
994ENUM subject2
995ENVELOPE SUBSTR
996EQUALS SUBSTRING
997error SUBSTRING_INDEX
998ERRORS SUBTIME
999ESCAPE SUM
1000ESCAPED SUPER
1001EVENTS surname
1002EXECUTE SUSPEND
1003EXISTS SYSDATE
1004exit system
1005EXIT SYSTEM_USER
1006EXP TABLE
1007EXPANSION TABLES
1008EXPLAIN TABLESPACE
1009EXPORT_SET TAN
1010EXTENDED taxonomy
1011EXTERIORRING tee
1012EXTRACT TEMPORARY
1013FALSE TEMPTABLE
1014FAST term_group
1015feed term_id
1016feed_time term_order
1017FETCH term_taxonomy_id
1018FIELD TERMINATED
1019FIELDS test
1020FILE TEXT
1021FIND_IN_SET theme
1022FIRST THEN
1023FIXED TIME
1024FLOAT time
1025FLOAT4 TIME_FORMAT
1026FLOAT8 TIME_TO_SEC
1027FLOOR TIMEDIFF
1028FLUSH TIMESTAMP
1029followup TIMESTAMPADD
1030followup_step TIMESTAMPDIFF
1031followup_time TINYBLOB
1032FOR TINYINT
1033FORCE TINYTEXT
1034FOREIGN TO
1035FORMAT TO_DAYS
1036FOUND to_ping
1037FOUND_ROWS token
1038FROM total
1039FROM_DAYS TOUCHES
1040FROM_UNIXTIME track
1041FULL TRAILING
1042FULLTEXT TRANSACTION
1043FUNCTION TRIGGER
1044GEOMCOLLFROMTEXT TRIGGERS
1045GEOMCOLLFROMWKB TRIM
1046GEOMETRY TRUE
1047GEOMETRYCOLLECTION TRUNCATE
1048GEOMETRYCOLLECTIONFROMTEXT TYPE
1049GEOMETRYCOLLECTIONFROMWKB type
1050GEOMETRYFROMTEXT TYPES
1051GEOMETRYFROMWKB UCASE
1052GEOMETRYN umeta_id
1053GEOMETRYTYPE UNCOMMITTED
1054GEOMFROMTEXT UNCOMPRESS
1055GEOMFROMWKB UNCOMPRESSED_LENGTH
1056GET_FORMAT UNDEFINED
1057GET_LOCK UNDO
1058GLENGTH UNHEX
1059GLOBAL UNICODE
1060go UNION
1061GRANT UNIQUE
1062GRANTS UNIQUE_USERS
1063GREATEST UNIX_TIMESTAMP
1064GROUP UNKNOWN
1065GROUP_CONCAT UNLOCK
1066GROUP_UNIQUE_USERS unlock tables
1067guid UNSIGNED
1068HANDLER unsub_email_id
1069HASH unsub_time
1070HAVING UNTIL
1071HELP UPDATE
1072help UPGRADE
1073HEX UPPER
1074HIGH_PRIORITY url
1075HOSTS USAGE
1076HOUR use
1077HOUR_MICROSECOND USE
1078HOUR_MINUTE USE_FRM
1079HOUR_SECOND USER
1080http_referer user_activation_key
1081ID user_email
1082ID user_id
1083id user_login
1084IDENTIFIED user_nicename
1085IF user_pass
1086IFNULL user_registered
1087IGNORE USER_RESOURCES
1088IMPORT user_status
1089IN user_url
1090INDEX USING
1091INDEXES UTC_DATE
1092INET_ATON UTC_TIME
1093INET_NTOA UTC_TIMESTAMP
1094INFILE UUID
1095information_schema VALUE
1096INNER VALUES
1097INNOBASE VAR_POP
1098INNODB VAR_SAMP
1099INOUT VARBINARY
1100INSENSITIVE VARCHAR
1101INSERT VARCHARACTER
1102INSERT_METHOD VARIABLES
1103INSTR VARIANCE
1104INT VARYING
1105INT1 version
1106INT2 VERSION
1107INT3 VIEW
1108INT4 warnings
1109INT8 WARNINGS
1110INTEGER WEEK
1111INTERIORRINGN WEEKDAY
1112INTERSECTS WEEKOFYEAR
1113INTERVAL WHEN
1114INTO WHERE
1115INVOKER WHILE
1116IO_THREAD WITH
1117ip WITHIN
1118IS WORK
1119IS_FREE_LOCK wp_user_id
1120IS_USED_LOCK wpp6_commentmeta
1121ISCLOSED wpp6_commentmeta.comment_id
1122ISEMPTY wpp6_commentmeta.meta_id
1123ISNULL wpp6_commentmeta.meta_key
1124ISOLATION wpp6_commentmeta.meta_value
1125ISSIMPLE wpp6_comments
1126ISSUER wpp6_comments.comment_agent
1127ITERATE wpp6_comments.comment_approved
1128JOIN wpp6_comments.comment_author
1129JSON_ARRAY wpp6_comments.comment_author_email
1130JSON_ARRAY_APPEND wpp6_comments.comment_author_IP
1131JSON_CONTAINS wpp6_comments.comment_author_url
1132JSON_CONTAINS_PATH wpp6_comments.comment_content
1133JSON_DEPTH wpp6_comments.comment_date
1134JSON_EXTRACT wpp6_comments.comment_date_gmt
1135JSON_INSERT wpp6_comments.comment_ID
1136JSON_KEYS wpp6_comments.comment_karma
1137JSON_LENGTH wpp6_comments.comment_parent
1138JSON_MERGE wpp6_comments.comment_post_ID
1139JSON_QUOTE wpp6_comments.comment_type
1140JSON_REPLACE wpp6_comments.user_id
1141JSON_ROWOBJECT wpp6_links
1142JSON_SEARCH wpp6_links.link_description
1143JSON_SET wpp6_links.link_id
1144JSON_TYPE wpp6_links.link_image
1145JSON_UNQUOTE wpp6_links.link_name
1146JSON_VALID wpp6_links.link_notes
1147KEY wpp6_links.link_owner
1148KEYS wpp6_links.link_rating
1149KILL wpp6_links.link_rel
1150LANGUAGE wpp6_links.link_rss
1151LAST wpp6_links.link_target
1152LAST_DAY wpp6_links.link_updated
1153last_id wpp6_links.link_url
1154LAST_INSERT_ID wpp6_links.link_visible
1155LCASE wpp6_newsletter
1156LEADING wpp6_newsletter.city
1157LEAST wpp6_newsletter.country
1158LEAVE wpp6_newsletter.created
1159LEAVES wpp6_newsletter.email
1160LEFT wpp6_newsletter.feed
1161LENGTH wpp6_newsletter.feed_time
1162LEVEL wpp6_newsletter.followup
1163LIKE wpp6_newsletter.followup_step
1164LIMIT wpp6_newsletter.followup_time
1165LINEFROMTEXT wpp6_newsletter.http_referer
1166LINEFROMWKB wpp6_newsletter.id
1167LINES wpp6_newsletter.ip
1168LINESTRING wpp6_newsletter.list
1169LINESTRINGFROMTEXT wpp6_newsletter.list_1
1170LINESTRINGFROMWKB wpp6_newsletter.list_10
1171link_description wpp6_newsletter.list_11
1172link_id wpp6_newsletter.list_12
1173link_image wpp6_newsletter.list_13
1174link_name wpp6_newsletter.list_14
1175link_notes wpp6_newsletter.list_15
1176link_owner wpp6_newsletter.list_16
1177link_rating wpp6_newsletter.list_17
1178link_rel wpp6_newsletter.list_18
1179link_rss wpp6_newsletter.list_19
1180link_target wpp6_newsletter.list_2
1181link_updated wpp6_newsletter.list_20
1182link_url wpp6_newsletter.list_3
1183link_visible wpp6_newsletter.list_4
1184list wpp6_newsletter.list_5
1185list_1 wpp6_newsletter.list_6
1186list_10 wpp6_newsletter.list_7
1187list_11 wpp6_newsletter.list_8
1188list_12 wpp6_newsletter.list_9
1189list_13 wpp6_newsletter.name
1190list_14 wpp6_newsletter.profile
1191list_15 wpp6_newsletter.profile_1
1192list_16 wpp6_newsletter.profile_10
1193list_17 wpp6_newsletter.profile_11
1194list_18 wpp6_newsletter.profile_12
1195list_19 wpp6_newsletter.profile_13
1196list_2 wpp6_newsletter.profile_14
1197list_20 wpp6_newsletter.profile_15
1198list_3 wpp6_newsletter.profile_16
1199list_4 wpp6_newsletter.profile_17
1200list_5 wpp6_newsletter.profile_18
1201list_6 wpp6_newsletter.profile_19
1202list_7 wpp6_newsletter.profile_2
1203list_8 wpp6_newsletter.profile_20
1204list_9 wpp6_newsletter.profile_3
1205LN wpp6_newsletter.profile_4
1206LOAD wpp6_newsletter.profile_5
1207load data from wpp6_newsletter.profile_6
1208LOAD_FILE wpp6_newsletter.profile_7
1209LOCAL wpp6_newsletter.profile_8
1210LOCALTIME wpp6_newsletter.profile_9
1211LOCALTIMESTAMP wpp6_newsletter.referrer
1212LOCATE wpp6_newsletter.region
1213LOCK wpp6_newsletter.sex
1214lock tables wpp6_newsletter.status
1215LOCKS wpp6_newsletter.surname
1216LOG wpp6_newsletter.test
1217LOG10 wpp6_newsletter.token
1218LOG2 wpp6_newsletter.unsub_email_id
1219LOGS wpp6_newsletter.unsub_time
1220LONG wpp6_newsletter.wp_user_id
1221LONGBLOB wpp6_newsletter_emails
1222LONGTEXT wpp6_newsletter_emails.click_count
1223LOOP wpp6_newsletter_emails.created
1224LOW_PRIORITY wpp6_newsletter_emails.editor
1225LOWER wpp6_newsletter_emails.id
1226LPAD wpp6_newsletter_emails.last_id
1227LTRIM wpp6_newsletter_emails.list
1228MAKE_SET wpp6_newsletter_emails.message
1229MAKEDATE wpp6_newsletter_emails.message2
1230MAKETIME wpp6_newsletter_emails.message_text
1231MASTER wpp6_newsletter_emails.name2
1232MASTER_CONNECT_RETRY wpp6_newsletter_emails.open_count
1233MASTER_HOST wpp6_newsletter_emails.options
1234MASTER_LOG_FILE wpp6_newsletter_emails.preferences
1235MASTER_LOG_POS wpp6_newsletter_emails.private
1236MASTER_PASSWORD wpp6_newsletter_emails.query
1237MASTER_PORT wpp6_newsletter_emails.send_on
1238MASTER_POS_WAIT wpp6_newsletter_emails.sent
1239MASTER_SERVER_ID wpp6_newsletter_emails.sex
1240MASTER_SSL wpp6_newsletter_emails.status
1241MASTER_SSL_CA wpp6_newsletter_emails.subject
1242MASTER_SSL_CAPATH wpp6_newsletter_emails.subject2
1243MASTER_SSL_CERT wpp6_newsletter_emails.theme
1244MASTER_SSL_CIPHER wpp6_newsletter_emails.token
1245MASTER_SSL_KEY wpp6_newsletter_emails.total
1246MASTER_TLS_VERSION wpp6_newsletter_emails.track
1247MASTER_USER wpp6_newsletter_emails.type
1248MATCH wpp6_newsletter_emails.version
1249MAX wpp6_newsletter_sent
1250MAX_CONNECTIONS_PER_HOUR wpp6_newsletter_sent.email_id
1251MAX_QUERIES_PER_HOUR wpp6_newsletter_sent.error
1252MAX_ROWS wpp6_newsletter_sent.ip
1253MAX_UPDATES_PER_HOUR wpp6_newsletter_sent.open
1254MAX_USER_CONNECTIONS wpp6_newsletter_sent.status
1255MBRCONTAINS wpp6_newsletter_sent.time
1256MBRDISJOINT wpp6_newsletter_sent.user_id
1257MBREQUAL wpp6_newsletter_stats
1258MBRINTERSECTS wpp6_newsletter_stats.anchor
1259MBROVERLAPS wpp6_newsletter_stats.country
1260MBRTOUCHES wpp6_newsletter_stats.created
1261MBRWITHIN wpp6_newsletter_stats.email_id
1262MD5 wpp6_newsletter_stats.id
1263MEDIUM wpp6_newsletter_stats.ip
1264MEDIUMBLOB wpp6_newsletter_stats.link_id
1265MEDIUMINT wpp6_newsletter_stats.newsletter
1266MEDIUMTEXT wpp6_newsletter_stats.url
1267menu_order wpp6_newsletter_stats.user_id
1268MERGE wpp6_options
1269message wpp6_options.autoload
1270message2 wpp6_options.option_id
1271message_text wpp6_options.option_name
1272meta_id wpp6_options.option_value
1273meta_key wpp6_postmeta
1274meta_value wpp6_postmeta.meta_id
1275MICROSECOND wpp6_postmeta.meta_key
1276MID wpp6_postmeta.meta_value
1277MIDDLEINT wpp6_postmeta.post_id
1278MIGRATE wpp6_posts
1279MIN wpp6_posts.comment_count
1280MIN_ROWS wpp6_posts.comment_status
1281MINUTE wpp6_posts.guid
1282MINUTE_MICROSECOND wpp6_posts.ID
1283MINUTE_SECOND wpp6_posts.menu_order
1284MLINEFROMTEXT wpp6_posts.ping_status
1285MLINEFROMWKB wpp6_posts.pinged
1286MOD wpp6_posts.post_author
1287MODE wpp6_posts.post_content
1288MODIFIES wpp6_posts.post_content_filtered
1289MODIFY wpp6_posts.post_date
1290MONTH wpp6_posts.post_date_gmt
1291MONTHNAME wpp6_posts.post_excerpt
1292MPOINTFROMTEXT wpp6_posts.post_mime_type
1293MPOINTFROMWKB wpp6_posts.post_modified
1294MPOLYFROMTEXT wpp6_posts.post_modified_gmt
1295MPOLYFROMWKB wpp6_posts.post_name
1296MULTILINESTRING wpp6_posts.post_parent
1297MULTILINESTRINGFROMTEXT wpp6_posts.post_password
1298MULTILINESTRINGFROMWKB wpp6_posts.post_status
1299MULTIPOINT wpp6_posts.post_title
1300MULTIPOINTFROMTEXT wpp6_posts.post_type
1301MULTIPOINTFROMWKB wpp6_posts.to_ping
1302MULTIPOLYGON wpp6_term_relationships
1303MULTIPOLYGONFROMTEXT wpp6_term_relationships.object_id
1304MULTIPOLYGONFROMWKB wpp6_term_relationships.term_order
1305MUTEX wpp6_term_relationships.term_taxonomy_id
1306NAME wpp6_term_taxonomy
1307name wpp6_term_taxonomy.count
1308name2 wpp6_term_taxonomy.description
1309NAME_CONST wpp6_term_taxonomy.parent
1310NAMES wpp6_term_taxonomy.taxonomy
1311NATIONAL wpp6_term_taxonomy.term_id
1312NATURAL wpp6_term_taxonomy.term_taxonomy_id
1313NCHAR wpp6_termmeta
1314NDB wpp6_termmeta.meta_id
1315NDBCLUSTER wpp6_termmeta.meta_key
1316NEW wpp6_termmeta.meta_value
1317newsletter wpp6_termmeta.term_id
1318NEXT wpp6_terms
1319NO wpp6_terms.name
1320NO_WRITE_TO_BINLOG wpp6_terms.slug
1321NONE wpp6_terms.term_group
1322nopager wpp6_terms.term_id
1323NOT wpp6_usermeta
1324notee wpp6_usermeta.meta_key
1325NOW wpp6_usermeta.meta_value
1326nowarning wpp6_usermeta.umeta_id
1327NULL wpp6_usermeta.user_id
1328NULLIF wpp6_users
1329NUMERIC wpp6_users.display_name
1330NUMGEOMETRIES wpp6_users.ID
1331NUMINTERIORRINGS wpp6_users.user_activation_key
1332NUMPOINTS wpp6_users.user_email
1333NVARCHAR wpp6_users.user_login
1334object_id wpp6_users.user_nicename
1335OCT wpp6_users.user_pass
1336OCTET_LENGTH wpp6_users.user_registered
1337OFFSET wpp6_users.user_status
1338ON wpp6_users.user_url
1339ONE WRITE
1340ONE_SHOT X
1341OPEN X509
1342open XA
1343open_count XOR
1344OPTIMIZE Y
1345OPTION YEAR
1346option_id YEAR_MONTH
1347option_name YEARWEEK
1348option_value ZEROFILL
1349mysql> use wp
1350Display all 220 possibilities? (y or n)
1351mysql> use wp
1352Display all 220 possibilities? (y or n)
1353mysql> use asapa454_wp444;
1354Database changed
1355mysql> show tables
1356 -> ;
1357+--------------------------+
1358| Tables_in_asapa454_wp444 |
1359+--------------------------+
1360| wpp6_commentmeta |
1361| wpp6_comments |
1362| wpp6_links |
1363| wpp6_newsletter |
1364| wpp6_newsletter_emails |
1365| wpp6_newsletter_sent |
1366| wpp6_newsletter_stats |
1367| wpp6_options |
1368| wpp6_postmeta |
1369| wpp6_posts |
1370| wpp6_term_relationships |
1371| wpp6_term_taxonomy |
1372| wpp6_termmeta |
1373| wpp6_terms |
1374| wpp6_usermeta |
1375| wpp6_users |
1376+--------------------------+
137716 rows in set (0.00 sec)
1378
1379mysql> drop table
1380Display all 1152 possibilities? (y or n)
1381mysql> drop table
1382 -> ;
1383ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
1384mysql> drop table wpp6_commentmeta |
1385 -> | wpp6_comments |
1386 -> | wpp6_links |
1387 -> | wpp6_newsletter |
1388 -> | wpp6_newsletter_emails |
1389 -> | wpp6_newsletter_sent |
1390 -> | wpp6_newsletter_stats |
1391 -> | wpp6_options |
1392 -> | wpp6_postmeta |
1393 -> | wpp6_posts |
1394 -> | wpp6_term_relationships |
1395 -> | wpp6_term_taxonomy |
1396 -> | wpp6_termmeta |
1397 -> | wpp6_terms |
1398 -> | wpp6_usermeta |
1399 -> exit
1400exit
1401^C
1402mysql> drop table wpp6_commentmeta , wpp6_comments , wpp6_links , wpp6_newsletter , wpp6_newsletter_emails , wpp6_newsletter_sent , wpp6_newsletter_stats , wpp6_options , wpp6_postmeta , wpp6_posts , wpp6_term_relationships , wpp6_term_taxonomy , wpp6_termmeta , wpp6_terms , wpp6_usermeta , wpp6_user;
1403ERROR 1051 (42S02): Unknown table 'asapa454_wp444.wpp6_user'
1404mysql> drop table wpp6_commentmeta , wpp6_comments , wpp6_links , wpp6_newsletter , wpp6_newsletter_emails , wpp6_newsletter_sent , wpp6_newsletter_stats , wpp6_options , wpp6_postmeta , wpp6_posts , wpp6_term_relationships , wpp6_term_taxonomy , wpp6_termmeta , wpp6_terms , wpp6_usermeta , wpp6_user;
1405ERROR 1051 (42S02): Unknown table 'asapa454_wp444.wpp6_commentmeta,asapa454_wp444.wpp6_comments,asapa454_wp444.wpp6_links,asapa454_wp44'
1406mysql> use asapa454_wp444
1407Database changed
1408mysql> drop table wpp6_commentmeta , wpp6_comments , wpp6_links , wpp6_newsletter , wpp6_newsletter_emails , wpp6_newsletter_sent , wpp6_newsletter_stats , wpp6_options , wpp6_postmeta , wpp6_posts , wpp6_term_relationships , wpp6_term_taxonomy , wpp6_termmeta , wpp6_terms , wpp6_usermeta , wpp6_user;
1409ERROR 1051 (42S02): Unknown table 'asapa454_wp444.wpp6_commentmeta,asapa454_wp444.wpp6_comments,asapa454_wp444.wpp6_links,asapa454_wp44'
1410mysql> drop table wpp6_comments;
1411ERROR 1051 (42S02): Unknown table 'asapa454_wp444.wpp6_comments'
1412mysql> drop table `wpp6_comments`;
1413ERROR 1051 (42S02): Unknown table 'asapa454_wp444.wpp6_comments'
1414mysql> drop database;
1415ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
1416mysql> drop database
1417 -> ;
1418ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
1419mysql> create table peq;
1420ERROR 1113 (42000): A table must have at least 1 column
1421mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20),
1422 -> -> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
1423ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-> species VARCHAR(20), sex CHAR(1), birth DATE, death DATE)' at line 2
1424mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE);
1425Query OK, 0 rows affected (0.02 sec)
1426
1427mysql> show tables
1428 -> ;
1429+--------------------------+
1430| Tables_in_asapa454_wp444 |
1431+--------------------------+
1432| pet |
1433| wpp6_users |
1434+--------------------------+
14352 rows in set (0.00 sec)
1436
1437mysql> drop table wpp6_users
1438 -> ;
1439Query OK, 0 rows affected (0.00 sec)
1440
1441mysql> drop table pet;
1442Query OK, 0 rows affected (0.01 sec)
1443
1444mysql> exit
1445Bye
1446root@carclick:/var/www# mysql -u asapa454_admin -p asapa454_wp444 < asapa454_wp444.sql
1447Enter password:
1448root@carclick:/var/www# mysq
1449No command 'mysq' found, did you mean:
1450 Command 'mysql' from package 'mariadb-client-core-10.0' (universe)
1451 Command 'mysql' from package 'mysql-client-core-5.7' (main)
1452mysq: command not found
1453root@carclick:/var/www# mysql
1454ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
1455root@carclick:/var/www# mysql -u asapa454_admin -p asapa454_wp444
1456Enter password:
1457Reading table information for completion of table and column names
1458You can turn off this feature to get a quicker startup with -A
1459
1460Welcome to the MySQL monitor. Commands end with ; or \g.
1461Your MySQL connection id is 60
1462Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu)
1463
1464Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
1465
1466Oracle is a registered trademark of Oracle Corporation and/or its
1467affiliates. Other names may be trademarks of their respective
1468owners.
1469
1470Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
1471
1472mysql> show tables
1473 -> ;
1474+--------------------------+
1475| Tables_in_asapa454_wp444 |
1476+--------------------------+
1477| wpp6_commentmeta |
1478| wpp6_comments |
1479| wpp6_links |
1480| wpp6_newsletter |
1481| wpp6_newsletter_emails |
1482| wpp6_newsletter_sent |
1483| wpp6_newsletter_stats |
1484| wpp6_options |
1485| wpp6_postmeta |
1486| wpp6_posts |
1487| wpp6_term_relationships |
1488| wpp6_term_taxonomy |
1489| wpp6_termmeta |
1490| wpp6_terms |
1491| wpp6_usermeta |
1492| wpp6_users |
1493+--------------------------+
149416 rows in set (0.00 sec)
1495
1496mysql> drop table wpp6_commentmeta , wpp6_comments , wpp6_links , wpp6_newsletter , wpp6_newsletter_emails , wpp6_newsletter_sent , wpp6_newsletter_stats , wpp6_options , wpp6_postmeta , wpp6_posts , wpp6_term_relationships , wpp6_term_taxonomy , wpp6_termmeta , wpp6_terms , wpp6_usermeta , wpp6_user;
1497ERROR 1051 (42S02): Unknown table 'asapa454_wp444.wpp6_user'
1498mysql> drop table wpp6_users;
1499Query OK, 0 rows affected (0.00 sec)
1500
1501mysql> show tables;
1502Empty set (0.00 sec)
1503
1504mysql> exit
1505Bye
1506root@carclick:/var/www# mysql -u asapa454_admin -p asapa454_wp444 < asapa454_wp444.sql
1507Enter password:
1508root@carclick:/var/www# mysql
1509ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
1510root@carclick:/var/www# mysql -u asapa454_admin -p asapa454_wp444
1511Enter password:
1512Reading table information for completion of table and column names
1513You can turn off this feature to get a quicker startup with -A
1514
1515Welcome to the MySQL monitor. Commands end with ; or \g.
1516Your MySQL connection id is 68
1517Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu)
1518
1519Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
1520
1521Oracle is a registered trademark of Oracle Corporation and/or its
1522affiliates. Other names may be trademarks of their respective
1523owners.
1524
1525Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
1526
1527mysql> drop table wpp6_commentmeta , wpp6_comments , wpp6_links , wpp6_newsletter , wpp6_newsletter_emails , wpp6_newsletter_sent , wpp6_newsletter_stats , wpp6_options , wpp6_postmeta , wpp6_posts , wpp6_term_relationships , wpp6_term_taxonomy , wpp6_termmeta , wpp6_terms , wpp6_usermeta , wpp6_users;
1528Query OK, 0 rows affected (0.00 sec)
1529
1530mysql> exit
1531Bye
1532root@carclick:/var/www# mysql -u asapa454_admin -p asapa454_wp444 < asapa454_wp444.sql
1533Enter password:
1534root@carclick:/var/www# sudo systemctl restart nginx
1535root@carclick:/var/www# sudo nano /etc/nginx/sites-available/default
1536root@carclick:/var/www# mysql -u asapa454_admin -p asapa454_wp444
1537Enter password:
1538Reading table information for completion of table and column names
1539You can turn off this feature to get a quicker startup with -A
1540
1541Welcome to the MySQL monitor. Commands end with ; or \g.
1542Your MySQL connection id is 73
1543Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu)
1544
1545Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
1546
1547Oracle is a registered trademark of Oracle Corporation and/or its
1548affiliates. Other names may be trademarks of their respective
1549owners.
1550
1551Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
1552
1553mysql> drop table wpp6_commentmeta , wpp6_comments , wpp6_links , wpp6_newsletter , wpp6_newsletter_emails , wpp6_newsletter_sent , wpp6_newsletter_stats , wpp6_options , wpp6_postmeta , wpp6_posts , wpp6_term_relationships , wpp6_term_taxonomy , wpp6_termmeta , wpp6_terms , wpp6_usermeta , wpp6_users;
1554Query OK, 0 rows affected (0.00 sec)
1555
1556mysql> exit
1557Bye
1558root@carclick:/var/www# mysql -u asapa454_admin -p asapa454_wp444 < asapa454_wp444.sql
1559Enter password:
1560root@carclick:/var/www# mysql -u asapa454_admin -p asapa454_wp444
1561Enter password:
1562Reading table information for completion of table and column names
1563You can turn off this feature to get a quicker startup with -A
1564
1565Welcome to the MySQL monitor. Commands end with ; or \g.
1566Your MySQL connection id is 79
1567Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu)
1568
1569Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
1570
1571Oracle is a registered trademark of Oracle Corporation and/or its
1572affiliates. Other names may be trademarks of their respective
1573owners.
1574
1575Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
1576
1577mysql> drop table wpp6_commentmeta , wpp6_comments , wpp6_links , wpp6_newsletter , wpp6_newsletter_emails , wpp6_newsletter_sent , wpp6_newsletter_stats , wpp6_options , wpp6_postmeta , wpp6_posts , wpp6_term_relationships , wpp6_term_taxonomy , wpp6_termmeta , wpp6_terms , wpp6_usermeta , wpp6_users;
1578Query OK, 0 rows affected (0.00 sec)
1579
1580mysql> exit
1581Bye
1582root@carclick:/var/www# mysql -u asapa454_admin -p asapa454_wp444 < asapa454_wp444.sql
1583Enter password:
1584root@carclick:/var/www# sudo nano /etc/nginx/sites-available/default
1585root@carclick:/var/www# sudo systemctl restart nginx
1586root@carclick:/var/www# sudo systemctl status nginx
1587â— nginx.service - A high performance web server and a reverse proxy server
1588 Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
1589 Active: active (running) since Tue 2017-11-21 18:17:49 GMT; 7s ago
1590 Process: 1165 ExecStop=/sbin/start-stop-daemon --quiet --stop --retry QUIT/5 --pidfile /run/nginx.pid (code=exit
1591 Process: 1173 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
1592 Process: 1169 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=0/SUCCESS
1593 Main PID: 1175 (nginx)
1594 CGroup: /system.slice/nginx.service
1595 ├─1175 nginx: master process /usr/sbin/nginx -g daemon on; master_process on
1596 ├─1176 nginx: worker process
1597 └─1177 nginx: worker process
1598
1599Nov 21 18:17:49 carclick systemd[1]: Stopped A high performance web server and a reverse proxy server.
1600Nov 21 18:17:49 carclick systemd[1]: Starting A high performance web server and a reverse proxy server...
1601Nov 21 18:17:49 carclick systemd[1]: Started A high performance web server and a reverse proxy server.
1602
1603root@carclick:/var/www# php status
1604Could not open input file: status
1605root@carclick:/var/www# php -s
1606
1607^C
1608root@carclick:/var/www# php -v
1609PHP 7.0.22-0ubuntu0.16.04.1 (cli) ( NTS )
1610Copyright (c) 1997-2017 The PHP Group
1611Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies
1612 with Zend OPcache v7.0.22-0ubuntu0.16.04.1, Copyright (c) 1999-2017, by Zend Technologies
1613root@carclick:/var/www# sudo systemctl restart php7.0-fpm
1614root@carclick:/var/www# sudo systemctl status mysql
1615â— mysql.service - MySQL Community Server
1616 Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
1617 Active: active (running) since Sun 2017-11-19 18:54:15 GMT; 1 day 23h ago
1618 Main PID: 10613 (mysqld)
1619 CGroup: /system.slice/mysql.service
1620 └─10613 /usr/sbin/mysqld
1621
1622Warning: Journal has been rotated since unit was started. Log output is incomplete or unavailable.
1623root@carclick:/var/www# sudo nano /etc/nginx/sites-available/default
1624root@carclick:/var/www# sudo systemctl status nginx
1625â— nginx.service - A high performance web server and a reverse proxy server
1626 Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
1627 Active: active (running) since Tue 2017-11-21 18:17:49 GMT; 6min ago
1628 Process: 1165 ExecStop=/sbin/start-stop-daemon --quiet --stop --retry QUIT/5 --pidfile /run/nginx.pid (code=exit
1629 Process: 1173 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
1630 Process: 1169 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=0/SUCCESS
1631 Main PID: 1175 (nginx)
1632 CGroup: /system.slice/nginx.service
1633 ├─1175 nginx: master process /usr/sbin/nginx -g daemon on; master_process on
1634 ├─1176 nginx: worker process
1635 └─1177 nginx: worker process
1636
1637Nov 21 18:17:49 carclick systemd[1]: Stopped A high performance web server and a reverse proxy server.
1638Nov 21 18:17:49 carclick systemd[1]: Starting A high performance web server and a reverse proxy server...
1639Nov 21 18:17:49 carclick systemd[1]: Started A high performance web server and a reverse proxy server.
1640...skipping...
1641â— nginx.service - A high performance web server and a reverse proxy server
1642 Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
1643 Active: active (running) since Tue 2017-11-21 18:17:49 GMT; 6min ago
1644 Process: 1165 ExecStop=/sbin/start-stop-daemon --quiet --stop --retry QUIT/5 --pidfile /run/nginx.pid (code=exit
1645 Process: 1173 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
1646 Process: 1169 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=0/SUCCESS
1647 Main PID: 1175 (nginx)
1648 CGroup: /system.slice/nginx.service
1649 ├─1175 nginx: master process /usr/sbin/nginx -g daemon on; master_process on
1650 ├─1176 nginx: worker process
1651 └─1177 nginx: worker process
1652
1653Nov 21 18:17:49 carclick systemd[1]: Stopped A high performance web server and a reverse proxy server.
1654Nov 21 18:17:49 carclick systemd[1]: Starting A high performance web server and a reverse proxy server...
1655Nov 21 18:17:49 carclick systemd[1]: Started A high performance web server and a reverse proxy server.
1656~
1657~
1658~
1659~
1660~
1661~
1662~
1663~
1664~
1665~
1666~
1667~
1668~
1669~
1670~
1671~
1672~
1673~
1674~
1675~
1676~
1677~
1678~
1679~
1680~
1681~
1682~
1683~
1684~
1685~
1686~
1687~
1688~
1689~
1690~
1691~
1692
1693root@carclick:/var/www# sudo systemctl restart nginx
1694root@carclick:/var/www# sudo nano /etc/nginx/sites-available/default
1695root@carclick:/var/www# mysql -u asapa454_admin -p asapa454_wp444
1696Enter password:
1697Reading table information for completion of table and column names
1698You can turn off this feature to get a quicker startup with -A
1699
1700Welcome to the MySQL monitor. Commands end with ; or \g.
1701Your MySQL connection id is 96
1702Server version: 5.7.20-0ubuntu0.16.04.1 (Ubuntu)
1703
1704Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
1705
1706Oracle is a registered trademark of Oracle Corporation and/or its
1707affiliates. Other names may be trademarks of their respective
1708owners.
1709
1710Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
1711
1712mysql> drop table wpp6_commentmeta , wpp6_comments , wpp6_links , wpp6_newsletter , wpp6_newsletter_emails , wpp6_newsletter_sent , wpp6_newsletter_stats , wpp6_options , wpp6_postmeta , wpp6_posts , wpp6_term_relationships , wpp6_term_taxonomy , wpp6_termmeta , wpp6_terms , wpp6_usermeta , wpp6_users;
1713Query OK, 0 rows affected (0.00 sec)
1714
1715mysql> exit
1716Bye
1717root@carclick:/var/www# mysql -u asapa454_admin -p asapa454_wp444 < asapa454_wp444.sql
1718Enter password:
1719root@carclick:/var/www# sudo nano /etc/nginx/sites-available/default
1720
1721 GNU nano 2.5.3 File: /etc/nginx/sites-available/default
1722
1723# Virtual Host configuration for example.com
1724#
1725# You can move that to a different file under sites-available/ and symlink that
1726# to sites-enabled/ to enable it.
1727#
1728server {
1729 listen 80;
1730 listen [::]:80;
1731
1732 server_name carclick.kz;
1733
1734 root /var/www/site;
1735 index index.html index.php;
1736
1737 location / {
1738 try_files $uri $uri/ =404;
1739 }
1740
1741 location ~ \.php$ {
1742 include snippets/fastcgi-php.conf;
1743 fastcgi_pass unix:/run/php/php7.0-fpm.sock;
1744 }
1745
1746}