Linux za Sve forum

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

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: 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'.
~

Kod: Označi sve

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

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

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

Kod: Označi sve

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

Kod: Označi sve

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

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