what is the difference between running mysql using:
/etc/rc.d/rc.mysqld start and
./mysql.server start (of /usr/share/mysql)

first picks data directory /var/lib/mysql
second picks data directory using /etc/my.cnf

If you look at those two scripts, you will see they are way different.
First one is written by PatV and explicitly sets
in the mysqld_start() function.

The second one is written by someone else and thus presumably does things differently (as you state yourself).
Also it comes with the mariadb package.
(this on my primary -current box)


So not sure what to say besides; yes they are two different scripts which behaves differently, so your results will be different running one or the other.
I guess it means you should be mindful of which you want to run and/or rewrite one to match the other (with the implicated management overhead over time).


Thanks
--
KarlMag

Thanks for your reply, I modified --datadir=/var/lib/mysql to --datadir=/home/my-path
Hope its good practice to edit rc.mysqld in this way