Move MySQL directory on Virtualmin

Virtualmin
1

I’m trying to move my MySQL directory to /home

I’ve done so but can’t seem to get it started using the Virtualmin web portal

If I try and start MySQL with this command

service mysqld start

I get this output

Starting mysqld: [ OK ]

However when I try to start it from the web portal it appears that the page just refreshes.

My my.cnf is as follows

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

innodb_buffer_pool_size = 1G
symbolic-links=0
innodb_file_per_table = 1
thread_concurrency = 8
query_cache_size = 32M
thread_cache_size = 8
myisam_sort_buffer_size = 64M
read_rnd_buffer_size = 8M
read_buffer_size = 2M
sort_buffer_size = 2M
table_cache = 512
max_allowed_packet = 1M
key_buffer = 384M
bind-address = 127.0.0.1

[mysqld_safe]
log-error=/home/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Can’t seem to see why it’s not starting. Is there anything else that needs to be configured for Virtualmin or anything else I should check?

2

Nevermind I have resolved the issue.

For anybody that is experiencing the same issue here’s what to look out for.

Make sure your directory with mysql.sock is owned by mysql

chown -R mysql:root /var/live/mysql