After the change of the Maria DB databases no longer connects with PhpMyAdmin

Issues related to applications and software problems
FabioB
Posts: 17
Joined: 2015/10/03 19:57:37
Location: Perugia (Italia)

Re: After the change of the Maria DB databases no longer connects with PhpMyAdmin

Post by FabioB » 2018/06/07 21:27:46

It's a new installation, I've only installed CentOS and LAMP and redirected the databases folder, there's no data. I would have liked to solve the problem rather than circumvent it.

User avatar
TrevorH
Site Admin
Posts: 33216
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: After the change of the Maria DB databases no longer connects with PhpMyAdmin

Post by TrevorH » 2018/06/07 22:18:47

The correct solution is to either expand the filesystem that contains /var/lib/mysql or to create a new filesystem that you can dedicate to it. Moving it under /home is a horrible hack and no solution.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

FabioB
Posts: 17
Joined: 2015/10/03 19:57:37
Location: Perugia (Italia)

Re: After the change of the Maria DB databases no longer connects with PhpMyAdmin

Post by FabioB » 2018/06/08 14:20:48

Ok, I will format and give different sizes to disk. The /home mount point is obligatory?

User avatar
TrevorH
Site Admin
Posts: 33216
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: After the change of the Maria DB databases no longer connects with PhpMyAdmin

Post by TrevorH » 2018/06/08 14:22:23

You will need a /home directory but it doesn't need to be 147GB if you only aim to keep 166MB on it.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

FabioB
Posts: 17
Joined: 2015/10/03 19:57:37
Location: Perugia (Italia)

Re: After the change of the Maria DB databases no longer connects with PhpMyAdmin

Post by FabioB » 2018/06/08 15:50:10

I left CenOS partitioning automatically.
Well, but, the last thing, in what mount poin is /var?

FabioB
Posts: 17
Joined: 2015/10/03 19:57:37
Location: Perugia (Italia)

Re: After the change of the Maria DB databases no longer connects with PhpMyAdmin

Post by FabioB » 2018/06/11 20:01:07

All right, now it's so

Code: Select all

[root@decoraweb ~]# df -h
File system              Dim. Usati Dispon. Uso% Montato su
/dev/mapper/centos-root   90G  1,9G     88G   3% /
devtmpfs                 485M     0    485M   0% /dev
tmpfs                    497M     0    497M   0% /dev/shm
tmpfs                    497M  7,1M    489M   2% /run
tmpfs                    497M     0    497M   0% /sys/fs/cgroup
/dev/sda1               1014M  159M    856M  16% /boot
/dev/mapper/centos-home  7,6G   33M    7,6G   1% /home
tmpfs                    100M     0    100M   0% /run/user/0

Post Reply