mysql 安装

小鱼儿 2022-04-11 07:25 261阅读 0赞

wget [http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.13-linux-glibc2.5-i686.tar.gz][http_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-5.7.13-linux-glibc2.5-i686.tar.gz]  
tar -zxvf mysql-5.7.13-linux-glibc2.5-i686.tar.gz  
cp mysql-5.7.13-linux-glibc2.5-i686 /usr/local/mysql -r  
cd /usr/local/mysql/  
mkdir data

groupadd mysql  
useradd -r -g mysql mysql

chown -R mysql:mysql ./

vi /etc/my.cnf  
basedir=/usr/local/mysql/  
datadir=/usr/local/mysql/data

4.修改vi /etc/my.cnf 文件 \[mysqld\] basedir=/usr/local/mysql/  
datadir=/usr/local/mysql/data 5.初始化数据 进入mysql安装目录 cd /usr/local/mysql 执行: bin/mysqld –user=mysql –basedir=/usr/local/mysql/ –datadir=/usr/local/mysql/data/ – secure-file-priv=/root/ –initialize

6.启动mysql  
添加开机启动:执行命令cp support-files/mysql.server /etc/init.d/mysql 把启动脚本放到开机初始化目录  
启动mysql服务：执行命令service mysql start  
执行命令：ps -ef”grep mysql 看到mysql服务说明启动成功

解决动态密码的问题  
[http://blog.itpub.net/10569970/viewspace-1726363/][http_blog.itpub.net_10569970_viewspace-1726363]

使用的时候出现一个错误  
bash: /usr/local/bin/rar: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory  
是因为64位系统中安装了32位程序  
解决方法：  
yum install glibc.i686

重新安装以后还有如下类系错误 再继续安装包

error while loading shared libraries: libstdc++.so.6: cannot open shared object file: No such file or directory  
yum install libstdc++.so.6

--------------------

bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory  
yum install libaio  
yum install libaio.i686 (系统内核版本问题)  
跟下面问题一样  
\[图片\]  
yum install libaio.i686 (系统内核版本问题)安装和本机内核一样的版本即可  
系统内核查看  
cat /proc/version  
uname -a

今天登陆oracle10g的sqlplus发现如下错误： 
\[oracle@plinuxt19 10g\]sqlplus/nologSQL∗Plus:Release10.2.0.3.0−ProductiononWedOct2911:15:052008Copyright(c)1982,2006,Oracle.AllRightsReserved.SQL>conn/assysdba;oracleirmdb:errorwhileloadingsharedlibraries:libaio.so.1:cannotopensharedobjectfile:NosuchfileordirectoryERROR:ORA−12547:TNS:lostcontactSQL>quitDisconnected错误原因可能是libaio的rpm包没有装，su到root检验一下\[oracle@plinuxt19\]<script type="math/tex" id="MathJax-Element-1"> sqlplus /nolog SQL\*Plus: Release 10.2.0.3.0 - Production on Wed Oct 29 11:15:05 2008 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. SQL> conn / as sysdba; oracleirmdb: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory ERROR: ORA-12547: TNS:lost contact SQL> quit Disconnected 错误原因可能是libaio的rpm包没有装，su到root检验一下 \[oracle@plinuxt19 ~\]</script> exit 
logout 
\[root@plinuxt19 ~\]\# rpm -qa | grep libaio 
libaio-devel-0.3.105-2 
libaio-0.3.105-2 
奇怪明明已经安装了。 
后来想到current os version是x86\_64位的，我所看到的libaio的包很可能是(i386)的？ 
\[root@plinuxt19 ~\]\# rpm -q –qf ‘%\{NAME\}-%\{VERSION\}-%\{RELEASE\} (%\{ARCH\})\\n’ libaio 
libaio-0.3.105-2 (i386) 
果然是这样，但这是为什么呢？难道RHEL 4在安装的时候对于libaio的包只安装32bit的？ 
随即将libaio对应的x86\_64的包装上： 
\[root@plinuxt19 ~\]\# rpm -ivh libaio-0.3.105-2.x86\_64.rpm 
warning: libaio-0.3.105-2.x86\_64.rpm: V3 DSA signature: NOKEY, key ID 652e84dc 
Preparing… \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\] 
1:libaio \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\] 
\[oracle@plinuxt19 ~\]$ sqlplus /nolog 
SQL\*Plus: Release 10.2.0.3.0 - Production on Wed Oct 29 12:54:20 2008 
Copyright (c) 1982, 2006, Oracle. All Rights Reserved. 
SQL> conn / as sysdba; 
Connected to an idle instance. 
由此问题解决，但是疑惑的是，为什么当时没有装64bit的包，也许是相应option没有勾选。基本上就是这样，记录下

[http://www.2cto.com/database/201604/498462.html][http_www.2cto.com_database_201604_498462.html]

[http://dev.mysql.com/doc/refman/5.7/en/binary-installation.html][http_dev.mysql.com_doc_refman_5.7_en_binary-installation.html]

[http_dev.mysql.com_get_Downloads_MySQL-5.7_mysql-5.7.13-linux-glibc2.5-i686.tar.gz]: http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.13-linux-glibc2.5-i686.tar.gz
[http_blog.itpub.net_10569970_viewspace-1726363]: http://blog.itpub.net/10569970/viewspace-1726363/
[http_www.2cto.com_database_201604_498462.html]: http://www.2cto.com/database/201604/498462.html
[http_dev.mysql.com_doc_refman_5.7_en_binary-installation.html]: http://dev.mysql.com/doc/refman/5.7/en/binary-installation.html