Mysql 5.5.56版本(二进制包安装)自定义安装路径步骤记录
安装路径:/application/mysql-5.5.56
1.前期准备
mysql依赖
libaio yuminstall-ylibaio
创建用户mysql,以该用户的身份执行mysql
useradd-s/bin/false-Mmysql
下载mysql二进制包并解压
cd/tools wgethttps://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.56-linux-glibc2.5-x86_64.tar.gz tar-zxfmysql-5.5.56-linux-glibc2.5-x86_64.tar.gz-C/application/
切换到/application目录,将mysql文件夹名改短,给mysql目录做一个软链接
cd/application/ mvmysql-5.5.56-linux-glibc2.5-x86_64/mysql-5.5.56 ln-smysql-5.5.56/mysql
递归设置mysql目录的所属组和所属用户
chown-Rmysql:mysqlmysql-5.5.56/
2.mysql目录内操作
cdmysql
初始化数据库
会在mysql目录内生成一个data目录,存放数据库的目录
./scripts/mysql_install_db--basedir=/application/mysql--datadir=/application/mysql/data/--user=mysql
更改所属用户和组
chown-Rroot. chown-Rmysqldata
除了mysql目录下的data目录所属用户不变,其他所有文件的所属用户改为root
拷贝配置文件
cpsupport-files/my-medium.cnf/etc/my.cnf
将mysql的配置文件拷贝为/etc/目录下的my.cnf
修改配置文件
sed-i28i'log-error=/application/mysql/data/mysqld.error'/etc/my.cnf
在配置文件插入了一行,进行配置错误日志
/etc/my.cnfContent: #ExampleMySQLconfigfileformediumsystems. # #Thisisforasystemwithlittlememory(32M-64M)whereMySQLplays #animportantpart,orsystemsupto128MwhereMySQLisusedtogetherwith #otherprograms(suchasawebserver) # #MySQLprogramslookforoptionfilesinasetof #locationswhichdependonthedeploymentplatform. #Youcancopythisoptionfiletooneofthose #locations.Forinformationabouttheselocations,see: #http://dev.mysql.com/doc/mysql/en/option-files.html # #Inthisfile,youcanusealllongoptionsthataprogramsupports. #Ifyouwanttoknowwhichoptionsaprogramsupports,runtheprogram #withthe"--help"option. #ThefollowingoptionswillbepassedtoallMySQLclients [client] #password=your_password port=3306 socket=/tmp/mysql.sock #Herefollowsentriesforsomespecificprograms #TheMySQLserver [mysqld] port=3306 log-error=/application/mysql/data/mysqld.error socket=/tmp/mysql.sock skip-external-locking key_buffer_size=16M max_allowed_packet=1M table_open_cache=64 sort_buffer_size=512K net_buffer_length=8K read_buffer_size=256K read_rnd_buffer_size=512K myisam_sort_buffer_size=8M #Don'tlistenonaTCP/IPportatall.Thiscanbeasecurityenhancement, #ifallprocessesthatneedtoconnecttomysqldrunonthesamehost. #AllinteractionwithmysqldmustbemadeviaUnixsocketsornamedpipes. #NotethatusingthisoptionwithoutenablingnamedpipesonWindows #(viathe"enable-named-pipe"option)willrendermysqlduseless! # #skip-networking #ReplicationMasterServer(default) #binaryloggingisrequiredforreplication log-bin=mysql-bin #binaryloggingformat-mixedrecommended binlog_format=mixed #requireduniqueidbetween1and2^32-1 #defaultsto1ifmaster-hostisnotset #butwillnotfunctionasamasterifomitted server-id=1 #ReplicationSlave(commentoutmastersectiontousethis) # #Toconfigurethishostasareplicationslave,youcanchoosebetween #twomethods: # #1)UsetheCHANGEMASTERTOcommand(fullydescribedinourmanual)- #thesyntaxis: # #CHANGEMASTERTOMASTER_HOST=,MASTER_PORT=, #MASTER_USER=,MASTER_PASSWORD=; # #whereyoureplace,,byquotedstringsand #bythemaster'sportnumber(3306bydefault). # #Example: # #CHANGEMASTERTOMASTER_HOST='125.564.12.1',MASTER_PORT=3306, #MASTER_USER='joe',MASTER_PASSWORD='secret'; # #OR # #2)Setthevariablesbelow.However,incaseyouchoosethismethod,then #startreplicationforthefirsttime(evenunsuccessfully,forexample #ifyoumistypedthepasswordinmaster-passwordandtheslavefailsto #connect),theslavewillcreateamaster.infofile,andanylater #changeinthisfiletothevariables'valuesbelowwillbeignoredand #overriddenbythecontentofthemaster.infofile,unlessyoushutdown #theslaveserver,deletemaster.infoandrestarttheslaverserver. #Forthatreason,youmaywanttoleavethelinesbelowuntouched #(commented)andinsteaduseCHANGEMASTERTO(seeabove) # #requireduniqueidbetween2and2^32-1 #(anddifferentfromthemaster) #defaultsto2ifmaster-hostisset #butwillnotfunctionasaslaveifomitted #server-id=2 # #Thereplicationmasterforthisslave-required #master-host= # #Theusernametheslavewilluseforauthenticationwhenconnecting #tothemaster-required #master-user= # #Thepasswordtheslavewillauthenticatewithwhenconnectingto #themaster-required #master-password= # #Theportthemasterislisteningon. #optional-defaultsto3306 #master-port= # #binarylogging-notrequiredforslaves,butrecommended #log-bin=mysql-bin #UncommentthefollowingifyouareusingInnoDBtables #innodb_data_home_dir=/usr/local/mysql/data #innodb_data_file_path=ibdata1:10M:autoextend #innodb_log_group_home_dir=/usr/local/mysql/data #Youcanset.._buffer_pool_sizeupto50-80% #ofRAMbutbewareofsettingmemoryusagetoohigh #innodb_buffer_pool_size=16M #innodb_additional_mem_pool_size=2M #Set.._log_file_sizeto25%ofbufferpoolsize #innodb_log_file_size=5M #innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_lock_wait_timeout=50 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #RemovethenextcommentcharacterifyouarenotfamiliarwithSQL #safe-updates [myisamchk] key_buffer_size=20M sort_buffer_size=20M read_buffer=2M write_buffer=2M [mysqlhotcopy] interactive-timeout
拷贝启动程序
cpsupport-files/mysql.server/etc/init.d/mysql
将mysql的启动程序拷贝到/etc/init.d/目录下,以便启动程序
编辑启动文件,配置启动目录
方法一:
思路是给配置文件提供的变量进行赋值。较麻烦。
sed-i':a;N;$!ba;s/basedir=\ndatadir=/basedir=\/application\/mysql\ndatadir=\/application\/mysql\/data/g'/etc/init.d/mysql sed-i':a;N;$!ba;s/mysqld_pid_file_path=\n/mysqld_pid_file_path=\/application\/mysql\/data\/mysqld.pid\n/g'/etc/init.d/mysql
等价于将45、46两行
basedir= datadir= mysqld_pid_file_path=
替换成
basedir=/application/mysql datadir=/application/mysql/data mysqld_pid_file_path=/application/mysql/data/mysql.pid
方法二(推荐):
思路是将脚本的默认地址(/usr/local/mysql)直接替换成自定义路径(/application/mysql),便不用给变量赋值
sed-i's#/usr/local/mysql#/application/mysql#g'/etc/init.d/mysql
到这里mysql安装完成可以正常启动
3.后期结尾
命令创建软链接
将mysql命令创建软链接到环境变量的目录,使用户可以在变量找到相应的命令
ln-s/application/mysql/bin/*/usr/local/sbin
设置与修改密码
第一次设置密码:
mysqladmin-u''password''
例子:
mysqladmin-u'root'password'PassWord'
往后修改密码:
mysqladmin-u''-p''password''
例子:
mysqladmin-u'root'-p'PassWord'password'NewPassWord'
登录mysql
$mysql-u'root'-p'PassWord' WelcometotheMySQLmonitor.Commandsendwith;or\g. ... mysql>#成功登陆到mysql控制台 $mysql-uroot-pPassWord WelcometotheMySQLmonitor.Commandsendwith;or\g. ... mysql>#成功登陆到mysql控制台 $mysql-u'root'-p Enterpassword:#这里输入用户的密码 WelcometotheMySQLmonitor.Commandsendwith;or\g. ...
mysql>#成功登陆到mysql控制台
$mysql-uroot-p Enterpassword:#这里输入用户的密码 WelcometotheMySQLmonitor.Commandsendwith;or\g. ...
mysql>#成功登陆到mysql控制台
键入quit或Ctrl+d退出mysql环境
mysql>quit Bye [root@wwwmysql]# or mysql>^DBye [root@wwwmysql]#
4.常用命令
进入mysql
mysql-u'root'-p'PassWord' mysql-uroot-pPassWord mysql-u'root'-p mysql-uroot-p
启动mysql
servicemysqlstart
停止mysql
servicemysqlstop
重启mysql
servicemysqlrestart
以上所述是小编给大家介绍的Mysql5.5.56版本(二进制包安装)自定义安装路径步骤记录,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持!