@H_@H_502_1@
@H_502_1@
@H_502_1@
|
[root@pluto 桌面]# ps -ef|grep MysqL@H_502_1@ root 7921 6778 0 23:00 pts/3 00:00:00 grep MysqL@H_502_1@ [root@pluto 桌面]# rpm -qa|grep MysqL@H_502_1@ MysqL-libs-5.1.73-7.el6.x86_64@H_502_1@ [root@pluto 桌面]# uname -a@H_502_1@ Linux pluto.pluto 2.6.32-642.el6.x86_64 #1 SMP Tue May 10 17:27:01 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux@H_502_1@ |
rpm包名基本格式：MysqL-libs-5.1.73-7.el6.x86_64@H_502_1@
|-版本号：5.1.73@H_502_1@
|-适用操作系统：el6.x86_64，表示centos6.x的64位系统@H_502_1@
通过以上的信息我们可以得知MysqL已经安装了，所以我们只需要卸载就好了。安装我们想要的MysqL版本。@H_502_1@
|
[root@pluto 桌面]# rpm -e MysqL-libs@H_502_1@ error: Failed dependencies:@H_502_1@ libMysqLclient.so.16()(64bit) is needed by (installed) postfix-2:2.6.6-6.el6_7.1.x86_64@H_502_1@ libMysqLclient.so.16(libMysqLclient_16)(64bit) is needed by (installed) postfix-2:2.6.6-6.el6_7.1.x86_64@H_502_1@ MysqL-libs is needed by (installed) postfix-2:2.6.6-6.el6_7.1.x86_64@H_502_1@ |
|
[root@pluto opt]# rpm -ivh MysqL-server-5.5.48-1.linux2.6.i386.rpm @H_502_1@ [root@pluto opt]# rpm -ivh MysqL-client-5.5.48-1.linux2.6.i386.rpm @H_502_1@ |
注：如果出现error:libaio.so.1，则我们需要安装依赖包.目前我只会通过yum安装，要想通过yum安装必须保证linux是可以联网的。其它方式可以通过百度查询。@H_502_1@
@H_|
[root@pluto opt]# rpm -ivh MysqL-server-5.5.48-1.linux2.6.i386.rpm @H_502_1@ warning: MysqL-server-5.5.48-1.linux2.6.i386.rpm: Header V3 DSA/SHA1 Signature,key ID 5072e1f5: NOKEY@H_502_1@ error: Failed dependencies:@H_502_1@ libaio.so.1 is needed by MysqL-server-5.5.48-1.linux2.6.i386@H_502_1@ libaio.so.1(LIBAIO_0.1) is needed by MysqL-server-5.5.48-1.linux2.6.i386@H_502_1@ libaio.so.1(LIBAIO_0.4) is needed by MysqL-server-5.5.48-1.linux2.6.i386@H_502_1@ @H_502_1@ #出现error:libaio.so.1则执行以下命令@H_502_1@ [root@pluto opt]# yum install libaio.so.1@H_502_1@ @H_502_1@ [root@pluto opt]# rpm -ivh MysqL-client-5.5.48-1.linux2.6.i386.rpm @H_502_1@ warning: MysqL-client-5.5.48-1.linux2.6.i386.rpm: Header V3 DSA/SHA1 Signature,key ID 5072e1f5: NOKEY@H_502_1@ error: Failed dependencies:@H_502_1@ libncurses.so.5 is needed by MysqL-client-5.5.48-1.linux2.6.i386@H_502_1@ @H_502_1@ #出现libncurses.so.5则执行以下命令@H_502_1@ [root@pluto opt]# yum install libncurses.so.5@H_502_1@ |
注：最好不要使用 yum install libaio这个命令，明确指出要安装的依赖包，否则有可能依然会提示依赖没有安装。@H_502_1@
[2]查看MysqL安装时创建的MysqL用户和MysqL组@H_502_1@
|
[root@pluto 桌面]# cat /etc/passwd|grep MysqL@H_502_1@ MysqL:x:496:493:MysqL server:/var/lib/MysqL:/bin/bash@H_502_1@ |
或者通过以下方式可以查看是否安装成功，以下类似于java -version@H_502_1@
|
[root@pluto 桌面]# MysqLadmin --version@H_502_1@ MysqLadmin Ver 8.42 Distrib 5.5.48,for Linux on i686@H_502_1@ |
|
[root@pluto 桌面]# service MysqL start@H_502_1@ Starting MysqL.... [确定]@H_502_1@ @H_502_1@ |
|
[root@pluto 桌面]# /usr/bin/MysqLadmin -u root password 123456@H_502_1@ |
|
[root@pluto 桌面]# chkconfig MysqL on@H_502_1@ [root@pluto 桌面]# chkconfig --list | grep MysqL@H_502_1@ MysqL 0:关闭 1:关闭 2:启用 3:启用 4:启用 5:启用 6:关闭@H_502_1@ @H_502_1@ #查看runlevel@H_502_1@ [root@pluto 桌面]# cat /etc/inittab @H_502_1@ @H_502_1@ #查看开启启动的服务，带*表示为开机启动的服务@H_502_1@ [root@pluto 桌面]# ntsysv @H_502_1@ |
|
[root@pluto 桌面]# ps -ef|grep MysqL@H_502_1@ root 8530 1 0 23:23 pts/1 00:00:00 /bin/sh /usr/bin/MysqLd_safe --datadir=/var/lib/MysqL --pid-file=/var/lib/MysqL/pluto.pluto.pid@H_502_1@ MysqL 8621 8530 0 23:23 pts/1 00:00:00 /usr/sbin/MysqLd --basedir=/usr --datadir=/var/lib/MysqL --plugin-dir=/usr/lib/MysqL/plugin --user=MysqL --log-error=/var/lib/MysqL/pluto.pluto.err --pid-file=/var/lib/MysqL/pluto.pluto.pid@H_502_1@ root 8750 8229 0 23:34 pts/1 00:00:00 grep MysqL@H_502_1@ |
@H_@H_502_1@
@H_502_1@
@H_502_1@
|
[root@pluto MysqL]# cp /usr/share/MysqL/my-huge.cnf /etc/my.cnf@H_502_1@ |
@H_@H_502_1@
@H_502_1@
@H_502_1@
@H_@H_502_1@
@H_502_1@
@H_502_1@
默认的客户端和服务器都是用latin1,所以进行插入中文时会出现乱码@H_502_1@
@H_@H_502_1@
@H_502_1@
@H_502_1@
|
[root@pluto etc]# vim /etc/my.cnf@H_502_1@ [client]@H_502_1@ #password = your_password@H_502_1@ port = 3306@H_502_1@ socket = /var/lib/MysqL/MysqL.sock@H_502_1@ default-character-set=utf8@H_502_1@ @H_502_1@ port = 3306@H_502_1@ character_set_server=utf8@H_502_1@ character_set_client=utf8@H_502_1@ collation-server=utf8_general_ci@H_502_1@ socket = /var/lib/MysqL/MysqL.sock@H_502_1@ skip-external-locking@H_502_1@ key_buffer_size = 384M@H_502_1@ max_allowed_packet = 1M@H_502_1@ table_open_cache = 512@H_502_1@ sort_buffer_size = 2M@H_502_1@ read_buffer_size = 2M@H_502_1@ read_rnd_buffer_size = 8M@H_502_1@ myisam_sort_buffer_size = 64M@H_502_1@ thread_cache_size = 8@H_502_1@ query_cache_size = 32M@H_502_1@ # Try number of cpu's*2 for thread_concurrency@H_502_1@ thread_concurrency = 8@H_502_1@ @H_502_1@ no-auto-rehash@H_502_1@ default-character-set=utf8@H_502_1@ @H_502_1@ [root@pluto etc]# service MysqL restart@H_502_1@ |
注：重新连接后重新create database并使用新建的库，然后新建的表才能插入、显示中文。@H_502_1@
|
https://www.cnblogs.com/happyhuangjinjin/p/8244851.html@H_502_1@ |
[1].linux网络设置@H_502_1@
|
https://zhidao.baidu.com/question/1771404477336032980.html@H_502_1@ |
|
MysqL> grant all privileges on *.* to root@'%' identified by '123456';@H_502_1@ |
@H_@H_502_1@
@H_502_1@
[3].防火墙设置3306可通行@H_502_1@
|
https://www.cnblogs.com/xxoome/p/6884376.html@H_502_1@ |
|
[root@pluto 桌面]# vim /etc/sysconfig/iptables@H_502_1@ @H_502_1@ -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT@H_502_1@ [root@pluto 桌面]# service iptables restart@H_502_1@ |
@H_@H_502_1@
