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
Online computer courses, code, programming tutorial and sidebar information for monitoring Canadian S&P/TSX index. Build friendship and networking. Welcome to visit my blogs often!!! I also have two other sites: YouTube Channel and Google site.
Adsense
Popular Posts
- PHPWind-- A PHP forum script applcaition in China
- Free host forum is not reliable
- job interview questions (1)
- Powerful js library datable to export table in pdf, excel, sorting, freezing column and table header fixed (sticky)
- PHP connect IBM db2 database in XAMPP
- Set up a child account and set screen time limit in Windows 8
- Datatable export excel wraptext and newline
- phpexcel toggle expand and hide column in EXCEL and summary
- Mirror my WordPress website
- Install PHP ibm_db2 extension in Linux (redHat)
No comments:
Post a Comment