Kako napraviti web stranicu - što me sve čeka prije početka?

[Vl@do]

Nakon instalacije mariadb

Kod: Označi sve

[vl4do@archlinux ~]$ mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2 "No such file or directory")
Enter current password for root (enter for none): 

što god da upišem ili ne upišem, isti error. Možda zato što sam ranije instalirao mariadb, mysql... i štošta. Moram to sve prvo očistiti.

[gagiD]

Da ok je ono za PHP.

Provjeri stanje servisa s:

Kod: Označi sve

systemctl status mysqld

[Vl@do]

Kod: Označi sve

● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Sat 2017-01-28 17:15:49 CET; 14h ago
  Process: 284 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 266 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-e
  Process: 257 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 284 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

Jan 28 17:15:42 archlinux systemd[1]: Starting MariaDB database server...
Jan 28 17:15:48 archlinux mysqld[284]: 2017-01-28 17:15:48 139754614713856 [Note] /usr/sbin/mysqld (mysqld 10.1.21-MariaDB) starting as process 284 ...
Jan 28 17:15:48 archlinux mysqld[284]: 2017-01-28 17:15:48 139754614713856 [Warning] Can't create test file /var/lib/mysql/archlinux.lower-test
Jan 28 17:15:48 archlinux mysqld[284]: [90B blob data]
Jan 28 17:15:48 archlinux mysqld[284]: 2017-01-28 17:15:48 139754614713856 [ERROR] Aborting
Jan 28 17:15:49 archlinux systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 28 17:15:49 archlinux systemd[1]: Failed to start MariaDB database server.
Jan 28 17:15:49 archlinux systemd[1]: mariadb.service: Unit entered failed state.
Jan 28 17:15:49 archlinux systemd[1]: mariadb.service: Failed with result 'exit-code'.
~

[Vl@do]

U /etc/mysql/my.cnf sam dodao

Kod: Označi sve

[mysqld]
datadir = /var/lib/mysql/
socket = /var/lib/mysql/mysql.sock

Nakon toga

Kod: Označi sve

systemctl status mysqld

Kod: Označi sve

● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since Sun 2017-01-29 12:41:41 CET; 8s ago
  Process: 1760 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited,
  Process: 1669 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/gal
  Process: 1667 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, 
 Main PID: 1731 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 27 (limit: 4915)
   CGroup: /system.slice/mariadb.service
           └─1731 /usr/sbin/mysqld

Jeaah, pokrenuo se.
Morao sam, čini mi se i dati ovlasti svim fileovima u mapi msql. Nšao u terminalu još brdo manuala.
Idem na sljedeći korak "phpmyadmin".

[Vl@do]

Provjera mysql

Kod: Označi sve

[vl4do@archlinux ~]$ mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 7
Server version: 10.1.21-MariaDB MariaDB Server

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)]> 

Za sada bez passworda, a mislim da nema ni potrebe.

[Vl@do]

@gagiD, phpmyadmin instaliran i dostupan na localhost/phpmyadmin
WP instaliran i dostupan na localhost/wordpress. Nisam ga raspakirao u /srv/httpd (ne postoji taj folder), nego u /srv/http.
Sada još ostaje login u jedno i drugo (poslije ručka uz )

[Vl@do]

@ /etc/webapps/phpmyadmin/config.inc.php promijenio "false" u "TRUE" u liniji $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
...i opet se ne mogu logirati u phpmyadmin.

[gagiD]

Stavi ovo u config:

Kod: Označi sve

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

[Vl@do]

U /etc/webapps/phpmyadmin/config.inc.php ?
Kad to dodam na kraj filea, ne mogu ni login ekran otvoriti. Po ovim uputama sam resetirao pass i sada se uredno prijavim sa svojim passom u mariaDB

Kod: Označi sve

MariaDB [(none)]> SELECT CURRENT_USER();
+----------------+
| CURRENT_USER() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

[Vl@do]

Probao još i ovo:

Kod: Označi sve

grant all on *.* to vlado@127.0.0.1 identified by 'novi_pass';

Kod: Označi sve

grant all on *.* to vlado@localhost identified by 'novi_pass';

Kod: Označi sve

sudo systemctl restart httpd

Sad mogu iz konzole pokrenuti mariaDB kao root ili kao novi_user, ali u pregledniku localhost/phpmyadmin još uvijek ne.