linux下linux解壓linux過程(生產環境下centos?redhat經過n輪使用)
1.linuxmysql-5.5.29-linux2.6-x86_64.tar.gz文件到opt目錄
2.進入opt目錄解壓文件#tar?-zxvf?mysql-5.5.29-linux2.6-x86_64.tar.gz
3.建立mysql用戶組#groupadd?mysql
4.建立mysql用戶并加入mysql用戶組#useradd?mysql?-g?mysql?-p?1234567890?-s?/sbin/nologin?-m
5.建立軟鏈接#ln?-s?mysql-5.5.29-linux2.6-x86_64?mysql
6.(說明一下,以下的/opt/mysql/的路徑要保持一致,如果是/opt/mysql那就都保持這個一致)
#cd?mysql #chown?-R?mysql?. #chgrp?-R?mysql?. #scripts/mysql_install_db?--user=mysql?--datadir=/opt/mysql/data/ #chown?-R?root?. #chown?-R?mysql?data #cp?support-files/my-medium.cnf?/etc/my.cnf??(128M內存) 或者cp?support-files/my-large.cnf?/etc/my.cnf(512M內存) 或者cp?support-files/my-huge.cnf?/etc/my.cnf?(1-2G內存) 或者cp?support-files/my-innodb-heavy-4G.cnf?/etc/my.cnf(4G內存)
在my.cnf文件修改端口等配置
#vi?/etc/my.cnf
(1)、兩個地方的3306端口,改成13316
(2)、最大連接數?和?innodb_file_per_table設置.開啟
在
#?The?MySQL?server
[mysqld]
的末尾,加上
max_connections=3100 innodb_file_per_table=1
#bin/mysqld_safe?–user=mysql?&?????等幾分鐘再往下執行(回車)
拷貝文件#cp?support-files/mysql.server?/etc/init.d/mysql
然后修改/etc/init.d/mysql文件
basedir=/opt/mysql datadir=/opt/mysql/data
往下看,這幾個都改成這樣(和解壓安裝的mysql路徑關聯):
basedir=/opt/mysql bindir=/opt/mysql/bin datadir=/opt/mysql/data sbindir=/opt/mysql/bin libexecdir=/opt/mysql/bin
自動啟動#chkconfig?–add?mysql
????????#chkconfig?mysql?on
停止#service?mysql?stop???如果報Punrecognized?service錯則:chmod?755?/etc/rc.d/init.d/mysql
啟動#service?mysql?start
#cd?../
初始化管理員root的密碼#/opt/mysql/bin/mysqladmin?-u?root?password?‘1234567890’
讓root帳號可以本地和遠程連接使用#/opt/mysql/bin/mysql?-u?root?-p
輸入初始好的密碼1234567890
mysql>GRANT?ALL?PRIVILEGES?ON?*.*?TO?root@"%"?IDENTIFIED?BY?"1234567890"; mysql>flush?privileges;
創建其他賬號
mysql>GRANT?ALL?PRIVILEGES?ON?*.*?TO?abcd@"%"?IDENTIFIED?BY?"abcd#123456"; mysql>flush?privileges; mysql>quit;
查看mysql進程
#ps?-ef|grep?mysql
來來來,為自己點贊,已經完成,請繼續加油。
【相關推薦】
1.?linux
2.?linux
3.linux