安装mysql

一、实验环境
在Linux系统中安装mysql二、操作脚本1.光盘挂载cd /mntlsmount /dev/cdrom /mnt2.建立yum仓库cd /etc/yum.repos.d/vim aaa.repo[aaa]name=testbaseurl=file:///mntenabled=1gpgcheck=0lsrm -rf rhel-source.repo yum list3.共享挂载mkdir /opt/lampsmbclient -L //192.168.119.2/mount.cifs //192.168.119.2/john /opt/lamp4.文件的解压缩cd /opt/lamptar zxvf mysql-5.5.24.tar.gz -C /opt5.安装环境包yum install gcc gcc-c++ make cmake -yrpm -ivh /mnt/Packages/ncurses-devel-5.7-3.20090208.el6.x86_64.rpmrpm -ivh /mnt/Packages/bison-2.4.1-5.el6.x86_64.rpm rpm -ivh /mnt/Packages/libaio-devel-0.3.107-10.el6.x86_64.rpm 6.添加mysql用户并加入到mysql组useradd -s /sbin/nologin mysqlmkdir -p /usr/local/mysql7.编译安装cd /opt/mysql-5.5.24cmake -DCMAKE_INSTAL开发云主机域名L_PREFIX=/usr/local/mysql
-DMYSQL_UNIX_ADDR=/home/mysql/mysql.sock
-DDEFAULT_CHARSET=utf8
-DDEFAULT_COLLATION=utf8_general_ci
-DWITH_EXTRA_CHARSETS=all
-DWITH_MYISAM_STORAGE_ENGINE=1
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_MEMORY_STORAGE_ENGINE=1
-DWITH_READLINE=1
-DENABLED_LOCAL_INFILE=1
-DMYSQL_DATADIR=/home/mysql
-DMYSQL_USER=mysql
-DMYSQL_TCP_PORT=3306 make && make install 8.递归复制chown -R mysql.mysql /usr/local/mysql9.开机时刷新export PATH=$PATH:/usr/local/mysql/bin/ 10.复制配置文件cp support-files/my-medium.cnf /etc/my.cnfcp support-files/mysql.server /etc/init.d/mysqld 11.增加文件执行权限chmod 755 /etc/init.d/mysqld12.添加并启动mysqld服务chkconfig –add /etc/init.d/mysqldchkconfig mysqld –level 35 on 13.初始化数据库/usr/local/mysql/scripts/mysql_install_db
–user=mysql
–ldata=/var/lib/mysql
–basedir=/usr/local/mysql
–datadir=/home/mysql14.建立软链接ln -s /var/lib/mysql/mysql.sock /home/mysql/mysql.sock15.修改配置文件vim /etc/init.d/mysqldbasedir=/usr/local/mysqldatadir=/home/mysql16.开启mysqld服务并验证service mysqld startnetstat -tnl 3306cd /opt/mysql-5.5.24mysqlshow databases;三、实验步骤示图

四、实验结果结果表明：mysql安装成功，如下图

相关推荐: 什么是mysql的联合查询

本文主要给大家介绍什么是mysql的联合查询，文章内容都是笔者用心摘选和编辑的，具有一定的针对性，对大家的参考意义还是比较大的，下面跟笔者一起了解下什么是mysql的联合查询吧。基本概念：将两个具有相同字段数量的查询语句的结果，以“上下堆叠”的方式，合并为一个…