Mysql 5.5以后使用了CMake进行安装,参考与以前的区别请参考: http://www.blogjava.net/kelly859/archive/2012/09/04/387005.html
接上文。 1:必要软件包 yum -y install gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make cmake
# 新增用户组
# 新增用户
# 新建数据库执行文件目录
# 新建数据库数据文件目录
# 修改目录拥有者 chown -R mysql:mysql /usr/local/mysql chown -R mysql:mysql /db/mysql/data chown -R mysql:mysql /usr/local/mysql/. chown -R mysql:mysql /db/mysql/data/.
# 编辑PATH搜索路径
# 生效PATH搜索路径
# 安装编译源码所需的工具和库
# 进入源码压缩包下载目录
# 下载源码压缩包
# 解压缩源码包 # 进入解压缩源码目录 cd mysql-5.6.10 # 编译并安装 cmake \ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_MYISAM_STORAGE_ENGINE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DWITH_SPHINX_STORAGE_ENGINE=1 \ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \ -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \ -DWITH_MEMORY_STORAGE_ENGINE=1 \ -DWITH_READLINE=1 \ -DENABLED_LOCAL_INFILE=1 \ -DMYSQL_DATADIR=/db/mysql/data \ -DMYSQL_USER=mysql \ -DMYSQL_TCP_PORT=3306 \ -DWITH_DEBUG=0 make && make install 红色部分表示禁用Debug模式。
# 复制配置文件
# 进入安装路径
# 执行配置脚本
# 复制服务启动脚本
# 启动MySQL服务
# 设置开机自动启动服务 >>>>>>>>>>>>>>>完成 如果发生如下错误:
[root@rekfan mysql]# service mysql restart 黄海的问题解决办法是:
killall命令
killall命令杀死同一进程组内的所有进程。其允许指定要终止的进程的名称,而非PID。
# killall mysqld
再次查看mysqld进程:
ps -ef|grep mysqld
没有了!世界清静了。
运行 mysql 然后进入mysql> 提示符后,输入status; 查看安装情况。 mysql> status; -------------- mysql Ver 14.14 Distrib 5.6.10, for Linux (x86_64) using EditLine wrapper Connection id: 1 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 5.6.10 Source distribution Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /tmp/mysql.sock Uptime: 7 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 67 Flush tables: 1 Open tables: 60 Queries per second avg: 0.714 -------------- #表名全部为小写,避免出现大小写敏感 vi /etc/my.cnf 添加如下内容,解决大小写表名敏感问题。
lower_case_table_names=1
修改MySQL的root用户的密码以及打开远程连接 mysql mysql> use mysql; mysql> desc user; mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root"; //为root添加远程连接的能力 mysql> update user set Password = password('123456') where User='root'; //设置root用户密码 mysql> select Host,User,Password from user where User='root'; mysql> flush privileges; mysql> exit
附自动安装脚本如下: vi installmysql.sh chmod 777 installmysql.sh ./installmysql.sh
内容如下: yum -y install wget gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* make cmake perl groupadd mysql useradd mysql -g mysql mkdir -p /usr/local/mysql mkdir -p /db/mysql/data chown -R mysql:mysql /usr/local/mysql chown -R mysql:mysql /db/mysql/data chown -R mysql:mysql /usr/local/mysql/. chown -R mysql:mysql /db/mysql/data/. echo "PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:\$PATH" >> /etc/profile echo "export PATH" >> /etc/profile source /etc/profile cd /usr/software/ #下载mysql源码包 #wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.10.tar.gz/from/http://cdn.mysql.com/ tar -zxvf mysql-5.6.10.tar.gz cd /usr/software/mysql-5.6.10 cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/db/mysql/data -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=3306 make && make install cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf cd /usr/local/mysql scripts/mysql_install_db --user=mysql --datadir=/db/mysql/data cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql echo "lower_case_table_names=1" >> /etc/my.cnf service mysql start chkconfig mysql on mysqladmin -u root password 'dsideal' service iptables stop chkconfig iptables off sed -i 's#SELINUX=enforcing#SELINUX=disabled#'g /etc/sysconfig/selinux (责任编辑:IT) |