I have a Web Server with Centos 7.5.1804 which previously worked very well. I wanted to change the path of the Maria DB database folder and to do this I did:
Code: Select all
systemctl stop mariadb
rsync -av /var/lib/mysql /home/db
mv /var/lib/mysql /var/lib/mysql.bak
vi /etc/my.cnf
------------------------------------
[mysqld]
datadir=/home/db
socket=/home/db/mysql.sock
[client]
port=3306
socket=/home/db/mysql.sock
!includedir /etc/my.cnf.d
----------------------------------
systemctl start mariadb
Code: Select all
mysql -u root -p
select @@datadir;
+----------------------------+
| @@datadir |
+----------------------------+
| /home/db/ |
+----------------------------+
1 row in set (0.01 sec)
The problem that now I can no longer connect via the browser to phpMyAdmin. The login window opens but does not recognize the password and so no CSM is installed.
I completely disabled selinux.
The password is recognized from the command line: I can access the under console of Mysql, create and delete dabase, create users, change passwords etc.
Please help me. Thank you!