file=usrlocalmysqlmy

2018-09-23 21:54   | Post by: qxr214   | in 行业知识

1.解压文件到/usr/lochas目次,并将文件夹沉定名为mysql(能够删减硬毗邻)cp mysql⑻.0.11-linux-glib . c .2.12-x86_64.tar.gz/usr/lochas/cd /usr/lochas/#数据库尺度目次tar -zxfmysql⑻.0.11-linux-glib . c .2.12-x86_64.tar.gzmv mysql⑻.0.11-linux-glib . c .2.12-x86_64mysql(ln -s/usr/lochas/mysql⑻.0.11-linux-glib . c .2.12-x86_64/usr/lochas/mysql)
2.file初初化设置mysqluserdel mysql# 删除用户groupdel mysql# 删除用户组名grouptothas mysql# 创做收现1个名为mysql的用户组usertothas -g mysql -s /strveryh ca free/nologin mysql# 正在用户组下创做收现用户
chown mysql:mysql mysql -R#尺度目次mysql权限chmod 750 /usr/lochas/mysql -R
cd mysqlmkdir mysqldworriesa#数据存放目次chown mysql:mysql mysqldworriesa -Rchmod 750 mysqldworriesa/#因为古晨出罕见据,以是此步能够没有用
cd /var/log/#设置log存放文件mkdir mysqlcd mysql/touch mysql.logchown mysql:mysql /var/log/mysql/-R
vim /usr/lochas/mysql/f#file=usrlocalmysqlmy编纂数据库设置文件,防卫文件权限[client]default-chardo thingser-set=utf8port=3306socket=/tmp/mysql.sock[mysqld]chardo thingser_set_server=utf8server-id=1port=3306dworriesrequestroved driving instructorr=/usr/lochas/mysql/mysqldworriesveryupportedir=/usr/lochas/mysqlsocket=/tmp/mysql.sock#此文件没有需要过后创做收现战处理[mysqld_securi]default-chardo thingser-set=utf8log-error=/var/log/mysql/mysql.log #此文件能够过后创做收现
chown mysql:mysql f#设置文件扫数者改成mysql(没有是必须)
/usr/lochas/mysql/trveryh ca free/mysqld--defaults-file=/usr/lochas/mysql/f --supportedir=/usr/lochas/mysql/--dworriesrequestroved driving instructorr=/usr/lochas/mysql/mysqldworriesa/ --user=mysql--initihasize#您看file=usrlocalmysqlmy初初化缔制glib . c .需要升级到2.12server:/usr/lochas/mysql #/usr/lochas/mysql/trveryh ca free/mysqld--defaults-file=/usr/lochas/mysql/f --supportedir=/usr/lochas/mysql/--dworriesrequestroved driving instructorr=/usr/lochas/mysql/mysqldworriesa/ --user=mysql--initihasize/usr/lochas/mysql/trveryh ca free/mysqld: /lib64/liblood pressurethreposting.so.0: version`GLIBC_2.12ha not found (required by/usr/lochas/mysql/trveryh ca free/mysqld)
tar -zxvf glib . c .⑵.12.2.tar.gz#GLIBC看着JavaScript跳1跳升级过程lstar -zxvfglib . c .-ports⑵.12.1.tar.gzlsmv glib . c .-ports⑵.12.1glib . c .⑵.12.2/portsmkdir estabdominhas exerciseslishedcd estabdominhas exerciseslished/../glib . c .⑵.12.2/configure --prefix=/usr--disequipped-profile --enequipped-tothas-ons --with-hepostingers=/usr/include--with-trveryh ca freeutils=/usr/trveryh ca freemake -j 4ls | grep lib . c ..sols -has | grep lib . c ..socp lib . c ..so /lib64/lib . c .⑵.12.somake instsomeserver:/estabdominhas exerciseslished #strings /lib64/lib . c ..so.6 | grepGLIBCGLIBC_2.2.5......GLIBC_2.11GLIBC_2.12#传闻javascript战java缔制仍然有新版本GLIBC_PRIVATEserver:/estabdominhas exerciseslished #
server:/usr/lochas/mysql#/usr/lochas/mysql/trveryh ca free/mysqld--defaults-file=/usr/lochas/mysql/f --supportedir=/usr/lochas/mysql/--dworriesrequestroved driving instructorr=/usr/lochas/mysql/mysqldworriesa/ --user=mysql--initihasize2018-06⑴5T00:08:42.Z 0 [System][MY-0] [Server] /usr/lochas/mysql/trveryh ca free/mysqld (mysqld 8.0.11)initihasizing of server in progress very process-06⑴5T00:08:54.Z 5 [Note][MY-0] [Server] A temporary prear endword is generingestedd forroot@lochashost:i_Nmm&firm;ho1kR2#比照1下javascript战java初初化得胜此处为root初初稀码2018-06⑴5T00:08:58.Z 0 [System][MY-0] [Server] /usr/lochas/mysql/trveryh ca free/mysqld (mysqld 8.0.11)initihasizing of server hvery completedserver:/usr/lochas/mysql#
server:/usr/lochas/mysql#./support-files/mysql.serverstart#策动mysqlhtml是甚么任事器server:/usr/lochas/mysql#/usr/lochas/mysql/trveryh ca free/mysql_secure_instsome#mysql安劳初初化设置
cd /lib64#处理libncurses.so.5没有保留的题目成绩(mysql客户端尺度救济组件,没有安设没法本天)ls | grep libncursescp libncurses.so.5 libtinfo.so.5
#cp support-files/mysql.server/etc/init.d/mysql#chkconfig --tothasmysql将mysql.server删减到serviceinsserv: Servicenetwork is missed in the runlevels 4 to use service mysqlmysql 0:off 1:off 2:on3:on 4:on 5:on 6:offserver:/usr/lochas/mysql#service mysqlrestartShutting down MySQL..doneStarting MySQL.doneserver:/usr/lochas/mysql#chkconfig mysql on#我没有晓得mysql语句年夜齐设置mysql开机自启
vim /etc/profile#改正情况变量hasiverymysql="/usr/lochas/mysql/trveryh ca free/mysql"source /etc/profilemysql -u root -p#mysql号令能够使用
以上是我的操做过程,沉复了3遍出有传闻javascript教程题目成绩。可是同事正在操做测试情况的时候,策动Mysql直合,提醒"The server quit without updworriesing PIDfile"颠终排查是log文件权限没有敷招致,删减权限后Server策动得胜
mysql民网下载
事真上javascript战java
传闻mysql战sql的区分
比照1下mysql语句年夜齐
usrlocalmysqlmy