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
- How to blend adsense inside your post?
- Formatting my post
- Notepad++ - Add C++ compiler
- Install PHPMailer 5.2.4 and use smtp gmail
- Datatable export excel wraptext and newline
- phpexcel toggle expand and hide column in EXCEL and summary
- Linux, automatically backup MySQL database daily
- SPSS job interview questions
- Install PHP ibm_db2 extension in Linux (redHat)
No comments:
Post a Comment