centos6.5 MySQL5.5安装

最新推荐文章于 2024-05-20 07:30:00 发布

原创最新推荐文章于 2024-05-20 07:30:00 发布 · 927 阅读

0 ·

CC 4.0 BY-SA版权

Mysql 专栏收录该内容

24 篇文章

订阅专栏

本文介绍如何从源码编译安装MySQL 5.5，并配置初始环境及创建数据库。包括安装编译工具、配置用户、下载源码包、进行编译安装等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

安装编译工具(如果系统本身没有的话)
yum -y install gcc gcc-c++
yum -y install ncurses-devel
yum -y install make
yum -y install ncurses-devel cmake

echo 'export LC_ALL=C'>> /etc/profile
source /etc/profile
useradd mysql -s /sbin/nologin -M
cd /usr/local/src/
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.39.tar.gz
tar xzf mysql-5.5.39.tar.gz
cd mysql-5.5.39
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=complex -DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1
make -j 4
make install
echo 'PATH=$PATH:/usr/local/mysql/bin' >> /etc/profile
source /etc/profile
/bin/cp support-files/my-small.cnf /etc/my.cnf
mkdir -p /data/mysql
vim /etc/my.cnf 
datadir = /data/mysql

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql
cp support-files/mysql.server /etc/init.d/mysqld
chmod 700 /etc/init.d/mysqld 
/etc/init.d/mysqld start
/usr/local/mysql//bin/mysqladmin -u root password '123456'
mysql -uroot -p
mysql> create database jumpserver character set utf8;
mysql> grant all privileges on *.* to jumpserver@'linux-node1.example.com' identified by '123456';
mysql> flush privileges;