Tuesday, July 20, 2010

run mysql as non-root user

For example in westgrid:

1) in home directory, create file .my.cnf
---------------------------------------------------------------
[mysqld]
datadir=/global/home/jiansen6/mymysql
socket=/global/home/jiansen6/mymysql/thesock
port=8081

[mysql]
socket=/global/home/jiansen6/mymysql/thesock
port=8081

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/global/home/jiansen6/mymysql/the.log
pid-file=/global/home/jiansen6/mymysql/the.pid
-------------------------------------------------------------
2) mysql_install_db
3) mysqld_safe &

shutdown mysql
4) mysqladmin -u root -S /global/home/jiansen6/mymysql/thesock shutdown -p

No comments:

Post a Comment