数据库教程:linux mysql5.6版本的安装配置过程分享

从今年3月份开始mysql官网开始发布相关的5.6系列的各个版本，对于mysql5.6系列的版本对一起的版本进行了全局性的细节性加强；个人感觉，以下是在虚拟机中配置的mysql5.6.10源码安装的过程分享记录下：
[root@mysql5~]#groupaddmysql
[root@mysql5~]#useradd-r-gmysqlmysql
[root@mysql5~]#ls
anaconda-ks.cfginstall.loginstall.log.syslogmysql-5.6.10.tar.gz
[root@mysql5~]#cd/usr/local/
[root@mysql5local]#ls
binetcgamesincludeliblibexecsbinsharesrc
[root@mysql5local]#cp/root/mysql-5.6.10.tar.gz/usr/local/
[root@mysql5local]#ll
total34468
drwxr-xr-x2rootroot4096Jan272010bin
drwxr-xr-x2rootroot4096Jan272010etc
drwxr-xr-x2rootroot4096Jan272010games
drwxr-xr-x2rootroot4096Jan272010include
drwxr-xr-x2rootroot4096Jan272010lib
drwxr-xr-x2rootroot4096Jan272010libexec
-rw-r–r–1rootroot35174149Apr1700:55mysql-5.6.10.tar.gz
drwxr-xr-x2rootroot4096Jan272010sbin
drwxr-xr-x4rootroot4096Apr1700:32share
drwxr-xr-x2rootroot4096Jan272010src
[root@mysql5local]#tar-zxvfmysql-5.6.10.tar.gz
[root@mysql5local]#cdmysql-5.6.10
cmake.
make&&makeinstall
[root@mysql5mysql-5.6.10]#chown-Rmysql.mysql/usr/local/mysql
[root@mysql5mysql-5.6.10]#
[root@mysql5mysql-5.6.10]#cd/usr/local/mysql/scripts/
[root@mysql5scripts]#./mysql_install_db–user=mysql–basedir=/usr/local/mys
ql–datadir=/usr/local/mysql/data
InstallingMySQLsystemtables…2013-04-1701:26:580[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse–explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).
2013-04-1701:26:5818715[Note]InnoDB:TheInnoDBmemoryheapisdisabled
2013-04-1701:26:5818715[Note]InnoDB:Mutexesandrw_locksuseInnoDB’sownimplementation
2013-04-1701:26:5818715[Note]InnoDB:Compressedtablesusezlib1.2.3
2013-04-1701:26:5818715[Note]InnoDB:CPUdoesnotsupportcrc32instructions
2013-04-1701:26:5818715[Note]InnoDB:Initializingbufferpool,size=128.0M
2013-04-1701:26:5818715[Note]InnoDB:Completedinitializationofbufferpool
2013-04-1701:26:5818715[Note]InnoDB:Thefirstspecifieddatafile./ibdata1didnotexist:anewdatabasetobecreated!
2013-04-1701:26:5918715[Note]InnoDB:Settingfile./ibdata1sizeto12MB
2013-04-1701:26:5918715[Note]InnoDB:Databasephysicallywritesthefilefull:wait…
2013-04-1701:26:5918715[Note]InnoDB:Settinglogfile./ib_logfile101sizeto48MB
2013-04-1701:26:5918715[Note]InnoDB:Settinglogfile./ib_logfile1sizeto48MB
2013-04-1701:26:5918715[Note]InnoDB:Renaminglogfile./ib_logfile101to./ib_logfile0
2013-04-1701:26:5918715[Warning]InnoDB:Newlogfilescreated,LSN=45781
2013-04-1701:26:5918715[Note]InnoDB:Doublewritebuffernotfound:creatingnew
2013-04-1701:26:5918715[Note]InnoDB:Doublewritebuffercreated
2013-04-1701:26:5918715[Note]InnoDB:128rollbacksegment(s)areactive.
2013-04-1701:26:5918715[Warning]InnoDB:Creatingforeignkeyconstraintsystemtables.
2013-04-1701:26:5918715[Note]InnoDB:Foreignkeyconstraintsystemtablescreated
2013-04-1701:26:5918715[Note]InnoDB:Creatingtablespaceanddatafilesystemtables.
2013-04-1701:26:5918715[Note]InnoDB:Tablespaceanddatafilesystemtablescreated.
2013-04-1701:26:5918715[Note]InnoDB:Waitingforpurgetostart
2013-04-1701:26:5918715[Note]InnoDB:1.2.10started;logsequencenumber0
2013-04-1701:26:5918715[Note]Binlogend
2013-04-1701:26:5918715[Note]InnoDB:FTSoptimizethreadexiting.
2013-04-1701:26:5918715[Note]InnoDB:Startingshutdown…
2013-04-1701:27:0018715[Note]InnoDB:Shutdowncompleted;logsequencenumber1625977
OK
Fillinghelptables…2013-04-1701:27:000[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse–explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).
2013-04-1701:27:0018738[Note]InnoDB:TheInnoDBmemoryheapisdisabled
2013-04-1701:27:0018738[Note]InnoDB:Mutexesandrw_locksuseInnoDB’sownimplementation
2013-04-1701:27:0018738[Note]InnoDB:Compressedtablesusezlib1.2.3
2013-04-1701:27:0018738[ Note]InnoDB:CPUdoesnotsupportcrc32instructions
2013-04-1701:27:0018738[Note]InnoDB:Initializingbufferpool,size=128.0M
2013-04-1701:27:0018738[Note]InnoDB:Completedinitializationofbufferpool
2013-04-1701:27:0018738[Note]InnoDB:HighestsupportedfileformatisBarracuda.
2013-04-1701:27:0018738[Note]InnoDB:128rollbacksegment(s)areactive.
2013-04-1701:27:0018738[Note]InnoDB:Waitingforpurgetostart
2013-04-1701:27:0118738[Note]InnoDB:1.2.10started;logsequencenumber1625977
2013-04-1701:27:0118738[Note]Binlogend
2013-04-1701:27:0118738[Note]InnoDB:FTSoptimizethreadexiting.
2013-04-1701:27:0118738[Note]InnoDB:Startingshutdown…
2013-04-1701:27:0218738[Note]InnoDB:Shutdowncompleted;logsequencenumber1625987
OK
Tostartmysqldatboottimeyouhavetocopy
support-files/mysql.servertotherightplaceforyoursystem
PLEASEREMEMBERTOSETAPASSWORDFORTHEMySQLrootUSER!
Todoso,starttheserver,thenissuethefollowingcommands:
/usr/local/mysql/bin/mysqladmin-urootpassword’new-password’
/usr/local/mysql/bin/mysqladmin-uroot-hmysql5.6password’new-password’
Alternativelyyoucanrun:
/usr/local/mysql/bin/mysql_secure_installation
whichwillalsogiveyoutheoptionofremovingthetest
databasesandanonymoususercreatedbydefault.Thisis
stronglyrecommendedforproductionservers.
Seethemanualformoreinstructions.
YoucanstarttheMySQLdaemonwith:
cd.;/usr/local/mysql/bin/mysqld_safe&
YoucantesttheMySQLdaemonwithmysql-test-run.pl
cdmysql-test;perlmysql-test-run.pl
Pleasereportanyproblemswiththe./bin/mysqlbugscript!
ThelatestinformationaboutMySQLisavailableonthewebat
https://www.mysql.com
SupportMySQLbybuyingsupport/licensesathttps://shop.mysql.com
Newdefaultconfigfilewascreatedas/usr/local/mysql/my.cnfand
willbeusedbydefaultbytheserverwhenyoustartit.
Youmayeditthisfiletochangeserversettings
WARNING:Defaultconfigfile/etc/my.cnfexistsonthesystem
ThisfilewillbereadbydefaultbytheMySQLserver
Ifyoudonotwanttousethis,eitherremoveit,orusethe
–defaults-fileargumenttomysqld_safewhenstartingtheserver
[root@mysql5scripts]#
[root@mysql5scripts]#cd/usr/local/mysql/support-files/
[root@mysql5support-files]#cpmysql.server/etc/rc.d/init.d/mysql
[root@mysql5support-files]#cpmy-default.cnf/etc/my.cnf
cp:overwrite`/etc/my.cnf’?y
[root@mysql5support-files]#
[root@mysql5support-files]#chkconfig-addmysql
-add:unknownoption
[root@mysql5support-files]#chkconfig–addmysql
[root@mysql5support-files]#chkconfigmysqlon
[root@mysql5support-files]#servicemysqlstart
StartingMySQL.[OK]
[root@mysql5support-files]#
[root@mysql5data]#mysql-umysql-p-S/tmp/mysql.sock
Enterpassword:
WelcometotheMySQLmonitor.Commandsendwith;org.
YourMySQLconnectionidis1
Serverversion:5.6.10Sourcedistribution
Type’help;’or’h’forhelp.Type’c’toclearthebuffer.
mysql>
mysql>status;
————–
mysqlVer14.12Distrib5.0.77,forredhat-linux-gnu(i686)usingreadline5.1
Connectionid:1
Currentdatabase:
Currentuser:mysql@localhost
SSL:Notinuse
Currentpager:stdout
Usingoutfile:”
Usingdelimiter:;
Serverversion:5.6.10Sourcedistribution
Protocolversion:10
Connection:LocalhostviaUNIXsocket
Servercharacterset:latin1
Dbcharacterset:latin1
Clientcharacterset:latin1
Conn.characterset:latin1
UNIXsocket:/tmp/mysql.sock
Uptime:3min38sec
Threads:1Questions:5Slowqueries:0Opens:67Flushtables:1Opentables:60Queriespersecondavg:0.022
————–
mysql> 您可能感兴趣的文章:linux下安装apache与php;Apache+PHP+MySQL配置攻略mysql5.7.13安装配置方法图文教程(linux)Linux下MySQL安装配置MySQL配置参数详解最全的mysql5.7.13安装配置方法图文教程(linux)强烈推荐!查看linux服务器上mysql配置文件路径的方法linux下指定mysql数据库服务器主从同步的配置实例linux下apache、mysql、php安装配置详细笔记CentOSLinux下配置Apache2+PHP5+MySQL5+GD库的方法Linux虚拟机下mysql5.7安装配置方法图文教程一次Linux修改MySQL配置不生效的问题解决

MySQL中批量删除指定前缀表的sql语句

Linux下安装mysql-5.6.4 的图文教程

上述就是数据库技术:linux mysql5.6版本的安装配置过程分享的全部内容，如果对大家有所用处且需要了解更多关于mysql数据库学习教程，希望大家多多关注—计算机技术网(www.ctvol.com)!